Create BAG database

Description

It is used to process a big zip file that contains information off all buildings of the Netherlands including addresses.
These xml-files can not be read into QGIS without processing them first.

Currently this plugin is developed, tested and working on Windows OS and Linux.
Soon it will be supported on OSX OS as well.

First download the following two files using the link and place only those files in the folder that will be referred to as the input folder:

1. inspireadressen.zip
   http://geodata.nationaalgeoregister.nl/inspireadressen/extract/inspireadressen.zip
2. Tabel33 Gemeententabel (gesorteerd op omschrijving).csv
   http://www.bprbzk.nl/dsresource?objectid=16993&type=org

The file inspireadressen.zip that is downloaded is a zip-file holding many XML files. Never extract this zip file! It is a lot of data (about 60 GB) zipped it is only 1.4 GB.

Parameters

This folder should contain the two downloaded files that are used to read the information to create the BAG database.

The output folder is where you want to create the bag database.
If you select the folder C:\data\bag, the database C:\data\bag\bag.sqlite will be created.

Additional information

Processing will take a long time. It is a lot of data to process and it can take several hours. The better the hardware, the faster the processing.

After loading

Using QGIS relations, you can set up a relation between pand and verblijfsplaats.

• In QGIS select Project --> Project Properties...
• Select on the left side relation and add a relation using the button [Add Relation]

Provide following values in New relation dialog:

• * Name: Adressen
• * Referencing Layer (Child): verblijfplaats
• * Referencing Field: id_pand
• * Referenced Layer (Parent): pand
• * Referenced Field: id

On styles

When you rename or move the created spatialite database to another location, be aware that loaded styles are not applied anymore. You can easily solve this, see: http://www.qgis.nl/2015/10/27/spatialite-en-verdwenen-stijlen/?lang=en

Requirements

There are minimal requirement for the hardware.
Make sure you have at least:

• 20 GB diskspace available
• 3 GB of internal memory

Test resources

For test purposes there is a smaller inspireadressen.zip available that can be obtained using the next link referring to a public google drive folder:
https://drive.google.com/open?id=0B9t0iHYnTgnTWkFTWHJFMXRqN3M

An example of output is available on: http://qgis.nl/zwartsluis.zip

Created by Diethard Jansen, http://www.GIS-hulp.nl, 2015