[OSM-talk-be] AGIV CRAB import

[Ben Abelshausen]

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 <kurt at roeckx.be> 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
> Talk-be at openstreetmap.org
> https://lists.openstreetmap.org/listinfo/talk-be
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk-be/attachments/20131111/7e399859/attachment.htm>