Mercurial > gemma
changeset 2560:f3211d888317
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