Mercurial > gemma

comparison schema/geoserver_views.sql @ 4582:51dc19001808 iso-areas

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added geoserver view and named style to match.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Tue, 08 Oct 2019 16:13:53 +0200
parents c657dec6b0fa
children 0b01fd83bc3b
comparison
equal deleted inserted replaced
4581:01ea1e547c28 4582:51dc19001808
194 SELECT bottleneck_id, max(date_info) AS current 194 SELECT bottleneck_id, max(date_info) AS current
195 FROM waterway.sounding_results 195 FROM waterway.sounding_results
196 GROUP BY bottleneck_id) sr ON sr.bottleneck_id = bn.bottleneck_id 196 GROUP BY bottleneck_id) sr ON sr.bottleneck_id = bn.bottleneck_id
197 WHERE bn.validity @> current_timestamp 197 WHERE bn.validity @> current_timestamp
198 ORDER BY objnam; 198 ORDER BY objnam;
199
200 CREATE OR REPLACE VIEW waterway.sounding_results_areas_geoserver AS
201 SELECT
202 bottleneck_id,
203 date_info,
204 height,
205 CAST(areas AS geometry(multipolygon, 4326)) as areas
206 FROM waterway.sounding_results_iso_areas ia
207 JOIN waterway.sounding_results sr ON sr.id = ia.sounding_result_id;