Mercurial > gemma
comparison pkg/imports/sr.go @ 4637:0ed1489af8b6
Removed ST_MakeValid from inserting sounding results and differences ... in hope that they are not broken.
This speeds inserting up a lot.
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Fri, 11 Oct 2019 15:09:13 +0200 |
| parents | 7acb03e8a737 |
| children | 4380f5483c03 |
comparison
equal
deleted
inserted
replaced
| 4636:a08e0c8c53ee | 4637:0ed1489af8b6 |
|---|---|
| 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_SimplifyPreserveTopology( |
| 179 ST_Multi(ST_Collectionextract( | 179 ST_GeomFromWKB($4, $3::integer), |
| 180 ST_MakeValid(ST_GeomFromWKB($4, $3::integer)), 3)), | |
| 181 $5 | 180 $5 |
| 182 ), | 181 ), |
| 183 3 | 182 3 |
| 184 ) | 183 ) |
| 185 ), | 184 ), |
| 909 if err != nil { | 908 if err != nil { |
| 910 return err | 909 return err |
| 911 } | 910 } |
| 912 defer stmt.Close() | 911 defer stmt.Close() |
| 913 | 912 |
| 913 var size int | |
| 914 | |
| 914 for i, a := range areas { | 915 for i, a := range areas { |
| 915 if len(a) == 0 { | 916 if len(a) == 0 { |
| 916 continue | 917 continue |
| 917 } | 918 } |
| 919 wkb := a.AsWKB() | |
| 920 size += len(wkb) | |
| 918 if _, err := stmt.ExecContext( | 921 if _, err := stmt.ExecContext( |
| 919 ctx, | 922 ctx, |
| 920 id, heights[i], epsg, | 923 id, heights[i], epsg, |
| 921 a.AsWKB(), | 924 wkb, |
| 922 contourTolerance, | 925 contourTolerance, |
| 923 ); err != nil { | 926 ); err != nil { |
| 924 return err | 927 return err |
| 925 } | 928 } |
| 926 } | 929 } |
| 927 | 930 |
| 931 feedback.Info("Transfered WKB size: %.2fMB.", | |
| 932 float64(size)/(1024*1024)) | |
| 933 | |
| 928 return nil | 934 return nil |
| 929 } | 935 } |