Mercurial > gemma

comparison pkg/imports/sr.go @ 4686:1d6f28e45696

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
morphology: Doing ST_SimplifyPreserveTopology before ST_MakeValid when storing geometries to database speeds things up ... a lot.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 16 Oct 2019 11:51:53 +0200
parents 0ddb308fed37
children 56bd9ba0354c
comparison
equal deleted inserted replaced
4685:7a9388943840 4686:1d6f28e45696
173 $1, 173 $1,
174 $2, 174 $2,
175 ST_Transform( 175 ST_Transform(
176 ST_Multi( 176 ST_Multi(
177 ST_CollectionExtract( 177 ST_CollectionExtract(
178 ST_SimplifyPreserveTopology( 178 ST_MakeValid(
179 ST_Multi(ST_Collectionextract( 179 ST_Multi(
180 ST_MakeValid(ST_GeomFromWKB($4, $3::integer)), 3)), 180 ST_Collectionextract(
181 $5 181 ST_SimplifyPreserveTopology(ST_GeomFromWKB($4, $3::integer), $5),
182 3
183 )
184 )
182 ), 185 ),
183 3 186 3
184 ) 187 )
185 ), 188 ),
186 4326 189 4326