Two entries for postal code 63263

rockstaedt commented 9 months ago

Hi there!

Thanks a lot for this cool API. We are using it to prefill city and district names when a postal code is entered.

However, we came across the issue that a request for the postal code 63263 returns two entries:

Request: https://openplzapi.org/de/Localities?postalCode=63263&page=1&pageSize=10

Result:

[
{
    "postalCode": "63263",
    "name": "Frankfurt am Main",
    "municipality": {
        "key": "06412000",
        "name": "Frankfurt am Main, Stadt",
        "type": "Kreisfreie_Stadt"
    },
    "district": {
        "key": "06412",
        "name": "Frankfurt am Main, Stadt",
        "type": "Kreisfreie_Stadt"
    },
    "federalState": {
        "key": "06",
        "name": "Hessen"
    }
},
{
    "postalCode": "63263",
    "name": "Neu-Isenburg",
    "municipality": {
        "key": "06438009",
        "name": "Neu-Isenburg, Stadt",
        "type": "Stadt"
    },
    "district": {
        "key": "06438",
        "name": "Offenbach",
        "type": "Landkreis"
    },
    "federalState": {
        "key": "06",
        "name": "Hessen"
    }
}
]

When I search for 63263, I only get Neu-Isenburg as the city and not Frankfurt am Main. Since we only use the first result, user were complaining that the wrong city was prefilled. I am the opinion that postal codes in Germany are unique, aren't they?

Is this intended or can it be fixed? I am happy to help if I am directed in the right direction :)

rockstaedt commented 9 months ago

Ah I also searched the street.csv file for the postal code.

63263 in combination with Neu-Isenburg exists over 200 times whereas 63263 in combination with Frankfurt am Main only three times.

fstueber commented 8 months ago

This seems to be a bug in merging OSM data with GV100AD data.

rockstaedt commented 8 months ago

Alright :) And where can this be fixed? The repo only contains the data, doesn't it?

fstueber commented 8 months ago

Yes, exactly. The workflow for extracting and merging data is not yet open sourced. I will try to look into this in the coming days.

rockstaedt commented 8 months ago

Okidoki, thanks a lot!

rockstaedt commented 1 month ago

Any news here?

fstueber commented 1 month ago

No yet. Sorry. But it is not forgotten :-)

openpotato / openplzapi.data

Two entries for postal code 63263 #3