Skip to Main Content

Info

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

As sys:
Create a new schema/user BAG.

As 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:
As bag: