Mercurial > gemma

changeset 4622:b03aa1502736 geoserver_sql_views

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fixup rev. 4476ec4db818 Missed to change also database update script.
author Tom Gottfried <tom@intevation.de>
date Fri, 04 Oct 2019 17:26:56 +0200
parents d2eac69ba86b
children 30bb2d819d57
files schema/updates/1300/02.views_to_geoservers.sql
diffstat 1 files changed, 7 insertions(+), 7 deletions(-) [+]
line wrap: on
line diff
--- a/schema/updates/1300/02.views_to_geoservers.sql	Fri Oct 04 16:40:04 2019 +0200
+++ b/schema/updates/1300/02.views_to_geoservers.sql	Fri Oct 04 17:26:56 2019 +0200
@@ -93,7 +93,7 @@
             s.name,
             (s.section).lower::varchar as lower,
             (s.section).upper::varchar as upper,
-            s.area::Geometry(MULTIPOLYGON, 4326),
+            s.area,
             s.objnam,
             s.nobjnam,
             s.date_info,
@@ -116,7 +116,7 @@
             s.name,
             (s.stretch).lower::varchar as lower,
             (s.stretch).upper::varchar as upper,
-            s.area::Geometry(MULTIPOLYGON, 4326),
+            s.area,
             s.objnam,
             s.nobjnam,
             s.date_info,
@@ -139,7 +139,7 @@
     ('waterway', 'distance_marks_ashore_geoserver', 4326, $$
         SELECT id,
            country,
-           geom::Geometry(POINT, 4326),
+           geom,
            related_enc,
            hectom,
            catdis,
@@ -149,7 +149,7 @@
     ('waterway', 'distance_marks_geoserver', 4326, $$
         SELECT
            isrs_asText(location_code) AS location,
-           geom::Geometry(POINT, 4326),
+           geom,
            related_enc,
            (location_code).hectometre
         FROM waterway.distance_marks_virtual
@@ -158,7 +158,7 @@
         SELECT bottleneck_id,
             date_info,
             height,
-            CAST(lines AS geometry(multilinestring, 4326)) AS lines
+            lines
         FROM waterway.sounding_results_contour_lines cl
             JOIN waterway.sounding_results sr ON sr.id = cl.sounding_result_id
     $$),
@@ -208,7 +208,7 @@
     ('waterway', 'bottleneck_overview', 4326, $$
         SELECT
             objnam AS name,
-            ST_Centroid(area)::Geometry(POINT, 4326) AS point,
+            ST_Centroid(area) AS point,
             (lower(stretch)).hectometre AS from,
             (upper(stretch)).hectometre AS to,
             sr.current::text,
@@ -228,7 +228,7 @@
             srm.date_info   AS minuend,
             srs.date_info   AS subtrahend,
             sdcl.height     AS height,
-            CAST(sdcl.lines AS geometry(multilinestring, 4326)) AS lines
+            sdcl.lines      AS lines
         FROM caching.sounding_differences sd
             JOIN caching.sounding_differences_contour_lines sdcl
                 ON sd.id = sdcl.sounding_differences_id