Hi Kurt, Your tool may come in handy when generating diffs because it has a database. I deliberately did not use a database because it can be a lot of work to set this up and I believe the AGIV CRAB data should be usable by anyone.
The interface here is translated: http://addr.openstreetmap.fr/vlaanderen/ I just send the csv files to frédéric rodrigo and he uploads them and creates relations etc. If you can send me a new file that would be great when the issue I had have been solved: - Improve the script to handle 'special' chars. - Improve the script to Always take the most accurate position. - Improve the script to remove data with an end-date before today. But if i followed your explanation this should all be ok no? Thanks for the good work. Oh and can you keep the format I used? https://www.dropbox.com/s/w0nglkunw4x2osk/crab.csv Dot-comma seperated and the same columns? This will make it easier for frederic to update. Met vriendelijke groeten, Best regards, Ben Abelshausen On Sun, Nov 10, 2013 at 7:44 PM, Kurt Roeckx <[email protected]> wrote: > 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 >
_______________________________________________ Talk-be mailing list [email protected] https://lists.openstreetmap.org/listinfo/talk-be
