search

openpotato / openplzapi.data

Raw data for the OpenPLZ API project
https://www.openplzapi.org
Open Data Commons Open Database License v1.0
22 stars 0 forks source link

Borough vs. Suburb? #5

Open mhupf opened 3 weeks ago

mhupf commented 3 weeks ago

Hi there,

I have a understanding problem with the columns "Borough" and "Suburb". On large cities with a borough (Deutsch: Stadtbezirk) I can find the suburb (Deutsch: Stadtteil) on the "Suburb" column:

Name,PostalCode,Locality,RegionalKey,Borough,Suburb
Am Theise,51143,Köln,05315000,Porz,Zündorf
Dischkaul,51143,Köln,05315000,Porz,Langel
Am Schmelzofen,51143,Köln,05315000,Porz,Porz

But on small cities when there's no borough, the suburb seems to be in the column of borough:

Name,PostalCode,Locality,RegionalKey,Borough,Suburb
Biberweg,36041,Fulda,06631009,Haimbach,

To get the suburb I have to check if the last column is empty. Is that the intended approach?

Shouldn't it be like this?

Name,PostalCode,Locality,RegionalKey,Borough,Suburb
Biberweg,36041,Fulda,06631009,,Haimbach
fstueber commented 3 weeks ago

The data for Boroughs and Suburbs are coming directly from OpenStreetMaps. And this data is not always consistent. Some larger cities do not have Borough or Suburb areas at all.