Mercurial > gemma
comparison pkg/imports/sr.go @ 4686:1d6f28e45696
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 |