Mercurial > gemma
changeset 1963:f7a35ba9f409
Added view for publishing bottlenecks
The new view adds reference gauge and reference water level to the
bottleneck information.
author | Sascha Wilde <wilde@intevation.de> |
---|---|
date | Tue, 22 Jan 2019 18:22:57 +0100 |
parents | b275d5e14087 |
children | da6dc9b73f34 |
files | client/src/components/Maplayer.vue schema/demo-data/published_services.sql schema/gemma.sql |
diffstat | 3 files changed, 23 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/client/src/components/Maplayer.vue Tue Jan 22 17:35:45 2019 +0100 +++ b/client/src/components/Maplayer.vue Tue Jan 22 18:22:57 2019 +0100 @@ -290,7 +290,7 @@ { featureNS: "gemma", featurePrefix: "gemma", - featureTypes: ["bottlenecks"], + featureTypes: ["bottlenecks_geoserver"], geometryName: "area" }, "/internal/wfs",
--- a/schema/demo-data/published_services.sql Tue Jan 22 17:35:45 2019 +0100 +++ b/schema/demo-data/published_services.sql Tue Jan 22 18:22:57 2019 +0100 @@ -16,7 +16,7 @@ ('waterway.fairway_dimensions'), ('waterway.distance_marks_geoserver'), ('waterway.sounding_results_contour_lines_geoserver'), - ('waterway.bottlenecks'), + ('waterway.bottlenecks_geoserver'), ('waterway.bottleneck_overview'), ('waterway.waterway_axis'), ('waterway.waterway_area')
--- a/schema/gemma.sql Tue Jan 22 17:35:45 2019 +0100 +++ b/schema/gemma.sql Tue Jan 22 18:22:57 2019 +0100 @@ -471,6 +471,27 @@ PRIMARY KEY (bottleneck_id, riverbed) ) + -- Published view for GeoServer + CREATE VIEW bottlenecks_geoserver AS SELECT + b.bottleneck_id, + b.objnam, + b.nobjnm, + b.stretch, + b.area, + b.rb, + b.lb, + b.responsible_country, + b.revisiting_time, + b.limiting, + b.date_info, + b.source_organization, + g.location AS gauge_isrs_code, + g.objname AS gauge_objname, + grwl.reference_water_level, + grwl.value AS reference_water_level_value + FROM bottlenecks b, gauges g, gauges_reference_water_levels grwl + WHERE b.fk_g_fid = g.location AND g.location = grwl.gauge_id + CREATE TABLE sounding_results ( id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, bottleneck_id int NOT NULL REFERENCES bottlenecks(id),