Mercurial > gemma
comparison schema/default_sysconfig.sql @ 4787:3a8ec3c396e0
Fixed date_info in sounding result area geoserver view.
author | Raimund Renkert <raimund@renkert.org> |
---|---|
date | Wed, 23 Oct 2019 16:29:07 +0200 |
parents | 63ead1fab71b |
children | 9b9b4150f296 |
comparison
equal
deleted
inserted
replaced
4786:3b3cf2083730 | 4787:3a8ec3c396e0 |
---|---|
187 (location_code).hectometre | 187 (location_code).hectometre |
188 FROM waterway.distance_marks_virtual | 188 FROM waterway.distance_marks_virtual |
189 $$), | 189 $$), |
190 ('waterway', 'sounding_results_areas_geoserver', 4326, NULL, $$ | 190 ('waterway', 'sounding_results_areas_geoserver', 4326, NULL, $$ |
191 SELECT bottleneck_id, | 191 SELECT bottleneck_id, |
192 date_info, | 192 to_char(date_info, 'YYYY-MM-DD') AS date_info, |
193 height, | 193 height, |
194 areas, | 194 areas, |
195 surtyp | 195 surtyp |
196 FROM waterway.sounding_results_iso_areas ia | 196 FROM waterway.sounding_results_iso_areas ia |
197 JOIN waterway.sounding_results sr ON sr.id = ia.sounding_result_id | 197 JOIN waterway.sounding_results sr ON sr.id = ia.sounding_result_id |