[dev-italia] Misurare la lunghezza del grafo stradale

Lun 24 Feb 2014 16:10:56 UTC

Ciao,
ci avviciniamo molto.

In effetti  usando solo le vie routable i risultati sono molto simili (le
differenze sono dovute sostanzialmente al diverso giorno di aggiornamento).
Rimane il problema della discrepanza delle statistiche sulle track se ho
tempo stasera approfondisco.

  *cod_reg* *highway* *diego* *daniele* *stefano* *diff*  20 track 15,237
50,533
231.64%  20 unclassified 9,616 9,656 9,662 0.41%  20 residential 6,141 6,181
6,192 0.64%  20 tertiary 4,321 4,340 4,341 0.44%  20 primary 2,657 2,667
2,667 0.37%  20 secondary 2,655 2,670 2,671 0.58%  20 path 1,673 1,763
5.38%  20 service 1,161 1,214 1,217 4.53%  20 trunk 983 983 983 0.01%  20
road 319 319 319 0.05%  20 footway 237 262
10.76%  20 trunk_link 226 226 226 -0.16%  20 primary_link 102 102 102 -0.46%
20 construction 81 81
-0.01%  20 cycleway 67 71
6.77%  20 bridleway 55 55
-0.11%  20 tertiary_link 45 45
0.27%  20 pedestrian 41 115
179.19%  20 secondary_link 32 32 32 0.01%  20 steps 15 17
13.71%  20 raceway 9 10
12.14%  20 living_street 8 9 9 6.08%  20 rest_area 1 2
58.49%  20 services 1 1
104.62%  20 piste 0 0
25.55%  20 razed 0 0
-0.95%  20 proposed 0 0
-0.73%  20 yes 0 0
-1.00%  20 bus_stop 0 0
-1.88%  20 residential;unclassified 3 3
0.00%
Totale 45,685 81,355 28,421

*Totale routable* *28,221* *28,398* *28,421*

2014-02-24 14:26 GMT+01:00 sabas88 <sabas88 a gmail.com>:

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