Hot answers tagged


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 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