Mercurial > gemma
comparison pkg/controllers/diff.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 | 7a9388943840 |
children | c91e759007da |
comparison
equal
deleted
inserted
replaced
4685:7a9388943840 | 4686:1d6f28e45696 |
---|---|
83 $1, | 83 $1, |
84 $2, | 84 $2, |
85 ST_Transform( | 85 ST_Transform( |
86 ST_Multi( | 86 ST_Multi( |
87 ST_CollectionExtract( | 87 ST_CollectionExtract( |
88 ST_SimplifyPreserveTopology( | 88 ST_MakeValid( |
89 ST_Multi(ST_Collectionextract( | 89 ST_Multi( |
90 ST_MakeValid(ST_GeomFromWKB($4, $3::integer)), 3)), | 90 ST_Collectionextract( |
91 $5 | 91 ST_SimplifyPreserveTopology(ST_GeomFromWKB($4, $3::integer), $5), |
92 3 | |
93 ) | |
94 ) | |
92 ), | 95 ), |
93 3 | 96 3 |
94 ) | 97 ) |
95 ), | 98 ), |
96 4326 | 99 4326 |