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 _______________________________________________ Talk-be mailing list [email protected] https://lists.openstreetmap.org/listinfo/talk-be
