I have imported osm data into PostgreSQL using this command
Now how can i get all the ways of a city(or a bounding region). asked 31 Mar '18, 15:20 _partha aseerel4c26 ♦ |
NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum
I have imported osm data into PostgreSQL using this command
Now how can i get all the ways of a city(or a bounding region). asked 31 Mar '18, 15:20 _partha aseerel4c26 ♦ |
Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
Question tags:
question asked: 31 Mar '18, 15:20
question was seen: 1,080 times
last updated: 11 May '18, 02:53
NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum
with postgis, you have just to intersect you box with the col way ( example : select * from planet_osm_way where "way" && ST_SetSRID ('BOX3D(-11704037.77103247 4811252.308384717, -11660010.04274018 4855280.036677003)'::box3d, 3857) ; )