Hello, I need to get cities boundaries, I know how to do it by query the planet_osm_polygon table and get the exact result as in www.openstreetmap.org but its differ from the real city area as marked in grey

e.g Towcester: https://www.openstreetmap.org/relation/1641604

As it can see the area marked in orange is much bigger than the city area

asked 24 Dec '18, 15:08

altopalo's gravatar image

altopalo
412510
accept rate: 0%

edited 24 Dec '18, 15:09

2

What do you mean by "the real city area" exactly? It looks like the "area marked as grey" is mapped as landuse=residential. It doesn't correspond to any administrative boundary and naturally a city may have other landuses such as commercial or industrial.

(24 Dec '18, 15:29) alan_gr

Tn'x for the data So I looks for a way to get that 'grey area' (landuse=residential) from the osm dump DB. I assume the area I gets and also seen in the map is the administrative area of the city.

(24 Dec '18, 15:52) altopalo
2

Landuse=residential has nothing to do with administration, it simply marks areas of land that mappers perceive as primarily used for housing.

If you want adminstrative areas you will need to look at boundary relations, but that seems to be where you started as you already gave an example of such a relation.

(24 Dec '18, 18:35) alan_gr

Tn'x but I know how to get the administrative area.

I'm looking for a way to get the Landuse=residentialstrative area of specific city by query the postgis DB.

(25 Dec '18, 07:28) altopalo
2

Well, you'd query the database the same way as you did for the administrative boundary, but instead query for landuse=residential objects. As has been mentioned, though, this won't give you the complete area of a settlement. There will likely also be landuse=industrial, landuse=commercial, landuse=retail, leisure=park, amenity=school, and many other types of areas that together combine to form the area of the settlement. This also assumes that the landuses and other areas have all been mapped, which isn't guaranteed.

(27 Dec '18, 16:56) alester
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:

×95
×1

question asked: 24 Dec '18, 15:08

question was seen: 134 times

last updated: 27 Dec '18, 16:56

powered by OSQA