Mercurial > gemma

comparison schema/gemma.sql @ 697:77928a3497f1

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
schema: fix view distance_marks_geoserver
author Bernhard Reiter <bernhard@intevation.de>
date Thu, 20 Sep 2018 16:13:35 +0200
parents f595b3455d75
children aeaa2adf5a8b
comparison
equal deleted inserted replaced
691:d643ff60f607 697:77928a3497f1
287 SELECT location_code::VARCHAR, 287 SELECT location_code::VARCHAR,
288 geom::Geometry(POINT, 4326), 288 geom::Geometry(POINT, 4326),
289 distance_mark_function, 289 distance_mark_function,
290 position_code, 290 position_code,
291 (location_code).hectometre 291 (location_code).hectometre
292 FROM waterway.distance_marks; 292 FROM waterway.distance_marks
293 293
294 CREATE TABLE sections_stretches ( 294 CREATE TABLE sections_stretches (
295 id varchar PRIMARY KEY, 295 id varchar PRIMARY KEY,
296 is_section boolean NOT NULL, -- maps 'function' from interface 296 is_section boolean NOT NULL, -- maps 'function' from interface
297 stretch isrsrange, 297 stretch isrsrange,