Mercurial > gemma

comparison schema/geoserver_views.sql @ 3010:293bdd05ffcd

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Remove unnecessary indentation
author Tom Gottfried <tom@intevation.de>
date Thu, 11 Apr 2019 12:13:27 +0200
parents ddc4d54b8331
children 232fc90e6ee2
comparison
equal deleted inserted replaced
3009:ddc4d54b8331 3010:293bdd05ffcd
126 bn.objnam AS objnam, 126 bn.objnam AS objnam,
127 srm.date_info AS minuend, 127 srm.date_info AS minuend,
128 srs.date_info AS subtrahend, 128 srs.date_info AS subtrahend,
129 sdcl.height AS height, 129 sdcl.height AS height,
130 CAST(sdcl.lines AS geometry(multilinestring, 4326)) AS lines 130 CAST(sdcl.lines AS geometry(multilinestring, 4326)) AS lines
131 FROM 131 FROM caching.sounding_differences sd
132 caching.sounding_differences sd 132 JOIN caching.sounding_differences_contour_lines sdcl
133 JOIN caching.sounding_differences_contour_lines sdcl 133 ON sd.id = sdcl.sounding_differences_id
134 ON sd.id = sdcl.sounding_differences_id 134 JOIN waterway.sounding_results srm
135 JOIN waterway.sounding_results srm 135 ON sd.minuend = srm.id
136 ON sd.minuend = srm.id 136 JOIN waterway.sounding_results srs
137 JOIN waterway.sounding_results srs 137 ON sd.subtrahend = srs.id
138 ON sd.subtrahend = srs.id 138 JOIN waterway.bottlenecks bn
139 JOIN waterway.bottlenecks bn 139 ON srm.bottleneck_id = bn.id;
140 ON srm.bottleneck_id = bn.id;