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 |
I think the problem is that I was using planet_osm_points rather than planet_osm_polygons