Mercurial > gemma

comparison schema/updates/1204/03.geoserver-views.sql @ 4581:01ea1e547c28 iso-areas

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added geoserver view for areas.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Tue, 08 Oct 2019 14:29:33 +0200
parents
children 0b01fd83bc3b
comparison
equal deleted inserted replaced
4580:02cf2b4be955 4581:01ea1e547c28
1 CREATE OR REPLACE VIEW waterway.sounding_results_areas_geoserver AS
2 SELECT bottleneck_id,
3 date_info,
4 height,
5 CAST(areas AS geometry(multipolygon, 4326)) as areas
6 FROM waterway.sounding_results_iso_areas ia
7 JOIN waterway.sounding_results sr ON sr.id = ia.sounding_result_id;
8
9 GRANT SELECT ON ALL TABLES IN SCHEMA public, users, waterway TO waterway_user;