Mercurial > gemma

changeset 2560:f3211d888317

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
merge
author Thomas Junk <thomas.junk@intevation.de>
date Fri, 08 Mar 2019 13:38:11 +0100
parents d9e1db955d49 (current diff) 802d2a62b4bc (diff)
children 4d5f419a2318
files
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/schema/gemma.sql	Fri Mar 08 13:36:24 2019 +0100
+++ b/schema/gemma.sql	Fri Mar 08 13:38:11 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