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

[Linusable]

good news !
I suppose it will be useful to put a reference or a copy of the 
Multipharma authorization somewhere on the wiki (belgian project ?).
What are the usual guidelines ?

Linusable

Le 19/05/11 11:06, Pol a écrit :
>
> 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/20110519/a15180bb/attachment.htm>