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

[Pol]

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 !
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk-be/attachments/20110519/338a76c0/attachment.htm>