Re: Magyar közúthálózat definiálása viszonylatként
Dömcsi
kititomi at gmail.com
2011. Sze. 27., K, 10:31:57 UTC
Most így néz ki:
route=road kapcsolatok
osm_id | ref | távolság
----------+-------+-------------------
-22133 | 1 | 178.864561220601
-23089 | 10 | 69.7587346184988
-38459 | 101 | 1.13363974344904
-38449 | 11 | 74.0597870385587
-90235 | 1101 | 6.98447946907325
-90250 | 1102 | 16.8057784187427
-90266 | 1103 | 16.6793447572907
-90282 | 1104 | 26.0064445346268
-90304 | 1105 | 15.9092473068423
-90297 | 1106 | 17.1528171431619
-90317 | 1107 | 16.2923000985316
-105393 | 1108 | 13.0676225353385
-105403 | 1109 | 8.49480086820538
-38455 | 111 | 7.60031419894363
-105405 | 1111 | 36.1223270115703
-105413 | 1112 | 3.22383027044319
-105432 | 1113 | 21.157000213191
-105415 | 1114 | 4.27528112078457
-105423 | 1115 | 5.28394885629609
-105429 | 1116 | 18.2458422730369
-38456 | 117 | 15.280691203959
-38469 | 12 | 26.416186118378
-38470 | 13 | 29.1016494441316
-38471 | 14 | 13.878763157527
-23090 | 150 | 0.859481369930645
-23096 | 2 | 68.6598707572827
-23097 | 21 | 66.0974784214228
-193196 | 2101 | 15.097616709518
-193225 | 2102 | 36.2383575423901
-193434 | 2103 | 9.45475893028998
-193443 | 2104 | 25.5284265812937
-193518 | 2105 | 14.3629046976148
-193599 | 2106 | 41.4561643766754
-193602 | 2107 | 7.62755397820497
-193613 | 2108 | 57.2434098572219
-193655 | 2109 | 24.1591359648383
-38481 | 22 | 66.3999185855732
-38483 | 221 | 2.10760028248544
-38486 | 23 | 32.3533234742904
-38501 | 24 | 62.3112102733431
-38506 | 25 | 82.1483511400754
-38508 | 26 | 45.4271848868091
-1212514 | 2613 | 27.0411530255914
-1209465 | 2615 | 24.443345737843
-1205083 | 2616 | 18.8654056905198
-1201779 | 2617 | 24.7521857392835
-1201781 | 2618 | 4.74092510506036
-1199358 | 2619 | 6.43673553093989
-1201438 | 2622 | 33.6586859200005
-1203239 | 2623 | 6.05321883722299
-1203220 | 2624 | 36.8476089228661
-1203233 | 2625 | 7.95068842922546
-23099 | 3 | 219.5997746419
-223258 | 301 | 2.1032235616963
-38533 | 302 | 2.80241925032452
-38531 | 304 | 4.47352707232089
-223268 | 306 | 2.60439567044505
-38582 | 31 | 130.851838401833
-195598 | 3101 | 21.0646412827282
-195652 | 3102 | 35.5776568746522
-195666 | 3103 | 23.2478658463307
-195784 | 3104 | 29.8247124824336
-195785 | 3105 | 33.3052435855807
-195796 | 3106 | 18.9010194857968
-196212 | 3107 | 14.3493858141086
-196227 | 3108 | 12.6640132806868
-196228 | 3109 | 10.8513890532875
-38583 | 311 | 34.257833524087
-196244 | 3111 | 17.2511765954673
-196245 | 3112 | 41.9469590052645
-196291 | 3113 | 13.9233686229821
-196293 | 3114 | 13.1072937201091
-196292 | 3115 | 22.0706526701965
-196326 | 3116 | 20.3151805963806
-196327 | 3117 | 19.1654660748648
-196328 | 3118 | 18.4516433350234
-196329 | 3119 | 17.179155623224
-196330 | 3121 | 20.2851762913913
-196331 | 3122 | 13.9027747939503
-38584 | 32 | 83.2252439932162
-51842 | 33 | 110.652569044792
-51843 | 34 | 53.3437955558389
-51851 | 35 | 83.9621419144067
-23104 | 354 | 4.76314874522109
-65762 | 36 | 51.2464493037796
-65777 | 37 | 82.5405464168253
-65785 | 38 | 39.7198366520796
-37939 | 4 | 371.694595810728
-38615 | 40 | 43.9446771865342
-38610 | 400 | 9.44011600147349
-38617 | 401 | 1.1756975000287
-23490 | 403 | 15.0724727616248
-23488 | 405 | 15.4641955497336
-23578 | 41 | 72.6405876355596
-23570 | 42 | 38.2046701208446
-23585 | 43 | 53.0913774002302
-65799 | 431 | 6.39641570314858
-23586 | 44 | 148.075071624948
-65805 | 441 | 32.6979907835891
-65815 | 442 | 40.8887066460127
-65830 | 443 | 19.3765926968407
-65895 | 444 | 2.01181988563189
-65892 | 445 | 6.64297633986562
-65897 | 45 | 52.5738463668093
-65900 | 451 | 43.1457516674737
-65904 | 46 | 72.4912858900864
-194490 | 4601 | 95.4818572771442
-194491 | 4602 | 16.2357216103599
-194499 | 4603 | 24.5952809203693
-194520 | 4604 | 29.1931712398255
-194550 | 4605 | 23.1528000098403
-194988 | 4606 | 30.5460181176827
-194989 | 4607 | 20.9839606151945
-194990 | 4608 | 32.612531688032
-195199 | 4609 | 30.5487435046402
-195200 | 4611 | 20.3223337295524
-195201 | 4612 | 12.453772906272
-195202 | 4613 | 28.521091271711
-195319 | 4614 | 38.0248902809357
-195303 | 4615 | 13.0173960563392
-195220 | 4616 | 9.66817562779002
-195302 | 4617 | 2.45239843765488
-66036 | 47 | 220.690381627864
-65919 | 470 | 21.2117815242452
-66035 | 471 | 73.5998702359607
-66047 | 472 | 0.847341042446387
-66042 | 474 | 12.6999010327861
-65996 | 48 | 30.0969907411182
-66001 | 49 | 57.3341008945302
-66029 | 491 | 38.0859415154942
-38124 | 5 | 185.264726509807
-23489 | 502 | 4.722904597979
-66256 | 51 | 178.207229960742
-66006 | 510 | 19.8567673732669
-105854 | 5101 | 49.9089265273031
-66271 | 511 | 3.80142257738739
-1204312 | 5113 | 20.3300739291107
-1204311 | 5114 | 5.44326364034979
-66274 | 512 | 3.55576560616679
-66259 | 513 | 8.05183366996047
-66289 | 52 | 64.0679741006811
-193019 | 5201 | 7.81057846269789
-193026 | 5202 | 71.837835390624
-193032 | 5203 | 56.5744372375987
-193034 | 5204 | 9.97401918277147
-193033 | 5205 | 40.4222620551679
-193035 | 5206 | 19.6241543426761
-66298 | 53 | 75.7098587127834
-66326 | 54 | 93.2231313792061
-66328 | 541 | 3.39753036852873
-66330 | 542 | 9.57253022083557
-66320 | 55 | 148.644181391059
-66272 | 551 | 2.00796231600988
-66364 | 56 | 53.6717348960846
-66365 | 57 | 43.3559760803678
-66370 | 58 | 32.9795502081131
-21818 | 6 | 272.899025903157
-66928 | 61 | 201.728492936134
-66959 | 610 | 16.4680237655711
-66977 | 611 | 15.1416253496678
-67117 | 62 | 45.8849992647818
-67132 | 63 | 97.8104749493119
-67133 | 64 | 37.2200584640075
-67139 | 65 | 85.6923126595894
-67142 | 66 | 55.3701286558531
-67157 | 67 | 94.2500601127242
-67169 | 68 | 96.4023588298269
-37761 | 7 | 254.321066212542
-67193 | 71 | 117.865489644611
-1203170 | 710 | 16.1492157836043
-67235 | 72 | 7.79682435593523
-67246 | 73 | 13.4146418466632
-67247 | 74 | 77.5851327475127
-225695 | 741 | 1.14319919961172
-67250 | 75 | 75.342171962016
-67248 | 76 | 80.9526170824658
-67249 | 761 | 4.99072066189289
-38159 | 8 | 197.211396936916
-67335 | 81 | 83.6578511496786
-105213 | 8101 | 33.7175107645518
-105331 | 8102 | 26.0666677832029
-105334 | 8103 | 5.35580064977565
-105346 | 8104 | 14.2744763546307
-105363 | 8105 | 1.39198796450551
-105375 | 8106 | 18.621913269189
-105388 | 8107 | 2.50747647994014
-67339 | 811 | 40.296011294684
-67346 | 82 | 76.7890336578932
-67352 | 821 | 3.06573411089638
-67353 | 83 | 73.3790216738208
-67395 | 84 | 130.860753912391
-67401 | 85 | 70.9165145778474
-67426 | 86 | 189.298288205953
-67390 | 861 | 2.15461568176633
-67379 | 87 | 51.3050297625193
-67367 | 88 | 11.7136552421332
-67372 | 89 | 12.4126607490821
-38388 | E 573 | 181.309460336608
-38441 | E 575 | 20.1051367263161
-195443 | E 60 | 533.735791346557
-33232 | E 65 | 259.538287168008
-38436 | E 653 | 8.22594572512149
-38304 | E 66 | 195.180265960799
-38437 | E 661 | 97.2521660608021
-38260 | E 68 | 138.928151800165
-38345 | E 71 | 819.558832194371
-38373 | E 73 | 366.242248014054
-67630 | E 75 | 600.172685982669
-32929 | E 77 | 61.7818118447094
-38273 | E 79 | 235.175311400234
-21750 | M0 | 165.755552014132
-21313 | M1 | 338.910941481219
-21742 | M15 | 17.0664379816763
-21743 | M19 | 12.0210257092003
-21741 | M2 | 37.208783820247
-21316 | M3 | 459.220380948569
-23060 | M30 | 58.2863328694461
-23062 | M35 | 86.9224928216123
-23064 | M43 | 73.2165804884342
-23070 | M5 | 269.0769700968
-23086 | M6 | 359.255746420562
-1028298 | M60 | 61.497741877084
-21311 | M7 | 367.036803937234
-21739 | M70 | 8.22594572512149
-23087 | M8 | 18.9103801028412
-225681 | M86 | 13.5451966070139
-21737 | M9 | 20.6437571872337
-1566972 | | 1.03300066735877
-1566953 | | 7.16117520224866
-1566971 | | 0.39893338005546
-1566955 | | 15.0398986516162
(231 rows)
Ha némelyik autópálya hosszúnak tűnik az azért van mert mindkét
pályatest hozzá van adva a kapcsolathoz.
További információk a(z) Talk-hu levelezőlistáról