changeset 784:5616c6bfb186

Search: show more human readable results for rkm.
author Sascha Wilde <wilde@intevation.de>
date Wed, 26 Sep 2018 16:00:32 +0200
parents ab9604a46075
children 1d8ccdb532de
files pkg/controllers/search.go
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/controllers/search.go	Wed Sep 26 15:29:17 2018 +0200
+++ b/pkg/controllers/search.go	Wed Sep 26 16:00:32 2018 +0200
@@ -12,7 +12,7 @@
 
 const (
 	searchHectometreSQL = `SELECT COALESCE(json_agg(r),'[]')
-FROM (SELECT location_code::text AS name,
+FROM (SELECT (location_code).hectometre || ' rhm' AS name,
              ST_AsGeoJSON(geom)::json AS geom
       FROM waterway.distance_marks
       WHERE (location_code).hectometre = $1) r`