[OSM-talk-be] Importing csv, good practices and tips : Multipharma Case Study

[Jo]

That's very good news indeed. I'd like to see that Python script. I can also
help with integrating such Python script into JOSM.

It would be a nice challenge to create a script which can merge the existing
data with the source data and updated data. Remember that pharmacies can be
represented by POI nodes or by building outlines (closed ways). I should
probably check out this Merkaartor CSV file importer plugin.

Polyglot

2011/5/19 Pol <d.paolino at gmail.com>

> Hello,
>
> 3 weeks after my initial request, I received from the IT Director (E.
> Joos), a CSV file containing all the informations about each Multipharma in
> Belgium and the right to publish them on OSM ! Hooray !
>
> The file is raw and needs to be parsed and cleaned.
>
> I did that part and the file is now converted into a .osm.
>
> To do that, I used LibreOffice to transform some fields, it worked without
> problems, the CSV handling in LibreOffice is the best I ever seen.
> To convert the csv file into something usable like a .osm, I used a custom
> python script I can share.
>
> My questions are:
>
>
>    1. How to be sure not to override existing data ?
>    2. How to maintain such a list ?
>    I mean, if I receive an updated CSV in some month, should I upload the
>    whole set ? What about duplicates then ?
>    3. After work, the current fields in the CSV are
>       1. Latitude
>       2. Longitude
>       3. Country
>       4. Name
>       5. addr:postcode
>       6. addr:city
>       7. addr:street
>       8. addr:housenumber
>       9. phone
>       10. fax
>       11. amenity
>
>       Should I add more fields ? Source ? addr:full ? something else ?
>
>       4. What is the preferred file encoding when submitting ? Iso-8859-1
>    or UTF8 ? Is suppose this is the later, but I want to be sure.
>
> Thanks for the help !
>
>
>
> _______________________________________________
> Talk-be mailing list
> Talk-be at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/talk-be
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk-be/attachments/20110520/e4860420/attachment.htm>