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 |