This is a static archive of our old OpenStreetMap Help Site. Please post any new questions and answers at community.osm.org.

Area relations

0

Hi, I'm new to OSM so please bear with me.

I've used osm2pgsql to produce a dataset from a small osm file (south yorkshire). What I'm trying to achieve is to be able to determine relationships, so for instance Crookes is a suburb in Sheffield which is a city in the United Kingdom.

I thought I was on to something when I saw that points that are places are also closed ways and so tried ST_XMax, ST_YMax etc on the way column to determine the bounding box. It seems however that these are just points (as ST_XMax and ST_XMin on place=city,name=Sheffield come back the same).

Am I completely on the wrong track, if so, can anyone point me in the right direction to achieve what I'm looking for?

asked 16 May '12, 13:41

TBriggs's gravatar image

TBriggs
1111
accept rate: 0%

I think the problem is that I was using planet_osm_points rather than planet_osm_polygons

(16 May '12, 14:10) TBriggs

Source code available on GitHub .