<div dir="ltr"><br>Ciao,<div style>ho rifatto i calcoli (il mio db è aggiornato a venerdì scorso). Rimane il problema delle track. </div><div style><br></div><div style>Il importo tutti i dati con osm2pgsql, poi seleziono linee e poligoni con highway non nullo e lo ritaglio con i confini comunali. Ignoro le relazioni ma in genere sono pochi gli elementi lineari che sono solo nelle relazioni. Sto cercando di capire dove possa essere l'errore. </div>
<div style><br></div><div><br></div><div>
<table frame="VOID" cellspacing="0" cols="5" rules="NONE" border="0">
<colgroup><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"></colgroup>
<tbody>
<tr>
<td width="86" height="17" align="CENTER"><b>cod_reg</b></td>
<td width="86" align="CENTER"><b>highway</b></td>
<td width="86" align="CENTER"><b>diego</b></td>
<td width="86" align="CENTER"><b>daniele</b></td>
<td width="86" align="CENTER"><b>diff</b></td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">track</td>
<td align="RIGHT">15,237,180</td>
<td align="RIGHT">50,532,619</td>
<td align="RIGHT">231.64%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">unclassified</td>
<td align="RIGHT">9,616,284</td>
<td align="RIGHT">9,655,929</td>
<td align="RIGHT">0.41%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">residential</td>
<td align="RIGHT">6,140,916</td>
<td align="RIGHT">6,180,505</td>
<td align="RIGHT">0.64%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">tertiary</td>
<td align="RIGHT">4,321,056</td>
<td align="RIGHT">4,340,279</td>
<td align="RIGHT">0.44%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">primary</td>
<td align="RIGHT">2,656,779</td>
<td align="RIGHT">2,666,742</td>
<td align="RIGHT">0.37%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">secondary</td>
<td align="RIGHT">2,654,913</td>
<td align="RIGHT">2,670,233</td>
<td align="RIGHT">0.58%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">path</td>
<td align="RIGHT">1,672,527</td>
<td align="RIGHT">1,762,505</td>
<td align="RIGHT">5.38%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">service</td>
<td align="RIGHT">1,161,368</td>
<td align="RIGHT">1,213,976</td>
<td align="RIGHT">4.53%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">trunk</td>
<td align="RIGHT">982,802</td>
<td align="RIGHT">982,904</td>
<td align="RIGHT">0.01%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">road</td>
<td align="RIGHT">319,091</td>
<td align="RIGHT">319,244</td>
<td align="RIGHT">0.05%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">footway</td>
<td align="RIGHT">236,579</td>
<td align="RIGHT">262,027</td>
<td align="RIGHT">10.76%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">trunk_link</td>
<td align="RIGHT">225,917</td>
<td align="RIGHT">225,557</td>
<td align="RIGHT">-0.16%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">primary_link</td>
<td align="RIGHT">102,225</td>
<td align="RIGHT">101,756</td>
<td align="RIGHT">-0.46%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">construction</td>
<td align="RIGHT">80,911</td>
<td align="RIGHT">80,904</td>
<td align="RIGHT">-0.01%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">cycleway</td>
<td align="RIGHT">66,586</td>
<td align="RIGHT">71,091</td>
<td align="RIGHT">6.77%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">bridleway</td>
<td align="RIGHT">54,952</td>
<td align="RIGHT">54,893</td>
<td align="RIGHT">-0.11%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">tertiary_link</td>
<td align="RIGHT">44,761</td>
<td align="RIGHT">44,881</td>
<td align="RIGHT">0.27%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">pedestrian</td>
<td align="RIGHT">41,308</td>
<td align="RIGHT">115,329</td>
<td align="RIGHT">179.19%</td>
</tr>
<tr>
<td height="32" align="RIGHT">20</td>
<td align="LEFT">secondary_link</td>
<td align="RIGHT">31,893</td>
<td align="RIGHT">31,898</td>
<td align="RIGHT">0.01%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">steps</td>
<td align="RIGHT">14,772</td>
<td align="RIGHT">16,798</td>
<td align="RIGHT">13.71%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">raceway</td>
<td align="RIGHT">8,629</td>
<td align="RIGHT">9,676</td>
<td align="RIGHT">12.14%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">living_street</td>
<td align="RIGHT">8,209</td>
<td align="RIGHT">8,708</td>
<td align="RIGHT">6.08%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">rest_area</td>
<td align="RIGHT">1,389</td>
<td align="RIGHT">2,202</td>
<td align="RIGHT">58.49%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">services</td>
<td align="RIGHT">522</td>
<td align="RIGHT">1,068</td>
<td align="RIGHT">104.62%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">piste</td>
<td align="RIGHT">256</td>
<td align="RIGHT">321</td>
<td align="RIGHT">25.55%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">razed</td>
<td align="RIGHT">95</td>
<td align="RIGHT">94</td>
<td align="RIGHT">-0.95%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">proposed</td>
<td align="RIGHT">90</td>
<td align="RIGHT">89</td>
<td align="RIGHT">-0.73%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">yes</td>
<td align="RIGHT">87</td>
<td align="RIGHT">86</td>
<td align="RIGHT">-1.00%</td>
</tr>
<tr>
<td height="17" align="RIGHT">20</td>
<td align="LEFT">bus_stop</td>
<td align="RIGHT">14</td>
<td align="RIGHT">14</td>
<td align="RIGHT">-1.88%</td>
</tr>
<tr>
<td height="32" align="RIGHT">20</td>
<td align="LEFT">residential;unclassified</td>
<td align="RIGHT">2,778</td>
<td align="RIGHT">2,778</td>
<td align="RIGHT">0.00%</td>
</tr>
<tr>
<td height="17" align="LEFT"><br></td>
<td align="LEFT">Totale</td>
<td align="RIGHT">45684890</td>
<td align="RIGHT">81355106</td>
<td align="RIGHT">7</td>
</tr>
</tbody>
</table></div><div><br></div><div style><br></div><div style>I dati nazionali sono in linea:</div><div style><br></div><div style><table frame="VOID" cellspacing="0" cols="21" rules="NONE" border="0">
<colgroup><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"></colgroup>
<tbody>
<tr>
<td style="border-width:1px 1px 1px 2px;border-style:solid;border-color:rgb(0,0,0)" width="86" height="17" align="LEFT"><br></td>
<td width="86" align="LEFT">PIEMONTE</td>
<td width="86" align="LEFT">VALLE D'AOSTA</td>
<td width="86" align="LEFT">LOMBARDIA</td>
<td width="86" align="LEFT">TRENTINO - ALTO ADIGE</td>
<td width="86" align="LEFT">VENETO</td>
<td width="86" align="LEFT">FRIULI VENEZIA GIULIA</td>
<td width="86" align="LEFT">LIGURIA</td>
<td width="86" align="LEFT">EMILIA ROMAGNA</td>
<td width="86" align="LEFT">TOSCANA</td>
<td width="86" align="LEFT">UMBRIA</td>
<td width="86" align="LEFT">MARCHE</td>
<td width="86" align="LEFT">LAZIO</td>
<td width="86" align="LEFT">ABRUZZO</td>
<td width="86" align="LEFT">MOLISE</td>
<td width="86" align="LEFT">CAMPANIA</td>
<td width="86" align="LEFT">PUGLIA</td>
<td width="86" align="LEFT">BASILICATA</td>
<td width="86" align="LEFT">CALABRIA</td>
<td width="86" align="LEFT">SICILIA</td>
<td width="86" align="LEFT">SARDEGNA</td>
</tr>
<tr>
<td style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(0,0,0)" height="17" align="LEFT">unclassified</td>
<td style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(0,0,0)" align="RIGHT">17,408,820</td>
<td align="RIGHT">1,041,656</td>
<td align="RIGHT">24,233,177</td>
<td align="RIGHT">5,689,596</td>
<td align="RIGHT">14,721,185</td>
<td align="RIGHT">4,963,728</td>
<td align="RIGHT">4,088,969</td>
<td align="RIGHT">18,503,884</td>
<td align="RIGHT">13,890,745</td>
<td align="RIGHT">5,030,247</td>
<td align="RIGHT">7,002,836</td>
<td align="RIGHT">10,450,865</td>
<td align="RIGHT">6,195,919</td>
<td align="RIGHT">2,168,446</td>
<td align="RIGHT">9,921,517</td>
<td align="RIGHT">14,897,004</td>
<td align="RIGHT">4,556,105</td>
<td align="RIGHT">9,746,244</td>
<td align="RIGHT">17,088,679</td>
<td align="RIGHT">9,616,284</td>
</tr>
<tr>
<td style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(0,0,0)" height="17" align="LEFT">track</td>
<td style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(0,0,0)" align="RIGHT">18,430,676</td>
<td align="RIGHT">2,509,609</td>
<td align="RIGHT">14,674,120</td>
<td align="RIGHT">17,231,141</td>
<td align="RIGHT">10,533,767</td>
<td align="RIGHT">9,811,695</td>
<td align="RIGHT">4,126,397</td>
<td align="RIGHT">21,102,375</td>
<td align="RIGHT">23,422,743</td>
<td align="RIGHT">5,079,073</td>
<td align="RIGHT">5,326,746</td>
<td align="RIGHT">8,552,442</td>
<td align="RIGHT">2,924,901</td>
<td align="RIGHT">1,232,911</td>
<td align="RIGHT">3,712,223</td>
<td align="RIGHT">8,653,799</td>
<td align="RIGHT">5,151,833</td>
<td align="RIGHT">2,557,963</td>
<td align="RIGHT">11,544,277</td>
<td align="RIGHT">15,237,180</td>
</tr>
<tr>
<td style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(0,0,0)" height="17" align="LEFT">residential</td>
<td style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(0,0,0)" align="RIGHT">7,572,489</td>
<td align="RIGHT">380,310</td>
<td align="RIGHT">16,367,680</td>
<td align="RIGHT">3,144,053</td>
<td align="RIGHT">14,063,422</td>
<td align="RIGHT">4,071,644</td>
<td align="RIGHT">2,275,071</td>
<td align="RIGHT">11,701,164</td>
<td align="RIGHT">7,273,672</td>
<td align="RIGHT">2,269,024</td>
<td align="RIGHT">3,438,778</td>
<td align="RIGHT">10,633,672</td>
<td align="RIGHT">2,329,765</td>
<td align="RIGHT">480,345</td>
<td align="RIGHT">7,595,027</td>
<td align="RIGHT">6,476,046</td>
<td align="RIGHT">1,039,921</td>
<td align="RIGHT">2,986,137</td>
<td align="RIGHT">8,681,048</td>
<td align="RIGHT">6,140,916</td>
</tr>
<tr>
<td style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(0,0,0)" height="17" align="LEFT">tertiary</td>
<td style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(0,0,0)" align="RIGHT">6,725,930</td>
<td align="RIGHT">480,733</td>
<td align="RIGHT">8,578,087</td>
<td align="RIGHT">1,885,769</td>
<td align="RIGHT">7,929,142</td>
<td align="RIGHT">2,138,790</td>
<td align="RIGHT">2,281,071</td>
<td align="RIGHT">8,616,425</td>
<td align="RIGHT">6,293,226</td>
<td align="RIGHT">1,952,374</td>
<td align="RIGHT">3,662,517</td>
<td align="RIGHT">6,305,742</td>
<td align="RIGHT">3,934,395</td>
<td align="RIGHT">1,883,840</td>
<td align="RIGHT">6,537,934</td>
<td align="RIGHT">5,733,283</td>
<td align="RIGHT">2,679,349</td>
<td align="RIGHT">5,126,407</td>
<td align="RIGHT">6,771,310</td>
<td align="RIGHT">4,321,056</td>
</tr>
<tr>
<td style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(0,0,0)" height="17" align="LEFT">path</td>
<td style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(0,0,0)" align="RIGHT">9,439,501</td>
<td align="RIGHT">2,511,086</td>
<td align="RIGHT">9,396,743</td>
<td align="RIGHT">11,493,548</td>
<td align="RIGHT">5,666,687</td>
<td align="RIGHT">4,504,116</td>
<td align="RIGHT">3,953,002</td>
<td align="RIGHT">4,169,819</td>
<td align="RIGHT">6,728,324</td>
<td align="RIGHT">1,036,901</td>
<td align="RIGHT">2,242,921</td>
<td align="RIGHT">2,063,764</td>
<td align="RIGHT">1,320,684</td>
<td align="RIGHT">72,591</td>
<td align="RIGHT">908,373</td>
<td align="RIGHT">257,144</td>
<td align="RIGHT">151,870</td>
<td align="RIGHT">595,648</td>
<td align="RIGHT">846,762</td>
<td align="RIGHT">1,672,527</td>
</tr>
<tr>
<td style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(0,0,0)" height="17" align="LEFT">secondary</td>
<td style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(0,0,0)" align="RIGHT">5,718,465</td>
<td align="RIGHT">346,187</td>
<td align="RIGHT">5,039,811</td>
<td align="RIGHT">1,570,546</td>
<td align="RIGHT">4,929,782</td>
<td align="RIGHT">1,847,936</td>
<td align="RIGHT">1,733,550</td>
<td align="RIGHT">4,657,428</td>
<td align="RIGHT">4,504,383</td>
<td align="RIGHT">1,295,670</td>
<td align="RIGHT">2,629,419</td>
<td align="RIGHT">3,458,275</td>
<td align="RIGHT">1,631,754</td>
<td align="RIGHT">979,464</td>
<td align="RIGHT">2,359,158</td>
<td align="RIGHT">3,960,942</td>
<td align="RIGHT">1,833,699</td>
<td align="RIGHT">2,953,167</td>
<td align="RIGHT">4,040,811</td>
<td align="RIGHT">2,654,913</td>
</tr>
<tr>
<td style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(0,0,0)" height="17" align="LEFT">service</td>
<td style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(0,0,0)" align="RIGHT">2,420,550</td>
<td align="RIGHT">112,401</td>
<td align="RIGHT">4,680,657</td>
<td align="RIGHT">2,157,326</td>
<td align="RIGHT">3,254,031</td>
<td align="RIGHT">1,330,159</td>
<td align="RIGHT">748,140</td>
<td align="RIGHT">4,036,422</td>
<td align="RIGHT">2,955,357</td>
<td align="RIGHT">1,492,600</td>
<td align="RIGHT">971,000</td>
<td align="RIGHT">2,552,745</td>
<td align="RIGHT">663,083</td>
<td align="RIGHT">324,834</td>
<td align="RIGHT">1,336,715</td>
<td align="RIGHT">1,011,485</td>
<td align="RIGHT">341,107</td>
<td align="RIGHT">537,207</td>
<td align="RIGHT">2,491,364</td>
<td align="RIGHT">1,161,368</td>
</tr>
<tr>
<td style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(0,0,0)" height="17" align="LEFT">primary</td>
<td style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(0,0,0)" align="RIGHT">2,371,191</td>
<td align="RIGHT">138,099</td>
<td align="RIGHT">2,968,503</td>
<td align="RIGHT">1,495,914</td>
<td align="RIGHT">2,315,464</td>
<td align="RIGHT">961,806</td>
<td align="RIGHT">695,079</td>
<td align="RIGHT">2,114,365</td>
<td align="RIGHT">2,663,350</td>
<td align="RIGHT">816,225</td>
<td align="RIGHT">721,914</td>
<td align="RIGHT">1,703,069</td>
<td align="RIGHT">1,100,980</td>
<td align="RIGHT">424,226</td>
<td align="RIGHT">1,581,991</td>
<td align="RIGHT">1,302,652</td>
<td align="RIGHT">1,020,437</td>
<td align="RIGHT">1,244,154</td>
<td align="RIGHT">3,084,277</td>
<td align="RIGHT">2,656,779</td>
</tr>
<tr>
<td style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(0,0,0)" height="17" align="LEFT">motorway</td>
<td style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(0,0,0)" align="RIGHT">1,732,259</td>
<td align="RIGHT">173,327</td>
<td align="RIGHT">1,181,983</td>
<td align="RIGHT">373,744</td>
<td align="RIGHT">1,100,314</td>
<td align="RIGHT">501,757</td>
<td align="RIGHT">731,107</td>
<td align="RIGHT">1,229,014</td>
<td align="RIGHT">861,226</td>
<td align="RIGHT">111,782</td>
<td align="RIGHT">379,567</td>
<td align="RIGHT">956,677</td>
<td align="RIGHT">762,981</td>
<td align="RIGHT">72,113</td>
<td align="RIGHT">1,004,867</td>
<td align="RIGHT">619,291</td>
<td align="RIGHT">131,128</td>
<td align="RIGHT">600,662</td>
<td align="RIGHT">1,443,005</td>
<td align="LEFT"><br></td>
</tr>
<tr>
<td style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(0,0,0)" height="17" align="LEFT">footway</td>
<td style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(0,0,0)" align="RIGHT">731,263</td>
<td align="RIGHT">69,230</td>
<td align="RIGHT">2,011,027</td>
<td align="RIGHT">849,813</td>
<td align="RIGHT">1,203,628</td>
<td align="RIGHT">270,708</td>
<td align="RIGHT">312,184</td>
<td align="RIGHT">903,415</td>
<td align="RIGHT">840,701</td>
<td align="RIGHT">137,974</td>
<td align="RIGHT">210,726</td>
<td align="RIGHT">663,884</td>
<td align="RIGHT">136,028</td>
<td align="RIGHT">16,114</td>
<td align="RIGHT">369,458</td>
<td align="RIGHT">200,470</td>
<td align="RIGHT">59,523</td>
<td align="RIGHT">80,965</td>
<td align="RIGHT">399,904</td>
<td align="RIGHT">236,579</td>
</tr>
<tr>
<td style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(0,0,0)" height="17" align="LEFT">trunk</td>
<td style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(0,0,0)" align="RIGHT">271,747</td>
<td align="RIGHT">27,783</td>
<td align="RIGHT">600,859</td>
<td align="RIGHT">177,767</td>
<td align="RIGHT">460,546</td>
<td align="RIGHT">82,670</td>
<td align="RIGHT">40,271</td>
<td align="RIGHT">475,375</td>
<td align="RIGHT">988,993</td>
<td align="RIGHT">550,667</td>
<td align="RIGHT">359,344</td>
<td align="RIGHT">660,161</td>
<td align="RIGHT">151,592</td>
<td align="RIGHT">42,166</td>
<td align="RIGHT">560,291</td>
<td align="RIGHT">1,563,503</td>
<td align="RIGHT">163,209</td>
<td align="RIGHT">172,346</td>
<td align="RIGHT">178,599</td>
<td align="RIGHT">982,802</td>
</tr>
<tr>
<td style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(0,0,0)" height="17" align="LEFT">cycleway</td>
<td style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(0,0,0)" align="RIGHT">435,890</td>
<td align="RIGHT">24,925</td>
<td align="RIGHT">1,951,261</td>
<td align="RIGHT">633,199</td>
<td align="RIGHT">1,247,564</td>
<td align="RIGHT">397,632</td>
<td align="RIGHT">68,359</td>
<td align="RIGHT">1,237,893</td>
<td align="RIGHT">450,679</td>
<td align="RIGHT">61,973</td>
<td align="RIGHT">92,055</td>
<td align="RIGHT">134,616</td>
<td align="RIGHT">98,811</td>
<td align="RIGHT">6,956</td>
<td align="RIGHT">33,920</td>
<td align="RIGHT">112,588</td>
<td align="RIGHT">10,108</td>
<td align="RIGHT">20,377</td>
<td align="RIGHT">33,025</td>
<td align="RIGHT">66,586</td>
</tr>
<tr>
<td style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(0,0,0)" height="17" align="LEFT">road</td>
<td style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(0,0,0)" align="RIGHT">211,623</td>
<td align="RIGHT">1,856</td>
<td align="RIGHT">176,871</td>
<td align="RIGHT">29,332</td>
<td align="RIGHT">152,702</td>
<td align="RIGHT">3,697</td>
<td align="RIGHT">48,642</td>
<td align="RIGHT">122,751</td>
<td align="RIGHT">258,457</td>
<td align="RIGHT">333,730</td>
<td align="RIGHT">299,967</td>
<td align="RIGHT">582,796</td>
<td align="RIGHT">493,676</td>
<td align="RIGHT">84,356</td>
<td align="RIGHT">396,415</td>
<td align="RIGHT">304,704</td>
<td align="RIGHT">95,752</td>
<td align="RIGHT">149,557</td>
<td align="RIGHT">38,484</td>
<td align="RIGHT">319,091</td>
</tr>
<tr>
<td style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(0,0,0)" height="17" align="LEFT">motorway_link</td>
<td style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(0,0,0)" align="RIGHT">368,247</td>
<td align="RIGHT">21,102</td>
<td align="RIGHT">374,526</td>
<td align="RIGHT">47,337</td>
<td align="RIGHT">203,211</td>
<td align="RIGHT">93,735</td>
<td align="RIGHT">122,755</td>
<td align="RIGHT">173,530</td>
<td align="RIGHT">123,458</td>
<td align="RIGHT">5,956</td>
<td align="RIGHT">38,854</td>
<td align="RIGHT">239,096</td>
<td align="RIGHT">98,631</td>
<td align="RIGHT">4,827</td>
<td align="RIGHT">204,416</td>
<td align="RIGHT">66,493</td>
<td align="RIGHT">16,972</td>
<td align="RIGHT">65,248</td>
<td align="RIGHT">247,367</td>
<td align="LEFT"><br></td>
</tr>
<tr>
<td style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(0,0,0)" height="17" align="LEFT">pedestrian</td>
<td style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(0,0,0)" align="RIGHT">171,707</td>
<td align="RIGHT">12,318</td>
<td align="RIGHT">305,735</td>
<td align="RIGHT">73,935</td>
<td align="RIGHT">261,400</td>
<td align="RIGHT">53,076</td>
<td align="RIGHT">342,200</td>
<td align="RIGHT">130,690</td>
<td align="RIGHT">219,855</td>
<td align="RIGHT">36,859</td>
<td align="RIGHT">72,758</td>
<td align="RIGHT">180,435</td>
<td align="RIGHT">35,258</td>
<td align="RIGHT">7,506</td>
<td align="RIGHT">90,773</td>
<td align="RIGHT">154,019</td>
<td align="RIGHT">21,653</td>
<td align="RIGHT">80,076</td>
<td align="RIGHT">165,162</td>
<td align="RIGHT">41,308</td>
</tr>
<tr>
<td style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(0,0,0)" height="17" align="LEFT">trunk_link</td>
<td style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(0,0,0)" align="RIGHT">105,826</td>
<td align="RIGHT">2,170</td>
<td align="RIGHT">213,112</td>
<td align="RIGHT">45,138</td>
<td align="RIGHT">146,363</td>
<td align="RIGHT">27,233</td>
<td align="RIGHT">18,083</td>
<td align="RIGHT">170,553</td>
<td align="RIGHT">201,327</td>
<td align="RIGHT">113,333</td>
<td align="RIGHT">71,464</td>
<td align="RIGHT">187,908</td>
<td align="RIGHT">64,884</td>
<td align="RIGHT">11,501</td>
<td align="RIGHT">214,937</td>
<td align="RIGHT">411,327</td>
<td align="RIGHT">32,108</td>
<td align="RIGHT">28,357</td>
<td align="RIGHT">57,390</td>
<td align="RIGHT">225,917</td>
</tr>
<tr>
<td style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(0,0,0)" height="17" align="LEFT">construction</td>
<td style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(0,0,0)" align="RIGHT">54,660</td>
<td align="RIGHT">4,013</td>
<td align="RIGHT">506,874</td>
<td align="RIGHT">19,367</td>
<td align="RIGHT">177,225</td>
<td align="RIGHT">8,531</td>
<td align="RIGHT">16,189</td>
<td align="RIGHT">137,369</td>
<td align="RIGHT">143,991</td>
<td align="RIGHT">86,442</td>
<td align="RIGHT">93,774</td>
<td align="RIGHT">107,295</td>
<td align="RIGHT">16,214</td>
<td align="RIGHT">43,594</td>
<td align="RIGHT">51,224</td>
<td align="RIGHT">22,953</td>
<td align="RIGHT">68,388</td>
<td align="RIGHT">132,157</td>
<td align="RIGHT">140,665</td>
<td align="RIGHT">80,911</td>
</tr>
<tr>
<td style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(0,0,0)" height="17" align="LEFT">primary_link</td>
<td style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(0,0,0)" align="RIGHT">125,602</td>
<td align="RIGHT">7,140</td>
<td align="RIGHT">260,628</td>
<td align="RIGHT">47,694</td>
<td align="RIGHT">103,929</td>
<td align="RIGHT">28,505</td>
<td align="RIGHT">20,969</td>
<td align="RIGHT">106,452</td>
<td align="RIGHT">58,298</td>
<td align="RIGHT">35,053</td>
<td align="RIGHT">36,476</td>
<td align="RIGHT">119,595</td>
<td align="RIGHT">66,751</td>
<td align="RIGHT">82,431</td>
<td align="RIGHT">122,545</td>
<td align="RIGHT">103,416</td>
<td align="RIGHT">111,424</td>
<td align="RIGHT">74,523</td>
<td align="RIGHT">201,218</td>
<td align="RIGHT">102,225</td>
</tr>
<tr>
<td style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(0,0,0)" height="17" align="LEFT">living_street</td>
<td style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(0,0,0)" align="RIGHT">44,736</td>
<td align="RIGHT">2,891</td>
<td align="RIGHT">142,288</td>
<td align="RIGHT">33,420</td>
<td align="RIGHT">91,024</td>
<td align="RIGHT">23,813</td>
<td align="RIGHT">53,094</td>
<td align="RIGHT">133,833</td>
<td align="RIGHT">100,745</td>
<td align="RIGHT">6,682</td>
<td align="RIGHT">11,910</td>
<td align="RIGHT">116,733</td>
<td align="RIGHT">9,730</td>
<td align="RIGHT">1,009</td>
<td align="RIGHT">181,305</td>
<td align="RIGHT">42,165</td>
<td align="RIGHT">7,839</td>
<td align="RIGHT">18,044</td>
<td align="RIGHT">135,475</td>
<td align="RIGHT">8,209</td>
</tr>
<tr>
<td style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(0,0,0)" height="17" align="LEFT">steps</td>
<td style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(0,0,0)" align="RIGHT">23,779</td>
<td align="RIGHT">1,876</td>
<td align="RIGHT">83,029</td>
<td align="RIGHT">29,171</td>
<td align="RIGHT">94,765</td>
<td align="RIGHT">33,096</td>
<td align="RIGHT">135,036</td>
<td align="RIGHT">21,932</td>
<td align="RIGHT">31,167</td>
<td align="RIGHT">13,705</td>
<td align="RIGHT">21,753</td>
<td align="RIGHT">69,243</td>
<td align="RIGHT">10,976</td>
<td align="RIGHT">3,039</td>
<td align="RIGHT">56,722</td>
<td align="RIGHT">21,636</td>
<td align="RIGHT">15,701</td>
<td align="RIGHT">12,961</td>
<td align="RIGHT">78,790</td>
<td align="RIGHT">14,772</td>
</tr>
<tr>
<td style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(0,0,0)" height="17" align="LEFT">bridleway</td>
<td style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(0,0,0)" align="RIGHT">35,416</td>
<td align="RIGHT">673</td>
<td align="RIGHT">81,773</td>
<td align="RIGHT">23,797</td>
<td align="RIGHT">63,984</td>
<td align="RIGHT">16,009</td>
<td align="RIGHT">12,723</td>
<td align="RIGHT">56,370</td>
<td align="RIGHT">57,577</td>
<td align="RIGHT">13,928</td>
<td align="RIGHT">16,359</td>
<td align="RIGHT">194,901</td>
<td align="RIGHT">1,328</td>
<td align="RIGHT">682</td>
<td align="RIGHT">28,293</td>
<td align="RIGHT">10,739</td>
<td align="LEFT"><br></td>
<td align="RIGHT">1,057</td>
<td align="RIGHT">2,510</td>
<td align="RIGHT">54,952</td>
</tr>
<tr>
<td style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(0,0,0)" height="17" align="LEFT">secondary_link</td>
<td style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(0,0,0)" align="RIGHT">27,281</td>
<td align="RIGHT">1,002</td>
<td align="RIGHT">59,851</td>
<td align="RIGHT">4,653</td>
<td align="RIGHT">44,592</td>
<td align="RIGHT">10,963</td>
<td align="RIGHT">4,315</td>
<td align="RIGHT">45,921</td>
<td align="RIGHT">14,023</td>
<td align="RIGHT">6,185</td>
<td align="RIGHT">5,734</td>
<td align="RIGHT">37,713</td>
<td align="RIGHT">7,188</td>
<td align="RIGHT">1,707</td>
<td align="RIGHT">29,952</td>
<td align="RIGHT">59,632</td>
<td align="RIGHT">10,894</td>
<td align="RIGHT">23,188</td>
<td align="RIGHT">65,254</td>
<td align="RIGHT">31,893</td>
</tr>
<tr>
<td style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(0,0,0)" height="17" align="LEFT">raceway</td>
<td style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(0,0,0)" align="RIGHT">84,146</td>
<td align="RIGHT">715</td>
<td align="RIGHT">58,075</td>
<td align="RIGHT">5,412</td>
<td align="RIGHT">13,270</td>
<td align="RIGHT">2,668</td>
<td align="RIGHT">1,084</td>
<td align="RIGHT">59,172</td>
<td align="RIGHT">18,689</td>
<td align="RIGHT">4,313</td>
<td align="RIGHT">6,206</td>
<td align="RIGHT">25,376</td>
<td align="RIGHT">2,558</td>
<td align="LEFT"><br></td>
<td align="RIGHT">9,485</td>
<td align="RIGHT">34,013</td>
<td align="RIGHT">1,075</td>
<td align="RIGHT">4,870</td>
<td align="RIGHT">28,698</td>
<td align="RIGHT">8,629</td>
</tr>
<tr>
<td style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(0,0,0)" height="17" align="LEFT">tertiary_link</td>
<td style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(0,0,0)" align="RIGHT">10,420</td>
<td align="LEFT"><br></td>
<td align="RIGHT">29,285</td>
<td align="RIGHT">2,395</td>
<td align="RIGHT">21,610</td>
<td align="RIGHT">5,787</td>
<td align="RIGHT">2,670</td>
<td align="RIGHT">42,876</td>
<td align="RIGHT">7,484</td>
<td align="RIGHT">9,229</td>
<td align="RIGHT">846</td>
<td align="RIGHT">33,061</td>
<td align="RIGHT">10,120</td>
<td align="RIGHT">4,258</td>
<td align="RIGHT">44,843</td>
<td align="RIGHT">38,288</td>
<td align="RIGHT">8,824</td>
<td align="RIGHT">16,378</td>
<td align="RIGHT">24,686</td>
<td align="RIGHT">44,761</td>
</tr>
<tr>
<td height="17" align="LEFT"><br></td>
<td align="LEFT"><br></td>
<td align="LEFT"><br></td>
<td align="LEFT"><br></td>
<td align="LEFT"><br></td>
<td align="LEFT"><br></td>
<td align="LEFT"><br></td>
<td align="LEFT"><br></td>
<td align="LEFT"><br></td>
<td align="LEFT"><br></td>
<td align="LEFT"><br></td>
<td align="LEFT"><br></td>
<td align="LEFT"><br></td>
<td align="LEFT"><br></td>
<td align="LEFT"><br></td>
<td align="LEFT"><br></td>
<td align="LEFT"><br></td>
<td align="LEFT"><br></td>
<td align="LEFT"><br></td>
<td align="LEFT"><br></td>
<td align="LEFT"><br></td>
</tr>
</tbody>
</table></div><div class="gmail_extra"><br><br><div class="gmail_quote">2014-02-24 10:38 GMT+01:00 sabas88 <span dir="ltr"><<a href="mailto:sabas88@gmail.com" target="_blank">sabas88@gmail.com</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr"><br><div class="gmail_extra"><br><br><div class="gmail_quote">
Il giorno 24 febbraio 2014 10:28, Daniele Forsi <span dir="ltr"><<a href="mailto:dforsi@gmail.com" target="_blank">dforsi@gmail.com</a>></span> ha scritto:<div>
<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">Il 24 febbraio 2014 09:20, Diego Guidotti - Aedit s.r.l. ha scritto:<br>
<div><br>
> anche Daniele Forsi mi aveva segnalato lo stesso errore, io uso Postgres, se<br>
> ricordo bene la discrepanza era legata alle track.<br>
<br>
</div>le track spiegavano abbastanza bene le nostre differenze, ma io avevo<br>
2 versioni di haversine che davano risultati molto diversi e non<br>
sapevo quale era giusta, ora dopo il post di sabas88 ho visto che<br>
c'era un bug nella funzione haversine interna a osmium, ho rifatto i<br>
calcoli e ora i risultati tra le 2 versioni sono praticamente identici<br>
per i nostri fini, Stefano stai usando una versione di osmium che ha<br>
questa correzione?<br>
<a href="https://github.com/joto/osmium/commit/3adda4470b11c60cf066bfc9fa5401f5604f7cab" target="_blank">https://github.com/joto/osmium/commit/3adda4470b11c60cf066bfc9fa5401f5604f7cab</a><br>
<div><br></div></blockquote><div><br></div></div><div>No, me la sono copiata da una implementazione javascript, non mi pare che osmium esponga la funzione su osmjs... (la documentazione non aiuta :D)</div><div><a href="https://github.com/sabas/OSMetrics/blob/master/inc/utils.js#L47" target="_blank">https://github.com/sabas/OSMetrics/blob/master/inc/utils.js#L47</a><br>
</div><div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div>
> Probabilmente è un mio errore.<br>
<br>
</div>non è detto, io e Stefano stiamo usando la solita libreria quindi non<br>
è un indizio in più<br>
<br>
allego i miei risultati sul sardegna.pdf di ieri calcolati con la<br>
haversine interna a osmium senza il bug<br>
io ottengo<br>
totale 81.219.295 metri<br>
track 50.532.619<br>
differenza 30.686.676<br></blockquote><div> </div></div><div>I miei risultati non tengono conto delle track <a href="https://github.com/sabas/OSMetrics/blob/master/config.inc.js#L25" target="_blank">https://github.com/sabas/OSMetrics/blob/master/config.inc.js#L25</a></div>
<div>Sarà quello il problema?</div><div><br></div><div>Magari provo a reimplementare la funzione seguendo quella di osmium...</div><span><font color="#888888"><div><br></div></font></span><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<span><font color="#888888">
<span><font color="#888888">
--<br>
Daniele Forsi<br>
</font></span></font></span><div><br>_______________________________________________<br>
dev-italia mailing list<br>
<a href="mailto:dev-italia@openstreetmap.org" target="_blank">dev-italia@openstreetmap.org</a><br>
<a href="https://lists.openstreetmap.org/listinfo/dev-italia" target="_blank">https://lists.openstreetmap.org/listinfo/dev-italia</a><br>
<br></div></blockquote></div><br></div></div>
<br>_______________________________________________<br>
dev-italia mailing list<br>
<a href="mailto:dev-italia@openstreetmap.org" target="_blank">dev-italia@openstreetmap.org</a><br>
<a href="https://lists.openstreetmap.org/listinfo/dev-italia" target="_blank">https://lists.openstreetmap.org/listinfo/dev-italia</a><br>
<br></blockquote></div><br></div></div>