<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
good news !<br>
I suppose it will be useful to put a reference or a copy of the
Multipharma authorization somewhere on the wiki (belgian project ?).<br>
What are the usual guidelines ?<br>
<br>
Linusable<br>
<br>
Le 19/05/11 11:06, Pol a écrit :
<blockquote
cite="mid:BANLkTim0Hy4HGcYRgDyRHaNPc2HqAF_Y0w@mail.gmail.com"
type="cite">
<p>Hello, </p>
<p>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 !</p>
<p>The file is raw and needs to be parsed and cleaned.</p>
<p>I did that part and the file is now converted into a .osm.</p>
<p>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.<br>
To convert the csv file into something usable like a .osm, I
used a custom python script I can share.</p>
<p>My questions are:<br>
</p>
<ol>
<li>How to be sure not to override existing data ?</li>
<li>How to maintain such a list ?<br>
I mean, if I receive an updated CSV in some month, should I
upload the whole set ? What about duplicates then ?</li>
<li>After work, the current fields in the CSV are</li>
<ol>
<li>Latitude</li>
<li>Longitude</li>
<li>Country</li>
<li>Name</li>
<li>addr:postcode</li>
<li>addr:city</li>
<li>addr:street</li>
<li>addr:housenumber</li>
<li>phone</li>
<li>fax</li>
<li>amenity<br>
<br>
Should I add more fields ? Source ? addr:full ? something
else ?<br>
<br>
</li>
</ol>
<li>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.</li>
</ol>
<div>Thanks for the help !</div>
<p><br>
</p>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Talk-be mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Talk-be@openstreetmap.org">Talk-be@openstreetmap.org</a>
<a class="moz-txt-link-freetext" href="http://lists.openstreetmap.org/listinfo/talk-be">http://lists.openstreetmap.org/listinfo/talk-be</a>
</pre>
</blockquote>
<br>
</body>
</html>