Mercurial > gemma
comparison schema/updates/1300/02.views_to_geoservers.sql @ 4623:30bb2d819d57 geoserver_sql_views
Merge default into geoserver_sql_views
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Wed, 09 Oct 2019 16:40:18 +0200 |
parents | b03aa1502736 |
children |
comparison
equal
deleted
inserted
replaced
4622:b03aa1502736 | 4623:30bb2d819d57 |
---|---|
152 geom, | 152 geom, |
153 related_enc, | 153 related_enc, |
154 (location_code).hectometre | 154 (location_code).hectometre |
155 FROM waterway.distance_marks_virtual | 155 FROM waterway.distance_marks_virtual |
156 $$), | 156 $$), |
157 ('waterway', 'sounding_results_contour_lines_geoserver', 4326, $$ | 157 ('waterway', 'sounding_results_areas_geoserver', 4326, $$ |
158 SELECT bottleneck_id, | 158 SELECT bottleneck_id, |
159 date_info, | 159 date_info, |
160 height, | 160 height, |
161 lines | 161 areas |
162 FROM waterway.sounding_results_contour_lines cl | 162 FROM waterway.sounding_results_iso_areas ia |
163 JOIN waterway.sounding_results sr ON sr.id = cl.sounding_result_id | 163 JOIN waterway.sounding_results sr ON sr.id = ia.sounding_result_id |
164 $$), | 164 $$), |
165 ('waterway', 'bottlenecks_geoserver', 4326, $$ | 165 ('waterway', 'bottlenecks_geoserver', 4326, $$ |
166 SELECT | 166 SELECT |
167 b.id, | 167 b.id, |
168 b.bottleneck_id, | 168 b.bottleneck_id, |
225 SELECT | 225 SELECT |
226 sd.id AS id, | 226 sd.id AS id, |
227 bn.objnam AS objnam, | 227 bn.objnam AS objnam, |
228 srm.date_info AS minuend, | 228 srm.date_info AS minuend, |
229 srs.date_info AS subtrahend, | 229 srs.date_info AS subtrahend, |
230 sdcl.height AS height, | 230 sdia.height AS height, |
231 sdcl.lines AS lines | 231 sdia.areas AS areas |
232 FROM caching.sounding_differences sd | 232 FROM caching.sounding_differences sd |
233 JOIN caching.sounding_differences_contour_lines sdcl | 233 JOIN caching.sounding_differences_iso_areas sdia |
234 ON sd.id = sdcl.sounding_differences_id | 234 ON sd.id = sdia.sounding_differences_id |
235 JOIN waterway.sounding_results srm | 235 JOIN waterway.sounding_results srm |
236 ON sd.minuend = srm.id | 236 ON sd.minuend = srm.id |
237 JOIN waterway.sounding_results srs | 237 JOIN waterway.sounding_results srs |
238 ON sd.subtrahend = srs.id | 238 ON sd.subtrahend = srs.id |
239 JOIN waterway.bottlenecks bn | 239 JOIN waterway.bottlenecks bn |
250 waterway.distance_marks_geoserver, | 250 waterway.distance_marks_geoserver, |
251 waterway.distance_marks_ashore_geoserver, | 251 waterway.distance_marks_ashore_geoserver, |
252 waterway.bottlenecks_geoserver, | 252 waterway.bottlenecks_geoserver, |
253 waterway.stretches_geoserver, | 253 waterway.stretches_geoserver, |
254 waterway.sections_geoserver, | 254 waterway.sections_geoserver, |
255 waterway.sounding_results_contour_lines_geoserver, | |
256 waterway.bottleneck_overview, | 255 waterway.bottleneck_overview, |
256 waterway.sounding_results_areas_geoserver, | |
257 waterway.sounding_differences; | 257 waterway.sounding_differences; |