Skip to content
Tools to work with the CRAB open data
Python
Pull request Compare This branch is 4 commits ahead, 1 commit behind pietercolpaert:master.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Failed to load latest commit information.
crab_csv
python
.gitignore
README.md

README.md

CRAB : the address - geocode database for Flanders

Set up

Download the CRAB db from http://download.agiv.be/Producten/Detail?id=102&title=CRAB_adresposities (it's free and open)

Be sure to have a postgis ready.

After you have unzipped the files, run this:

ogr2ogr -a_srs EPSG:31370 -f "PostgreSQL" PG:"host=localhost user=... dbname=... password=... port=5432" GML/terrobj.gml -overwrite

Wait for ~4hours (on a machine with 4 cores and an SSD)

(there are some common pitfalls when installing postgis. Just use the internet to get you out there if stuck.)

Tools

Load the DBF (the data files) in the postgresql db:

First change them to csv using your favourite tool (a perl file in the bin/ folder of this repo may help)

This script will again take a long time, but afterwards, the most important tables can again be ingested in the postgresdb:

CREATE TABLE tablename
( columns and types );
COPY tablename FROM 'foo/bar.csv' DELIMITER ',' CSV;
Something went wrong with that request. Please try again.