# HG changeset patch
# User Bernhard Reiter <bernhard@intevation.de>
# Date 1552047752 -3600
# Node ID 802d2a62b4bcdbb26b10e073d82c19a59430f502
# Parent  91c68153e7b62aed03d5051c388de0e90677f599
schema: fix bottleneck_overview's project

 * Add an explicit SRID to the point type cast, so that Geoserver
   can recognise the projection.

diff -r 91c68153e7b6 -r 802d2a62b4bc schema/gemma.sql
--- 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