Why not ask your question on the new OpenStreetMap Community Forum?

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
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×700
×261
×127

question asked: 16 May '12, 13:41

question was seen: 2,101 times

last updated: 16 May '12, 14:10

powered by OSQA