Mercurial > gemma
changeset 2558:802d2a62b4bc
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