Mercurial > gemma

comparison pkg/imports/sr.go @ 1131:2e6b47cdb2ca

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Store octrees along with sounding results The extra table with 1:1-relation to sounding results was a provisorial solution with the intention to make it easily removable.
author Tom Gottfried <tom@intevation.de>
date Wed, 07 Nov 2018 17:54:50 +0100
parents 42617bba8709
children a5069da2f0b7
comparison
equal deleted inserted replaced
1130:42617bba8709 1131:2e6b47cdb2ca
101 ELSE 101 ELSE
102 32700 102 32700
103 END + floor((ST_X(ST_Centroid(point_cloud::geometry))+180)/6)::int + 1` 103 END + floor((ST_X(ST_Centroid(point_cloud::geometry))+180)/6)::int + 1`
104 104
105 insertOctreeSQL = ` 105 insertOctreeSQL = `
106 INSERT INTO waterway.octrees ( 106 UPDATE waterway.sounding_results SET
107 sounding_result_id, 107 octree_checksum = $2, octree_index = $3
108 checksum, 108 WHERE id = $1`
109 octree_index
110 ) VALUES (
111 $1,
112 $2,
113 $3
114 )`
115 109
116 insertContourSQL = ` 110 insertContourSQL = `
117 INSERT INTO waterway.sounding_results_contour_lines ( 111 INSERT INTO waterway.sounding_results_contour_lines (
118 sounding_result_id, 112 sounding_result_id,
119 height, 113 height,