Hot answers tagged

3

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


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