Mercurial > gemma
changeset 1024:96ea805d44b9
back end: Added new field "type" to search results.
author | Sascha Wilde <wilde@intevation.de> |
---|---|
date | Wed, 24 Oct 2018 12:29:25 +0200 |
parents | 337a7f4c8a16 |
children | a55f20dc8d8d |
files | pkg/controllers/search.go |
diffstat | 1 files changed, 3 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/pkg/controllers/search.go Wed Oct 24 12:24:26 2018 +0200 +++ b/pkg/controllers/search.go Wed Oct 24 12:29:25 2018 +0200 @@ -26,12 +26,13 @@ const ( searchHectometreSQL = `SELECT COALESCE(json_agg(r),'[]') FROM (SELECT (location_code).hectometre || ' rhm' AS name, - ST_AsGeoJSON(geom)::json AS geom + ST_AsGeoJSON(geom)::json AS geom, 'rhm' AS type FROM waterway.distance_marks_virtual WHERE (location_code).hectometre = $1) r` searchBottleneckSQL = `SELECT COALESCE(json_agg(r),'[]') FROM (SELECT objnam AS name, - ST_AsGeoJSON(ST_Centroid(area))::json AS geom + ST_AsGeoJSON(ST_Centroid(area))::json AS geom, + 'bottleneck' AS type FROM waterway.bottlenecks WHERE objnam ILIKE $1) r` )