Mercurial > gemma

comparison schema/updates/1300/02.views_to_geoservers.sql @ 4623:30bb2d819d57 geoserver_sql_views

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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;