Mercurial > gemma
changeset 4622:b03aa1502736 geoserver_sql_views
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