How to get all nodes of a polygon (for buildings) with one known inside node

Question

Hi everyone!

I'm now using OSMnx to extract data for buildings. What I need is the addresses for buildings along with their footprint data. The question I met is about some of the buildings have multiple addresses, thus there are no address data for that building's polygon.

For example, the building 'Furutorpsgatan 49A' (in Helsingborg, Sweden) has three nodes you can search for, which are:

Furutorpsgatan 49A; Furutorpsgatan 49B; Gustav Adolfs Gata 23

alt text

but if you export the geometry data (polygon), there's no address data at all!

I was trying to use OSMid for polygons to match the position, but I can't find the building with OSMid 'w483244917'

Then I'm thinking is there any method I can export the polygon data through one or several nodes inside?

Or could you suggest me some methods to get any building footprint polygons through building addresses?

Thank you!

Answer 1

Import data into PostGIS with osm2pgsql, then

SELECT way
FROM planet_osm_polygon
WHERE ST_CONTAINS(way, 
   (SELECT way FROM planet_osm_point 
   WHERE osm_id=1234))
AND building IS NOT NULL;

will find you the building outline that contains the node with the id 1234. Of course you could also query for the node properties with something like WHERE tags->'addr:street'='something' and so on. (This syntax with tags assumes you have imported with the "hstore" option.)

How to get all nodes of a polygon (for buildings) with one known inside node

Follow this question

Related questions