Dutch address bulk geocoder from CSV to CSV by using the PDOK api for address coordinates retrieval in RD and WGS84.
This python script loops through different corrections and cleanup actions when nothing is found untill the address name matches.
The script tries to look for regular used column names and uses these to add to the api. The api is filled with each cel that is found in these columns which contains:
address (with number and subdivision in one cell), address and number separate or addres, number, subdivision separate.
Keep in mind, there must be at least an address and city column, else the geocoder will not work properly:
http://geodata.nationaalgeoregister.nl/geocoder/Geocoder?zoekterm="+address+number+subdivision+ city
usage:
Use the terminal or command line
>>> python address_cleanup_pdok.py your_filename.csv
output:
This wil output the file as:
your_filename_BAG_geocoded.csv
and
your_filename_BAG_notfound.csv
for debugging and list of mismatched addresses