Mercurial > gemma

comparison schema/geoserver_views.sql @ 3307:b90b17d0b5a9 sections-backend

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
added sections_geoserver view, renamed stretch column to section in schema
author Markus Kottlaender <markus@intevation.de>
date Fri, 17 May 2019 11:28:20 +0200
parents ec6163c6687d
children 3e7a670896bd
comparison
equal deleted inserted replaced
3305:5932f9574493 3307:b90b17d0b5a9
98 FROM waterway.stretch_countries 98 FROM waterway.stretch_countries
99 WHERE stretches_id = id) AS countries, 99 WHERE stretches_id = id) AS countries,
100 staging_done 100 staging_done
101 FROM waterway.stretches; 101 FROM waterway.stretches;
102 102
103 CREATE OR REPLACE VIEW waterway.sections_geoserver AS
104 SELECT
105 id,
106 name,
107 (section).lower::varchar as lower,
108 (section).upper::varchar as upper,
109 area::Geometry(MULTIPOLYGON, 4326),
110 objnam,
111 nobjnam,
112 date_info,
113 source_organization,
114 staging_done
115 FROM waterway.sections;
116
103 CREATE OR REPLACE VIEW waterway.sounding_results_contour_lines_geoserver AS 117 CREATE OR REPLACE VIEW waterway.sounding_results_contour_lines_geoserver AS
104 SELECT bottleneck_id, 118 SELECT bottleneck_id,
105 date_info, 119 date_info,
106 height, 120 height,
107 CAST(lines AS geometry(multilinestring, 4326)) AS lines 121 CAST(lines AS geometry(multilinestring, 4326)) AS lines