# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1549463730 -3600
# Node ID bc310a0b5bae65ffeef7344aefb5c324fc0f6acb
# Parent  a1f2cfa624cf4cc57327402571a92f519fc88266
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.

diff -r a1f2cfa624cf -r bc310a0b5bae schema/gemma.sql
--- 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