Mercurial > gemma
changeset 995:e03fab882b47
Use distance_marks_virtual table for search.
This is a (hot?) fix as the distance_marks table is now empty for some
reasons...
author | Sascha Wilde <wilde@intevation.de> |
---|---|
date | Mon, 22 Oct 2018 13:12:28 +0200 |
parents | d9cc1e906469 |
children | 839526f44f0f 26ca04caa330 |
files | pkg/controllers/search.go |
diffstat | 1 files changed, 1 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/pkg/controllers/search.go Mon Oct 22 13:09:26 2018 +0200 +++ b/pkg/controllers/search.go Mon Oct 22 13:12:28 2018 +0200 @@ -14,7 +14,7 @@ searchHectometreSQL = `SELECT COALESCE(json_agg(r),'[]') FROM (SELECT (location_code).hectometre || ' rhm' AS name, ST_AsGeoJSON(geom)::json AS geom - FROM waterway.distance_marks + FROM waterway.distance_marks_virtual WHERE (location_code).hectometre = $1) r` searchBottleneckSQL = `SELECT COALESCE(json_agg(r),'[]') FROM (SELECT objnam AS name,