<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="transparent" text="#000000">
Bonjour, on va simplifier :<br>
alors que le titre semblait indiquer que ourairports était
américano-américain, il est en fait mondial et en données versées au
domaine public.<br>
J'ai fait un comparatif qui semble parler de lui-même :<br>
<br>
<table style="border-collapse: collapse;width:572pt" border="0"
cellpadding="0" cellspacing="0" width="762">
<colgroup><col
style="mso-width-source:userset;mso-width-alt:7862;width:161pt"
width="215"> <col
style="mso-width-source:userset;mso-width-alt:10605;width:218pt"
width="290"> <col
style="mso-width-source:userset;mso-width-alt:9398;width:193pt"
width="257"> </colgroup><tbody>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt;width:161pt" height="20" width="215"><br>
</td>
<td style="width:218pt" width="290">OurAirports</td>
<td style="width:193pt" width="257">OpenFlights</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20">License</td>
<td class="xl66"><b>public domain</b> souhaitent mais
n'exigent pas d'être cités<br>
</td>
<td class="xl63">OBdL/commercial</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20">Entrées</td>
<td class="xl66" align="right"><b>46 516</b></td>
<td class="xl63" align="right">8 107</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20">Position</td>
<td>lat, lon, ele</td>
<td>lat, lon, ele (en pieds)</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20">latitude</td>
<td>latitude_deg</td>
<td>lat</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20">longitude</td>
<td>longitude_deg</td>
<td>lon</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20">altitude</td>
<td>elevation_ft</td>
<td>ele_ft</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20"><br>
</td>
<td><br>
</td>
<td><br>
</td>
</tr>
<tr style="height:135.0pt" height="180">
<td style="height:135.0pt" height="180"><b>Type</b></td>
<td class="xl67" style="width:218pt" width="290">ballonport<br>
heliport<br>
seaplane_base<br>
<br>
small_airport<br>
medium_airport<br>
large_airport<br>
<br>
closed</td>
<td class="xl63">-<br>
</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20"><br>
</td>
<td class="xl64" style="width:218pt" width="290"><br>
</td>
<td class="xl63"><br>
</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20">Dénomination</td>
<td class="xl64" style="width:218pt" width="290"><br>
</td>
<td class="xl63"><br>
</td>
</tr>
<tr style="height:15.0pt" height="20">
<td class="xl68" style="height:15.0pt" height="20">name:en</td>
<td class="xl63">name</td>
<td class="xl63"><br>
</td>
</tr>
<tr style="height:30.0pt" height="40">
<td style="height:30.0pt" height="40">localité</td>
<td class="xl64" style="width:218pt" width="290">couple ville
principale/commune du site<br>
quelques vides</td>
<td class="xl65" style="width:193pt" width="257">city= ville
principale<br>
name=commune locale ou lieu-dit</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20">continent</td>
<td class="xl63">oui</td>
<td class="xl63">-</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20">pays</td>
<td class="xl63">iso_country</td>
<td>country</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20">état/région</td>
<td class="xl63">iso_region</td>
<td>-</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20"><br>
</td>
<td><br>
</td>
<td><br>
</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20">Référence</td>
<td><br>
</td>
<td><br>
</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20">3 alpha (<font
class="font5">iata</font><font class="font0">)</font></td>
<td>iata_code</td>
<td>iata</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20">4 alpha (<font
class="font5">icao</font><font class="font0">)</font></td>
<td>gps_code</td>
<td>icao</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20">4-7 alpha</td>
<td class="xl63">ident</td>
<td><br>
</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20">code local/national<span
style="mso-spacerun:yes"> </span>de l'aéroport</td>
<td class="xl63">local_code</td>
<td><br>
</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20"><br>
</td>
<td><br>
</td>
<td><br>
</td>
</tr>
<tr style="height:15.0pt" height="20">
<td class="xl68" style="height:15.0pt" height="20">wikipedia:en</td>
<td class="xl63"><b>wikipedia_link</b></td>
<td><br>
</td>
</tr>
<tr style="height:15.0pt" height="20">
<td class="xl68" style="height:15.0pt" height="20">website</td>
<td class="xl63"><b>home_link</b></td>
<td><br>
</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20"><br>
</td>
<td><br>
</td>
<td><br>
</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20">Divers</td>
<td><br>
</td>
<td><br>
</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20">scheduled_service</td>
<td class="xl63">indique si les vols sont préprogrammés</td>
<td>-</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20">fuseau horaire</td>
<td>-</td>
<td>oui, mais heure d'été sujette à caution dans certains
états</td>
</tr>
</tbody>
</table>
<br>
Voici ce que ça donne sur un degré carré :<br>
<br>
<table style="border-collapse: collapse;width:720pt" border="0"
cellpadding="0" cellspacing="0" width="960">
<colgroup><col style="width:60pt" span="12" width="80"> </colgroup><tbody>
<tr style="height:15.0pt" height="20">
<td class="xl63" style="height:15.0pt;width:60pt" height="20"
width="80">OpenFlightID</td>
<td style="width:60pt" width="80">Name</td>
<td style="width:60pt" width="80">City</td>
<td style="width:60pt" width="80">Country</td>
<td style="width:60pt" width="80">iata</td>
<td style="width:60pt" width="80">icao</td>
<td style="width:60pt" width="80">Lat</td>
<td style="width:60pt" width="80">Lon</td>
<td style="width:60pt" width="80">AltitudeFt</td>
<td style="width:60pt" width="80">Timezone</td>
<td style="width:60pt" width="80">DSTtype</td>
<td style="width:60pt" width="80">TimezoneName</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" align="right" height="20">1403</td>
<td>Guipavas</td>
<td>Brest</td>
<td>France</td>
<td>BES</td>
<td>LFRB</td>
<td align="right">48,447911</td>
<td align="right">-4,418539</td>
<td align="right">325</td>
<td align="right">1</td>
<td>E</td>
<td>Europe/Paris</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" align="right" height="20">1411</td>
<td>Landivisiau</td>
<td>Landivisiau</td>
<td>France</td>
<td><br>
</td>
<td>LFRJ</td>
<td align="right">48,530258</td>
<td align="right">-4,151642</td>
<td align="right">348</td>
<td align="right">1</td>
<td>E</td>
<td>Europe/Paris</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" align="right" height="20">1413</td>
<td>Poulmic</td>
<td>Lanvedoc</td>
<td>France</td>
<td><br>
</td>
<td>LFRL</td>
<td align="right">48,281703</td>
<td align="right">-4,445017</td>
<td align="right">287</td>
<td align="right">1</td>
<td>E</td>
<td>Europe/Paris</td>
</tr>
</tbody>
</table>
<br>
Aucun héliport, une erreur dans le nom d'une ville (Lanvéoc),
localisation moins précise que ci-dessous.<br>
<br>
<table style="border-collapse: collapse;width:1214pt" border="0"
cellpadding="0" cellspacing="0" width="1619">
<colgroup><col style="width:60pt" span="2" width="80"> <col
style="mso-width-source:userset;mso-width-alt:7424;width:152pt"
width="203"> <col
style="mso-width-source:userset;mso-width-alt:5302;width:109pt"
width="145"> <col style="width:60pt" span="5" width="80"> <col
style="mso-width-source:userset;mso-width-alt:5522;width:113pt"
width="151"> <col style="width:60pt" span="7" width="80"> </colgroup><tbody>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt;width:60pt" height="20" width="80">ident</td>
<td style="width:60pt" width="80">type</td>
<td style="width:152pt" width="203">name</td>
<td style="width:109pt" width="145">latitude_deg</td>
<td style="width:60pt" width="80">longitude_deg</td>
<td style="width:60pt" width="80">elevation_ft</td>
<td style="width:60pt" width="80">continent</td>
<td style="width:60pt" width="80">iso_country</td>
<td style="width:60pt" width="80">iso_region</td>
<td style="width:113pt" width="151">municipality</td>
<td style="width:60pt" width="80">scheduled_service</td>
<td style="width:60pt" width="80">gps_code</td>
<td style="width:60pt" width="80">iata_code</td>
<td style="width:60pt" width="80">local_code</td>
<td style="width:60pt" width="80">home_link</td>
<td style="width:60pt" width="80">wikipedia_link</td>
<td style="width:60pt" width="80">keywords</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20">FR-0046</td>
<td>heliport</td>
<td>Amirauté Heliport</td>
<td align="right">48,3805542</td>
<td align="right">-4,49166679</td>
<td align="right">8</td>
<td>EU</td>
<td>FR</td>
<td>FR-E</td>
<td>Brest</td>
<td>no</td>
<td><br>
</td>
<td><br>
</td>
<td><br>
</td>
<td><br>
</td>
<td><br>
</td>
<td><br>
</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20">FR-0053</td>
<td>heliport</td>
<td>La Cavale Blanche Centre Hospitalier Heliport</td>
<td align="right">48,40353012</td>
<td align="right">-4,52956676</td>
<td align="right">121</td>
<td>EU</td>
<td>FR</td>
<td>FR-E</td>
<td>Brest</td>
<td>no</td>
<td><br>
</td>
<td><br>
</td>
<td><br>
</td>
<td><br>
</td>
<td><br>
</td>
<td><br>
</td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20"><b>LFRB</b></td>
<td><b>medium_airport</b></td>
<td><b>Brest Bretagne Airport</b></td>
<td align="right"><b>48,44789886</b></td>
<td align="right"><b>-4,41854</b></td>
<td align="right"><b>325</b></td>
<td><b>EU</b></td>
<td><b>FR</b></td>
<td><b>FR-E</b></td>
<td><b>Brest/Guipavas</b></td>
<td><b>yes</b></td>
<td><b>LFRB</b></td>
<td><b>BES</b></td>
<td><b><br>
</b></td>
<td><b><br>
</b></td>
<td colspan="2" style="mso-ignore:colspan"><b><a class="moz-txt-link-freetext" href="http://en.wikipedia.org/wiki/Brest_Bretagne_Airport">http://en.wikipedia.org/wiki/Brest_Bretagne_Airport</a></b></td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20"><b>LFRJ</b></td>
<td><b>medium_airport</b></td>
<td><b>Landivisiau Air Base</b></td>
<td align="right"><b>48,53030014</b></td>
<td align="right"><b>-4,15163994</b></td>
<td align="right"><b>348</b></td>
<td><b>EU</b></td>
<td><b>FR</b></td>
<td><b>FR-E</b></td>
<td><b>Landivisiau</b></td>
<td><b>no</b></td>
<td><b>LFRJ</b></td>
<td><b>LDV</b></td>
<td><b><br>
</b></td>
<td><b><br>
</b></td>
<td><b><br>
</b></td>
<td><b><br>
</b></td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="height:15.0pt" height="20"><b>LFRL</b></td>
<td><b>medium_airport</b></td>
<td><b>Lanvéoc-Poulmic Air Base</b></td>
<td align="right"><b>48,28170013</b></td>
<td align="right"><b>-4,4450202</b></td>
<td align="right"><b>287</b></td>
<td><b>EU</b></td>
<td><b>FR</b></td>
<td><b>FR-E</b></td>
<td><b>Lanvéoc/Poulmic</b></td>
<td><b>no</b></td>
<td><b>LFRL</b></td>
<td><b><br>
</b></td>
<td><b><br>
</b></td>
<td><b><br>
</b></td>
<td><b><br>
</b></td>
<td><b><br>
</b></td>
</tr>
<tr>
<td valign="top"><br>
</td>
<td valign="top"><br>
</td>
<td valign="top"><br>
</td>
<td valign="top"><br>
</td>
<td valign="top"><br>
</td>
<td valign="top"><br>
</td>
<td valign="top"><br>
</td>
<td valign="top"><br>
</td>
<td valign="top"><br>
</td>
<td valign="top"><br>
</td>
<td valign="top"><br>
</td>
<td valign="top"><br>
</td>
<td valign="top"><br>
</td>
<td valign="top"><br>
</td>
<td valign="top"><br>
</td>
<td valign="top"><br>
</td>
<td valign="top"><br>
</td>
</tr>
</tbody>
</table>
<br>
Sachant que OpenStreeMap trouve 6 héliports.<br>
<br>
Se pose la question de la meilleure façon de rapprocher les données.<br>
Est-ce que vous savez à quoi ident correspondrait sur OpenStreeMap ?
ça ressemble à une référence internationale.<br>
<br>
Jean-Yvon<br>
</body>
</html>