[dev-italia] Misurare la lunghezza del grafo stradale

Lun 24 Feb 2014 11:54:47 UTC

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
>
>
-------------- parte successiva --------------
Un allegato HTML è stato rimosso...
URL: <http://lists.openstreetmap.org/pipermail/dev-italia/attachments/20140224/7c5d2eea/attachment-0001.html>