Hot answers tagged query
Create a view CREATE VIEW v_location AS SELECT id, name, address, ST_AsGeoJSON (location) AS location FROM "locations"; Use the "SELECT *" on it: SELECT * FROM v_location where "locations"."id" = 2 limit 1
I found a solution without python and postgis, using the graphical modeller. Here is a summarized explanation. Step 1: extract end nodes with v.to.point give them a unique id give them a new attribute roadtype based on following expression case when highway IN ('path','footway','footpath','steps','cycleway','pedestrian','track','bridleway') ...
Only top voted, non community-wiki answers of a minimum length are eligible