# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1568988495 -7200
# Node ID 4476ec4db8187d0d9cc5001b798d0d3192403cd5
# Parent  0f2c3cb139cc1c999f19d76a28cb8ded066c0536
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.

diff -r 0f2c3cb139cc -r 4476ec4db818 schema/default_sysconfig.sql
--- 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