From two layers in PostGIS (osm_places and osm_roads), I would need to have the roads belonging to a certain city.
It would be fair enough to get the street names of all streets in a radius of X kilometers from the coordinates of the point of osm_places.
The query I'm looking for is something like
SELECT OSM_ID FROM OSM_ROADS INNER JOIN OSM_PLACES WHERE DISTANCE_OF(LOCATION(OSM_ROADS), LOCATION(OSM_PLACES)) <= X AND OSM_PLACES.NAME = 'My City'
Can somebody point me in a direction please?
Thank you in advance,