Ciao,<br>dopo un po di tempo ho aggiornato le statistiche regionali sulla rete di strade mappate da OSM e le ho pubblicate sul wiki [1]. <br><br>Alcune curiosità: <br><ul><li>Briga Alta (cuneo) è il comune con più densità per abitante (46 km per 62 abitanti, pari a 700 m/abitante). Ciò grazie a chi ha mappato la sentieristica.</li>
<li>Cusano Milanino è il comune con maggiore densità per ettaro: 137 metri ogni 10000 metri quadri (<a href="http://osm.org/go/0CjQwDpj-?layers=00B0FTF">http://osm.org/go/0CjQwDpj-?layers=00B0FTF</a>)</li><li>Carbonia è la città più grande (30.000 abitanti ) senza nemmeno una strada. Si fa un mapping party?</li>
</ul>Ho messo in excel i dati comunali, non me le fa caricare sul wiki (non accetta il formato) a chi è interessato posso mandarle via email.<br><br><br>Di seguito riporto la tabella con la pecentuale di comuni "coperti", ovvero con almeno qualche strada (highway=*) presente nel db. Coperto chiaramente non significa "completo", ma è interessante vedere come i vuoti si stanno pian piano colmando.<br>
<br><table id="sortable_table_id_1" class="sortable" border="0" cellspacing="0" frame="void" rules="none"><tbody><tr class="even"><td align="left" height="16" width="178"><strong>Regione</strong> <a href="http://wiki.openstreetmap.org/wiki/WikiProject_Italy/Stats#" class="sortheader" onclick="ts_resortTable(this);return false;"><span class="sortarrow"></span></a></td>
<td align="center" width="66"><strong><font size="1">02/06/08</font></strong> <a href="http://wiki.openstreetmap.org/wiki/WikiProject_Italy/Stats#" class="sortheader" onclick="ts_resortTable(this);return false;"><span class="sortarrow"></span></a></td>
<td align="center" width="66"><strong><font size="1">18/8/08</font></strong> <a href="http://wiki.openstreetmap.org/wiki/WikiProject_Italy/Stats#" class="sortheader" onclick="ts_resortTable(this);return false;"><span class="sortarrow"></span></a></td>
<td align="right" width="66"><strong><font size="1">02/10/08</font></strong> <a href="http://wiki.openstreetmap.org/wiki/WikiProject_Italy/Stats#" class="sortheader" onclick="ts_resortTable(this);return false;"><span class="sortarrow"></span></a></td>
<td align="right" width="66"><strong><font size="1">11/11/08</font></strong> <a href="http://wiki.openstreetmap.org/wiki/WikiProject_Italy/Stats#" class="sortheader" onclick="ts_resortTable(this);return false;"><span class="sortarrow"></span></a></td>
<td align="right" width="79"><strong><font size="1">01/09/09</font></strong> <a href="http://wiki.openstreetmap.org/wiki/WikiProject_Italy/Stats#" class="sortheader" onclick="ts_resortTable(this);return false;"><span class="sortarrow"></span></a></td>
<td align="right" width="85"><strong><font size="1">03/01/09</font></strong> <a href="http://wiki.openstreetmap.org/wiki/WikiProject_Italy/Stats#" class="sortheader" onclick="ts_resortTable(this);return false;"><span class="sortarrow"></span></a></td>
<td align="right" width="85"><strong><font size="1">05/23/09</font></strong> <a href="http://wiki.openstreetmap.org/wiki/WikiProject_Italy/Stats#" class="sortheader" onclick="ts_resortTable(this);return false;"><span class="sortarrow"></span></a></td>
<td align="left" width="85"><strong><font size="1">17/7/09</font></strong> <a href="http://wiki.openstreetmap.org/wiki/WikiProject_Italy/Stats#" class="sortheader" onclick="ts_resortTable(this);return false;"><span class="sortarrow"></span></a></td>
<td align="left" width="85"><strong><font size="1">Comuni Mancanti</font></strong> <a href="http://wiki.openstreetmap.org/wiki/WikiProject_Italy/Stats#" class="sortheader" onclick="ts_resortTable(this);return false;"><span class="sortarrow"></span></a></td>
</tr>
<tr class="odd">
<td align="left" height="16">TOSCANA</td>
<td align="right" bgcolor="#99ccff">94.77%</td>
<td align="right" bgcolor="#99ccff">96.86%</td>
<td align="right" bgcolor="#99ccff">98.61%</td>
<td align="right" bgcolor="#99ccff">98.95%</td>
<td align="right" bgcolor="#99ccff">98.95%</td>
<td align="right" bgcolor="#99ccff">98.95%</td>
<td align="right" bgcolor="#0000ff">100.00%</td>
<td align="right" bgcolor="#0000ff">100.00%</td>
<td align="right">0</td>
</tr>
<tr class="even">
<td align="left" height="16">LIGURIA</td>
<td align="right" bgcolor="#ffff00">68.09%</td>
<td align="right" bgcolor="#ffff00">74.89%</td>
<td align="right" bgcolor="#00ff00">81.28%</td>
<td align="right" bgcolor="#00ff00">83.83%</td>
<td align="right" bgcolor="#00ff00">88.51%</td>
<td align="right" bgcolor="#99ccff">92.34%</td>
<td align="right" bgcolor="#99ccff">97.45%</td>
<td align="right" bgcolor="#99ccff">99.15%</td>
<td align="right">6</td>
</tr>
<tr class="odd">
<td align="left" height="16">FRIULI VENEZIA GIULIA</td>
<td align="right" bgcolor="#ffff00">65.75%</td>
<td align="right" bgcolor="#00ff00">87.67%</td>
<td align="right" bgcolor="#99ccff">94.06%</td>
<td align="right" bgcolor="#99ccff">95.43%</td>
<td align="right" bgcolor="#99ccff">96.35%</td>
<td align="right" bgcolor="#99ccff">96.35%</td>
<td align="right" bgcolor="#99ccff">97.26%</td>
<td align="right" bgcolor="#99ccff">98.63%</td>
<td align="right">6</td>
</tr>
<tr class="even">
<td align="left" height="16">TRENTINO - ALTO ADIGE</td>
<td align="right" bgcolor="#00ff00">81.42%</td>
<td align="right" bgcolor="#99ccff">94.69%</td>
<td align="right" bgcolor="#99ccff">97.35%</td>
<td align="right" bgcolor="#99ccff">97.35%</td>
<td align="right" bgcolor="#99ccff">98.53%</td>
<td align="right" bgcolor="#99ccff">97.64%</td>
<td align="right" bgcolor="#99ccff">97.64%</td>
<td align="right" bgcolor="#99ccff">97.94%</td>
<td align="right">8</td>
</tr>
<tr class="odd">
<td align="left" height="16">EMILIA ROMAGNA</td>
<td align="right" bgcolor="#ffff00">67.16%</td>
<td align="right" bgcolor="#00ff00">80.65%</td>
<td align="right" bgcolor="#00ff00">86.22%</td>
<td align="right" bgcolor="#00ff00">88.27%</td>
<td align="right" bgcolor="#00ff00">89.74%</td>
<td align="right" bgcolor="#99ccff">92.08%</td>
<td align="right" bgcolor="#99ccff">96.77%</td>
<td align="right" bgcolor="#99ccff">97.07%</td>
<td align="right">11</td>
</tr>
<tr class="even">
<td align="left" height="16">VENETO</td>
<td align="right" bgcolor="#ffff00">70.74%</td>
<td align="right" bgcolor="#00ff00">80.72%</td>
<td align="right" bgcolor="#00ff00">84.51%</td>
<td align="right" bgcolor="#00ff00">87.95%</td>
<td align="right" bgcolor="#99ccff">92.08%</td>
<td align="right" bgcolor="#99ccff">93.12%</td>
<td align="right" bgcolor="#99ccff">94.49%</td>
<td align="right" bgcolor="#99ccff">96.21%</td>
<td align="right">32</td>
</tr>
<tr class="odd">
<td align="left" height="16">BASILICATA</td>
<td align="right" bgcolor="#ff0000">42.75%</td>
<td align="right" bgcolor="#ff0000">42.75%</td>
<td align="right" bgcolor="#ffcc99">55.73%</td>
<td align="right" bgcolor="#00ff00">76.34%</td>
<td align="right" bgcolor="#00ff00">80.15%</td>
<td align="right" bgcolor="#00ff00">80.15%</td>
<td align="right" bgcolor="#00ff00">81.68%</td>
<td align="right" bgcolor="#99ccff">95.42%</td>
<td align="right">24</td>
</tr>
<tr class="even">
<td align="left" height="16">UMBRIA</td>
<td align="right" bgcolor="#ffff00">73.91%</td>
<td align="right" bgcolor="#00ff00">76.09%</td>
<td align="right" bgcolor="#00ff00">85.87%</td>
<td align="right" bgcolor="#00ff00">86.96%</td>
<td align="right" bgcolor="#00ff00">88.04%</td>
<td align="right" bgcolor="#99ccff">90.22%</td>
<td align="right" bgcolor="#99ccff">91.30%</td>
<td align="right" bgcolor="#99ccff">93.48%</td>
<td align="right">8</td>
</tr>
<tr class="odd">
<td align="left" height="16">LOMBARDIA</td>
<td align="right" bgcolor="#ffcc99">57.18%</td>
<td align="right" bgcolor="#ffff00">69.60%</td>
<td align="right" bgcolor="#00ff00">77.81%</td>
<td align="right" bgcolor="#00ff00">80.60%</td>
<td align="right" bgcolor="#00ff00">82.79%</td>
<td align="right" bgcolor="#00ff00">87.00%</td>
<td align="right" bgcolor="#99ccff">90.43%</td>
<td align="right" bgcolor="#99ccff">93.21%</td>
<td align="right">148</td>
</tr>
<tr class="even">
<td align="left" height="16">MARCHE</td>
<td align="right" bgcolor="#ffcc99">56.91%</td>
<td align="right" bgcolor="#ffff00">70.33%</td>
<td align="right" bgcolor="#ffff00">72.76%</td>
<td align="right" bgcolor="#00ff00">75.20%</td>
<td align="right" bgcolor="#00ff00">79.27%</td>
<td align="right" bgcolor="#00ff00">79.27%</td>
<td align="right" bgcolor="#00ff00">82.93%</td>
<td align="right" bgcolor="#99ccff">92.28%</td>
<td align="right">42</td>
</tr>
<tr class="odd">
<td align="left" height="16">VALLE D'AOSTA</td>
<td align="right" bgcolor="#ffcc99">55.41%</td>
<td align="right" bgcolor="#ffcc99">59.46%</td>
<td align="right" bgcolor="#00ff00">82.43%</td>
<td align="right" bgcolor="#00ff00">83.78%</td>
<td align="right" bgcolor="#00ff00">86.49%</td>
<td align="right" bgcolor="#00ff00">86.49%</td>
<td align="right" bgcolor="#00ff00">89.19%</td>
<td align="right" bgcolor="#99ccff">91.89%</td>
<td align="right">8</td>
</tr>
<tr class="even">
<td align="left" height="16">PUGLIA</td>
<td align="right" bgcolor="#ffcc99">51.16%</td>
<td align="right" bgcolor="#ffcc99">54.26%</td>
<td align="right" bgcolor="#00ff00">77.13%</td>
<td align="right" bgcolor="#00ff00">79.46%</td>
<td align="right" bgcolor="#00ff00">80.62%</td>
<td align="right" bgcolor="#00ff00">81.40%</td>
<td align="right" bgcolor="#00ff00">86.05%</td>
<td align="right" bgcolor="#00ff00">89.15%</td>
<td align="right">36</td>
</tr>
<tr class="odd">
<td align="left" height="16">SARDEGNA</td>
<td align="right" bgcolor="#ffcc99">56.23%</td>
<td align="right" bgcolor="#ffcc99">60.74%</td>
<td align="right" bgcolor="#ffff00">66.05%</td>
<td align="right" bgcolor="#ffff00">68.97%</td>
<td align="right" bgcolor="#ffff00">69.23%</td>
<td align="right" bgcolor="#00ff00">80.11%</td>
<td align="right" bgcolor="#00ff00">85.15%</td>
<td align="right" bgcolor="#00ff00">87.27%</td>
<td align="right">56</td>
</tr>
<tr class="even">
<td align="left" height="16">ABRUZZO</td>
<td align="right" bgcolor="#ffcc99">53.77%</td>
<td align="right" bgcolor="#ffcc99">57.38%</td>
<td align="right" bgcolor="#ffff00">67.54%</td>
<td align="right" bgcolor="#ffff00">70.49%</td>
<td align="right" bgcolor="#ffff00">71.48%</td>
<td align="right" bgcolor="#ffff00">72.46%</td>
<td align="right" bgcolor="#ffff00">76.39%</td>
<td align="right" bgcolor="#00ff00">86.23%</td>
<td align="right">72</td>
</tr>
<tr class="odd">
<td align="left" height="16">CAMPANIA</td>
<td align="right" bgcolor="#ffcc99">57.53%</td>
<td align="right" bgcolor="#ffcc99">60.98%</td>
<td align="right" bgcolor="#ffff00">66.42%</td>
<td align="right" bgcolor="#ffff00">68.06%</td>
<td align="right" bgcolor="#ffff00">70.60%</td>
<td align="right" bgcolor="#ffff00">74.23%</td>
<td align="right" bgcolor="#ffff00">74.95%</td>
<td align="right" bgcolor="#00ff00">85.66%</td>
<td align="right">138</td>
</tr>
<tr class="even">
<td align="left" height="16">LAZIO</td>
<td align="right" bgcolor="#ffcc99">58.20%</td>
<td align="right" bgcolor="#ffcc99">62.70%</td>
<td align="right" bgcolor="#ffff00">69.84%</td>
<td align="right" bgcolor="#ffff00">72.49%</td>
<td align="right" bgcolor="#ffff00">73.54%</td>
<td align="right" bgcolor="#ffff00">74.07%</td>
<td align="right" bgcolor="#ffff00">78.57%</td>
<td align="right" bgcolor="#00ff00">84.39%</td>
<td align="right">81</td>
</tr>
<tr class="odd">
<td align="left" height="16">SICILIA</td>
<td align="right" bgcolor="#ff0000">29.74%</td>
<td align="right" bgcolor="#ff0000">46.15%</td>
<td align="right" bgcolor="#ffcc99">56.92%</td>
<td align="right" bgcolor="#ffff00">66.67%</td>
<td align="right" bgcolor="#ffff00">68.72%</td>
<td align="right" bgcolor="#ffff00">69.23%</td>
<td align="right" bgcolor="#ffff00">72.31%</td>
<td align="right" bgcolor="#00ff00">81.03%</td>
<td align="right">108</td>
</tr>
<tr class="even">
<td align="left" height="16">CALABRIA</td>
<td align="right" bgcolor="#ff0000">34.96%</td>
<td align="right" bgcolor="#ff0000">34.96%</td>
<td align="right" bgcolor="#ff0000">43.03%</td>
<td align="right" bgcolor="#ff0000">43.28%</td>
<td align="right" bgcolor="#ff0000">49.63%</td>
<td align="right" bgcolor="#ffcc99">51.59%</td>
<td align="right" bgcolor="#ffff00">70.90%</td>
<td align="right" bgcolor="#ffff00">79.71%</td>
<td align="right">119</td>
</tr>
<tr class="odd">
<td align="left" height="16">PIEMONTE</td>
<td align="right" bgcolor="#ff0000">35.99%</td>
<td align="right" bgcolor="#ff0000">48.34%</td>
<td align="right" bgcolor="#ffcc99">61.28%</td>
<td align="right" bgcolor="#ffcc99">63.02%</td>
<td align="right" bgcolor="#ffcc99">63.76%</td>
<td align="right" bgcolor="#ffcc99">66.25%</td>
<td align="right" bgcolor="#ffff00">75.29%</td>
<td align="right" bgcolor="#ffff00">79.27%</td>
<td align="right">298</td>
</tr>
<tr class="even">
<td align="left" height="16">MOLISE</td>
<td align="right" bgcolor="#ff0000">44.12%</td>
<td align="right" bgcolor="#ff0000">45.59%</td>
<td align="right" bgcolor="#ffcc99">55.15%</td>
<td align="right" bgcolor="#ffcc99">55.15%</td>
<td align="right" bgcolor="#ffcc99">55.15%</td>
<td align="right" bgcolor="#ffff00">56.62%</td>
<td align="right" bgcolor="#ffff00">73.53%</td>
<td align="right" bgcolor="#ffff00">77.21%</td>
<td align="right">36</td>
</tr>
<tr class="odd">
<td align="left" height="16"><strong>TOTALE</strong></td>
<td align="right"><strong>55.29%</strong></td>
<td align="right"><strong>64.37%</strong></td>
<td align="right"><strong>72.66%</strong></td>
<td align="right"><strong>75.37%</strong></td>
<td align="right"><strong>77.42%</strong></td>
<td align="right"><strong>79.85%</strong></td>
<td align="right"><strong>84.73%</strong></td>
<td align="right"><strong>89.14%</strong></td>
<td align="right">1237</td></tr></tbody></table><br><br>Su base comunale ecco qualche classifica:<br><br><b>Elenco per km mappati<br><br></b>Per ogni comune i km di strade mappate. ind_pop da i metri per abitante e ind_area i metri per ettaro. with_name la percentuale delle strade con nome.Tra le grandi, ovvie vincitrici, Cerignola rules.<br>
<br>
<meta http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8"><title></title><meta name="GENERATOR" content="OpenOffice.org 2.2 (Linux)">
<style>
<!--
BODY,DIV,TABLE,THEAD,TBODY,TFOOT,TR,TH,TD,P { font-family:"DejaVu Sans"; font-size:x-small }
-->
</style>
<table border="0" cellspacing="0" cols="6" frame="void" rules="none">
<colgroup><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="112"></colgroup>
<tbody>
<tr>
<td align="left" height="17" width="86">Comune</td>
<td align="left" width="86">pop_2001</td>
<td align="left" width="86">km_osm</td>
<td align="left" width="86">ind_pop</td>
<td align="left" width="86">ind_area</td>
<td align="left" width="112">with_name</td>
</tr>
<tr>
<td align="left" height="16">ROMA</td>
<td align="right">2546804</td>
<td align="right">8499.15</td>
<td align="right">3.34</td>
<td align="right">36.76</td>
<td align="right">0.84</td>
</tr>
<tr>
<td align="left" height="16">MILANO</td>
<td align="right">1256211</td>
<td align="right">2792.34</td>
<td align="right">2.22</td>
<td align="right">75.77</td>
<td align="right">0.63</td>
</tr>
<tr>
<td align="left" height="16">GENOVA</td>
<td align="right">610307</td>
<td align="right">1879.79</td>
<td align="right">3.08</td>
<td align="right">40.08</td>
<td align="right">0.63</td>
</tr>
<tr>
<td align="left" height="32">PARMA</td>
<td align="right">163457</td>
<td align="right">1358.22</td>
<td align="right">8.31</td>
<td align="right">26.43</td>
<td align="right">0.79</td>
</tr>
<tr>
<td align="left" height="32">MODENA</td>
<td align="right">175502</td>
<td align="right">1337.47</td>
<td align="right">7.62</td>
<td align="right">37.02</td>
<td align="right">0.59</td>
</tr>
<tr>
<td align="left" height="16">CERIGNOLA</td>
<td align="right">57366</td>
<td align="right">1310.32</td>
<td align="right">22.84</td>
<td align="right">12.6</td>
<td align="right">0.34</td>
</tr>
<tr>
<td align="left" height="16">TORINO</td>
<td align="right">865263</td>
<td align="right">1275.46</td>
<td align="right">1.47</td>
<td align="right">49.6</td>
<td align="right">0.78</td>
</tr>
<tr>
<td align="left" height="16">VERONA</td>
<td align="right">253208</td>
<td align="right">1218.55</td>
<td align="right">4.81</td>
<td align="right">30.37</td>
<td align="right">0.49</td>
</tr>
<tr>
<td align="left" height="16">RAVENNA</td>
<td align="right">134631</td>
<td align="right">1198.95</td>
<td align="right">8.91</td>
<td align="right">9.41</td>
<td align="right">0.87</td>
</tr>
<tr>
<td align="left" height="16">FIRENZE</td>
<td align="right">356118</td>
<td align="right">1179.46</td>
<td align="right">3.31</td>
<td align="right">59.75</td>
<td align="right">0.82</td>
</tr>
<tr>
<td align="left" height="16">TRENTO</td>
<td align="right">104946</td>
<td align="right">1147.97</td>
<td align="right">10.94</td>
<td align="right">35.23</td>
<td align="right">0.49</td>
</tr>
<tr>
<td align="left" height="32">BOLOGNA</td>
<td align="right">371217</td>
<td align="right">1147.3</td>
<td align="right">3.09</td>
<td align="right">41.22</td>
<td align="right">0.8</td>
</tr>
<tr>
<td align="left" height="16">PADOVA</td>
<td align="right">204870</td>
<td align="right">1123.05</td>
<td align="right">5.48</td>
<td align="right">59.12</td>
<td align="right">0.87</td>
</tr>
</tbody>
</table>
<br><br>Ciao,<br>Diego<br><br><br>[1] <a href="http://wiki.openstreetmap.org/wiki/WikiProject_Italy#Statistiche">http://wiki.openstreetmap.org/wiki/WikiProject_Italy#Statistiche</a><br><br><br>