comparison cmd/octree2contour/store.go @ 925:15bf101e1522

Send 2D X/Y vertices to the database directly instead of sending 3D data and dropping the Z value afterwards.
author Sascha L. Teichmann <teichmann@intevation.de>
date Sat, 06 Oct 2018 13:34:51 +0200
parents 52cb0b82b490
children
comparison
equal deleted inserted replaced
924:c8146132059e 925:15bf101e1522
29 ST_Multi( 29 ST_Multi(
30 ST_CollectionExtract( 30 ST_CollectionExtract(
31 ST_Intersection( 31 ST_Intersection(
32 ST_Transform(sr.area::geometry, $3::integer), 32 ST_Transform(sr.area::geometry, $3::integer),
33 ST_SimplifyPreserveTopology( 33 ST_SimplifyPreserveTopology(
34 ST_LineMerge(ST_Force2D(ST_GeomFromWKB($2, $3::integer))), 34 ST_LineMerge(ST_GeomFromWKB($2, $3::integer)),
35 $6 35 $6
36 ) 36 )
37 ), 37 ),
38 2 38 2
39 ) 39 )
68 return err 68 return err
69 } 69 }
70 70
71 for _, r := range all { 71 for _, r := range all {
72 if _, err := stmt.Exec( 72 if _, err := stmt.Exec(
73 r.h, r.lines.AsWKB(), epsg, 73 r.h, r.lines.AsWKB2D(), epsg,
74 bottleneck, date, 74 bottleneck, date,
75 tol, 75 tol,
76 ); err != nil { 76 ); err != nil {
77 return err 77 return err
78 } 78 }