britiger / osm_address_db

Importing addresses into postgres using imposm3, the website uses the collection of scripts, shows data from Brandenburg, Germany
https://addresses.lorenz.lu/
10 stars 1 forks source link

Add postcode and centered lat/lon for each street in city_roads.csv #14

Open make125 opened 6 years ago

make125 commented 6 years ago

Is this possible? And thank you for the scripts!!

britiger commented 6 years ago

Thanks for this very complex issue. There are two possible sources for the postcode:

To get the centered lat/lon I need to split the roads into groups, e.g. by postcodes as suggested. Because there are roads with same names within big cities. If there no postal_code on some segments of the roads it causes that the road will be listed twice: with and without postcode, also if the road is the same logical. The other problem is if the equal named roads without postal_code in 2 different suburbs will be combined, so it generate a wrong lat/lon if I use the center. I'll try to find a solution for this problem. This is the reason why I don't implement this at this time.

If I have some time I will try to implement a solution without solve the last described problem to generate a new script which generates a new city_postcode_roads.csv

make125 commented 6 years ago

Great!! Thank you