# HG changeset patch
# User Thomas Junk <thomas.junk@intevation.de>
# Date 1552048691 -3600
# Node ID f3211d88831726d578c8af5de7da5b74ba7b21d5
# Parent  d9e1db955d4996b6f1eb4ed7939b496522861fdf# Parent  802d2a62b4bcdbb26b10e073d82c19a59430f502
merge

diff -r d9e1db955d49 -r f3211d888317 schema/gemma.sql
--- 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