Mercurial > gemma

comparison pkg/imports/st.go @ 2911:a75c546ef498

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Use buffer around axis for stretch area
author Tom Gottfried <tom@intevation.de>
date Tue, 02 Apr 2019 19:24:08 +0200
parents 2b4727a32ce6
children 5c8ecab9f2d4
comparison
equal deleted inserted replaced
2910:c8c7122047a2 2911:a75c546ef498
95 ($6::char(2), 95 ($6::char(2),
96 $7::char(3), 96 $7::char(3),
97 $8::char(5), 97 $8::char(5),
98 $9::char(5), 98 $9::char(5),
99 $10::int)::isrs) 99 $10::int)::isrs)
100 ) AS r 100 ) AS r),
101 ) 101 axs AS (
102 SELECT ISRSrange_axis((SELECT r FROM r), $16::double precision) AS axs)
102 INSERT INTO waterway.stretches ( 103 INSERT INTO waterway.stretches (
103 name, 104 name,
104 stretch, 105 stretch,
105 area, 106 area,
106 objnam, 107 objnam,
108 date_info, 109 date_info,
109 source_organization 110 source_organization
110 ) VALUES ( 111 ) VALUES (
111 $11, 112 $11,
112 (SELECT r FROM r), 113 (SELECT r FROM r),
113 ISRSrange_area( 114 ST_Transform(ISRSrange_area(
114 ISRSrange_axis((SELECT r FROM r), $16::double precision), 115 (SELECT axs FROM axs),
115 (SELECT ST_Collect(CAST(area AS geometry)) 116 (SELECT ST_Buffer(axs, 10000) FROM axs)),
116 FROM waterway.waterway_area)), 117 4326),
117 $12, 118 $12,
118 $13, 119 $13,
119 $14, 120 $14,
120 $15) 121 $15)
121 RETURNING id` 122 RETURNING id`