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

[Chris Browet]

Just for info, note that there is a CSV import module in Merkaartor.
If features are missing, don't hesitate to request them on the merkaartor
mailing list, or via ticket on http://merkaartor.be

- Chris -

On Thu, May 19, 2011 at 11:06, Pol <d.paolino at gmail.com> wrote:

> 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/d27ff4cf/attachment.htm>