Mercurial > gemma

comparison schema/gemma.sql @ 2558:802d2a62b4bc

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
schema: fix bottleneck_overview's project * Add an explicit SRID to the point type cast, so that Geoserver can recognise the projection.
author Bernhard Reiter <bernhard@intevation.de>
date Fri, 08 Mar 2019 13:22:32 +0100
parents fc7d828695c9
children f4c399a496cb
comparison
equal deleted inserted replaced
2557:91c68153e7b6 2558:802d2a62b4bc
590 ) 590 )
591 591
592 CREATE VIEW bottleneck_overview AS 592 CREATE VIEW bottleneck_overview AS
593 SELECT 593 SELECT
594 objnam AS name, 594 objnam AS name,
595 ST_Centroid(area)::Geometry AS point, 595 ST_Centroid(area)::Geometry(POINT, 4326) AS point,
596 (lower(stretch)).hectometre AS from, 596 (lower(stretch)).hectometre AS from,
597 (upper(stretch)).hectometre AS to, 597 (upper(stretch)).hectometre AS to,
598 sr.current::text 598 sr.current::text
599 FROM bottlenecks bn LEFT JOIN ( 599 FROM bottlenecks bn LEFT JOIN (
600 SELECT bottleneck_id, max(date_info) AS current FROM sounding_results 600 SELECT bottleneck_id, max(date_info) AS current FROM sounding_results