Mercurial > gemma

comparison pkg/imports/sr.go @ 984:3c9ea8ab856a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fixed small glitches in sounding result importer.
author Sascha L. Teichmann <teichmann@intevation.de>
date Fri, 19 Oct 2018 16:05:46 +0200
parents f4f5bd73bd27
children 7dfd3db94e6d
comparison
equal deleted inserted replaced
983:f4f5bd73bd27 984:3c9ea8ab856a
66 ) VALUES ( 66 ) VALUES (
67 (SELECT bottleneck_id from waterway.bottlenecks where objnam = $1), 67 (SELECT bottleneck_id from waterway.bottlenecks where objnam = $1),
68 $2::date, 68 $2::date,
69 $3, 69 $3,
70 ST_Transform(ST_GeomFromWKB($4, $6::integer), 4326)::geography, 70 ST_Transform(ST_GeomFromWKB($4, $6::integer), 4326)::geography,
71 (SELECT CASE $5 IS NULL THEN 71 (SELECT CASE WHEN $5::bytea IS NULL THEN
72 ST_Transform( 72 ST_Transform(
73 ST_ConcaveHull( 73 ST_ConcaveHull(
74 ST_Force2D(ST_GeomFromWKB($4, $6::integer)), 0.7), 4326)::geography 74 ST_Force2D(ST_GeomFromWKB($4, $6::integer)), 0.7), 4326)::geography
75 ELSE 75 ELSE
76 ST_Transform(ST_GeomFromWKB($5, $6::integer), 4326)::geography 76 ST_Transform(ST_GeomFromWKB($5, $6::integer), 4326)::geography