Mercurial > gemma

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

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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
comparison
equal deleted inserted replaced
5424:2f3fd2d0486b 5425:345515bc4548
220 $$), 220 $$),
221 ('waterway', 'sounding_results_marking_points_geoserver', 4326, NULL, $$ 221 ('waterway', 'sounding_results_marking_points_geoserver', 4326, NULL, $$
222 SELECT bottleneck_id, 222 SELECT bottleneck_id,
223 to_char(date_info, 'YYYY-MM-DD') AS date_info, 223 to_char(date_info, 'YYYY-MM-DD') AS date_info,
224 height, 224 height,
225 points, 225 points::geometry(MULTIPOINTZ, 4326),
226 surtyp, 226 surtyp,
227 zpg_exception 227 zpg_exception
228 FROM waterway.sounding_results_marking_points mp 228 FROM waterway.sounding_results_marking_points mp
229 JOIN waterway.sounding_results sr ON sr.id = mp.sounding_result_id 229 JOIN waterway.sounding_results sr ON sr.id = mp.sounding_result_id
230 $$), 230 $$),