Mercurial > gemma

changeset 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 91c68153e7b6
children f3211d888317
files schema/gemma.sql
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/schema/gemma.sql	Fri Mar 08 12:24:42 2019 +0100
+++ b/schema/gemma.sql	Fri Mar 08 13:22:32 2019 +0100
@@ -592,7 +592,7 @@
     CREATE VIEW bottleneck_overview AS
     SELECT
       objnam AS name,
-      ST_Centroid(area)::Geometry AS point,
+      ST_Centroid(area)::Geometry(POINT, 4326) AS point,
       (lower(stretch)).hectometre AS from,
       (upper(stretch)).hectometre AS to,
       sr.current::text