--- a/schema/gemma.sql	Mon Jan 21 11:37:24 2019 +0100
+++ b/schema/gemma.sql	Mon Jan 21 11:44:31 2019 +0100
@@ -370,6 +370,24 @@
         UNIQUE(stretches_id, country_code)
     )
 
+    -- Published view for GeoServer
+    CREATE VIEW stretches_geoserver AS SELECT
+        id,
+        name,
+        (stretch).lower::varchar as lower,
+        (stretch).upper::varchar as upper,
+        geom::Geometry(POLYGON, 4326),
+        objnam,
+        nobjnam,
+        date_info,
+        source_organization,
+        (SELECT string_agg(country_code, ', ')
+            FROM stretch_countries
+            WHERE stretches_id = id) AS countries,
+        staging_done
+    FROM stretches
+
+
     CREATE TRIGGER sections_stretches_date_info
         BEFORE UPDATE ON stretches
         FOR EACH ROW EXECUTE PROCEDURE update_date_info()