Mercurial > gemma

changeset 4619:4476ec4db818 geoserver_sql_views

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Remove unnecessary type casts They have been introduced to work-around failing automatic detections of SRS by GeoServer. Since we explicitly give the SRS now anyhow, they are obsolete.
author Tom Gottfried <tom@intevation.de>
date Fri, 20 Sep 2019 16:08:15 +0200
parents 0f2c3cb139cc
children f77a6f9216ae
files schema/default_sysconfig.sql
diffstat 1 files changed, 7 insertions(+), 7 deletions(-) [+]
line wrap: on
line diff
--- a/schema/default_sysconfig.sql	Fri Sep 20 15:35:16 2019 +0200
+++ b/schema/default_sysconfig.sql	Fri Sep 20 16:08:15 2019 +0200
@@ -120,7 +120,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,
@@ -143,7 +143,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,
@@ -166,7 +166,7 @@
     ('waterway', 'distance_marks_ashore_geoserver', 4326, $$
         SELECT id,
            country,
-           geom::Geometry(POINT, 4326),
+           geom,
            related_enc,
            hectom,
            catdis,
@@ -176,7 +176,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
@@ -185,7 +185,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
     $$),
@@ -235,7 +235,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,
@@ -255,7 +255,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