Mercurial > gemma

changeset 2128:bc310a0b5bae

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Flatten location code in distance marks view This enables GeoServer to serve the attribute and thus it will be user visible in the client via the identify tool.
author Tom Gottfried <tom@intevation.de>
date Wed, 06 Feb 2019 15:35:30 +0100
parents a1f2cfa624cf
children 8f6345ad5f13 f3aabc05f9b2
files schema/gemma.sql
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/schema/gemma.sql	Wed Feb 06 15:23:30 2019 +0100
+++ b/schema/gemma.sql	Wed Feb 06 15:35:30 2019 +0100
@@ -329,7 +329,7 @@
     -- At least geoserver-2.13.2 does not serve type geography correctly
     -- and does not serve the location_code as isrs type
     CREATE VIEW distance_marks_geoserver AS
-        SELECT location_code::VARCHAR,
+        SELECT isrs_asText(location_code),
                geom::Geometry(POINT, 4326),
                related_enc,
                (location_code).hectometre