Mercurial > gemma
changeset 744:6fe6839f5ce6
Make search return an array of features, including name.
This form should be sufficiently generic.
author | Sascha Wilde <wilde@intevation.de> |
---|---|
date | Mon, 24 Sep 2018 13:51:26 +0200 |
parents | fdff2de616ad |
children | 97b0beecf7c3 |
files | pkg/controllers/search.go |
diffstat | 1 files changed, 5 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/pkg/controllers/search.go Mon Sep 24 13:26:57 2018 +0200 +++ b/pkg/controllers/search.go Mon Sep 24 13:51:26 2018 +0200 @@ -12,8 +12,11 @@ ) const ( - searchHectometreSQL = `SELECT ST_AsGeoJSON(geom) FROM waterway.distance_marks -WHERE (location_code).hectometre = $1` + searchHectometreSQL = `SELECT json_agg(r) +FROM (SELECT location_code::text AS name, + ST_AsGeoJSON(geom)::json AS geom + FROM waterway.distance_marks + WHERE (location_code).hectometre = $1) r` ) var rkmRegex = regexp.MustCompile(