Mercurial > gemma

changeset 690:f595b3455d75

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Schema: Add view for waterway axis * Use view to help geoserver serve WFS 1.1.0. Also change client to ask for the new name instead of the original table.
author Bernhard Reiter <bernhard@intevation.de>
date Thu, 20 Sep 2018 14:15:32 +0200
parents 89b497d0ee0f
children d643ff60f607
files client/src/map/Maplayer.vue schema/gemma.sql
diffstat 2 files changed, 12 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/client/src/map/Maplayer.vue	Thu Sep 20 12:45:00 2018 +0200
+++ b/client/src/map/Maplayer.vue	Thu Sep 20 14:15:32 2018 +0200
@@ -205,7 +205,7 @@
       srsName: "EPSG:3857",
       featureNS: "gemma",
       featurePrefix: "gemma",
-      featureTypes: ["distance_marks"],
+      featureTypes: ["distance_marks_geoserver"],
       outputFormat: "application/json"
     });
 
--- a/schema/gemma.sql	Thu Sep 20 12:45:00 2018 +0200
+++ b/schema/gemma.sql	Thu Sep 20 14:15:32 2018 +0200
@@ -280,6 +280,17 @@
         position_code char(2) NOT NULL REFERENCES position_codes
     )
 
+    -- A table to help geoserver serve the distance marks as WFS 1.1.0.
+    -- At least geoserver-2.13.2 does not serve type geography correctly
+    -- and does not serve the location_code as isrs type
+    CREATE VIEW waterway.distance_marks_geoserver AS
+        SELECT location_code::VARCHAR,
+               geom::Geometry(POINT, 4326),
+               distance_mark_function,
+               position_code,
+               (location_code).hectometre
+            FROM waterway.distance_marks;
+
     CREATE TABLE sections_stretches (
         id varchar PRIMARY KEY,
         is_section boolean NOT NULL, -- maps 'function' from interface