[OSM-talk-be] AGIV CRAB import

[Kurt Roeckx]

Hi,

I've been looking at creating my own tools for the CRAB data.
I've made some software to import the files provided by AGIV
into a postgresql database.  You can find it here:
https://github.com/kroeckx/crab-tools

To create the same .csv files as Ben generates I suggest you
use the following query:
SELECT
DISTINCT ON (point)
postcode, municipality_name, street_name, house_number_label, ST_Y(ST_Transform(point, 4326)), ST_X(ST_Transform(point, 4326))
FROM crab.address_position
WHERE postcode = ?
ORDER BY point;

This should give you more addresses and only the valid addresses,
and in most cases it should now end up on the building.  It should
also have grouped all the different numbers belonging to the same
building into 1 node.

I'm not sure how the data on http://addr.openstreetmap.fr/vlaanderen
is generated exactly.  But I'm going to look into improving
things.


Kurt