Mercurial > gemma
changeset 4619:4476ec4db818 geoserver_sql_views
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