Hi all, I'm currently struggling with the export of address data, checked already a bunch of discussions about here, but still found no solution... Use case: I need a bunch/huge set of addresses per country with lat, lon, country, city, street and optionally housenumber. Important is, that lat/lon is nearly matching to the address/street for geo selection demo content. So I tried with a small test pbf (Liechtenstein) osmconvert: osmconvert %1.clean.o5m --all-to-nodes --csv="@id @lat @lon addr:country addr:postcode addr:city addr:street addr:housenumber amenity" --csv-headline --csv-separator=";" -o=%1.csv Fine. After filtering in excel (sufficient in this case) the blank/incomplete entries it's what I'm looking for. Next I've tried osmfilter with goal to remove exactly the same incomplete entries (of course, before I run osmconvert): osmfilter %1.o5m --keep="addr:country= and addr:city= and addr:street=" --ignore-dependencies --drop-relations --drop-ways -o=%1.clean.o5m Afterwards I compared the results: - osmconvert and manual filtering with excel: 91 records - osmfilter and osmconvert: 26 records But... - Why are the results different? What does osmfilter suppress additionally? Can I use it just to suppress the empty/incomplete entries? - 91 complete addresses is looking litte bit less for me for Liechtenstein. How can I get as much as possible valid geocode + address information like described above? - Is an alternative public address data set with lon, lat, country, city..., cleaned-up and best in csv format, already available? Thanks for support, Regards, Joerg

Hi all, I'm currently struggling with the export of address data, checked already a bunch of discussions about here, but still found no solution... Use case: I need a bunch/huge set of addresses per country with lat, lon, country, city, street and optionally housenumber. Important is, that lat/lon is nearly matching to the address/street for geo selection demo content. So I tried with a small test pbf (Liechtenstein) osmconvert: osmconvert %1.clean.o5m --all-to-nodes --csv="@id @lat @lon addr:country addr:postcode addr:city addr:street addr:housenumber amenity" --csv-headline --csv-separator=";" -o=%1.csv Fine. After filtering in excel (sufficient in this case) the blank/incomplete entries it's what I'm looking for. Next I've tried osmfilter with goal to remove exactly the same incomplete entries (of course, before I run osmconvert): osmfilter %1.o5m --keep="addr:country= and addr:city= and addr:street=" --ignore-dependencies --drop-relations --drop-ways > %1.clean.o5m -o=%1.clean.o5m Afterwards I compared the results: - osmconvert and manual filtering with excel: 91 records - osmfilter and osmconvert: 26 records But... - Why are the results different? What does osmfilter suppress additionally? Can I use it just to suppress the empty/incomplete entries? - 91 complete addresses is looking litte bit less for me for Liechtenstein. How can I get as much as possible valid geocode + address information like described above? - Is an alternative public address data set with lon, lat, country, city..., cleaned-up and best in csv format, already available? Thanks for support, Regards, Joerg

Hi all, I'm currently struggling with the export of address data, checked already a bunch of discussions about here, but still found no solution... Use case: I need a bunch/huge set of addresses per country with lat, lon, country, city, street and optionally housenumber. Important is, that lat/lon is nearly matching to the address/street for geo selection demo content. So I tried with a small test pbf (Liechtenstein) osmconvert: osmconvert %1.clean.o5m --all-to-nodes --csv="@id @lat @lon addr:country addr:postcode addr:city addr:street addr:housenumber amenity" --csv-headline --csv-separator=";" -o=%1.csv Fine. After filtering in excel (sufficient in this case) the blank/incomplete entries it's what I'm looking for. Next I've tried osmfilter with goal to remove exactly the same incomplete entries (of course, before I run osmconvert): osmfilter %1.o5m --keep="addr:country= and addr:city= and addr:street=" --ignore-dependencies --drop-relations --drop-ways > %1.clean.o5m Afterwards I compared the results: - osmconvert and manual filtering with excel: 91 records - osmfilter and osmconvert: 26 records So now to my questions: But... - Why are the results different? What does osmfilter suppress additionally? Can I use it just to suppress the empty/incomplete entries? - 91 complete addresses is looking litte bit less for me for Liechtenstein. How can I get as much as possible valid geocode + address information like described above? - Is an alternative public address data set with lon, lat, country, city..., cleaned-up and best in csv format, already available? Thanks for support, Regards, Joerg

Hi all, I'm currently struggling with the export of address data, checked already a bunch of discussions about here, but still found no solution... Use case: I need a bunch/huge set of addresses per country with lat, lon, country, city, street and optionally housenumber. Important is, that lat/lon is nearly matching to the address/street for geo selection demo content. So I tried with a small test pbf (Liechtenstein) osmconvert: osmconvert %1.clean.o5m --all-to-nodes --csv="@id @lat @lon addr:country addr:postcode addr:city addr:street addr:housenumber amenity" --csv-headline --csv-separator=";" -o=%1.csv Fine. After filtering in excel (sufficient in this case) the blank/incomplete entries it's what I'm looking for. Next I've tried osmfilter with goal to remove exactly the same incomplete entries (of course, before I run osmconvert): osmfilter %1.o5m --keep="addr:country= and addr:city= and addr:street=" --ignore-dependencies --drop-relations --drop-ways > %1.clean.o5m Afterwards I compared the results: - osmconvert and manual filtering with excel: 91 records - osmfilter and osmconvert: 26 records So now to my questions: - Why are the results different? What does osmfilter suppress additionally? additionally? Can I use it just to suppress the empty/incomplete entries? - 91 complete addresses is looking litte bit less for me for Liechtenstein. How can I get as much as possible valid geocode + address information like described above? - Is an alternative public address data set with lon, lat, country, city..., cleaned-up and best in csv format, already available? Thanks for support, Regards, Joerg

Hi all, I'm currently struggling with the export of address data, checked already a bunch of discussions about here, but still found no solution... Use case: I need a bunch/huge set of addresses per country with lat, lon, country, city, street and optionally housenumber. Important is, that lat/lon is nearly matching to the address/street for geo selection demo content. So I tried with a small test pbf (Liechtenstein) osmconvert: osmconvert %1.clean.o5m --all-to-nodes --csv="@id @lat @lon addr:country addr:postcode addr:city addr:street addr:housenumber amenity" --csv-headline --csv-separator=";" -o=%1.csv Fine. After filtering in excel (sufficient in this case) the blank/incomplete entries it's what I'm looking for. Next I've tried osmfilter with goal to remove exactly the same incomplete entries (of course, before I run osmconvert): osmfilter %1.o5m --keep="addr:country= and addr:city= and addr:street=" --ignore-dependencies --drop-relations --drop-ways > %1.clean.o5m Afterwards I compared the results: - osmconvert and manual filtering with excel: 91 records - osmfilter and osmconvert: 26 records So now to my questions: - Why are the results different? What does osmfilter suppress additionally? - 91 complete addresses is looking litte bit less for me for Liechtenstein. How can I get as much as possible valid geocode + address information like described above? - Is a an alternative public download possibility existing for addresses like described before? address data set with lon, lat, country, city..., cleaned-up and best in csv format, already available? Thanks for support, Regards, Joerg

Hi all, I'm currently struggling with the export of address data, checked already a bunch of discussions about here, but still found no solution... Use case: I need a bunch/huge set of addresses per country with lat, lon, country, city, street and optionally housenumber. Important is, that lat/lon is nearly matching to the address/street for geo selection demo content. So I tried with a small test pbf (Liechtenstein) osmconvert: osmconvert %1.clean.o5m --all-to-nodes --csv="@id @lat @lon addr:country addr:postcode addr:city addr:street addr:housenumber amenity" --csv-headline --csv-separator=";" -o=%1.csv Fine. After filtering in excel (sufficient in this case) the blank/incomplete entries it's what I'm looking for. Next I've tried osmfilter with goal to remove exactly the same incomplete entries (of course, before I run osmconvert): osmfilter %1.o5m --keep="addr:country= and addr:city= and addr:street=" --ignore-dependencies --drop-relations --drop-ways > %1.clean.o5m Afterwards I compared the results: - osmconvert and manual filtering with excel: 91 records - osmfilter and osmconvert: 26 records Questions: So now to my questions: - Why are the results different? What does osmfilter suppress additionally? - 91 complete addresses is looking litte bit less for me for Liechtenstein. How can I get as much as possible valid geocode + address information like described above? - Is a public download possibility existing for addresses like described before? Thanks for support, Regards, Joerg

Hi all, I'm currently struggling with the export of address data, checked already a bunch of discussions about here, but still found no solution... Use case: I need a bunch/huge set of addresses per country with lat, lon, country, city, street and optionally housenumber. Important is, that lat/lon is nearly matching to the address/street for geo selection demo content. So I tried with a small test pbf (Liechtenstein) osmconvert: osmconvert %1.clean.o5m --all-to-nodes --csv="@id @lat @lon addr:country addr:postcode addr:city addr:street addr:housenumber amenity" --csv-headline --csv-separator=";" -o=%1.csv Fine. After filtering in excel (sufficient in this case) the blank/incomplete entries it's what I'm looking for. Next I've tried osmfilter with goal to remove exactly the same incomplete entries (of course, before I run osmconvert): osmfilter %1.o5m --keep="addr:country= and addr:city= and addr:street=" --ignore-dependencies --drop-relations --drop-ways > %1.clean.o5m Afterwards I compared the results: - osmconvert and manual filtering with excel: 91 records - osmfilter and osmconvert: 26 records Questions: - Why are the results different? What does osmfilter suppress additionally? - 91 complete addresses is looking litte bit less for me for Liechtenstein. How can I get as much as possible valid geocode + address information like described above? - Is a public download possibility existing for addresses like described before? Thanks for support, Regards, Joerg