diff schema/default_sysconfig.sql @ 5425:345515bc4548 marking-single-beam

Make GeoServer layer sounding_results_marking_points_geoserver working.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 09 Jul 2021 22:03:44 +0200
parents 24156a964eaa
children 67ffa7517888
line wrap: on
line diff
--- a/schema/default_sysconfig.sql	Fri Jul 09 01:35:04 2021 +0200
+++ b/schema/default_sysconfig.sql	Fri Jul 09 22:03:44 2021 +0200
@@ -222,7 +222,7 @@
         SELECT bottleneck_id,
             to_char(date_info, 'YYYY-MM-DD') AS date_info,
             height,
-            points,
+            points::geometry(MULTIPOINTZ, 4326),
             surtyp,
             zpg_exception
         FROM waterway.sounding_results_marking_points mp