NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the 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

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:

×710
×263
×129

question asked: 16 May '12, 13:41

question was seen: 2,255 times

last updated: 16 May '12, 14:10

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum