Mercurial > gemma
changeset 2128:bc310a0b5bae
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