Mercurial > gemma

comparison pkg/imports/sec.go @ 3560:ec1aec03676d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Use waterway area as basis for section area
author Tom Gottfried <tom@intevation.de>
date Fri, 31 May 2019 16:54:09 +0200
parents 40bc7e3bc561
children 4c585b5d4fe8
comparison
equal deleted inserted replaced
3559:c220ad7e61ed 3560:ec1aec03676d
108 date_info, 108 date_info,
109 source_organization 109 source_organization
110 ) VALUES ( 110 ) VALUES (
111 $11, 111 $11,
112 (SELECT r FROM r), 112 (SELECT r FROM r),
113 ST_Transform(ISRSrange_area( 113 ISRSrange_area(
114 (SELECT axs FROM axs), 114 (SELECT axs FROM axs),
115 (SELECT ST_Buffer(axs, 1500) FROM axs)), 115 (SELECT ST_Collect(CAST(area AS geometry))
116 4326), 116 FROM waterway.waterway_area)),
117 $12, 117 $12,
118 $13, 118 $13,
119 $14, 119 $14,
120 $15) 120 $15)
121 RETURNING id` 121 RETURNING id`