NLExtract provides Open Source datasets and tools for Dutch geodata.
They provide some great tools and documentation for PostgresSQL and PostGIS. Check it out at http://www.nlextract.nl
To access the BAG (Basisregistratie Adressen en Gebouwen) CSV data using an Oracle database (on a Linux server), I did the following:
Linux, as OS user root:
Linux, as OS user oracle:
Download the latest CSV data file (.zip) here: http://data.nlextract.nl/
Extract it, and copy the bagadres.csv file to /bag_import
Create a new schema/user BAG.
Now you can query the data like this:
And make a real table out of it like this (much faster, especially if you add the right indexes):
Some of the data seems incorrect - this is a first attempt to find some obvious errors: