Mercurial > gemma

comparison pkg/imports/sr.go @ 4055:98e2041c7ebf historization_ng

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Adapted sr-import to new historization model.
author Sascha Wilde <wilde@intevation.de>
date Wed, 24 Jul 2019 18:16:27 +0200
parents 3eab3fc113b7
children 5a650cde0574
comparison
equal deleted inserted replaced
4054:033a8e3fec8e 4055:98e2041c7ebf
114 relation = 'waterway.sounding_results'::regclass)` 114 relation = 'waterway.sounding_results'::regclass)`
115 115
116 insertHullSQL = ` 116 insertHullSQL = `
117 INSERT INTO waterway.sounding_results ( 117 INSERT INTO waterway.sounding_results (
118 bottleneck_id, 118 bottleneck_id,
119 bottleneck_validity,
120 date_info, 119 date_info,
121 depth_reference, 120 depth_reference,
122 area 121 area
123 ) SELECT 122 ) SELECT
124 bottleneck_id, 123 bottleneck_id,
125 validity,
126 $2::date, 124 $2::date,
127 $3, 125 $3,
128 (SELECT 126 (SELECT
129 CASE WHEN $5::bytea IS NULL THEN 127 CASE WHEN $5::bytea IS NULL THEN
130 ST_Transform(ST_ConcaveHull(ST_Force2D(ST_GeomFromWKB($4, $6::integer)), 0.7), 4326)::geography 128 ST_Transform(ST_ConcaveHull(ST_Force2D(ST_GeomFromWKB($4, $6::integer)), 0.7), 4326)::geography
188 grwl.value, 186 grwl.value,
189 grwl.depth_reference 187 grwl.depth_reference
190 FROM waterway.gauges_reference_water_levels grwl 188 FROM waterway.gauges_reference_water_levels grwl
191 JOIN waterway.bottlenecks bns 189 JOIN waterway.bottlenecks bns
192 ON grwl.location = bns.gauge_location 190 ON grwl.location = bns.gauge_location
193 AND grwl.validity = bns.gauge_validity 191 AND grwl.validity @> CAST($2 AS timestamptz)
194 WHERE bns.objnam = $1 192 WHERE bns.objnam = $1
195 AND bns.validity @> CAST($2 AS timestamptz) 193 AND bns.validity @> CAST($2 AS timestamptz)
196 AND grwl.depth_reference like 'LDC%' 194 AND grwl.depth_reference like 'LDC%'
197 ` 195 `
198 196