<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><blockquote type="cite" class="">On 11 Dec 2014, at 10:33, Shohreh <<a href="mailto:codecomplete@free.fr" class="">codecomplete@free.fr</a>> wrote:<br class=""><br class="">Merci mais je ne sais pas trop comment modifier la requête construite par le wizard pour obtenir les données en CSV:<br class=""></blockquote><div><br class=""></div><div>La réponse était dans ce message que je croyais avoir envoyé à la liste, oups </div><div><br class=""></div><div><blockquote type="cite" class=""><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;" class=""><span style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, sans-serif; color:rgba(0, 0, 0, 1.0);" class=""><b class="">From: </b></span><span style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, sans-serif;" class="">Yves Pratter <<a href="mailto:yves.pratter@gmail.com" class="">yves.pratter@gmail.com</a>><br class=""></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;" class=""><span style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, sans-serif; color:rgba(0, 0, 0, 1.0);" class=""><b class="">Subject: </b></span><span style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, sans-serif;" class=""><b class="">Re: [OSM-talk-fr] Envoyer requêtes à OSM et récupérer bike=shop?</b><br class=""></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;" class=""><span style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, sans-serif; color:rgba(0, 0, 0, 1.0);" class=""><b class="">Date: </b></span><span style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, sans-serif;" class="">10 Dec 2014 11:38:52 CET<br class=""></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;" class=""><span style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, sans-serif; color:rgba(0, 0, 0, 1.0);" class=""><b class="">To: </b></span><span style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, sans-serif;" class="">Marc Gemis <<a href="mailto:marc.gemis@gmail.com" class="">marc.gemis@gmail.com</a>><br class=""></span></div><br class=""><div class=""><meta http-equiv="Content-Type" content="text/html charset=utf-8" class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><br class=""><div class=""><blockquote type="cite" class=""><div class="">On 10 Dec 2014, at 09:22, Marc Gemis <<a href="mailto:marc.gemis@gmail.com" class="">marc.gemis@gmail.com</a>> wrote:</div><div class=""><div dir="ltr" class=""><div class="">excusez-moi pour mon pouvre français…</div></div></div></blockquote>Pas de problème, tu peux aussi écrire en anglais ;-)</div><div class=""><br class=""><blockquote type="cite" class=""><div dir="ltr" class=""><div class="">Une example pour shop=bicycle <span class="" style="font-size: 13px;">à Anvers</span></div></div></blockquote><blockquote type="cite" class=""><div class=""><div dir="ltr" class=""><div style="" class=""><div class="">dessous "data" . C'est quelque chose comme ça que vous voulez ?</div></div></div></div></blockquote>Presque ;-)</div><div class=""><br class=""></div><div class="">Je pense qu’il a besoin d’une sortie en CSV…</div><div class=""><br class=""></div><div class=""><a href="http://overpass-turbo.eu/s/6sb" class="">http://overpass-turbo.eu/s/6sb</a></div><div class=""><div class=""><font face="Courier New" class="">/*</font></div><div class=""><font face="Courier New" class="">This has been generated by the overpass-turbo wizard.</font></div><div class=""><font face="Courier New" class="">The original search was:</font></div><div class=""><font face="Courier New" class="">“shop=bike in Antwerpen”</font></div><div class=""><font face="Courier New" class="">*/</font></div><div class=""><font face="Courier New" class=""><b class="">[out:csv( ::lat, ::lon, name, phone, "addr:housenumber", "addr:street", "addr:postcode", "addr:city", website)]</b>[timeout:25];</font></div><div class=""><font face="Courier New" class="">// fetch area “Antwerpen” to search in</font></div><div class=""><font face="Courier New" class="">{{geocodeArea:Antwerpen}}->.searchArea;</font></div><div class=""><font face="Courier New" class="">// gather results</font></div><div class=""><font face="Courier New" class="">(</font></div><div class=""><font face="Courier New" class=""> // query part for: “shop=bike”</font></div><div class=""><font face="Courier New" class=""> node["shop"="bicycle"](area.searchArea);</font></div><div class=""><font face="Courier New" class=""> way["shop"="bicyle"](area.searchArea);</font></div><div class=""><font face="Courier New" class=""> relation["shop"="bicyle"](area.searchArea);</font></div><div class=""><font face="Courier New" class="">);</font></div><div class=""><font face="Courier New" class="">// print results</font></div><div class=""><font face="Courier New" class="">out body;</font></div><div class=""><font face="Courier New" class="">>;</font></div><div class=""><font face="Courier New" class="">out skel qt;</font></div><div class=""><font face="Courier New" class=""><br class=""></font></div><div class="">Avec un résultat comme ça :</div><div class=""><div class=""><font face="Courier New" class="">@lat<span class="Apple-tab-span" style="white-space:pre"> </span>@lon<span class="Apple-tab-span" style="white-space:pre"> </span>name<span class="Apple-tab-span" style="white-space:pre"> </span>phone<span class="Apple-tab-span" style="white-space:pre"> </span>addr:housenumber<span class="Apple-tab-span" style="white-space:pre"> </span>addr:street<span class="Apple-tab-span" style="white-space:pre"> </span>addr:postcode<span class="Apple-tab-span" style="white-space:pre"> </span>addr:city<span class="Apple-tab-span" style="white-space:pre"> </span>website</font></div><div class=""><font face="Courier New" class="">51.2094794<span class="Apple-tab-span" style="white-space: pre;"> </span>4.4294467<span class="Apple-tab-span" style="white-space: pre;"> </span>Vélo & co<span class="Apple-tab-span" style="white-space: pre;"> </span>+ 32 (0)3 298 95 88<span class="Apple-tab-span" style="white-space: pre;"> </span>124<span class="Apple-tab-span" style="white-space: pre;"> </span>Plantin en Moretuslei<span class="Apple-tab-span" style="white-space: pre;"> </span>2018<span class="Apple-tab-span" style="white-space: pre;"> </span>Antwerpen<span class="Apple-tab-span" style="white-space: pre;"> </span><a href="http://www.velo-en-co.be/" class="">http://www.velo-en-co.be/</a></font></div><div class=""><font face="Courier New" class="">51.2181604<span class="Apple-tab-span" style="white-space:pre"> </span>4.3977965<span class="Apple-tab-span" style="white-space:pre"> </span>De Ligfiets<span class="Apple-tab-span" style="white-space:pre"> </span>+32 3 293 74 56<span class="Apple-tab-span" style="white-space:pre"> </span>23<span class="Apple-tab-span" style="white-space:pre"> </span>Steenhouwersvest<span class="Apple-tab-span" style="white-space:pre"> </span>2000<span class="Apple-tab-span" style="white-space:pre"> </span>Antwerpen<span class="Apple-tab-span" style="white-space:pre"> </span><a href="http://www.ligfiets.be/index.php?selectie=deligfietsantwerpen" class="">http://www.ligfiets.be/index.php?selectie=deligfietsantwerpen</a></font></div><div class=""><font face="Courier New" class="">51.1997858<span class="Apple-tab-span" style="white-space:pre"> </span>4.4072691<span class="Apple-tab-span" style="white-space:pre"> </span>iBike Antwerpen<span class="Apple-tab-span" style="white-space:pre"> </span>+32 3 257 56 95<span class="Apple-tab-span" style="white-space:pre"> </span>215<span class="Apple-tab-span" style="white-space:pre"> </span>Lange Lozanastraat<span class="Apple-tab-span" style="white-space:pre"> </span>2018<span class="Apple-tab-span" style="white-space:pre"> </span>Antwerpen<span class="Apple-tab-span" style="white-space:pre"> </span><a href="http://www.ibike.be/over-ibike/winkels1/ibike-antwerpen/" class="">http://www.ibike.be/over-ibike/winkels1/ibike-antwerpen/</a></font></div><div class=""><font face="Courier New" class="">51.2328751<span class="Apple-tab-span" style="white-space:pre"> </span>4.4238604<span class="Apple-tab-span" style="white-space:pre"> </span>Odiel & Odette<span class="Apple-tab-span" style="white-space:pre"> </span>+32 3 283 04 56<span class="Apple-tab-span" style="white-space:pre"> </span>102<span class="Apple-tab-span" style="white-space:pre"> </span>Viaduct-Dam<span class="Apple-tab-span" style="white-space:pre"> </span>2060<span class="Apple-tab-span" style="white-space:pre"> </span>Antwerpen<span class="Apple-tab-span" style="white-space:pre"> </span><a href="http://www.odielenodette.com/" class="">http://www.odielenodette.com/</a></font></div><div class=""><br class=""></div><div class="">Après formatage ça devrait donner ça :</div><div class="">
<table cellspacing="0" border="0" class="">
<colgroup width="97" class=""></colgroup>
<colgroup width="88" class=""></colgroup>
<colgroup width="153" class=""></colgroup>
<colgroup width="154" class=""></colgroup>
<colgroup width="56" class=""></colgroup>
<colgroup width="163" class=""></colgroup>
<colgroup width="52" class=""></colgroup>
<colgroup width="101" class=""></colgroup>
<colgroup width="302" class=""></colgroup>
<tbody class=""><tr class="">
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" height="20" align="left" bgcolor="#9999FF" class=""><b class="">@lat</b></td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="left" bgcolor="#9999FF" class=""><b class="">@lon</b></td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="left" bgcolor="#9999FF" class=""><b class="">Nom</b></td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="left" bgcolor="#9999FF" class=""><b class="">Téléphone</b></td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000" align="right" bgcolor="#9999FF" class=""><b class="">N°</b></td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000" align="left" bgcolor="#9999FF" class=""><b class="">Rue</b></td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000" align="left" bgcolor="#9999FF" class=""><b class="">Code postal</b></td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000" align="left" bgcolor="#9999FF" class=""><b class="">Ville</b></td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="left" bgcolor="#9999FF" class=""><b class="">Site web</b></td>
</tr>
<tr class="">
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" height="20" align="right" sdval="51.2094794" sdnum="1033;" class="">51.2094794</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="right" sdval="4.4294467" sdnum="1033;" class="">4.4294467</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="left" bgcolor="#9999FF" class="">Vélo & co</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="left" class="">+ 32 (0)3 298 95 88</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000" align="right" sdnum="1033;0;@" class="">124</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000" align="left" class="">Plantin en Moretuslei</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000" align="left" sdnum="1033;0;@" class="">2018</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000" align="left" class="">Antwerpen</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="left" class=""><a href="http://www.velo-en-co.be/" class="">http://www.velo-en-co.be/</a></td>
</tr>
<tr class="">
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" height="20" align="right" sdval="51.2181604" sdnum="1033;" class="">51.2181604</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="right" sdval="4.3977965" sdnum="1033;" class="">4.3977965</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="left" bgcolor="#9999FF" class="">De Ligfiets</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="left" class="">+32 3 293 74 56</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000" align="right" sdnum="1033;0;@" class="">23</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000" align="left" class="">Steenhouwersvest</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000" align="left" sdnum="1033;0;@" class="">2000</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000" align="left" class="">Antwerpen</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="left" class=""><a href="http://www.ligfiets.be/index.php?selectie=deligfietsantwerpen" class="">http://www.ligfiets.be/index.php?selectie=deligfietsantwerpen</a></td>
</tr>
<tr class="">
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" height="20" align="right" sdval="51.1997858" sdnum="1033;" class="">51.1997858</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="right" sdval="4.4072691" sdnum="1033;" class="">4.4072691</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="left" bgcolor="#9999FF" class="">iBike Antwerpen</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="left" class="">+32 3 257 56 95</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000" align="right" sdnum="1033;0;@" class="">215</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000" align="left" class="">Lange Lozanastraat</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000" align="left" sdnum="1033;0;@" class="">2018</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000" align="left" class="">Antwerpen</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="left" class=""><a href="http://www.ibike.be/over-ibike/winkels1/ibike-antwerpen/" class="">http://www.ibike.be/over-ibike/winkels1/ibike-antwerpen/</a></td>
</tr>
<tr class="">
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" height="20" align="right" sdval="51.2328751" sdnum="1033;" class="">51.2328751</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="right" sdval="4.4238604" sdnum="1033;" class="">4.4238604</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="left" bgcolor="#9999FF" class="">Odiel & Odette</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="left" class="">+32 3 283 04 56</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000" align="right" sdnum="1033;0;@" class="">102</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000" align="left" class="">Viaduct-Dam</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000" align="left" sdnum="1033;0;@" class="">2060</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000" align="left" class="">Antwerpen</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="left" class=""><a href="http://www.odielenodette.com/" class="">http://www.odielenodette.com/</a></td>
</tr>
</tbody></table><br class=""></div><div class="">Le problème, c’est pour les objets qui n’ont pas les champs <b class="">addr:housenumber</b>, <b class="">addr:street</b>, <b class="">addr:postcode</b>,<b class=""> addr:city</b>, il faut faire du <b class="">géocodage inverse</b> avec nominatim</div><div class=""><br class=""></div><div class="">Il faut écrire un petit outil ou demander à Martin Raifer de rajouter ça à Overpass :-)</div><div class=""><br class=""></div><div class="">—</div><div class="">Yves</div></div></div></div></div></blockquote><div class=""><div class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class=""><div class=""><div class=""><br class=""></div></div></div></div></div></div></div><br class=""></body></html>