6. Appendix: Basic workshop solutions¶
6.1. Solutions to Pedestrian Routing¶
6.1.1. Exercise: 1 (Chapter: Pedestrian)¶
Exercise 1: Single pedestrian routing
seq | path_seq | start_vid | end_vid | node | edge | cost | agg_cost
-----+----------+-----------+---------+-------+-------+------------------------+-----------------------
1 | 1 | 956 | 11186 | 956 | 15379 | 4.950646422578627e-05 | 0
2 | 2 | 956 | 11186 | 13960 | 21118 | 0.0005299835725109238 | 4.950646422578627e-05
3 | 3 | 956 | 11186 | 21343 | 31852 | 0.0005129478141088024 | 0.00057949003673671
4 | 4 | 956 | 11186 | 21342 | 44390 | 0.0010532421715714721 | 0.0010924378508455125
5 | 5 | 956 | 11186 | 30567 | 44389 | 3.889318706260121e-05 | 0.0021456800224169846
6 | 6 | 956 | 11186 | 11749 | 24595 | 2.3769307939945654e-05 | 0.0021845732094795856
7 | 7 | 956 | 11186 | 30566 | 44387 | 8.772684884137155e-06 | 0.002208342517419531
8 | 8 | 956 | 11186 | 16642 | 25382 | 5.968048257081435e-05 | 0.002217115202303668
9 | 9 | 956 | 11186 | 18301 | 27692 | 1.8423083348303075e-05 | 0.0022767956848744825
10 | 10 | 956 | 11186 | 30565 | 44385 | 6.460789425305775e-05 | 0.0022952187682227856
11 | 11 | 956 | 11186 | 11744 | 27695 | 0.0016920113102375026 | 0.0023598266624758435
12 | 12 | 956 | 11186 | 18304 | 20205 | 9.524211253751028e-05 | 0.0040518379727133465
13 | 13 | 956 | 11186 | 171 | 12657 | 0.0002576686438042651 | 0.004147080085250857
14 | 14 | 956 | 11186 | 11186 | -1 | 0 | 0.004404748729055122
(14 rows)
6.1.2. Exercise: 2 (Chapter: Pedestrian)¶
Exercise 2: Many Pedestrians going to the same destination
seq | path_seq | start_vid | end_vid | node | edge | cost | agg_cost
-----+----------+-----------+---------+-------+-------+--------------------+--------------------
1 | 1 | 956 | 11186 | 956 | 15379 | 4.388891847163529 | 0
2 | 2 | 956 | 11186 | 13960 | 21118 | 52.14640405214529 | 4.388891847163529
3 | 3 | 956 | 11186 | 21343 | 31852 | 46.491094131176176 | 56.53529589930882
4 | 4 | 956 | 11186 | 21342 | 44390 | 94.83187965355248 | 103.026390030485
5 | 5 | 956 | 11186 | 30567 | 44389 | 3.7606323336486054 | 197.85826968403748
6 | 6 | 956 | 11186 | 11749 | 24595 | 2.2846749488340667 | 201.61890201768608
7 | 7 | 956 | 11186 | 30566 | 44387 | 0.8425527290468267 | 203.90357696652015
8 | 8 | 956 | 11186 | 16642 | 25382 | 5.798826334250774 | 204.74612969556696
9 | 9 | 956 | 11186 | 18301 | 27692 | 1.5796898799193155 | 210.54495602981774
10 | 10 | 956 | 11186 | 30565 | 44385 | 5.534588526784583 | 212.12464590973707
11 | 11 | 956 | 11186 | 11744 | 27695 | 174.74987454269322 | 217.65923443652164
12 | 12 | 956 | 11186 | 18304 | 20205 | 9.838171234496908 | 392.40910897921486
13 | 13 | 956 | 11186 | 171 | 12657 | 21.47764087293261 | 402.24728021371175
14 | 14 | 956 | 11186 | 11186 | -1 | 0 | 423.7249210866444
15 | 1 | 7039 | 11186 | 7039 | 6925 | 15.791472891514646 | 0
16 | 2 | 7039 | 11186 | 5820 | 16464 | 20.45352421564098 | 15.791472891514646
17 | 3 | 7039 | 11186 | 15037 | 7395 | 8.833089782213422 | 36.244997107155626
18 | 4 | 7039 | 11186 | 6254 | 16462 | 4.583342788997136 | 45.07808688936905
19 | 5 | 7039 | 11186 | 15035 | 6920 | 3.410782500499449 | 49.66142967836618
20 | 6 | 7039 | 11186 | 5814 | 13208 | 4.013779206664128 | 53.072212178865634
21 | 7 | 7039 | 11186 | 11743 | 6923 | 2.509191424875673 | 57.08599138552976
22 | 8 | 7039 | 11186 | 5817 | 6922 | 17.594370325159545 | 59.59518281040543
23 | 9 | 7039 | 11186 | 11765 | 13227 | 27.3157021773366 | 77.18955313556498
24 | 10 | 7039 | 11186 | 2260 | 2876 | 37.47398199097921 | 104.50525531290158
25 | 11 | 7039 | 11186 | 11634 | 13098 | 17.18643065813849 | 141.97923730388078
26 | 12 | 7039 | 11186 | 11735 | 13201 | 9.954211444192527 | 159.16566796201926
27 | 13 | 7039 | 11186 | 2261 | 19982 | 3.212633563208631 | 169.1198794062118
28 | 14 | 7039 | 11186 | 17627 | 26751 | 1.1154611174555893 | 172.33251296942043
29 | 15 | 7039 | 11186 | 11738 | 13203 | 2.77852751198013 | 173.44797408687603
30 | 16 | 7039 | 11186 | 11390 | 12857 | 16.770930826209703 | 176.22650159885615
31 | 17 | 7039 | 11186 | 11597 | 13058 | 7.810137850067213 | 192.99743242506585
32 | 18 | 7039 | 11186 | 11186 | -1 | 0 | 200.80757027513306
(32 rows)
6.1.3. Exercise: 3 (Chapter: Pedestrian)¶
Exercise 3: Many Pedestrians departing from the same location
seq | path_seq | start_vid | end_vid | node | edge | cost | agg_cost
-----+----------+-----------+---------+-------+-------+--------------------+--------------------
1 | 1 | 11186 | 956 | 11186 | 12657 | 16.521262209948162 | 0
2 | 2 | 11186 | 956 | 171 | 20205 | 7.5678240265360825 | 16.521262209948162
3 | 3 | 11186 | 956 | 18304 | 27695 | 134.42298041745633 | 24.089086236484246
4 | 4 | 11186 | 956 | 11744 | 44385 | 4.2573757898342945 | 158.51206665394056
5 | 5 | 11186 | 956 | 30565 | 27692 | 1.2151460614763965 | 162.76944244377486
6 | 6 | 11186 | 956 | 18301 | 25382 | 4.460635641731364 | 163.98458850525125
7 | 7 | 11186 | 956 | 16642 | 44387 | 0.6481174838821743 | 168.4452241469826
8 | 8 | 11186 | 956 | 30566 | 24595 | 1.7574422683338975 | 169.09334163086478
9 | 9 | 11186 | 956 | 11749 | 44389 | 2.8927941028066195 | 170.8507838991987
10 | 10 | 11186 | 956 | 30567 | 44390 | 72.9475997335019 | 173.7435780020053
11 | 11 | 11186 | 956 | 21342 | 31852 | 35.76238010090475 | 246.6911777355072
12 | 12 | 11186 | 956 | 21343 | 21118 | 40.112618501650225 | 282.45355783641196
13 | 13 | 11186 | 956 | 13960 | 15379 | 3.3760706516642527 | 322.5661763380622
14 | 14 | 11186 | 956 | 956 | -1 | 0 | 325.9422469897264
15 | 1 | 11186 | 7039 | 11186 | 13058 | 6.007798346205548 | 0
16 | 2 | 11186 | 7039 | 11597 | 12857 | 12.90071602016131 | 6.007798346205548
17 | 3 | 11186 | 7039 | 11390 | 13203 | 2.1373288553693306 | 18.90851436636686
18 | 4 | 11186 | 7039 | 11738 | 26751 | 0.8580470134273763 | 21.045843221736188
19 | 5 | 11186 | 7039 | 17627 | 19982 | 2.4712565870835626 | 21.903890235163566
20 | 6 | 11186 | 7039 | 2261 | 13201 | 7.657085726301943 | 24.375146822247128
21 | 7 | 11186 | 7039 | 11735 | 13098 | 13.220331275491146 | 32.032232548549075
22 | 8 | 11186 | 7039 | 11634 | 2876 | 28.82613999306093 | 45.25256382404022
23 | 9 | 11186 | 7039 | 2260 | 13227 | 21.01207859795123 | 74.07870381710116
24 | 10 | 11186 | 7039 | 11765 | 6922 | 13.534131019353495 | 95.09078241505239
25 | 11 | 11186 | 7039 | 5817 | 6923 | 1.9301472499043637 | 108.62491343440588
26 | 12 | 11186 | 7039 | 11743 | 13208 | 3.087522466664714 | 110.55506068431025
27 | 13 | 11186 | 7039 | 5814 | 6920 | 2.623678846538038 | 113.64258315097496
28 | 14 | 11186 | 7039 | 15035 | 16462 | 3.5256482992285663 | 116.266261997513
29 | 15 | 11186 | 7039 | 6254 | 7395 | 6.794684447856478 | 119.79191029674156
30 | 16 | 11186 | 7039 | 15037 | 16464 | 15.733480165877676 | 126.58659474459805
31 | 17 | 11186 | 7039 | 5820 | 6925 | 12.14728683962665 | 142.3200749104757
32 | 18 | 11186 | 7039 | 7039 | -1 | 0 | 154.46736175010236
(32 rows)
6.1.4. Exercise: 4 (Chapter: Pedestrian)¶
Exercise 4: Many Pedestrians going to different destinations
seq | path_seq | start_vid | end_vid | node | edge | cost | agg_cost
-----+----------+-----------+---------+-------+-------+----------------------+---------------------
1 | 1 | 956 | 6354 | 956 | 17798 | 1.2282241692539222 | 0
2 | 2 | 956 | 6354 | 645 | 17756 | 0.9101790102278335 | 1.2282241692539222
3 | 3 | 956 | 6354 | 513 | 633 | 0.4442389668917909 | 2.138403179481756
4 | 4 | 956 | 6354 | 1794 | 2288 | 0.6060510420719875 | 2.582642146373547
5 | 5 | 956 | 6354 | 1788 | 2279 | 0.6724934703589363 | 3.1886931884455345
6 | 6 | 956 | 6354 | 512 | 632 | 0.021336049618405 | 3.8611866588044705
7 | 7 | 956 | 6354 | 14163 | 21112 | 0.010343511656864155 | 3.8825227084228757
8 | 8 | 956 | 6354 | 21334 | 31840 | 0.7884005138611313 | 3.89286622007974
9 | 9 | 956 | 6354 | 15135 | 16565 | 0.3591552563357652 | 4.681266733940872
10 | 10 | 956 | 6354 | 971 | 1199 | 1.4484960824691477 | 5.040421990276637
11 | 11 | 956 | 6354 | 6354 | -1 | 0 | 6.4889180727457845
12 | 1 | 956 | 21407 | 956 | 15379 | 0.05626784419440421 | 0
13 | 2 | 956 | 21407 | 13960 | 21118 | 0.6685436416941705 | 0.05626784419440421
14 | 3 | 956 | 21407 | 21343 | 31852 | 0.5960396683484125 | 0.7248114858885747
15 | 4 | 956 | 21407 | 21342 | 44390 | 1.2157933288916984 | 1.3208511542369872
16 | 5 | 956 | 21407 | 30567 | 44389 | 0.04821323504677699 | 2.5366444831286854
17 | 6 | 956 | 21407 | 11749 | 24595 | 0.029290704472231626 | 2.5848577181754626
18 | 7 | 956 | 21407 | 30566 | 44387 | 0.010801958064702905 | 2.6141484226476943
19 | 8 | 956 | 21407 | 16642 | 25382 | 0.0743439273621894 | 2.6249503807123973
20 | 9 | 956 | 21407 | 18301 | 27692 | 0.02025243435793994 | 2.699294308074587
21 | 10 | 956 | 21407 | 30565 | 44386 | 0.07756141815895594 | 2.719546742432527
22 | 11 | 956 | 21407 | 21407 | -1 | 0 | 2.797108160591483
23 | 1 | 7039 | 6354 | 7039 | 6925 | 0.20245478066044417 | 0
24 | 2 | 7039 | 6354 | 5820 | 16464 | 0.2622246694312946 | 0.20245478066044417
25 | 3 | 7039 | 6354 | 15037 | 7395 | 0.11324474079760798 | 0.4646794500917387
26 | 4 | 7039 | 6354 | 6254 | 43773 | 0.24843498043677237 | 0.5779241908893467
27 | 5 | 7039 | 6354 | 30113 | 24511 | 0.1789926382805013 | 0.826359171326119
28 | 6 | 7039 | 6354 | 15049 | 16476 | 0.24277855571743723 | 1.0053518096066203
29 | 7 | 7039 | 6354 | 6284 | 7430 | 0.09826499683059635 | 1.2481303653240574
30 | 8 | 7039 | 6354 | 6283 | 7429 | 0.7619864679297488 | 1.3463953621546538
31 | 9 | 7039 | 6354 | 6276 | 7421 | 0.7675341278797493 | 2.1083818300844026
32 | 10 | 7039 | 6354 | 6272 | 7418 | 0.5465834379505062 | 2.875915957964152
33 | 11 | 7039 | 6354 | 6270 | 7415 | 0.12432377789391297 | 3.422499395914658
34 | 12 | 7039 | 6354 | 6253 | 7394 | 0.12439985279258152 | 3.546823173808571
35 | 13 | 7039 | 6354 | 12225 | 24517 | 0.02315593499063834 | 3.6712230266011523
36 | 14 | 7039 | 6354 | 30146 | 44915 | 0.44246512660669113 | 3.6943789615917906
37 | 15 | 7039 | 6354 | 30934 | 44914 | 0.054586998512356634 | 4.136844088198481
38 | 16 | 7039 | 6354 | 15296 | 24657 | 0.04986415863976471 | 4.191431086710838
39 | 17 | 7039 | 6354 | 30936 | 44917 | 1.036130486604866 | 4.241295245350603
40 | 18 | 7039 | 6354 | 21216 | 31683 | 0.11476361267462877 | 5.277425731955469
41 | 19 | 7039 | 6354 | 21215 | 31681 | 0.04766449638114226 | 5.392189344630098
42 | 20 | 7039 | 6354 | 14835 | 21059 | 0.024568137580087867 | 5.4398538410112405
43 | 21 | 7039 | 6354 | 21214 | 31680 | 0.03421541170676748 | 5.464421978591329
44 | 22 | 7039 | 6354 | 21182 | 31501 | 1.2137012699538916 | 5.4986373902980965
45 | 23 | 7039 | 6354 | 21090 | 31504 | 0.24082487281620235 | 6.712338660251988
46 | 24 | 7039 | 6354 | 21091 | 31505 | 0.47857551764048795 | 6.9531635330681905
47 | 25 | 7039 | 6354 | 21092 | 21016 | 0.03157996203762825 | 7.4317390507086785
48 | 26 | 7039 | 6354 | 14814 | 31752 | 0.03093631269002559 | 7.4633190127463065
49 | 27 | 7039 | 6354 | 21266 | 31753 | 0.7275764896000112 | 7.494255325436332
50 | 28 | 7039 | 6354 | 21265 | 31750 | 0.03427605314578379 | 8.221831815036342
51 | 29 | 7039 | 6354 | 14824 | 21076 | 0.03974844007043725 | 8.256107868182125
52 | 30 | 7039 | 6354 | 21262 | 31747 | 0.6820252158515563 | 8.295856308252562
53 | 31 | 7039 | 6354 | 29487 | 42880 | 0.02910910416223888 | 8.977881524104118
54 | 32 | 7039 | 6354 | 13996 | 23299 | 0.8150023931384649 | 9.006990628266356
55 | 33 | 7039 | 6354 | 27011 | 28688 | 0.042406733070242425 | 9.821993021404822
56 | 34 | 7039 | 6354 | 19013 | 40822 | 0.10021542929506538 | 9.864399754475064
57 | 35 | 7039 | 6354 | 27913 | 23692 | 0.03006927719545052 | 9.96461518377013
58 | 36 | 7039 | 6354 | 6354 | -1 | 0 | 9.99468446096558
59 | 1 | 7039 | 21407 | 7039 | 6925 | 0.20245478066044417 | 0
60 | 2 | 7039 | 21407 | 5820 | 16464 | 0.2622246694312946 | 0.20245478066044417
61 | 3 | 7039 | 21407 | 15037 | 7395 | 0.11324474079760798 | 0.4646794500917387
62 | 4 | 7039 | 21407 | 6254 | 16462 | 0.05876080498714277 | 0.5779241908893467
63 | 5 | 7039 | 21407 | 15035 | 6920 | 0.043727980775633966 | 0.6366849958764894
64 | 6 | 7039 | 21407 | 5814 | 13208 | 0.05145870777774523 | 0.6804129766521234
65 | 7 | 7039 | 21407 | 11743 | 6923 | 0.032169120831739395 | 0.7318716844298686
66 | 8 | 7039 | 21407 | 5817 | 16475 | 0.10791139234901702 | 0.764040805261608
67 | 9 | 7039 | 21407 | 15048 | 43775 | 0.7704311049889149 | 0.871952197610625
68 | 10 | 7039 | 21407 | 30115 | 27830 | 0.08859659439601732 | 1.6423833025995398
69 | 11 | 7039 | 21407 | 18399 | 27504 | 0.02318273516003578 | 1.7309798969955572
70 | 12 | 7039 | 21407 | 18173 | 27503 | 0.04911663869169241 | 1.754162632155593
71 | 13 | 7039 | 21407 | 18172 | 27831 | 0.02331095943275676 | 1.8032792708472853
72 | 14 | 7039 | 21407 | 18400 | 20236 | 0.024716645396698995 | 1.826590230280042
73 | 15 | 7039 | 21407 | 11665 | 43359 | 0.1035587292462392 | 1.851306875676741
74 | 16 | 7039 | 21407 | 29812 | 40426 | 0.29112746176237664 | 1.9548656049229802
75 | 17 | 7039 | 21407 | 27614 | 31940 | 0.12011445517087985 | 2.2459930666853567
76 | 18 | 7039 | 21407 | 21405 | 43362 | 0.04910817165828169 | 2.3661075218562364
77 | 19 | 7039 | 21407 | 29814 | 25383 | 0.022004164661102537 | 2.415215693514518
78 | 20 | 7039 | 21407 | 16643 | 26306 | 0.38827509761398404 | 2.4372198581756206
79 | 21 | 7039 | 21407 | 17280 | 25384 | 0.32472071488405024 | 2.8254949557896047
80 | 22 | 7039 | 21407 | 16644 | 44399 | 0.010073004621645796 | 3.150215670673655
81 | 23 | 7039 | 21407 | 30572 | 31941 | 0.08713552394086416 | 3.160288675295301
82 | 24 | 7039 | 21407 | 21406 | 31942 | 0.11466079418587798 | 3.247424199236165
83 | 25 | 7039 | 21407 | 21407 | -1 | 0 | 3.362084993422043
(83 rows)
6.1.5. Exercise: 5 (Chapter: Pedestrian)¶
Exercise 5: Many Pedestrians going to different destinations returning aggregate costs
start_vid | end_vid | agg_cost
-----------+---------+--------------------
956 | 6354 | 6.4889180727457845
956 | 21407 | 2.797108160591483
7039 | 6354 | 9.99468446096558
7039 | 21407 | 3.362084993422043
(4 rows)
6.1.6. Exercise: 6 (Chapter: Pedestrian)¶
start_vid | sum
-----------+--------------------
956 | 9.286026233337267
7039 | 13.356769454387623
(2 rows)
6.2. Solutions to Vehicle Routing¶
6.2.1. Exercise: 1 (Chapter: Vehicle)¶
Exercise 1: Vehicle routing - going
seq | path_seq | start_vid | end_vid | node | edge | cost | agg_cost
-----+----------+-----------+---------+-------+-------+------------------------+-----------------------
1 | 1 | 956 | 11186 | 956 | 15379 | 4.950646422578627e-05 | 0
2 | 2 | 956 | 11186 | 13960 | 21118 | 0.0005299835725109238 | 4.950646422578627e-05
3 | 3 | 956 | 11186 | 21343 | 31852 | 0.0005129478141088024 | 0.00057949003673671
4 | 4 | 956 | 11186 | 21342 | 44390 | 0.0010532421715714721 | 0.0010924378508455125
5 | 5 | 956 | 11186 | 30567 | 44389 | 3.889318706260121e-05 | 0.0021456800224169846
6 | 6 | 956 | 11186 | 11749 | 24595 | 2.3769307939945654e-05 | 0.0021845732094795856
7 | 7 | 956 | 11186 | 30566 | 44387 | 8.772684884137155e-06 | 0.002208342517419531
8 | 8 | 956 | 11186 | 16642 | 25382 | 5.968048257081435e-05 | 0.002217115202303668
9 | 9 | 956 | 11186 | 18301 | 27692 | 1.8423083348303075e-05 | 0.0022767956848744825
10 | 10 | 956 | 11186 | 30565 | 44385 | 6.460789425305775e-05 | 0.0022952187682227856
11 | 11 | 956 | 11186 | 11744 | 27695 | 0.0016920113102375026 | 0.0023598266624758435
12 | 12 | 956 | 11186 | 18304 | 20205 | 9.524211253751028e-05 | 0.0040518379727133465
13 | 13 | 956 | 11186 | 171 | 12657 | 0.0002576686438042651 | 0.004147080085250857
14 | 14 | 956 | 11186 | 11186 | -1 | 0 | 0.004404748729055122
(14 rows)
6.2.2. Exercise: 2 (Chapter: Vehicle)¶
Exercise 2: Vehicle routing - returning
seq | path_seq | start_vid | end_vid | node | edge | cost | agg_cost
-----+----------+-----------+---------+-------+-------+------------------------+-----------------------
1 | 1 | 11186 | 956 | 11186 | 13058 | 9.365682036108894e-05 | 0
2 | 2 | 11186 | 956 | 11597 | 24516 | 0.00011762525239313356 | 9.365682036108894e-05
3 | 3 | 11186 | 956 | 30141 | 43816 | 0.0002980478966330285 | 0.0002112820727542225
4 | 4 | 11186 | 956 | 21411 | 31948 | 1.2149074037856285e-05 | 0.000509329969387251
5 | 5 | 11186 | 956 | 31397 | 45528 | 0.0016195634479419744 | 0.0005214790434251073
6 | 6 | 11186 | 956 | 21406 | 31942 | 0.00010619199592913266 | 0.0021410424913670817
7 | 7 | 11186 | 956 | 21407 | 44386 | 6.163318911361132e-05 | 0.0022472344872962145
8 | 8 | 11186 | 956 | 30565 | 27692 | 1.8423083348303075e-05 | 0.0023088676764098258
9 | 9 | 11186 | 956 | 18301 | 25382 | 5.968048257081435e-05 | 0.002327290759758129
10 | 10 | 11186 | 956 | 16642 | 44387 | 8.772684884137155e-06 | 0.0023869712423289433
11 | 11 | 11186 | 956 | 30566 | 24595 | 2.3769307939945654e-05 | 0.0023957439272130803
12 | 12 | 11186 | 956 | 11749 | 44389 | 3.889318706260121e-05 | 0.002419513235153026
13 | 13 | 11186 | 956 | 30567 | 44390 | 0.0010532421715714721 | 0.002458406422215627
14 | 14 | 11186 | 956 | 21342 | 31852 | 0.0005129478141088024 | 0.003511648593787099
15 | 15 | 11186 | 956 | 21343 | 21118 | 0.0005299835725109238 | 0.004024596407895901
16 | 16 | 11186 | 956 | 13960 | 15379 | 4.950646422578627e-05 | 0.004554579980406825
17 | 17 | 11186 | 956 | 956 | -1 | 0 | 0.004604086444632611
(17 rows)
6.2.3. Exercise: 3 (Chapter: Vehicle)¶
Exercise 3: Vehicle routing when time is money
seq | path_seq | start_vid | end_vid | node | edge | cost | agg_cost
-----+----------+-----------+---------+-------+-------+-----------------------+----------------------
1 | 1 | 956 | 11186 | 956 | 15379 | 0.008777783694327057 | 0
2 | 2 | 956 | 11186 | 13960 | 21118 | 0.10429280810429059 | 0.008777783694327057
3 | 3 | 956 | 11186 | 21343 | 31852 | 0.09298218826235234 | 0.11307059179861764
4 | 4 | 956 | 11186 | 21342 | 44390 | 0.18966375930710497 | 0.20605278006097
5 | 5 | 956 | 11186 | 30567 | 44389 | 0.007521264667297211 | 0.39571653936807494
6 | 6 | 956 | 11186 | 11749 | 24595 | 0.004569349897668133 | 0.4032378040353721
7 | 7 | 956 | 11186 | 30566 | 44387 | 0.0016851054580936534 | 0.40780715393304023
8 | 8 | 956 | 11186 | 16642 | 25382 | 0.011597652668501547 | 0.4094922593911339
9 | 9 | 956 | 11186 | 18301 | 27692 | 0.003159379759838631 | 0.4210899120596354
10 | 10 | 956 | 11186 | 30565 | 44385 | 0.011069177053569168 | 0.4242492918194741
11 | 11 | 956 | 11186 | 11744 | 27695 | 0.3494997490853864 | 0.43531846887304326
12 | 12 | 956 | 11186 | 18304 | 20205 | 0.019676342468993815 | 0.7848182179584297
13 | 13 | 956 | 11186 | 171 | 12657 | 0.04295528174586522 | 0.8044945604274235
14 | 14 | 956 | 11186 | 11186 | -1 | 0 | 0.8474498421732888
(14 rows)
6.2.4. Exercise: 4 (Chapter: Vehicle)¶
Exercise 4: Vehicle routing without penalization
ALTER TABLE
UPDATE 36
seq | path_seq | start_vid | end_vid | node | edge | cost | agg_cost
-----+----------+-----------+---------+-------+-------+---------------------+--------------------
1 | 1 | 11186 | 956 | 11186 | 13058 | 0.5623299252048394 | 0
2 | 2 | 11186 | 956 | 11597 | 24516 | 0.8827556790716857 | 0.5623299252048394
3 | 3 | 11186 | 956 | 30141 | 43816 | 1.8230021030599453 | 1.445085604276525
4 | 4 | 11186 | 956 | 21411 | 31948 | 0.09012044664074541 | 3.2680877073364702
5 | 5 | 11186 | 956 | 31397 | 45528 | 12.044019706645777 | 3.3582081539772157
6 | 6 | 11186 | 956 | 21406 | 31942 | 0.6439350201478907 | 15.402227860622993
7 | 7 | 11186 | 956 | 21407 | 44386 | 0.43558492438069657 | 16.046162880770883
8 | 8 | 11186 | 956 | 30565 | 27692 | 0.11373767135419072 | 16.481747805151578
9 | 9 | 11186 | 956 | 18301 | 25382 | 0.4175154960660557 | 16.595485476505768
10 | 10 | 11186 | 956 | 16642 | 44387 | 0.06066379649137152 | 17.013000972571824
11 | 11 | 11186 | 956 | 30566 | 24595 | 0.1644965963160528 | 17.073664769063196
12 | 12 | 11186 | 956 | 11749 | 44389 | 0.2707655280226996 | 17.23816136537925
13 | 13 | 11186 | 956 | 30567 | 44390 | 6.8278953350557785 | 17.50892689340195
14 | 14 | 11186 | 956 | 21342 | 31852 | 3.3473587774446845 | 24.336822228457727
15 | 15 | 11186 | 956 | 21343 | 21118 | 3.754541091754461 | 27.68418100590241
16 | 16 | 11186 | 956 | 13960 | 15379 | 0.3160002129957741 | 31.43872209765687
17 | 17 | 11186 | 956 | 956 | -1 | 0 | 31.754722310652646
(17 rows)
6.2.5. Exercise: 5 (Chapter: Vehicle)¶
Exercise 5: Vehicle routing with penalization
seq | path_seq | start_vid | end_vid | node | edge | cost | agg_cost
-----+----------+-----------+---------+-------+-------+---------------------+--------------------
1 | 1 | 11186 | 956 | 11186 | 12657 | 7.73195071425574 | 0
2 | 2 | 11186 | 956 | 171 | 13218 | 0.44432222692118006 | 7.73195071425574
3 | 3 | 11186 | 956 | 11753 | 15589 | 7.497069955474949 | 8.17627294117692
4 | 4 | 11186 | 956 | 14165 | 220 | 0.12306717428755093 | 15.673342896651869
5 | 5 | 11186 | 956 | 185 | 16112 | 5.199219695787101 | 15.79641007093942
6 | 6 | 11186 | 956 | 14687 | 683 | 0.2748155513148442 | 20.99562976672652
7 | 7 | 11186 | 956 | 547 | 18716 | 2.107551224836839 | 21.270445318041364
8 | 8 | 11186 | 956 | 11320 | 785 | 0.5041292249792726 | 23.377996542878204
9 | 9 | 11186 | 956 | 637 | 17571 | 0.3017568826844637 | 23.882125767857477
10 | 10 | 11186 | 956 | 16069 | 17572 | 4.324419339513457 | 24.183882650541943
11 | 11 | 11186 | 956 | 16070 | 17670 | 4.314370521455101 | 28.5083019900554
12 | 12 | 11186 | 956 | 16175 | 17060 | 0.3265128030901856 | 32.822672511510504
13 | 13 | 11186 | 956 | 635 | 17114 | 7.292604172944715 | 33.149185314600686
14 | 14 | 11186 | 956 | 15608 | 17007 | 0.43699317609660426 | 40.4417894875454
15 | 15 | 11186 | 956 | 514 | 42599 | 6.501070805441249 | 40.878782663642006
16 | 16 | 11186 | 956 | 29235 | 24236 | 0.6671980382691262 | 47.37985346908326
17 | 17 | 11186 | 956 | 1015 | 16115 | 0.2884720654745603 | 48.047051507352386
18 | 18 | 11186 | 956 | 14690 | 2284 | 5.023784117299824 | 48.33552357282694
19 | 19 | 11186 | 956 | 1791 | 15389 | 2.612160540705735 | 53.35930769012677
20 | 20 | 11186 | 956 | 13970 | 1183 | 0.14930309306911418 | 55.97146823083251
21 | 21 | 11186 | 956 | 959 | 15383 | 4.549810241713953 | 56.12077132390162
22 | 22 | 11186 | 956 | 13964 | 791 | 0.23473787308099003 | 60.67058156561558
23 | 23 | 11186 | 956 | 642 | 794 | 21.629400605628565 | 60.905319438696566
24 | 24 | 11186 | 956 | 643 | 793 | 4.038360554037088 | 82.53472004432513
25 | 25 | 11186 | 956 | 956 | -1 | 0 | 86.57308059836221
(25 rows)
6.3. Solutions to SQL function¶
6.3.1. Exercise: 1 (Chapter: SQL)¶
Exercise 1: Creating a view for routing
CREATE VIEW
count
-------
46012
(1 row)
count
-------
22716
(1 row)
6.3.2. Exercise: 2 (Chapter: SQL)¶
Exercise 2: Limiting the road network within an area
CREATE VIEW
count
-------
4977
(1 row)
6.3.3. Exercise: 3 (Chapter: SQL)¶
Exercise 3: Creating a materialized view for routing pedestrians
SELECT 41599
count
-------
41599
(1 row)
6.3.4. Exercise: 4 (Chapter: SQL)¶
Exercise 4: Testing the views for routing
seq | id | seconds
-----+-------+----------------------
1 | 13058 | 0.5623299252048394
2 | 12857 | 1.2075070194870985
3 | 13203 | 0.20005398086256934
4 | 26751 | 0.08031320045680243
5 | 19982 | 0.23130961655102145
6 | 13201 | 0.7167032239818619
7 | 13098 | 1.2374230073859713
8 | 2876 | 2.698126703350503
9 | 13227 | 1.9667305567682352
10 | 6922 | 1.2667946634114873
11 | 2874 | 4.0910410464931
12 | 29337 | 1.2188613802879424
13 | 43365 | 2.1873204100667403
14 | 26700 | 1.7828630022881058
15 | 27343 | 1.700671252132037
16 | 27352 | 0.35686774599503723
17 | 27339 | 0.10090366340941788
18 | 27342 | 0.3248191168895792
19 | 20120 | 0.6535872798674627
20 | 13079 | 2.143247812719088
21 | 28649 | 0.4603224664188579
22 | 27689 | 2.418872289016195
23 | 28640 | 0.38974079531667627
24 | 27686 | 0.22761054509523695
25 | 27703 | 0.2665942920555928
26 | 28645 | 0.22317395481023594
27 | 20445 | 0.2114719845041045
28 | 43363 | 0.5791540579598466
29 | 25386 | 0.1494681911673113
30 | 25390 | 3.7112258318774374
31 | 25389 | 0.7569674800151832
32 | 27694 | 0.025411888724556884
33 | 27699 | 0.09459338634556248
34 | 20207 | 0.13247496924145674
35 | 17774 | 5.562530400457131
36 | 17761 | 3.494510316965437
37 | 16398 | 0.06349508818144431
38 | 680 | 6.5025099152856765
39 | 679 | 3.9216567393303388
40 | 15379 | 0.3160002129957741
41 | -1 | 0
(41 rows)
seq | id | seconds
-----+-------+----------------------
1 | 13058 | 0.5060969326843554
2 | 12857 | 1.0867563175383887
3 | 13203 | 0.18004858277631242
4 | 26751 | 0.07228188041112218
5 | 19982 | 0.2081786548959193
6 | 13201 | 0.6450329015836758
7 | 13098 | 1.1136807066473742
8 | 2876 | 2.428314033015453
9 | 13227 | 1.7700575010914117
10 | 6922 | 1.1401151970703385
11 | 2874 | 3.68193694184379
12 | 29337 | 1.0969752422591483
13 | 43365 | 1.9685883690600663
14 | 26700 | 1.6045767020592951
15 | 27343 | 1.5306041269188333
16 | 27352 | 0.32118097139553353
17 | 27339 | 0.09081329706847609
18 | 27342 | 0.2923372052006213
19 | 20120 | 0.5882285518807164
20 | 13079 | 1.9289230314471795
21 | 28649 | 0.4142902197769721
22 | 27689 | 2.1769850601145753
23 | 28640 | 0.3507667157850087
24 | 27686 | 0.20484949058571325
25 | 27703 | 0.23993486285003354
26 | 28645 | 0.20085655932921234
27 | 20445 | 0.19032478605369407
28 | 43363 | 0.521238652163862
29 | 25386 | 0.13452137205058018
30 | 25390 | 3.3401032486896938
31 | 25389 | 0.681270732013665
32 | 27694 | 0.022870699852101196
33 | 27699 | 0.08513404771100623
34 | 20207 | 0.11922747231731107
35 | 17774 | 5.006277360411418
36 | 17761 | 3.1450592852688932
37 | 16398 | 0.05714557936329988
38 | 680 | 5.852258923757109
39 | 679 | 3.529491065397305
40 | 15379 | 0.2844001916961967
41 | -1 | 0
(41 rows)
seq | id | seconds
-----+-------+---------------------
1 | 12658 | 13.508105033554621
2 | 13211 | 0.588926943015748
3 | 24758 | 3.0680623839800782
4 | 45527 | 1.0938326857746727
5 | 31949 | 9.052864227250197
6 | 31951 | 53.94292252479892
7 | 31950 | 0.32009225202051483
8 | 23548 | 1.1181185327985674
9 | 40407 | 69.90891522499619
10 | 31947 | 23.537457152822878
11 | 31945 | 0.5474709296454
12 | 682 | 1.9182725973804964
13 | 23233 | 0.2759043100739863
14 | 39368 | 1.727753563375398
15 | 31852 | 23.245547065588088
16 | 21118 | 26.073202026072646
17 | 15379 | 2.1944459235817644
18 | -1 | 0
(18 rows)
6.3.5. Exercise: 5 (Chapter: SQL)¶
Exercise 5: Get additional information
seq | id | seconds | name | length_m
-----+-------+----------------------+-----------------------------+---------------------
1 | 13058 | 0.5623299252048394 | Piazza Adua | 7.810137850067213
2 | 12857 | 1.2075070194870985 | Piazza Adua | 16.770930826209703
3 | 13203 | 0.20005398086256934 | Piazza Adua | 2.77852751198013
4 | 26751 | 0.08031320045680243 | Piazza della Stazione | 1.1154611174555893
5 | 19982 | 0.23130961655102145 | Piazza della Stazione | 3.212633563208631
6 | 13201 | 0.7167032239818619 | Piazza della Stazione | 9.954211444192527
7 | 13098 | 1.2374230073859713 | Piazza della Stazione | 17.18643065813849
8 | 2876 | 2.698126703350503 | Piazza della Stazione | 37.47398199097921
9 | 13227 | 1.9667305567682352 | Piazza della Stazione | 27.3157021773366
10 | 6922 | 1.2667946634114873 | Piazza della Stazione | 17.594370325159545
11 | 2874 | 4.0910410464931 | Piazza della Stazione | 56.82001453462638
12 | 29337 | 1.2188613802879424 | Piazza della Stazione | 16.92863028177698
13 | 43365 | 2.1873204100667403 | Piazza della Stazione | 30.37945013981584
14 | 26700 | 1.7828630022881058 | Piazza della Stazione | 24.761986142890358
15 | 27343 | 1.700671252132037 | Piazza della Stazione | 23.620434057389403
16 | 27352 | 0.35686774599503723 | Piazza della Stazione | 4.956496472153295
17 | 27339 | 0.10090366340941788 | Piazza della Stazione | 1.4014397695752483
18 | 27342 | 0.3248191168895792 | Piazza della Stazione | 4.511376623466378
19 | 20120 | 0.6535872798674627 | Piazza della Stazione | 9.077601109270315
20 | 13079 | 2.143247812719088 | Piazza della Stazione | 29.767330732209558
21 | 28649 | 0.4603224664188579 | Piazza della Stazione | 6.393367589150804
22 | 27689 | 2.418872289016195 | Piazza della Stazione | 33.595448458558266
23 | 28640 | 0.38974079531667627 | Piazza dell'Unità Italiana | 5.413066601620504
24 | 27686 | 0.22761054509523695 | Piazza dell'Unità Italiana | 3.16125757076718
25 | 27703 | 0.2665942920555928 | Piazza dell'Unità Italiana | 3.7026985007721223
26 | 28645 | 0.22317395481023594 | Piazza dell'Unità Italiana | 3.099638261253277
27 | 20445 | 0.2114719845041045 | Piazza dell'Unità Italiana | 2.9371108958903407
28 | 43363 | 0.5791540579598466 | Piazza dell'Unità Italiana | 8.043806360553425
29 | 25386 | 0.1494681911673113 | Piazza dell'Unità Italiana | 2.0759470995459903
30 | 25390 | 3.7112258318774374 | Piazza dell'Unità Italiana | 51.54480322051997
31 | 25389 | 0.7569674800151832 | Piazza dell'Unità Italiana | 10.513437222433101
32 | 27694 | 0.025411888724556884 | Piazza dell'Unità Italiana | 0.35294289895217895
33 | 27699 | 0.09459338634556248 | Piazza dell'Unità Italiana | 1.3137970325772568
34 | 20207 | 0.13247496924145674 | Piazza dell'Unità Italiana | 1.839930128353566
35 | 17774 | 5.562530400457131 | Via Sant'Antonino | 77.25736667301571
36 | 17761 | 3.494510316965437 | Via Sant'Antonino | 48.534865513408846
37 | 16398 | 0.06349508818144431 | Via Faenza | 0.8818762247422821
38 | 680 | 6.5025099152856765 | Via Faenza | 90.31263771230107
39 | 679 | 3.9216567393303388 | Via Giovan Battista Zannoni | 54.46745471292137
40 | 15379 | 0.3160002129957741 | Via Giovan Battista Zannoni | 4.388891847163529
41 | -1 | 0 | |
(41 rows)
6.3.6. Exercise: 6 (Chapter: SQL)¶
Exercise 6: Route geometry (human readable)
seq | id | seconds | route_readable
-----+-------+----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------
1 | 13058 | 0.5623299252048394 | LINESTRING(11.2493405 43.7777744,11.2492507 43.7777478)
2 | 12857 | 1.2075070194870985 | LINESTRING(11.2492507 43.7777478,11.2490531 43.7777)
3 | 13203 | 0.20005398086256934 | LINESTRING(11.2490531 43.7777,11.2490204 43.777692)
4 | 26751 | 0.08031320045680243 | LINESTRING(11.2490204 43.777692,11.2490066 43.7776911)
5 | 19982 | 0.23130961655102145 | LINESTRING(11.2490066 43.7776911,11.2489685 43.7776825)
6 | 13201 | 0.7167032239818619 | LINESTRING(11.2489685 43.7776825,11.2489468 43.7775943)
7 | 13098 | 1.2374230073859713 | LINESTRING(11.2489468 43.7775943,11.2489154 43.7774413)
8 | 2876 | 2.698126703350503 | LINESTRING(11.2489154 43.7774413,11.2488478 43.7771076)
9 | 13227 | 1.9667305567682352 | LINESTRING(11.2488478 43.7771076,11.2489723 43.7768789)
10 | 6922 | 1.2667946634114873 | LINESTRING(11.2489723 43.7768789,11.2490463 43.7767299)
11 | 2874 | 4.0910410464931 | LINESTRING(11.2490463 43.7767299,11.2492651 43.7762437)
12 | 29337 | 1.2188613802879424 | LINESTRING(11.2492651 43.7762437,11.249333 43.7760995)
13 | 43365 | 2.1873204100667403 | LINESTRING(11.249333 43.7760995,11.2494264 43.7759028,11.2494361 43.7758723,11.2494424 43.7758385)
14 | 26700 | 1.7828630022881058 | LINESTRING(11.2494424 43.7758385,11.2494381 43.7758094,11.2494258 43.7757849,11.2494086 43.7757648,11.2493663 43.7757309,11.2492713 43.7756609)
15 | 27343 | 1.700671252132037 | LINESTRING(11.2492713 43.7756609,11.24922 43.7755952,11.2491477 43.7754685)
16 | 27352 | 0.35686774599503723 | LINESTRING(11.2491477 43.7754685,11.2491392 43.7754465,11.2491369 43.7754248)
17 | 27339 | 0.10090366340941788 | LINESTRING(11.2491369 43.7754248,11.2491361 43.7754122)
18 | 27342 | 0.3248191168895792 | LINESTRING(11.2491361 43.7754122,11.2491321 43.7753717)
19 | 20120 | 0.6535872798674627 | LINESTRING(11.2491321 43.7753717,11.2491316 43.77529)
20 | 13079 | 2.143247812719088 | LINESTRING(11.2491316 43.77529,11.2495011 43.7752803)
21 | 28649 | 0.4603224664188579 | LINESTRING(11.2495011 43.7752803,11.2495802 43.7752752)
22 | 27689 | 2.418872289016195 | LINESTRING(11.2495802 43.7752752,11.2496077 43.7752707,11.2496462 43.7752582,11.2496851 43.7752316,11.2497227 43.7751843,11.2498164 43.7750416)
23 | 28640 | 0.38974079531667627 | LINESTRING(11.2498164 43.7750416,11.2498808 43.7750556)
24 | 27686 | 0.22761054509523695 | LINESTRING(11.2498808 43.7750556,11.2499184 43.7750638)
25 | 27703 | 0.2665942920555928 | LINESTRING(11.2499184 43.7750638,11.2499624 43.7750735)
26 | 28645 | 0.22317395481023594 | LINESTRING(11.2499624 43.7750735,11.2499992 43.7750817)
27 | 20445 | 0.2114719845041045 | LINESTRING(11.2499992 43.7750817,11.2500341 43.7750894)
28 | 43363 | 0.5791540579598466 | LINESTRING(11.2500341 43.7750894,11.2501298 43.7751102)
29 | 25386 | 0.1494681911673113 | LINESTRING(11.2501298 43.7751102,11.2501544 43.7751158)
30 | 25390 | 3.7112258318774374 | LINESTRING(11.2501544 43.7751158,11.250764 43.7752576)
31 | 25389 | 0.7569674800151832 | LINESTRING(11.250764 43.7752576,11.2508429 43.7751822)
32 | 27694 | 0.025411888724556884 | LINESTRING(11.2508429 43.7751822,11.2508469 43.7751835)
33 | 27699 | 0.09459338634556248 | LINESTRING(11.2508469 43.7751835,11.2508568 43.7751741)
34 | 20207 | 0.13247496924145674 | LINESTRING(11.2508568 43.7751741,11.2508706 43.7751609)
35 | 17774 | 5.562530400457131 | LINESTRING(11.2508706 43.7751609,11.2517275 43.7754739)
36 | 17761 | 3.494510316965437 | LINESTRING(11.2517275 43.7754739,11.2519606 43.7755664,11.2522562 43.7756838)
37 | 16398 | 0.06349508818144431 | LINESTRING(11.2522562 43.7756838,11.2522519 43.7756911)
38 | 680 | 6.5025099152856765 | LINESTRING(11.2522519 43.7756911,11.2521622 43.7758448,11.2519143 43.7762779,11.2518733 43.7763586,11.2518398 43.7764464)
39 | 679 | 3.9216567393303388 | LINESTRING(11.2523971 43.7767189,11.2519766 43.7764861,11.2518398 43.7764464)
40 | 15379 | 0.3160002129957741 | LINESTRING(11.2524404 43.7767429,11.2523971 43.7767189)
41 | -1 | 0 |
(41 rows)
6.3.7. Exercise: 7 (Chapter: SQL)¶
Exercise 7: Route geometry (binary format)
seq | id | seconds | route_geom
-----+-------+----------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 | 13058 | 0.5623299252048394 | 0102000020E610000002000000F722DA8EA97F264040D58D1C8EE345409D02AAC99D7F26409AC46A3D8DE34540
2 | 12857 | 1.2075070194870985 | 0102000020E6100000020000009D02AAC99D7F26409AC46A3D8DE3454051EF4EE3837F2640B30C71AC8BE34540
3 | 13203 | 0.20005398086256934 | 0102000020E61000000200000051EF4EE3837F2640B30C71AC8BE34540DC12149A7F7F2640302E55698BE34540
4 | 26751 | 0.08031320045680243 | 0102000020E610000002000000DC12149A7F7F2640302E55698BE34540EFF906CB7D7F2640F471C8618BE34540
5 | 19982 | 0.23130961655102145 | 0102000020E610000002000000EFF906CB7D7F2640F471C8618BE34540E6779ACC787F2640F415A4198BE34540
6 | 13201 | 0.7167032239818619 | 0102000020E610000002000000E6779ACC787F2640F415A4198BE3454041E378F4757F26402B07C43588E34540
7 | 13098 | 1.2374230073859713 | 0102000020E61000000200000041E378F4757F26402B07C43588E3454007F1DCD6717F2640A5074F3283E34540
8 | 2876 | 2.698126703350503 | 0102000020E61000000200000007F1DCD6717F2640A5074F3283E34540F45C95FA687F26408DBC074378E34540
9 | 13227 | 1.9667305567682352 | 0102000020E610000002000000F45C95FA687F26408DBC074378E3454045381C4C797F2640EA398EC470E34540
10 | 6922 | 1.2667946634114873 | 0102000020E61000000200000045381C4C797F2640EA398EC470E345402E6123FF827F2640A529A7E26BE34540
11 | 2874 | 4.0910410464931 | 0102000020E6100000020000002E6123FF827F2640A529A7E26BE345407F11D9AC9F7F2640EF9C1CF45BE34540
12 | 29337 | 1.2188613802879424 | 0102000020E6100000020000007F11D9AC9F7F2640EF9C1CF45BE345408CA03193A87F26409278793A57E34540
13 | 43365 | 2.1873204100667403 | 0102000020E6100000040000008CA03193A87F26409278793A57E345409E842DD1B47F2640FA6F6FC850E3454032E2A716B67F2640A82F95C84FE34540B4780CEAB67F2640253D0CAD4EE34540
14 | 26700 | 1.7828630022881058 | 0102000020E610000006000000B4780CEAB67F2640253D0CAD4EE34540B5C0C359B67F2640F676F0B84DE34540A98E0BBDB47F2640851D6BEB4CE34540ABAEE87BB27F2640A9B1CE424CE34540F5728EF0AC7F264092FF6E264BE34540AEA9E27CA07F264099243BDB48E34540
15 | 27343 | 1.700671252132037 | 0102000020E610000003000000AEA9E27CA07F264099243BDB48E34540AB048BC3997F2640A07719B446E345404BBF8E49907F2640024A438D42E34540
16 | 27352 | 0.35686774599503723 | 0102000020E6100000030000004BBF8E49907F2640024A438D42E345409F4D582C8F7F26401AA6B6D441E3454022742BDF8E7F2640F140AE1E41E34540
17 | 27339 | 0.10090366340941788 | 0102000020E61000000200000022742BDF8E7F2640F140AE1E41E34540878153C48E7F2640AFF5FBB440E34540
18 | 27342 | 0.3248191168895792 | 0102000020E610000002000000878153C48E7F2640AFF5FBB440E3454082C41B3E8E7F264039DF3E613FE34540
19 | 20120 | 0.6535872798674627 | 0102000020E61000000200000082C41B3E8E7F264039DF3E613FE34540E1CC542D8E7F26403A75E5B33CE34540
20 | 13079 | 2.143247812719088 | 0102000020E610000002000000E1CC542D8E7F26403A75E5B33CE34540CEA1B19BBE7F2640D5DD86623CE34540
21 | 28649 | 0.4603224664188579 | 0102000020E610000002000000CEA1B19BBE7F2640D5DD86623CE345405275D9F9C87F26402FB3BE373CE34540
22 | 27689 | 2.418872289016195 | 0102000020E6100000060000005275D9F9C87F26402FB3BE373CE34540D9A89894CC7F26400506FF113CE34540302471A0D17F2640597A23A93BE34540D498B5B9D67F2640B26900CA3AE345403C235BA7DB7F2640B36F383D39E34540480268EFE77F26400F852A9034E34540
23 | 28640 | 0.38974079531667627 | 0102000020E610000002000000480268EFE77F26400F852A9034E34540F0CB4F60F07F2640744A9B0535E34540
24 | 27686 | 0.22761054509523695 | 0102000020E610000002000000F0CB4F60F07F2640744A9B0535E345405956F54DF57F264020A8644A35E34540
25 | 27703 | 0.2665942920555928 | 0102000020E6100000020000005956F54DF57F264020A8644A35E3454097755A12FB7F2640853FC39B35E34540
26 | 28645 | 0.22317395481023594 | 0102000020E61000000200000097755A12FB7F2640853FC39B35E34540650D28E5FF7F2640329D8CE035E34540
27 | 20445 | 0.2114719845041045 | 0102000020E610000002000000650D28E5FF7F2640329D8CE035E3454004C5347804802640F63C242136E34540
28 | 43363 | 0.5791540579598466 | 0102000020E61000000200000004C5347804802640F63C242136E3454092825D0311802640E4E59FCF36E34540
29 | 25386 | 0.1494681911673113 | 0102000020E61000000200000092825D0311802640E4E59FCF36E34540A8E6CD3C1480264073CE99FE36E34540
30 | 25390 | 3.7112258318774374 | 0102000020E610000002000000A8E6CD3C1480264073CE99FE36E345403E07962364802640DCFC1AA43BE34540
31 | 25389 | 0.7569674800151832 | 0102000020E6100000020000003E07962364802640DCFC1AA43BE345401BDE077B6E8026407EB89A2B39E34540
32 | 27694 | 0.025411888724556884 | 0102000020E6100000020000001BDE077B6E8026407EB89A2B39E34540219B3F016F8026400C73823639E34540
33 | 27699 | 0.09459338634556248 | 0102000020E610000002000000219B3F016F8026400C73823639E345405BF56F4D70802640661AA8E738E34540
34 | 20207 | 0.13247496924145674 | 0102000020E6100000020000005BF56F4D70802640661AA8E738E34540490E7D1C72802640A851ED7838E34540
35 | 17774 | 5.562530400457131 | 0102000020E610000002000000490E7D1C72802640A851ED7838E34540F701486DE280264067B38FBA42E34540
36 | 17761 | 3.494510316965437 | 0102000020E610000003000000F701486DE280264067B38FBA42E34540D6C2D1FA0081264030F081C245E345402D6D82B927812640BD84549B49E34540
37 | 16398 | 0.06349508818144431 | 0102000020E6100000020000002D6D82B927812640BD84549B49E345402DB53929278126402E2691D849E34540
38 | 680 | 6.5025099152856765 | 0102000020E6100000050000002DB53929278126402E2691D849E34540289364671B812640C662E5E14EE345401ACA3FE9FA802640C48D00135DE34540A0788489F5802640F37BF6B75FE3454091A97125F1802640688C7B9862E34540
39 | 679 | 3.9216567393303388 | 0102000020E610000003000000E23554313A812640B1D760866BE34540EDB6B0130381264038A682E563E3454091A97125F1802640688C7B9862E34540
40 | 15379 | 0.3160002129957741 | 0102000020E610000002000000D9603CDE3F8126403A73B44F6CE34540E23554313A812640B1D760866BE34540
41 | -1 | 0 |
(41 rows)
6.3.8. Exercise: 8 (Chapter: SQL)¶
Exercise 8: Route geometry directionality
seq | id | seconds | route_readable | route_geom
-----+-------+----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 | 13058 | 0.5623299252048394 | LINESTRING(11.2493405 43.7777744,11.2492507 43.7777478) | 0102000020E610000002000000F722DA8EA97F264040D58D1C8EE345409D02AAC99D7F26409AC46A3D8DE34540
2 | 12857 | 1.2075070194870985 | LINESTRING(11.2492507 43.7777478,11.2490531 43.7777) | 0102000020E6100000020000009D02AAC99D7F26409AC46A3D8DE3454051EF4EE3837F2640B30C71AC8BE34540
3 | 13203 | 0.20005398086256934 | LINESTRING(11.2490531 43.7777,11.2490204 43.777692) | 0102000020E61000000200000051EF4EE3837F2640B30C71AC8BE34540DC12149A7F7F2640302E55698BE34540
4 | 26751 | 0.08031320045680243 | LINESTRING(11.2490204 43.777692,11.2490066 43.7776911) | 0102000020E610000002000000DC12149A7F7F2640302E55698BE34540EFF906CB7D7F2640F471C8618BE34540
5 | 19982 | 0.23130961655102145 | LINESTRING(11.2490066 43.7776911,11.2489685 43.7776825) | 0102000020E610000002000000EFF906CB7D7F2640F471C8618BE34540E6779ACC787F2640F415A4198BE34540
6 | 13201 | 0.7167032239818619 | LINESTRING(11.2489685 43.7776825,11.2489468 43.7775943) | 0102000020E610000002000000E6779ACC787F2640F415A4198BE3454041E378F4757F26402B07C43588E34540
7 | 13098 | 1.2374230073859713 | LINESTRING(11.2489468 43.7775943,11.2489154 43.7774413) | 0102000020E61000000200000041E378F4757F26402B07C43588E3454007F1DCD6717F2640A5074F3283E34540
8 | 2876 | 2.698126703350503 | LINESTRING(11.2489154 43.7774413,11.2488478 43.7771076) | 0102000020E61000000200000007F1DCD6717F2640A5074F3283E34540F45C95FA687F26408DBC074378E34540
9 | 13227 | 1.9667305567682352 | LINESTRING(11.2488478 43.7771076,11.2489723 43.7768789) | 0102000020E610000002000000F45C95FA687F26408DBC074378E3454045381C4C797F2640EA398EC470E34540
10 | 6922 | 1.2667946634114873 | LINESTRING(11.2489723 43.7768789,11.2490463 43.7767299) | 0102000020E61000000200000045381C4C797F2640EA398EC470E345402E6123FF827F2640A529A7E26BE34540
11 | 2874 | 4.0910410464931 | LINESTRING(11.2490463 43.7767299,11.2492651 43.7762437) | 0102000020E6100000020000002E6123FF827F2640A529A7E26BE345407F11D9AC9F7F2640EF9C1CF45BE34540
12 | 29337 | 1.2188613802879424 | LINESTRING(11.2492651 43.7762437,11.249333 43.7760995) | 0102000020E6100000020000007F11D9AC9F7F2640EF9C1CF45BE345408CA03193A87F26409278793A57E34540
13 | 43365 | 2.1873204100667403 | LINESTRING(11.249333 43.7760995,11.2494264 43.7759028,11.2494361 43.7758723,11.2494424 43.7758385) | 0102000020E6100000040000008CA03193A87F26409278793A57E345409E842DD1B47F2640FA6F6FC850E3454032E2A716B67F2640A82F95C84FE34540B4780CEAB67F2640253D0CAD4EE34540
14 | 26700 | 1.7828630022881058 | LINESTRING(11.2494424 43.7758385,11.2494381 43.7758094,11.2494258 43.7757849,11.2494086 43.7757648,11.2493663 43.7757309,11.2492713 43.7756609) | 0102000020E610000006000000B4780CEAB67F2640253D0CAD4EE34540B5C0C359B67F2640F676F0B84DE34540A98E0BBDB47F2640851D6BEB4CE34540ABAEE87BB27F2640A9B1CE424CE34540F5728EF0AC7F264092FF6E264BE34540AEA9E27CA07F264099243BDB48E34540
15 | 27343 | 1.700671252132037 | LINESTRING(11.2492713 43.7756609,11.24922 43.7755952,11.2491477 43.7754685) | 0102000020E610000003000000AEA9E27CA07F264099243BDB48E34540AB048BC3997F2640A07719B446E345404BBF8E49907F2640024A438D42E34540
16 | 27352 | 0.35686774599503723 | LINESTRING(11.2491477 43.7754685,11.2491392 43.7754465,11.2491369 43.7754248) | 0102000020E6100000030000004BBF8E49907F2640024A438D42E345409F4D582C8F7F26401AA6B6D441E3454022742BDF8E7F2640F140AE1E41E34540
17 | 27339 | 0.10090366340941788 | LINESTRING(11.2491369 43.7754248,11.2491361 43.7754122) | 0102000020E61000000200000022742BDF8E7F2640F140AE1E41E34540878153C48E7F2640AFF5FBB440E34540
18 | 27342 | 0.3248191168895792 | LINESTRING(11.2491361 43.7754122,11.2491321 43.7753717) | 0102000020E610000002000000878153C48E7F2640AFF5FBB440E3454082C41B3E8E7F264039DF3E613FE34540
19 | 20120 | 0.6535872798674627 | LINESTRING(11.2491321 43.7753717,11.2491316 43.77529) | 0102000020E61000000200000082C41B3E8E7F264039DF3E613FE34540E1CC542D8E7F26403A75E5B33CE34540
20 | 13079 | 2.143247812719088 | LINESTRING(11.2491316 43.77529,11.2495011 43.7752803) | 0102000020E610000002000000E1CC542D8E7F26403A75E5B33CE34540CEA1B19BBE7F2640D5DD86623CE34540
21 | 28649 | 0.4603224664188579 | LINESTRING(11.2495011 43.7752803,11.2495802 43.7752752) | 0102000020E610000002000000CEA1B19BBE7F2640D5DD86623CE345405275D9F9C87F26402FB3BE373CE34540
22 | 27689 | 2.418872289016195 | LINESTRING(11.2495802 43.7752752,11.2496077 43.7752707,11.2496462 43.7752582,11.2496851 43.7752316,11.2497227 43.7751843,11.2498164 43.7750416) | 0102000020E6100000060000005275D9F9C87F26402FB3BE373CE34540D9A89894CC7F26400506FF113CE34540302471A0D17F2640597A23A93BE34540D498B5B9D67F2640B26900CA3AE345403C235BA7DB7F2640B36F383D39E34540480268EFE77F26400F852A9034E34540
23 | 28640 | 0.38974079531667627 | LINESTRING(11.2498164 43.7750416,11.2498808 43.7750556) | 0102000020E610000002000000480268EFE77F26400F852A9034E34540F0CB4F60F07F2640744A9B0535E34540
24 | 27686 | 0.22761054509523695 | LINESTRING(11.2498808 43.7750556,11.2499184 43.7750638) | 0102000020E610000002000000F0CB4F60F07F2640744A9B0535E345405956F54DF57F264020A8644A35E34540
25 | 27703 | 0.2665942920555928 | LINESTRING(11.2499184 43.7750638,11.2499624 43.7750735) | 0102000020E6100000020000005956F54DF57F264020A8644A35E3454097755A12FB7F2640853FC39B35E34540
26 | 28645 | 0.22317395481023594 | LINESTRING(11.2499624 43.7750735,11.2499992 43.7750817) | 0102000020E61000000200000097755A12FB7F2640853FC39B35E34540650D28E5FF7F2640329D8CE035E34540
27 | 20445 | 0.2114719845041045 | LINESTRING(11.2499992 43.7750817,11.2500341 43.7750894) | 0102000020E610000002000000650D28E5FF7F2640329D8CE035E3454004C5347804802640F63C242136E34540
28 | 43363 | 0.5791540579598466 | LINESTRING(11.2500341 43.7750894,11.2501298 43.7751102) | 0102000020E61000000200000004C5347804802640F63C242136E3454092825D0311802640E4E59FCF36E34540
29 | 25386 | 0.1494681911673113 | LINESTRING(11.2501298 43.7751102,11.2501544 43.7751158) | 0102000020E61000000200000092825D0311802640E4E59FCF36E34540A8E6CD3C1480264073CE99FE36E34540
30 | 25390 | 3.7112258318774374 | LINESTRING(11.2501544 43.7751158,11.250764 43.7752576) | 0102000020E610000002000000A8E6CD3C1480264073CE99FE36E345403E07962364802640DCFC1AA43BE34540
31 | 25389 | 0.7569674800151832 | LINESTRING(11.250764 43.7752576,11.2508429 43.7751822) | 0102000020E6100000020000003E07962364802640DCFC1AA43BE345401BDE077B6E8026407EB89A2B39E34540
32 | 27694 | 0.025411888724556884 | LINESTRING(11.2508429 43.7751822,11.2508469 43.7751835) | 0102000020E6100000020000001BDE077B6E8026407EB89A2B39E34540219B3F016F8026400C73823639E34540
33 | 27699 | 0.09459338634556248 | LINESTRING(11.2508469 43.7751835,11.2508568 43.7751741) | 0102000020E610000002000000219B3F016F8026400C73823639E345405BF56F4D70802640661AA8E738E34540
34 | 20207 | 0.13247496924145674 | LINESTRING(11.2508568 43.7751741,11.2508706 43.7751609) | 0102000020E6100000020000005BF56F4D70802640661AA8E738E34540490E7D1C72802640A851ED7838E34540
35 | 17774 | 5.562530400457131 | LINESTRING(11.2508706 43.7751609,11.2517275 43.7754739) | 0102000020E610000002000000490E7D1C72802640A851ED7838E34540F701486DE280264067B38FBA42E34540
36 | 17761 | 3.494510316965437 | LINESTRING(11.2517275 43.7754739,11.2519606 43.7755664,11.2522562 43.7756838) | 0102000020E610000003000000F701486DE280264067B38FBA42E34540D6C2D1FA0081264030F081C245E345402D6D82B927812640BD84549B49E34540
37 | 16398 | 0.06349508818144431 | LINESTRING(11.2522562 43.7756838,11.2522519 43.7756911) | 0102000020E6100000020000002D6D82B927812640BD84549B49E345402DB53929278126402E2691D849E34540
38 | 680 | 6.5025099152856765 | LINESTRING(11.2522519 43.7756911,11.2521622 43.7758448,11.2519143 43.7762779,11.2518733 43.7763586,11.2518398 43.7764464) | 0102000020E6100000050000002DB53929278126402E2691D849E34540289364671B812640C662E5E14EE345401ACA3FE9FA802640C48D00135DE34540A0788489F5802640F37BF6B75FE3454091A97125F1802640688C7B9862E34540
39 | 679 | 3.9216567393303388 | LINESTRING(11.2518398 43.7764464,11.2519766 43.7764861,11.2523971 43.7767189) | 0102000020E61000000300000091A97125F1802640688C7B9862E34540EDB6B0130381264038A682E563E34540E23554313A812640B1D760866BE34540
40 | 15379 | 0.3160002129957741 | LINESTRING(11.2523971 43.7767189,11.2524404 43.7767429) | 0102000020E610000002000000E23554313A812640B1D760866BE34540D9603CDE3F8126403A73B44F6CE34540
41 | -1 | 0 | |
(41 rows)
6.3.9. Exercise: 9 (Chapter: SQL)¶
Exercise 9: Using the geometry
seq | id | seconds | azimuth
-----+-------+----------------------+---------------------
1 | 13058 | 0.5623299252048394 | 73.4999834879164
2 | 12857 | 1.2075070194870985 | 76.40122475415983
3 | 13203 | 0.20005398086256934 | 76.25270974093915
4 | 26751 | 0.08031320045680243 | 86.2686029866306
5 | 19982 | 0.23130961655102145 | 77.28026010114702
6 | 13201 | 0.7167032239818619 | 13.822054635403566
7 | 13098 | 1.2374230073859713 | 11.597703934792799
8 | 2876 | 2.698126703350503 | 11.451843278719066
9 | 13227 | 1.9667305567682352 | 331.43695461351274
10 | 6922 | 1.2667946634114873 | 333.5889693647525
11 | 2874 | 4.0910410464931 | 335.7712746972623
12 | 29337 | 1.2188613802879424 | 334.7854832322814
13 | 43365 | 2.1873204100667403 | 337.2586600832991
14 | 26700 | 1.7828630022881058 | 43.9320922278932
15 | 27343 | 1.700671252132037 | 32.71716139273595
16 | 27352 | 0.35686774599503723 | 13.881890987422635
17 | 27339 | 0.10090366340941788 | 3.6329507401267165
18 | 27342 | 0.3248191168895792 | 5.6405494308356605
19 | 20120 | 0.6535872798674627 | 0.35064298819647977
20 | 13079 | 2.143247812719088 | 271.5037657492953
21 | 28649 | 0.4603224664188579 | 273.68905906213246
22 | 27689 | 2.418872289016195 | 314.6829129293553
23 | 28640 | 0.38974079531667627 | 257.73522627184514
24 | 27686 | 0.22761054509523695 | 257.6972736802688
25 | 27703 | 0.2665942920555928 | 257.56774262247706
26 | 28645 | 0.22317395481023594 | 257.4382257879712
27 | 20445 | 0.2114719845041045 | 257.55813574796525
28 | 43363 | 0.5791540579598466 | 257.7377118804438
29 | 25386 | 0.1494681911673113 | 257.17560189431106
30 | 25390 | 3.7112258318774374 | 256.9052038675325
31 | 25389 | 0.7569674800151832 | 313.70057779891823
32 | 27694 | 0.025411888724556884 | 251.995838475785
33 | 27699 | 0.09459338634556248 | 313.5159853171293
34 | 20207 | 0.13247496924145674 | 313.7269699725753
35 | 17774 | 5.562530400457131 | 249.93425977746153
36 | 17761 | 3.494510316965437 | 248.34635131222444
37 | 16398 | 0.06349508818144431 | 149.50016676371678
38 | 680 | 6.5025099152856765 | 151.38263140121123
39 | 679 | 3.9216567393303388 | 63.94300131893053
40 | 15379 | 0.3160002129957741 | 61.001601274208866
41 | -1 | 0 |
(41 rows)
6.3.10. Exercise: 10 (Chapter: SQL)¶
Exercise 10: Function for an application
CREATE FUNCTION
6.3.11. Exercise: 11 (Chapter: SQL)¶
Exercise 11: Using the function
seq | id | seconds | name | length_m | route_readable | route_geom | azimuth
-----+-------+----------------------+-----------------------------+---------------------+-------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------
1 | 13058 | 0.5623299252048394 | Piazza Adua | 7.810137850067213 | LINESTRING(11.2492507 43.7777478,11.2493405 43.7777744) | 0102000020E6100000020000009D02AAC99D7F26409AC46A3D8DE34540F722DA8EA97F264040D58D1C8EE34540 | 73.4999834879164
2 | 12857 | 1.2075070194870985 | Piazza Adua | 16.770930826209703 | LINESTRING(11.2490531 43.7777,11.2492507 43.7777478) | 0102000020E61000000200000051EF4EE3837F2640B30C71AC8BE345409D02AAC99D7F26409AC46A3D8DE34540 | 76.40122475415983
3 | 13203 | 0.20005398086256934 | Piazza Adua | 2.77852751198013 | LINESTRING(11.2490204 43.777692,11.2490531 43.7777) | 0102000020E610000002000000DC12149A7F7F2640302E55698BE3454051EF4EE3837F2640B30C71AC8BE34540 | 76.25270974093915
4 | 26751 | 0.08031320045680243 | Piazza della Stazione | 1.1154611174555893 | LINESTRING(11.2490066 43.7776911,11.2490204 43.777692) | 0102000020E610000002000000EFF906CB7D7F2640F471C8618BE34540DC12149A7F7F2640302E55698BE34540 | 86.2686029866306
5 | 19982 | 0.23130961655102145 | Piazza della Stazione | 3.212633563208631 | LINESTRING(11.2489685 43.7776825,11.2490066 43.7776911) | 0102000020E610000002000000E6779ACC787F2640F415A4198BE34540EFF906CB7D7F2640F471C8618BE34540 | 77.28026010114702
6 | 13201 | 0.7167032239818619 | Piazza della Stazione | 9.954211444192527 | LINESTRING(11.2489468 43.7775943,11.2489685 43.7776825) | 0102000020E61000000200000041E378F4757F26402B07C43588E34540E6779ACC787F2640F415A4198BE34540 | 13.822054635403566
7 | 13098 | 1.2374230073859713 | Piazza della Stazione | 17.18643065813849 | LINESTRING(11.2489154 43.7774413,11.2489468 43.7775943) | 0102000020E61000000200000007F1DCD6717F2640A5074F3283E3454041E378F4757F26402B07C43588E34540 | 11.597703934792799
8 | 2876 | 2.698126703350503 | Piazza della Stazione | 37.47398199097921 | LINESTRING(11.2488478 43.7771076,11.2489154 43.7774413) | 0102000020E610000002000000F45C95FA687F26408DBC074378E3454007F1DCD6717F2640A5074F3283E34540 | 11.451843278719066
9 | 13227 | 1.9667305567682352 | Piazza della Stazione | 27.3157021773366 | LINESTRING(11.2489723 43.7768789,11.2488478 43.7771076) | 0102000020E61000000200000045381C4C797F2640EA398EC470E34540F45C95FA687F26408DBC074378E34540 | 331.43695461351274
10 | 6922 | 1.2667946634114873 | Piazza della Stazione | 17.594370325159545 | LINESTRING(11.2490463 43.7767299,11.2489723 43.7768789) | 0102000020E6100000020000002E6123FF827F2640A529A7E26BE3454045381C4C797F2640EA398EC470E34540 | 333.5889693647525
11 | 2874 | 4.0910410464931 | Piazza della Stazione | 56.82001453462638 | LINESTRING(11.2492651 43.7762437,11.2490463 43.7767299) | 0102000020E6100000020000007F11D9AC9F7F2640EF9C1CF45BE345402E6123FF827F2640A529A7E26BE34540 | 335.7712746972623
12 | 29337 | 1.2188613802879424 | Piazza della Stazione | 16.92863028177698 | LINESTRING(11.249333 43.7760995,11.2492651 43.7762437) | 0102000020E6100000020000008CA03193A87F26409278793A57E345407F11D9AC9F7F2640EF9C1CF45BE34540 | 334.7854832322814
13 | 43365 | 2.1873204100667403 | Piazza della Stazione | 30.37945013981584 | LINESTRING(11.2494424 43.7758385,11.2494361 43.7758723,11.2494264 43.7759028,11.249333 43.7760995) | 0102000020E610000004000000B4780CEAB67F2640253D0CAD4EE3454032E2A716B67F2640A82F95C84FE345409E842DD1B47F2640FA6F6FC850E345408CA03193A87F26409278793A57E34540 | 337.2586600832991
14 | 26700 | 1.7828630022881058 | Piazza della Stazione | 24.761986142890358 | LINESTRING(11.2492713 43.7756609,11.2493663 43.7757309,11.2494086 43.7757648,11.2494258 43.7757849,11.2494381 43.7758094,11.2494424 43.7758385) | 0102000020E610000006000000AEA9E27CA07F264099243BDB48E34540F5728EF0AC7F264092FF6E264BE34540ABAEE87BB27F2640A9B1CE424CE34540A98E0BBDB47F2640851D6BEB4CE34540B5C0C359B67F2640F676F0B84DE34540B4780CEAB67F2640253D0CAD4EE34540 | 43.9320922278932
15 | 27343 | 1.700671252132037 | Piazza della Stazione | 23.620434057389403 | LINESTRING(11.2491477 43.7754685,11.24922 43.7755952,11.2492713 43.7756609) | 0102000020E6100000030000004BBF8E49907F2640024A438D42E34540AB048BC3997F2640A07719B446E34540AEA9E27CA07F264099243BDB48E34540 | 32.71716139273595
16 | 27352 | 0.35686774599503723 | Piazza della Stazione | 4.956496472153295 | LINESTRING(11.2491369 43.7754248,11.2491392 43.7754465,11.2491477 43.7754685) | 0102000020E61000000300000022742BDF8E7F2640F140AE1E41E345409F4D582C8F7F26401AA6B6D441E345404BBF8E49907F2640024A438D42E34540 | 13.881890987422635
17 | 27339 | 0.10090366340941788 | Piazza della Stazione | 1.4014397695752483 | LINESTRING(11.2491361 43.7754122,11.2491369 43.7754248) | 0102000020E610000002000000878153C48E7F2640AFF5FBB440E3454022742BDF8E7F2640F140AE1E41E34540 | 3.6329507401267165
18 | 27342 | 0.3248191168895792 | Piazza della Stazione | 4.511376623466378 | LINESTRING(11.2491321 43.7753717,11.2491361 43.7754122) | 0102000020E61000000200000082C41B3E8E7F264039DF3E613FE34540878153C48E7F2640AFF5FBB440E34540 | 5.6405494308356605
19 | 20120 | 0.6535872798674627 | Piazza della Stazione | 9.077601109270315 | LINESTRING(11.2491316 43.77529,11.2491321 43.7753717) | 0102000020E610000002000000E1CC542D8E7F26403A75E5B33CE3454082C41B3E8E7F264039DF3E613FE34540 | 0.35064298819647977
20 | 13079 | 2.143247812719088 | Piazza della Stazione | 29.767330732209558 | LINESTRING(11.2495011 43.7752803,11.2491316 43.77529) | 0102000020E610000002000000CEA1B19BBE7F2640D5DD86623CE34540E1CC542D8E7F26403A75E5B33CE34540 | 271.5037657492953
21 | 28649 | 0.4603224664188579 | Piazza della Stazione | 6.393367589150804 | LINESTRING(11.2495802 43.7752752,11.2495011 43.7752803) | 0102000020E6100000020000005275D9F9C87F26402FB3BE373CE34540CEA1B19BBE7F2640D5DD86623CE34540 | 273.68905906213246
22 | 27689 | 2.418872289016195 | Piazza della Stazione | 33.595448458558266 | LINESTRING(11.2498164 43.7750416,11.2497227 43.7751843,11.2496851 43.7752316,11.2496462 43.7752582,11.2496077 43.7752707,11.2495802 43.7752752) | 0102000020E610000006000000480268EFE77F26400F852A9034E345403C235BA7DB7F2640B36F383D39E34540D498B5B9D67F2640B26900CA3AE34540302471A0D17F2640597A23A93BE34540D9A89894CC7F26400506FF113CE345405275D9F9C87F26402FB3BE373CE34540 | 314.6829129293553
23 | 28640 | 0.38974079531667627 | Piazza dell'Unità Italiana | 5.413066601620504 | LINESTRING(11.2498808 43.7750556,11.2498164 43.7750416) | 0102000020E610000002000000F0CB4F60F07F2640744A9B0535E34540480268EFE77F26400F852A9034E34540 | 257.73522627184514
24 | 27686 | 0.22761054509523695 | Piazza dell'Unità Italiana | 3.16125757076718 | LINESTRING(11.2499184 43.7750638,11.2498808 43.7750556) | 0102000020E6100000020000005956F54DF57F264020A8644A35E34540F0CB4F60F07F2640744A9B0535E34540 | 257.6972736802688
25 | 27703 | 0.2665942920555928 | Piazza dell'Unità Italiana | 3.7026985007721223 | LINESTRING(11.2499624 43.7750735,11.2499184 43.7750638) | 0102000020E61000000200000097755A12FB7F2640853FC39B35E345405956F54DF57F264020A8644A35E34540 | 257.56774262247706
26 | 28645 | 0.22317395481023594 | Piazza dell'Unità Italiana | 3.099638261253277 | LINESTRING(11.2499992 43.7750817,11.2499624 43.7750735) | 0102000020E610000002000000650D28E5FF7F2640329D8CE035E3454097755A12FB7F2640853FC39B35E34540 | 257.4382257879712
27 | 20445 | 0.2114719845041045 | Piazza dell'Unità Italiana | 2.9371108958903407 | LINESTRING(11.2500341 43.7750894,11.2499992 43.7750817) | 0102000020E61000000200000004C5347804802640F63C242136E34540650D28E5FF7F2640329D8CE035E34540 | 257.55813574796525
28 | 43363 | 0.5791540579598466 | Piazza dell'Unità Italiana | 8.043806360553425 | LINESTRING(11.2501298 43.7751102,11.2500341 43.7750894) | 0102000020E61000000200000092825D0311802640E4E59FCF36E3454004C5347804802640F63C242136E34540 | 257.7377118804438
29 | 25386 | 0.1494681911673113 | Piazza dell'Unità Italiana | 2.0759470995459903 | LINESTRING(11.2501544 43.7751158,11.2501298 43.7751102) | 0102000020E610000002000000A8E6CD3C1480264073CE99FE36E3454092825D0311802640E4E59FCF36E34540 | 257.17560189431106
30 | 25390 | 3.7112258318774374 | Piazza dell'Unità Italiana | 51.54480322051997 | LINESTRING(11.250764 43.7752576,11.2501544 43.7751158) | 0102000020E6100000020000003E07962364802640DCFC1AA43BE34540A8E6CD3C1480264073CE99FE36E34540 | 256.9052038675325
31 | 25389 | 0.7569674800151832 | Piazza dell'Unità Italiana | 10.513437222433101 | LINESTRING(11.2508429 43.7751822,11.250764 43.7752576) | 0102000020E6100000020000001BDE077B6E8026407EB89A2B39E345403E07962364802640DCFC1AA43BE34540 | 313.70057779891823
32 | 27694 | 0.025411888724556884 | Piazza dell'Unità Italiana | 0.35294289895217895 | LINESTRING(11.2508469 43.7751835,11.2508429 43.7751822) | 0102000020E610000002000000219B3F016F8026400C73823639E345401BDE077B6E8026407EB89A2B39E34540 | 251.995838475785
33 | 27699 | 0.09459338634556248 | Piazza dell'Unità Italiana | 1.3137970325772568 | LINESTRING(11.2508568 43.7751741,11.2508469 43.7751835) | 0102000020E6100000020000005BF56F4D70802640661AA8E738E34540219B3F016F8026400C73823639E34540 | 313.5159853171293
34 | 20207 | 0.13247496924145674 | Piazza dell'Unità Italiana | 1.839930128353566 | LINESTRING(11.2508706 43.7751609,11.2508568 43.7751741) | 0102000020E610000002000000490E7D1C72802640A851ED7838E345405BF56F4D70802640661AA8E738E34540 | 313.7269699725753
35 | 17774 | 5.562530400457131 | Via Sant'Antonino | 77.25736667301571 | LINESTRING(11.2517275 43.7754739,11.2508706 43.7751609) | 0102000020E610000002000000F701486DE280264067B38FBA42E34540490E7D1C72802640A851ED7838E34540 | 249.93425977746153
36 | 17761 | 3.494510316965437 | Via Sant'Antonino | 48.534865513408846 | LINESTRING(11.2522562 43.7756838,11.2519606 43.7755664,11.2517275 43.7754739) | 0102000020E6100000030000002D6D82B927812640BD84549B49E34540D6C2D1FA0081264030F081C245E34540F701486DE280264067B38FBA42E34540 | 248.34635131222444
37 | 16398 | 0.06349508818144431 | Via Faenza | 0.8818762247422821 | LINESTRING(11.2522519 43.7756911,11.2522562 43.7756838) | 0102000020E6100000020000002DB53929278126402E2691D849E345402D6D82B927812640BD84549B49E34540 | 149.50016676371678
38 | 680 | 6.5025099152856765 | Via Faenza | 90.31263771230107 | LINESTRING(11.2518398 43.7764464,11.2518733 43.7763586,11.2519143 43.7762779,11.2521622 43.7758448,11.2522519 43.7756911) | 0102000020E61000000500000091A97125F1802640688C7B9862E34540A0788489F5802640F37BF6B75FE345401ACA3FE9FA802640C48D00135DE34540289364671B812640C662E5E14EE345402DB53929278126402E2691D849E34540 | 151.38263140121123
39 | 679 | 3.9216567393303388 | Via Giovan Battista Zannoni | 54.46745471292137 | LINESTRING(11.2518398 43.7764464,11.2519766 43.7764861,11.2523971 43.7767189) | 0102000020E61000000300000091A97125F1802640688C7B9862E34540EDB6B0130381264038A682E563E34540E23554313A812640B1D760866BE34540 | 63.94300131893053
40 | 15379 | 0.3160002129957741 | Via Giovan Battista Zannoni | 4.388891847163529 | LINESTRING(11.2523971 43.7767189,11.2524404 43.7767429) | 0102000020E610000002000000E23554313A812640B1D760866BE34540D9603CDE3F8126403A73B44F6CE34540 | 61.001601274208866
41 | -1 | 0 | | | | |
(41 rows)
seq | id | seconds | name | length_m | route_readable | route_geom | azimuth
-----+-------+----------------------+-----------------------------+---------------------+-------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------
1 | 13058 | 0.5060969326843554 | Piazza Adua | 7.810137850067213 | LINESTRING(11.2492507 43.7777478,11.2493405 43.7777744) | 0102000020E6100000020000009D02AAC99D7F26409AC46A3D8DE34540F722DA8EA97F264040D58D1C8EE34540 | 73.4999834879164
2 | 12857 | 1.0867563175383887 | Piazza Adua | 16.770930826209703 | LINESTRING(11.2490531 43.7777,11.2492507 43.7777478) | 0102000020E61000000200000051EF4EE3837F2640B30C71AC8BE345409D02AAC99D7F26409AC46A3D8DE34540 | 76.40122475415983
3 | 13203 | 0.18004858277631242 | Piazza Adua | 2.77852751198013 | LINESTRING(11.2490204 43.777692,11.2490531 43.7777) | 0102000020E610000002000000DC12149A7F7F2640302E55698BE3454051EF4EE3837F2640B30C71AC8BE34540 | 76.25270974093915
4 | 26751 | 0.07228188041112218 | Piazza della Stazione | 1.1154611174555893 | LINESTRING(11.2490066 43.7776911,11.2490204 43.777692) | 0102000020E610000002000000EFF906CB7D7F2640F471C8618BE34540DC12149A7F7F2640302E55698BE34540 | 86.2686029866306
5 | 19982 | 0.2081786548959193 | Piazza della Stazione | 3.212633563208631 | LINESTRING(11.2489685 43.7776825,11.2490066 43.7776911) | 0102000020E610000002000000E6779ACC787F2640F415A4198BE34540EFF906CB7D7F2640F471C8618BE34540 | 77.28026010114702
6 | 13201 | 0.6450329015836758 | Piazza della Stazione | 9.954211444192527 | LINESTRING(11.2489468 43.7775943,11.2489685 43.7776825) | 0102000020E61000000200000041E378F4757F26402B07C43588E34540E6779ACC787F2640F415A4198BE34540 | 13.822054635403566
7 | 13098 | 1.1136807066473742 | Piazza della Stazione | 17.18643065813849 | LINESTRING(11.2489154 43.7774413,11.2489468 43.7775943) | 0102000020E61000000200000007F1DCD6717F2640A5074F3283E3454041E378F4757F26402B07C43588E34540 | 11.597703934792799
8 | 2876 | 2.428314033015453 | Piazza della Stazione | 37.47398199097921 | LINESTRING(11.2488478 43.7771076,11.2489154 43.7774413) | 0102000020E610000002000000F45C95FA687F26408DBC074378E3454007F1DCD6717F2640A5074F3283E34540 | 11.451843278719066
9 | 13227 | 1.7700575010914117 | Piazza della Stazione | 27.3157021773366 | LINESTRING(11.2489723 43.7768789,11.2488478 43.7771076) | 0102000020E61000000200000045381C4C797F2640EA398EC470E34540F45C95FA687F26408DBC074378E34540 | 331.43695461351274
10 | 6922 | 1.1401151970703385 | Piazza della Stazione | 17.594370325159545 | LINESTRING(11.2490463 43.7767299,11.2489723 43.7768789) | 0102000020E6100000020000002E6123FF827F2640A529A7E26BE3454045381C4C797F2640EA398EC470E34540 | 333.5889693647525
11 | 2874 | 3.68193694184379 | Piazza della Stazione | 56.82001453462638 | LINESTRING(11.2492651 43.7762437,11.2490463 43.7767299) | 0102000020E6100000020000007F11D9AC9F7F2640EF9C1CF45BE345402E6123FF827F2640A529A7E26BE34540 | 335.7712746972623
12 | 29337 | 1.0969752422591483 | Piazza della Stazione | 16.92863028177698 | LINESTRING(11.249333 43.7760995,11.2492651 43.7762437) | 0102000020E6100000020000008CA03193A87F26409278793A57E345407F11D9AC9F7F2640EF9C1CF45BE34540 | 334.7854832322814
13 | 43365 | 1.9685883690600663 | Piazza della Stazione | 30.37945013981584 | LINESTRING(11.2494424 43.7758385,11.2494361 43.7758723,11.2494264 43.7759028,11.249333 43.7760995) | 0102000020E610000004000000B4780CEAB67F2640253D0CAD4EE3454032E2A716B67F2640A82F95C84FE345409E842DD1B47F2640FA6F6FC850E345408CA03193A87F26409278793A57E34540 | 337.2586600832991
14 | 26700 | 1.6045767020592951 | Piazza della Stazione | 24.761986142890358 | LINESTRING(11.2492713 43.7756609,11.2493663 43.7757309,11.2494086 43.7757648,11.2494258 43.7757849,11.2494381 43.7758094,11.2494424 43.7758385) | 0102000020E610000006000000AEA9E27CA07F264099243BDB48E34540F5728EF0AC7F264092FF6E264BE34540ABAEE87BB27F2640A9B1CE424CE34540A98E0BBDB47F2640851D6BEB4CE34540B5C0C359B67F2640F676F0B84DE34540B4780CEAB67F2640253D0CAD4EE34540 | 43.9320922278932
15 | 27343 | 1.5306041269188333 | Piazza della Stazione | 23.620434057389403 | LINESTRING(11.2491477 43.7754685,11.24922 43.7755952,11.2492713 43.7756609) | 0102000020E6100000030000004BBF8E49907F2640024A438D42E34540AB048BC3997F2640A07719B446E34540AEA9E27CA07F264099243BDB48E34540 | 32.71716139273595
16 | 27352 | 0.32118097139553353 | Piazza della Stazione | 4.956496472153295 | LINESTRING(11.2491369 43.7754248,11.2491392 43.7754465,11.2491477 43.7754685) | 0102000020E61000000300000022742BDF8E7F2640F140AE1E41E345409F4D582C8F7F26401AA6B6D441E345404BBF8E49907F2640024A438D42E34540 | 13.881890987422635
17 | 27339 | 0.09081329706847609 | Piazza della Stazione | 1.4014397695752483 | LINESTRING(11.2491361 43.7754122,11.2491369 43.7754248) | 0102000020E610000002000000878153C48E7F2640AFF5FBB440E3454022742BDF8E7F2640F140AE1E41E34540 | 3.6329507401267165
18 | 27342 | 0.2923372052006213 | Piazza della Stazione | 4.511376623466378 | LINESTRING(11.2491321 43.7753717,11.2491361 43.7754122) | 0102000020E61000000200000082C41B3E8E7F264039DF3E613FE34540878153C48E7F2640AFF5FBB440E34540 | 5.6405494308356605
19 | 20120 | 0.5882285518807164 | Piazza della Stazione | 9.077601109270315 | LINESTRING(11.2491316 43.77529,11.2491321 43.7753717) | 0102000020E610000002000000E1CC542D8E7F26403A75E5B33CE3454082C41B3E8E7F264039DF3E613FE34540 | 0.35064298819647977
20 | 13079 | 1.9289230314471795 | Piazza della Stazione | 29.767330732209558 | LINESTRING(11.2495011 43.7752803,11.2491316 43.77529) | 0102000020E610000002000000CEA1B19BBE7F2640D5DD86623CE34540E1CC542D8E7F26403A75E5B33CE34540 | 271.5037657492953
21 | 28649 | 0.4142902197769721 | Piazza della Stazione | 6.393367589150804 | LINESTRING(11.2495802 43.7752752,11.2495011 43.7752803) | 0102000020E6100000020000005275D9F9C87F26402FB3BE373CE34540CEA1B19BBE7F2640D5DD86623CE34540 | 273.68905906213246
22 | 27689 | 2.1769850601145753 | Piazza della Stazione | 33.595448458558266 | LINESTRING(11.2498164 43.7750416,11.2497227 43.7751843,11.2496851 43.7752316,11.2496462 43.7752582,11.2496077 43.7752707,11.2495802 43.7752752) | 0102000020E610000006000000480268EFE77F26400F852A9034E345403C235BA7DB7F2640B36F383D39E34540D498B5B9D67F2640B26900CA3AE34540302471A0D17F2640597A23A93BE34540D9A89894CC7F26400506FF113CE345405275D9F9C87F26402FB3BE373CE34540 | 314.6829129293553
23 | 28640 | 0.3507667157850087 | Piazza dell'Unità Italiana | 5.413066601620504 | LINESTRING(11.2498808 43.7750556,11.2498164 43.7750416) | 0102000020E610000002000000F0CB4F60F07F2640744A9B0535E34540480268EFE77F26400F852A9034E34540 | 257.73522627184514
24 | 27686 | 0.20484949058571325 | Piazza dell'Unità Italiana | 3.16125757076718 | LINESTRING(11.2499184 43.7750638,11.2498808 43.7750556) | 0102000020E6100000020000005956F54DF57F264020A8644A35E34540F0CB4F60F07F2640744A9B0535E34540 | 257.6972736802688
25 | 27703 | 0.23993486285003354 | Piazza dell'Unità Italiana | 3.7026985007721223 | LINESTRING(11.2499624 43.7750735,11.2499184 43.7750638) | 0102000020E61000000200000097755A12FB7F2640853FC39B35E345405956F54DF57F264020A8644A35E34540 | 257.56774262247706
26 | 28645 | 0.20085655932921234 | Piazza dell'Unità Italiana | 3.099638261253277 | LINESTRING(11.2499992 43.7750817,11.2499624 43.7750735) | 0102000020E610000002000000650D28E5FF7F2640329D8CE035E3454097755A12FB7F2640853FC39B35E34540 | 257.4382257879712
27 | 20445 | 0.19032478605369407 | Piazza dell'Unità Italiana | 2.9371108958903407 | LINESTRING(11.2500341 43.7750894,11.2499992 43.7750817) | 0102000020E61000000200000004C5347804802640F63C242136E34540650D28E5FF7F2640329D8CE035E34540 | 257.55813574796525
28 | 43363 | 0.521238652163862 | Piazza dell'Unità Italiana | 8.043806360553425 | LINESTRING(11.2501298 43.7751102,11.2500341 43.7750894) | 0102000020E61000000200000092825D0311802640E4E59FCF36E3454004C5347804802640F63C242136E34540 | 257.7377118804438
29 | 25386 | 0.13452137205058018 | Piazza dell'Unità Italiana | 2.0759470995459903 | LINESTRING(11.2501544 43.7751158,11.2501298 43.7751102) | 0102000020E610000002000000A8E6CD3C1480264073CE99FE36E3454092825D0311802640E4E59FCF36E34540 | 257.17560189431106
30 | 25390 | 3.3401032486896938 | Piazza dell'Unità Italiana | 51.54480322051997 | LINESTRING(11.250764 43.7752576,11.2501544 43.7751158) | 0102000020E6100000020000003E07962364802640DCFC1AA43BE34540A8E6CD3C1480264073CE99FE36E34540 | 256.9052038675325
31 | 25389 | 0.681270732013665 | Piazza dell'Unità Italiana | 10.513437222433101 | LINESTRING(11.2508429 43.7751822,11.250764 43.7752576) | 0102000020E6100000020000001BDE077B6E8026407EB89A2B39E345403E07962364802640DCFC1AA43BE34540 | 313.70057779891823
32 | 27694 | 0.022870699852101196 | Piazza dell'Unità Italiana | 0.35294289895217895 | LINESTRING(11.2508469 43.7751835,11.2508429 43.7751822) | 0102000020E610000002000000219B3F016F8026400C73823639E345401BDE077B6E8026407EB89A2B39E34540 | 251.995838475785
33 | 27699 | 0.08513404771100623 | Piazza dell'Unità Italiana | 1.3137970325772568 | LINESTRING(11.2508568 43.7751741,11.2508469 43.7751835) | 0102000020E6100000020000005BF56F4D70802640661AA8E738E34540219B3F016F8026400C73823639E34540 | 313.5159853171293
34 | 20207 | 0.11922747231731107 | Piazza dell'Unità Italiana | 1.839930128353566 | LINESTRING(11.2508706 43.7751609,11.2508568 43.7751741) | 0102000020E610000002000000490E7D1C72802640A851ED7838E345405BF56F4D70802640661AA8E738E34540 | 313.7269699725753
35 | 17774 | 5.006277360411418 | Via Sant'Antonino | 77.25736667301571 | LINESTRING(11.2517275 43.7754739,11.2508706 43.7751609) | 0102000020E610000002000000F701486DE280264067B38FBA42E34540490E7D1C72802640A851ED7838E34540 | 249.93425977746153
36 | 17761 | 3.1450592852688932 | Via Sant'Antonino | 48.534865513408846 | LINESTRING(11.2522562 43.7756838,11.2519606 43.7755664,11.2517275 43.7754739) | 0102000020E6100000030000002D6D82B927812640BD84549B49E34540D6C2D1FA0081264030F081C245E34540F701486DE280264067B38FBA42E34540 | 248.34635131222444
37 | 16398 | 0.05714557936329988 | Via Faenza | 0.8818762247422821 | LINESTRING(11.2522519 43.7756911,11.2522562 43.7756838) | 0102000020E6100000020000002DB53929278126402E2691D849E345402D6D82B927812640BD84549B49E34540 | 149.50016676371678
38 | 680 | 5.852258923757109 | Via Faenza | 90.31263771230107 | LINESTRING(11.2518398 43.7764464,11.2518733 43.7763586,11.2519143 43.7762779,11.2521622 43.7758448,11.2522519 43.7756911) | 0102000020E61000000500000091A97125F1802640688C7B9862E34540A0788489F5802640F37BF6B75FE345401ACA3FE9FA802640C48D00135DE34540289364671B812640C662E5E14EE345402DB53929278126402E2691D849E34540 | 151.38263140121123
39 | 679 | 3.529491065397305 | Via Giovan Battista Zannoni | 54.46745471292137 | LINESTRING(11.2518398 43.7764464,11.2519766 43.7764861,11.2523971 43.7767189) | 0102000020E61000000300000091A97125F1802640688C7B9862E34540EDB6B0130381264038A682E563E34540E23554313A812640B1D760866BE34540 | 63.94300131893053
40 | 15379 | 0.2844001916961967 | Via Giovan Battista Zannoni | 4.388891847163529 | LINESTRING(11.2523971 43.7767189,11.2524404 43.7767429) | 0102000020E610000002000000E23554313A812640B1D760866BE34540D9603CDE3F8126403A73B44F6CE34540 | 61.001601274208866
41 | -1 | 0 | | | | |
(41 rows)
seq | id | seconds | name | length_m | route_readable | route_geom | azimuth
-----+-------+---------------------+-----------------------------+--------------------+----------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------
1 | 12658 | 13.508105033554621 | | 27.016210067109242 | LINESTRING(11.2493405 43.7777744,11.2493475 43.7780175) | 0102000020E610000002000000F722DA8EA97F264040D58D1C8EE34540C1ADBB79AA7F26409B1BD31396E34540 | 1.649361021362276
2 | 13211 | 0.588926943015748 | | 1.177853886031496 | LINESTRING(11.2493475 43.7780175,11.2493477 43.7780281) | 0102000020E610000002000000C1ADBB79AA7F26409B1BD31396E3454067AA7180AA7F26403C6FBE6C96E34540 | 1.0809241797789182
3 | 24758 | 3.0680623839800782 | | 6.1361247679601565 | LINESTRING(11.2493477 43.7780281,11.2494029 43.7780308,11.2494079 43.7780161) | 0102000020E61000000300000067AA7180AA7F26403C6FBE6C96E345401C0EA6BCB17F2640EFA3648396E3454063BA6B64B27F264078A1140896E34540 | 101.27332175554055
4 | 45527 | 1.0938326857746727 | | 2.1876653715493455 | LINESTRING(11.2494079 43.7780161,11.2494145 43.777997) | 0102000020E61000000200000063BA6B64B27F264078A1140896E34540E04BE141B37F26406CB1DB6795E34540 | 160.93742298618292
5 | 31949 | 9.052864227250197 | | 18.105728454500394 | LINESTRING(11.2496197 43.7779303,11.2494145 43.777997) | 0102000020E610000002000000EADF3F27CE7F2640A388563893E34540E04BE141B37F26406CB1DB6795E34540 | 288.0066870113601
6 | 31951 | 53.94292252479892 | | 107.88584504959783 | LINESTRING(11.2506627 43.778463,11.2503006 43.778258,11.2502657 43.7782949,11.2496197 43.7779303) | 0102000020E61000000400000074A785DC56802640B212F3ACA4E345409E56766627802640D9EC48F59DE34540009F69D3228026406112D32A9FE34540EADF3F27CE7F2640A388563893E34540 | 242.94486054993433
7 | 31950 | 0.32009225202051483 | | 0.6401845040410297 | LINESTRING(11.2506627 43.778463,11.2506673 43.7784583) | 0102000020E61000000200000074A785DC56802640B212F3ACA4E345406E5ADF76578026405EE68585A4E34540 | 135.6160599371088
8 | 23548 | 1.1181185327985674 | | 2.236237065597135 | LINESTRING(11.2506673 43.7784583,11.25068 43.7784404) | 0102000020E6100000020000006E5ADF76578026405EE68585A4E34540C6850321598026404DF15DEFA3E34540 | 144.64440563579782
9 | 40407 | 69.90891522499619 | | 139.81783044999239 | LINESTRING(11.25068 43.7784404,11.2506875 43.7784298,11.2507402 43.7783556,11.2509521 43.777884,11.2511206 43.7775401,11.2512728 43.7772588) | 0102000020E610000006000000C6850321598026404DF15DEFA3E345403108AC1C5A802640AC9D7296A3E34540C295FD046180264048540328A1E345409CB92CCB7C802640740AF2B391E345402CB418E1928026400F6A1A6F86E34540ABBF14D4A68026409C4363377DE34540 | 153.357417368863
10 | 31947 | 23.537457152822878 | | 47.074914305645756 | LINESTRING(11.2512728 43.7772588,11.2515557 43.776888) | 0102000020E610000002000000ABBF14D4A68026409C4363377DE34540AA3EA1E8CB802640D253E41071E34540 | 142.65836080914565
11 | 31945 | 0.5474709296454 | crossing | 1.0949418592908 | LINESTRING(11.2515557 43.776888,11.2515658 43.7768946) | 0102000020E610000002000000AA3EA1E8CB802640D253E41071E345408B95873BCD80264031B8414871E34540 | 56.83677536940089
12 | 682 | 1.9182725973804964 | Via Faenza | 3.8365451947609928 | LINESTRING(11.2515884 43.7768642,11.2515658 43.7768946) | 0102000020E6100000020000001E1BDC31D080264073373E4970E345408B95873BCD80264031B8414871E34540 | 323.3721105439734
13 | 23233 | 0.2759043100739863 | Via Faenza | 0.5518086201479726 | LINESTRING(11.2515884 43.7768642,11.2515913 43.7768597) | 0102000020E6100000020000001E1BDC31D080264073373E4970E345408FEA2A93D08026404A8A7E2370E34540 | 147.20046870145694
14 | 39368 | 1.727753563375398 | Via Faenza | 3.455507126750796 | LINESTRING(11.2515913 43.7768597,11.2516094 43.7768315) | 0102000020E6100000020000008FEA2A93D08026404A8A7E2370E345407CBB80F2D28026405680EF366FE34540 | 147.30586806025627
15 | 31852 | 23.245547065588088 | | 46.491094131176176 | LINESTRING(11.2520399 43.7771104,11.2516094 43.7768315) | 0102000020E6100000020000000093AF5F0B812640D4B0845A78E345407CBB80F2D28026405680EF366FE34540 | 237.0627618251047
16 | 21118 | 26.073202026072646 | | 52.14640405214529 | LINESTRING(11.2523971 43.7767189,11.2523837 43.7767324,11.2520399 43.7771104) | 0102000020E610000003000000E23554313A812640B1D760866BE345404216B36F388126402EDF9FF76BE345400093AF5F0B812640D4B0845A78E34540 | 317.6230427082644
17 | 15379 | 2.1944459235817644 | Via Giovan Battista Zannoni | 4.388891847163529 | LINESTRING(11.2523971 43.7767189,11.2524404 43.7767429) | 0102000020E610000002000000E23554313A812640B1D760866BE34540D9603CDE3F8126403A73B44F6CE34540 | 61.001601274208866
18 | -1 | 0 | | | | |
(18 rows)
6.4. Solutions to pl/pgsql function¶
6.4.1. Exercise: 1 (Chapter: pl/pgsql)¶
Exercise 1: Number of vertices
For ways_vertices_pgr:
count
-------
31768
(1 row)
For vehicle_net:
count
-------
19055
(1 row)
For taxi_net:
count
-------
4123
(1 row)
For walk_net:
count
-------
30554
(1 row)
6.4.2. Exercise: 2 (Chapter: pl/pgsql)¶
Exercise 2: Vertices on a table
For vehicle_net:
SELECT 19055
For taxi_net:
SELECT 4123
For walk_net:
SELECT 30554
6.4.3. Exercise: 3 (Chapter: pl/pgsql)¶
For ways_vertices_pgr:
osm_id
------------
7493947822
(1 row)
For vehicle_net_vertices_pgr:
id
------------
7493947833
(1 row)
For taxi_net_vertices_pgr:
id
------------
4540843675
(1 row)
For walk_net_vertices_pgr:
id
------------
7493947822
(1 row)
6.4.4. Exercise: 4 (Chapter: pl/pgsql)¶
Exercise 4: Nearest vertex function
CREATE FUNCTION
6.4.5. Exercise: 5 (Chapter: pl/pgsql)¶
Exercise 5: Test nearest vertex function
For ways_vertices_pgr:
wrk_nearestosm
----------------
29698
(1 row)
For vehicle_net_vertices_pgr:
wrk_nearestosm
----------------
7493947833
(1 row)
For taxi_net_vertices_pgr:
wrk_nearestosm
----------------
4540843675
(1 row)
For walk_net_vertices_pgr:
wrk_nearestosm
----------------
7493947822
(1 row)
6.4.6. Exercise: 6 (Chapter: pl/pgsql)¶
Exercise 6: Creating the main function
CREATE FUNCTION
6.4.7. Exercise: 7 (Chapter: pl/pgsql)¶
Exercise 7: Using the main function
For vehicle_net
seq | id | seconds | name | length_m | route_readable | route_geom | azimuth
-----+-------+---------------------+----------------------------+--------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------
1 | 43225 | 0.18831701643482568 | | 2.6155141171503566 | LINESTRING(11.2383414 43.7838931,11.2383433 43.7838696) | 0102000020E610000002000000D2904CE2077A2640B007EE9B56E4454002710D22087A2640102ACCD655E44540 | 175.37762975567907
2 | 43221 | 0.25814060288672386 | | 3.585286151204498 | LINESTRING(11.2383433 43.7838696,11.2383462 43.7838374) | 0102000020E61000000200000002710D22087A2640102ACCD655E4454073405C83087A2640DB30AFC854E44540 | 174.85370531154794
3 | 2134 | 1.3193753293997095 | Via Gaspare Luigi Spontini | 18.324657352773745 | LINESTRING(11.2381191 43.783826,11.2383462 43.7838374) | 0102000020E6100000020000001D1B26BFEA79264093E00D6954E4454073405C83087A2640DB30AFC854E44540 | 87.1262700040484
4 | 5987 | 0.7183005579935695 | Via Gaspare Luigi Spontini | 9.976396638799576 | LINESTRING(11.2379955 43.7838194,11.2381191 43.783826) | 0102000020E610000002000000BA30D28BDA792640347CB03154E445401D1B26BFEA79264093E00D6954E44540 | 86.94341955233288
5 | 11297 | 7.081882049247654 | Via Gaspare Luigi Spontini | 98.35947290621742 | LINESTRING(11.2368776 43.7834842,11.237089 43.7835812,11.2373654 43.7836873,11.237572 43.7837513,11.2377824 43.7837918,11.2379955 43.7838194) | 0102000020E610000006000000584F52054879264063F7D33549E44540917BBABA6379264056E185634CE4454067672CF58779264030E58DDD4FE4454000E48409A379264047D96CF651E44540F8205F9DBE792640BEEF294A53E44540BA30D28BDA792640347CB03154E44540 | 73.30874969469006
6 | 2139 | 0.9737265903893841 | Via Gaspare Luigi Spontini | 13.52398042207478 | LINESTRING(11.2367368 43.7834178,11.2367962 43.7834453,11.2368776 43.7834842) | 0102000020E610000003000000F684DB9035792640590DD30847E4454058A2FD593D7926403ADA82EF47E44540584F52054879264063F7D33549E44540 | 64.75186123067071
7 | 25825 | 0.9622949495228436 | Via Giuseppe Galliano | 13.365207632261717 | LINESTRING(11.2368757 43.7833519,11.2367368 43.7834178) | 0102000020E610000002000000296F91C54779264036E103E044E44540F684DB9035792640590DD30847E44540 | 295.3816290533428
8 | 25821 | 5.105279757202559 | Via Giuseppe Galliano | 70.90666329447998 | LINESTRING(11.2376119 43.7830015,11.2374186 43.7830933,11.2368757 43.7833519) | 0102000020E610000003000000E5475744A8792640069CA56439E4454099EC44EE8E792640BD9BB8663CE44540296F91C54779264036E103E044E44540 | 295.4524685260578
9 | 28098 | 7.326701900598858 | Via Giuseppe Galliano | 101.75974861942858 | LINESTRING(11.2386684 43.7824986,11.2376119 43.7830015) | 0102000020E610000002000000632D99BE327A2640381504EA28E44540E5475744A8792640069CA56439E44540 | 295.4547134845089
10 | 20327 | 0.21799087641662387 | Via Giuseppe Galliano | 3.0276510613419982 | LINESTRING(11.2386998 43.7824836,11.2386684 43.7824986) | 0102000020E6100000020000009C1F35DC367A264003D42F6C28E44540632D99BE327A2640381504EA28E44540 | 295.53413298870595
11 | 13475 | 0.7532529277381005 | Via Giuseppe Galliano | 10.461846218584729 | LINESTRING(11.2387475 43.7823968,11.2387361 43.7824315,11.2387267 43.782449,11.2386998 43.7824836) | 0102000020E610000004000000E700C11C3D7A26405E3F0E9425E44540CABF3B9E3B7A26401CEE23B726E44540305DD2623A7A2640DAE4F04927E445409C1F35DC367A264003D42F6C28E44540 | 331.20948166684525
12 | 4489 | 0.4615807820949248 | Via Giuseppe Galliano | 6.410844195762845 | LINESTRING(11.2387556 43.7823394,11.2387475 43.7823968) | 0102000020E61000000200000045798B2C3E7A2640A6AF8CB223E44540E700C11C3D7A26405E3F0E9425E44540 | 351.9677434798056
13 | 28107 | 8.13999382567353 | Via Benedetto Marcello | 113.05546980102125 | LINESTRING(11.2373824 43.782126,11.2387556 43.7823394) | 0102000020E610000002000000BF4A992F8A792640F7AC6BB41CE4454045798B2C3E7A2640A6AF8CB223E44540 | 81.16669545791375
14 | 20332 | 1.2115944582869407 | Via Benedetto Marcello | 16.827700809540843 | LINESTRING(11.2371779 43.7820946,11.2373824 43.782126) | 0102000020E610000002000000FDAAB7616F79264069B004AD1BE44540BF4A992F8A792640F7AC6BB41CE44540 | 81.27068138718842
15 | 13480 | 0.741088125712795 | Via Benedetto Marcello | 10.292890634899932 | LINESTRING(11.2370539 43.782072,11.2371779 43.7820946) | 0102000020E6100000020000004CC7F7205F792640048F6FEF1AE44540FDAAB7616F79264069B004AD1BE44540 | 79.67075850835901
16 | 4216 | 7.447909481699016 | Via Benedetto Marcello | 103.44318724581967 | LINESTRING(11.2358456 43.7818002,11.2358718 43.7818294,11.2359077 43.7818511,11.2359573 43.7818753,11.2359996 43.7818887,11.2370539 43.782072) | 0102000020E6100000060000009DCF25C1C0782640CD80690712E44540E9184630C478264091065CFC12E44540C9BFE0E4C8782640BA6B64B213E4454043812D65CF7826406D86657D14E44540F8BC87F0D478264055CECDED14E445404CC7F7205F792640048F6FEF1AE44540 | 77.32266306367465
17 | 11553 | 0.6931484113947181 | Via del Ponte alle Mosse | 9.627061269371085 | LINESTRING(11.2359253 43.7817356,11.2358456 43.7818002) | 0102000020E61000000200000015996F33CB782640390F82E90FE445409DCF25C1C0782640CD80690712E44540 | 309.0261334106299
18 | 431 | 12.68607930426873 | Via del Ponte alle Mosse | 176.19554589262125 | LINESTRING(11.237248 43.7804741,11.2368314 43.7809111,11.2366262 43.7811253,11.2364038 43.7813225,11.2359253 43.7817356) | 0102000020E6100000050000003315E2917879264001704793E6E34540F0541BF741792640ACCA19E5F4E34540E6C0BC112779264002CAF0E9FBE34540DD4C3BEB0979264082902C6002E4454015996F33CB782640390F82E90FE44540 | 313.6433533083995
19 | 2091 | 0.3977411589062095 | Via del Ponte alle Mosse | 5.524182762586243 | LINESTRING(11.237286 43.7804327,11.237248 43.7804741) | 0102000020E610000002000000E998F38C7D7926404F9DFD37E5E345403315E2917879264001704793E6E34540 | 317.45197371084305
20 | 6576 | 8.425459509789347 | Via del Ponte alle Mosse | 117.02027096929648 | LINESTRING(11.2381482 43.7795857,11.2378532 43.7798441,11.237286 43.7804327) | 0102000020E610000003000000D933958FEE792640F2F6D676C9E34540767F06E5C779264041BD74EED1E34540E998F38C7D7926404F9DFD37E5E34540 | 314.4904792352936
21 | 13106 | 0.8367185106655376 | Via del Ponte alle Mosse | 11.621090425910245 | LINESTRING(11.2382402 43.7795051,11.2381482 43.7795857) | 0102000020E6100000020000005C2F979EFA79264059C8B7D2C6E34540D933958FEE792640F2F6D676C9E34540 | 311.2211786776502
22 | 10793 | 1.2590220988841692 | Via del Ponte alle Mosse | 17.486418040057906 | LINESTRING(11.2383786 43.7793838,11.2382645 43.7794838,11.2382402 43.7795051) | 0102000020E610000003000000EE2186C20C7A26401F042ED9C2E345407898F6CDFD79264083610A20C6E345405C2F979EFA79264059C8B7D2C6E34540 | 311.2327856820179
23 | 433 | 1.0209683036043506 | Via del Ponte alle Mosse | 14.180115327838203 | LINESTRING(11.2384852 43.7792822,11.2383786 43.7793838) | 0102000020E610000002000000F8286DBB1A7A26406EADE584BFE34540EE2186C20C7A26401F042ED9C2E34540 | 313.6242851004666
24 | 10799 | 5.322987640044557 | Via del Ponte alle Mosse | 73.93038388950774 | LINESTRING(11.2390361 43.7787499,11.2389431 43.7788403,11.238591 43.7791857,11.2384852 43.7792822) | 0102000020E610000004000000742090F0627A2640B321A413AEE34540B03500C0567A264046A7F809B1E34540683D7C99287A26406481655BBCE34540F8286DBB1A7A26406EADE584BFE34540 | 314.016251130705
25 | 14234 | 3.95528239938479 | Via del Ponte alle Mosse | 54.9344777692332 | LINESTRING(11.2394498 43.7783567,11.2390361 43.7787499) | 0102000020E6100000020000004611082A997A2640AE8F3D31A1E34540742090F0627A2640B321A413AEE34540 | 313.544663691545
26 | 4702 | 0.23926610498654155 | Via del Ponte alle Mosse | 3.3231403470352996 | LINESTRING(11.2394748 43.7783329,11.2394498 43.7783567) | 0102000020E610000002000000AA6EE4709C7A26404F739769A0E345404611082A997A2640AE8F3D31A1E34540 | 313.5913712649348
27 | 4703 | 2.2940344707611726 | Via del Ponte alle Mosse | 31.861589871682952 | LINESTRING(11.2397837 43.7781544,11.2397161 43.7781862,11.2396503 43.7782217,11.2394748 43.7783329) | 0102000020E6100000040000004E3ADBEDC47A2640879E39909AE345403BA69311BC7A26406999FB9A9BE3454003F4B171B37A2640CE44C7C49CE34540AA6EE4709C7A26404F739769A0E34540 | 300.0217665791065
28 | 5098 | 0.27865004073015504 | Via del Ponte alle Mosse | 3.870139454585487 | LINESTRING(11.2398283 43.7781414,11.2397837 43.7781544) | 0102000020E610000002000000804F62C6CA7A2640F3542C239AE345404E3ADBEDC47A2640879E39909AE34540 | 286.25033802894234
29 | 2202 | 0.8766488651014784 | Via del Ponte alle Mosse | 12.175678681964978 | LINESTRING(11.2399785 43.7781315,11.2399352 43.7781327,11.2398961 43.7781333,11.2398699 43.7781352,11.2398283 43.7781414) | 0102000020E6100000050000007C7C4276DE7A2640643E20D099E3454085515AC9D87A26405E3931DA99E345403AE05FA9D37A2640DBB639DF99E34540EF963F3AD07A2640E7EE29EF99E34540804F62C6CA7A2640F3542C239AE34540 | 273.77103148056875
30 | 4705 | 2.1451412738391165 | Via del Ponte alle Mosse | 29.793628803321063 | LINESTRING(11.2403455 43.7781553,11.2401621 43.778132,11.2400834 43.7781281,11.2399785 43.7781315) | 0102000020E610000004000000467BBC900E7B2640C35AC6979AE34540347ADA86F67A26404CFC51D499E34540FE9F1E36EC7A2640A0CC9AB399E345407C7C4276DE7A2640643E20D099E34540 | 266.28955654494143
31 | 2781 | 0.6410937671118804 | Piazzale di Porta al Prato | 8.904080098776117 | LINESTRING(11.2404466 43.7781878,11.2403455 43.7781553) | 0102000020E61000000200000069DE16D11B7B2640B69267A89BE34540467BBC900E7B2640C35AC6979AE34540 | 252.17927662461713
32 | 177 | 4.87411600570478 | Piazzale di Porta al Prato | 67.6960556347886 | LINESTRING(11.241223 43.7784218,11.2409649 43.7783425,11.2404466 43.7781878) | 0102000020E6100000030000000516C094817B264029BF5653A3E34540C3F759C05F7B26401F4B1FBAA0E3454069DE16D11B7B2640B69267A89BE34540 | 253.22766409549308
33 | 29457 | 0.18084752645234362 | Piazzale di Porta al Prato | 2.5117712007269946 | LINESTRING(11.2412515 43.778431,11.241223 43.7784218) | 0102000020E610000002000000CE380D51857B2640A69883A0A3E345400516C094817B264029BF5653A3E34540 | 252.10955644681033
34 | 20626 | 0.9911841143395348 | Piazzale di Porta al Prato | 13.766446032493539 | LINESTRING(11.2414079 43.7784811,11.2412515 43.778431) | 0102000020E610000002000000F9FDF6D0997B2640ED86C844A5E34540CE380D51857B2640A69883A0A3E34540 | 252.2380497920267
35 | 6624 | 7.751106277602056 | Viale Fratelli Rosselli | 107.65425385558412 | LINESTRING(11.2426358 43.7788648,11.2424897 43.7788196,11.2420552 43.7786868,11.2414079 43.7784811) | 0102000020E61000000400000077AD73C23A7C2640B7007ED7B1E34540D43B269C277C2640EDBD535CB0E345404AA7BFA8EE7B2640D8E95102ACE34540F9FDF6D0997B2640ED86C844A5E34540 | 252.64677243367373
36 | 29446 | 2.086591418539065 | Via Jacopo da Diacceto | 28.980436368598127 | LINESTRING(11.242914 43.7787,11.2428302 43.7787406,11.2426358 43.7788648) | 0102000020E610000003000000297B4B395F7C264096B20C71ACE3454058F66E3D547C2640A188A0C5ADE3454077AD73C23A7C2640B7007ED7B1E34540 | 300.6416345081347
37 | 20625 | 17.573375129711195 | Via Jacopo da Diacceto | 244.07465457932216 | LINESTRING(11.2454268 43.7774709,11.2441684 43.7780921,11.242914 43.7787) | 0102000020E610000003000000B61FDF94A87D2640BC8B9C2A84E34540EC6EF9A3037D264053639D8598E34540297B4B395F7C264096B20C71ACE34540 | 296.0649040714764
38 | 14012 | 1.0613270167065867 | Via Luigi Alamanni | 14.740653009813704 | LINESTRING(11.2455796 43.7773978,11.2454268 43.7774709) | 0102000020E6100000020000002821FD9BBC7D2640BE7D67C581E34540B61FDF94A87D2640BC8B9C2A84E34540 | 295.5665989296672
39 | 6037 | 1.424951424643908 | Via Luigi Alamanni | 19.790992008943167 | LINESTRING(11.2457316 43.7772724,11.2457277 43.7772997,11.2457138 43.7773292,11.2456869 43.7773486,11.2455796 43.7773978) | 0102000020E61000000500000000304388D07D2640AE0A79A97DE345404E716605D07D264066587B8E7EE345400E5AFE32CE7D2640E81CF2857FE345407B1C61ACCA7D2640B34BAF2880E345402821FD9BBC7D2640BE7D67C581E34540 | 309.52263127156954
40 | 9999 | 0.2757550011500176 | Via Luigi Alamanni | 3.8299305715280223 | LINESTRING(11.2457175 43.7772396,11.2457232 43.7772576,11.2457316 43.7772724) | 0102000020E610000003000000191C25AFCE7D2640FC9353967CE34540A8BC676ECF7D2640A248522D7DE3454000304388D07D2640AE0A79A97DE34540 | 23.26180760366172
41 | 2878 | 5.385097885843093 | Via Luigi Alamanni | 74.79302619226519 | LINESTRING(11.2461217 43.7766359,11.2460028 43.7767864,11.2457294 43.7771941,11.2457178 43.7772304,11.2457175 43.7772396) | 0102000020E610000005000000FEABD8A9037E264024B31FCE68E34540E8723914F47D264021FD9BBC6DE34540D754713ED07D26407412A5187BE34540131736B9CE7D26407FBA26497CE34540191C25AFCE7D2640FC9353967CE34540 | 326.19619410324947
42 | 8425 | 3.93594124661715 | Via Luigi Alamanni | 54.66585064746042 | LINESTRING(11.2465792 43.7762724,11.246347 43.7764517,11.2461217 43.7766359) | 0102000020E61000000300000068BFFFA03F7E2640CB64DDE45CE3454078EFA831217E26403936F1C462E34540FEABD8A9037E264024B31FCE68E34540 | 308.46838914958346
43 | 14231 | 0.13893518603907354 | Via Luigi Alamanni | 1.9296553616537993 | LINESTRING(11.2465954 43.7762596,11.2465792 43.7762724) | 0102000020E61000000200000026B094C0417E2640609A7D795CE3454068BFFFA03F7E2640CB64DDE45CE34540 | 308.31309067286264
44 | 13205 | 4.14470496275055 | Via Luigi Alamanni | 57.56534670486876 | LINESTRING(11.2470792 43.7758781,11.2468273 43.7760767,11.2467312 43.7761525,11.2465954 43.7762596) | 0102000020E6100000040000002F0B372A817E264060973CF94FE345401C85DA25607E264003D8367B56E3454040CE458D537E2640B51A12F758E3454026B094C0417E2640609A7D795CE34540 | 308.25750989922614
45 | 18445 | 0.26988435497519914 | Piazza della Stazione | 3.7483938190999884 | LINESTRING(11.24711 43.7758528,11.2470792 43.7758781) | 0102000020E6100000020000007407B133857E2640494101254FE345402F0B372A817E264060973CF94FE34540 | 309.40066066101303
46 | 18322 | 0.2769892908549861 | Piazza della Stazione | 3.847073484097029 | LINESTRING(11.2471414 43.7758267,11.24711 43.7758528) | 0102000020E610000002000000AEF94C51897E26408BEE0F4A4EE345407407B133857E2640494101254FE34540 | 309.7337043620762
47 | 17711 | 5.155494507799255 | Piazza della Stazione | 71.60409038610076 | LINESTRING(11.2476822 43.7753311,11.2476174 43.7753552,11.2475694 43.7753812,11.24748 43.7754517,11.2474375 43.7754934,11.2473975 43.7755427,11.2473452 43.7756283,11.247302 43.7756938,11.2472708 43.7757288,11.2472299 43.7757623,11.2471414 43.7758267) | 0102000020E61000000B000000489A8933D07E26402E09AB0C3EE3454052D735B5C77E26404B64D5D63EE345400EFB986AC17E264074F7EFB03FE3454002D4D4B2B57E26405590550042E34540A69BC420B07E2640C6A1235E43E345406D3997E2AA7E26406693B2FB44E3454029A5B107A47E2640112DC3C947E345408578245E9E7E2640E05A37EF49E34540F3823E479A7E26405D48D1144BE34540CC2FDEEA947E264020FCD52D4CE34540AEF94C51897E26408BEE0F4A4EE34540 | 312.5027700232734
48 | 26701 | 7.46721738783527 | Piazza della Stazione | 103.7113526088232 | LINESTRING(11.2489693 43.7752924,11.2480605 43.7753197,11.2477291 43.7753297,11.2476822 43.7753311) | 0102000020E610000004000000816A72E7787F26402E6B07C83CE34540DBDB2DC9017F2640E6B809AD3DE34540F8883D59D67E26400A8FEC003EE34540489A8933D07E26402E09AB0C3EE34540 | 271.72222735194464
49 | 19974 | 0.9409834968537008 | Piazza della Stazione | 13.069215234079177 | LINESTRING(11.2491316 43.77529,11.2489693 43.7752924) | 0102000020E610000002000000E1CC542D8E7F26403A75E5B33CE34540816A72E7787F26402E6B07C83CE34540 | 270.84719561994746
50 | 13079 | 2.143247812719088 | Piazza della Stazione | 29.767330732209558 | LINESTRING(11.2495011 43.7752803,11.2491316 43.77529) | 0102000020E610000002000000CEA1B19BBE7F2640D5DD86623CE34540E1CC542D8E7F26403A75E5B33CE34540 | 271.5037657492953
51 | 28649 | 0.4603224664188579 | Piazza della Stazione | 6.393367589150804 | LINESTRING(11.2495802 43.7752752,11.2495011 43.7752803) | 0102000020E6100000020000005275D9F9C87F26402FB3BE373CE34540CEA1B19BBE7F2640D5DD86623CE34540 | 273.68905906213246
52 | 27689 | 2.418872289016195 | Piazza della Stazione | 33.595448458558266 | LINESTRING(11.2498164 43.7750416,11.2497227 43.7751843,11.2496851 43.7752316,11.2496462 43.7752582,11.2496077 43.7752707,11.2495802 43.7752752) | 0102000020E610000006000000480268EFE77F26400F852A9034E345403C235BA7DB7F2640B36F383D39E34540D498B5B9D67F2640B26900CA3AE34540302471A0D17F2640597A23A93BE34540D9A89894CC7F26400506FF113CE345405275D9F9C87F26402FB3BE373CE34540 | 314.6829129293553
53 | 28640 | 0.38974079531667627 | Piazza dell'Unità Italiana | 5.413066601620504 | LINESTRING(11.2498808 43.7750556,11.2498164 43.7750416) | 0102000020E610000002000000F0CB4F60F07F2640744A9B0535E34540480268EFE77F26400F852A9034E34540 | 257.73522627184514
54 | 27686 | 0.22761054509523695 | Piazza dell'Unità Italiana | 3.16125757076718 | LINESTRING(11.2499184 43.7750638,11.2498808 43.7750556) | 0102000020E6100000020000005956F54DF57F264020A8644A35E34540F0CB4F60F07F2640744A9B0535E34540 | 257.6972736802688
55 | 27703 | 0.2665942920555928 | Piazza dell'Unità Italiana | 3.7026985007721223 | LINESTRING(11.2499624 43.7750735,11.2499184 43.7750638) | 0102000020E61000000200000097755A12FB7F2640853FC39B35E345405956F54DF57F264020A8644A35E34540 | 257.56774262247706
56 | 28645 | 0.22317395481023594 | Piazza dell'Unità Italiana | 3.099638261253277 | LINESTRING(11.2499992 43.7750817,11.2499624 43.7750735) | 0102000020E610000002000000650D28E5FF7F2640329D8CE035E3454097755A12FB7F2640853FC39B35E34540 | 257.4382257879712
57 | 20445 | 0.2114719845041045 | Piazza dell'Unità Italiana | 2.9371108958903407 | LINESTRING(11.2500341 43.7750894,11.2499992 43.7750817) | 0102000020E61000000200000004C5347804802640F63C242136E34540650D28E5FF7F2640329D8CE035E34540 | 257.55813574796525
58 | 795 | 6.014541306237784 | Piazza della Stazione | 83.53529591996923 | LINESTRING(11.2497195 43.7758058,11.249736 43.7757636,11.2499455 43.7752983,11.2500341 43.7750894) | 0102000020E610000004000000D158FB3BDB7F26400886BD9A4DE345408944A165DD7F2640AFB6BD384CE34540939048DBF87F26407C9285F93CE3454004C5347804802640F63C242136E34540 | 156.2917937653566
59 | 17702 | 0.848270317635813 | Piazza della Stazione | 11.781532189386292 | LINESTRING(11.2496896 43.7759096,11.2497195 43.7758058) | 0102000020E6100000020000007A4DB450D77F264083537A0151E34540D158FB3BDB7F26400886BD9A4DE34540 | 163.93074515519763
60 | 13130 | 3.0182686799934575 | Piazza della Stazione | 41.92039833324247 | LINESTRING(11.2495531 43.7762737,11.2496896 43.7759096) | 0102000020E610000002000000183B866CC57F2640591FC5EF5CE345407A4DB450D77F264083537A0151E34540 | 159.44912852559335
61 | 5183 | 4.436560995172385 | Piazza della Stazione | 61.61890271072756 | LINESTRING(11.2493525 43.7768089,11.2495531 43.7762737) | 0102000020E610000002000000085A8121AB7F2640F15E5A796EE34540183B866CC57F2640591FC5EF5CE34540 | 159.4533409916088
62 | 13097 | 5.098808365293045 | Piazza della Stazione | 70.81678285129229 | LINESTRING(11.2491215 43.7774239,11.2491444 43.7773628,11.2493525 43.7768089) | 0102000020E610000003000000FF756EDA8C7F26407CD058A082E345408DF6D3DA8F7F26404190CD9F80E34540085A8121AB7F2640F15E5A796EE34540 | 159.41333170503012
63 | 13210 | 1.0914849620779505 | Piazza della Stazione | 15.159513362193758 | LINESTRING(11.2490627 43.7775528,11.2490779 43.7775337,11.2490883 43.7775152,11.2491215 43.7774239) | 0102000020E610000004000000924E6E25857F2640E574A3D986E345400E507523877F2640D9846A3986E34540EAA16C80887F26404B123A9E85E34540FF756EDA8C7F26407CD058A082E34540 | 155.47906629943728
64 | 13204 | 0.5726528052410474 | Piazza della Stazione | 7.953511183903437 | LINESTRING(11.2490138 43.777615,11.2490627 43.7775528) | 0102000020E61000000200000060819EBC7E7F264084F068E388E34540924E6E25857F2640E574A3D986E34540 | 141.82650428939607
65 | 2877 | 0.6004407122099854 | Piazza della Stazione | 8.339454336249798 | LINESTRING(11.2489685 43.7776825,11.2490138 43.777615) | 0102000020E610000002000000E6779ACC787F2640F415A4198BE3454060819EBC7E7F264084F068E388E34540 | 146.13399921067472
66 | 19982 | 0.23130961655102145 | Piazza della Stazione | 3.212633563208631 | LINESTRING(11.2489685 43.7776825,11.2490066 43.7776911) | 0102000020E610000002000000E6779ACC787F2640F415A4198BE34540EFF906CB7D7F2640F471C8618BE34540 | 77.28026010114702
67 | 26751 | 0.08031320045680243 | Piazza della Stazione | 1.1154611174555893 | LINESTRING(11.2490066 43.7776911,11.2490204 43.777692) | 0102000020E610000002000000EFF906CB7D7F2640F471C8618BE34540DC12149A7F7F2640302E55698BE34540 | 86.2686029866306
68 | 13203 | 0.20005398086256934 | Piazza Adua | 2.77852751198013 | LINESTRING(11.2490204 43.777692,11.2490531 43.7777) | 0102000020E610000002000000DC12149A7F7F2640302E55698BE3454051EF4EE3837F2640B30C71AC8BE34540 | 76.25270974093915
69 | 12857 | 1.2075070194870985 | Piazza Adua | 16.770930826209703 | LINESTRING(11.2490531 43.7777,11.2492507 43.7777478) | 0102000020E61000000200000051EF4EE3837F2640B30C71AC8BE345409D02AAC99D7F26409AC46A3D8DE34540 | 76.40122475415983
70 | 13058 | 0.5623299252048394 | Piazza Adua | 7.810137850067213 | LINESTRING(11.2492507 43.7777478,11.2493405 43.7777744) | 0102000020E6100000020000009D02AAC99D7F26409AC46A3D8DE34540F722DA8EA97F264040D58D1C8EE34540 | 73.4999834879164
71 | 12658 | 1.9451671248318654 | | 27.016210067109242 | LINESTRING(11.2493405 43.7777744,11.2493475 43.7780175) | 0102000020E610000002000000F722DA8EA97F264040D58D1C8EE34540C1ADBB79AA7F26409B1BD31396E34540 | 1.649361021362276
72 | -1 | 0 | | | | |
(72 rows)
For taxi_net
The
WARNINGmessage:
SELECT *
FROM wrk_dijkstra(
'taxi_net',
(SELECT wrk_NearestOSM(
'taxi_net_vertices_pgr',
43.784, 11.2384)),
(SELECT wrk_NearestOSM('taxi_net_vertices_pgr', 43.778, 11.2492))
)
The query results:
seq | id | seconds | name | length_m | route_readable | route_geom | azimuth
-----+-------+---------------------+----------------------------+--------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------
1 | 11322 | 5.784403870940626 | Via Maragliano | 89.26549183550348 | LINESTRING(11.2394203 43.7844184,11.2396904 43.7842663,11.2399554 43.7841367,11.2399804 43.7841251,11.2400242 43.7841019,11.2403219 43.7839512) | 0102000020E6100000060000003DFF2C4C957A2640B93077D267E4454090543AB3B87A26406EED8ED662E4454048FF266FDB7A2640F30B65975EE44540AC5C03B6DE7A2640823C16365EE44540447FB273E47A2640A19D78735DE445407106DA780B7B264079D44E8358E44540 | 117.3927338946043
2 | 11299 | 0.4937612539188402 | Via Maragliano | 7.619772437019138 | LINESTRING(11.2403219 43.7839512,11.2403681 43.7839249,11.2403963 43.7839088) | 0102000020E6100000030000007106DA780B7B264079D44E8358E44540D9001187117B26409202B0A657E44540A8284D39157B2640F785A11F57E44540 | 119.67848992376945
3 | 7022 | 0.6684916998224658 | Piazza di San Iacopino | 10.31622993553188 | LINESTRING(11.2403742 43.7838205,11.2403696 43.7838359,11.2403691 43.7838549,11.240372 43.7838693,11.2403756 43.7838791,11.2403817 43.7838906,11.2403903 43.7839023,11.2403963 43.7839088) | 0102000020E610000008000000B59ABF53127B264099B7EA3A54E44540BBE765B9117B264022F719BC54E445401BF09EA8117B264099277C5B55E445408CBFED09127B264051EB47D455E445404483B982127B26404B427D2656E44540201D684F137B26402752F58656E445401F8DF96F147B26402DE11AE956E44540A8284D39157B2640F785A11F57E44540 | 14.051510128951143
4 | 7019 | 1.6845022025362013 | Piazza di San Iacopino | 25.995404360126564 | LINESTRING(11.2406285 43.7837823,11.2405982 43.7837604,11.2405617 43.7837472,11.2405455 43.783744,11.2405166 43.7837416,11.2404867 43.7837436,11.2404558 43.7837507,11.2404241 43.7837645,11.2404031 43.7837774,11.2403863 43.7837967,11.2403742 43.7838205) | 0102000020E61000000B00000098F8A3A8337B264082D778FA52E44540F4F3F0AF2F7B26402FF3C24252E44540205734E72A7B2640712A08D451E4454062669FC7287B2640D63730B951E445404C4AE6FD247B2640E2410EA551E44540F53E9F12217B26408339D5B551E445405C44CA051D7B2640CA5B64F151E4454029571DDE187B264005A2276552E44540CBB6781D167B2640052C5ED152E445401AD0C1E9137B26403B9B447353E44540B59ABF53127B264099B7EA3A54E44540 | 278.5428844722186
5 | 7020 | 0.5415508069969085 | Piazza di San Iacopino | 8.357265540075748 | LINESTRING(11.2406285 43.7837823,11.2406467 43.7837586,11.2406788 43.7837165) | 0102000020E61000000300000098F8A3A8337B264082D778FA52E44540D8C7540B367B2640B87AA93352E4454059AE6D403A7B2640F46A80D250E44540 | 142.6043408213474
6 | 11298 | 1.2726948292594435 | Piazza di San Iacopino | 19.640352303386475 | LINESTRING(11.2406788 43.7837165,11.2407971 43.7835619) | 0102000020E61000000200000059AE6D403A7B2640F46A80D250E445407BF1EAC1497B264021729FC14BE44540 | 142.57676465341856
7 | 2176 | 1.1142227853095519 | Piazza di San Iacopino | 17.194796069591852 | LINESTRING(11.2406825 43.7834313,11.2407971 43.7835619) | 0102000020E610000002000000657094BC3A7B2640D514127A47E445407BF1EAC1497B264021729FC14BE44540 | 41.26657970063224
8 | 13473 | 0.2018216899547349 | Via Bartolommeo Cristofori | 3.1145322523878844 | LINESTRING(11.2406637 43.7834068,11.2406825 43.7834313) | 0102000020E61000000200000031ABC145387B264065BB8CAC46E44540657094BC3A7B2640D514127A47E44540 | 37.500719473675915
9 | 2132 | 5.060657873979921 | Via Bartolommeo Cristofori | 78.09657212931978 | LINESTRING(11.2402269 43.782785,11.240229 43.7828209,11.2402401 43.78286,11.2406637 43.7834068) | 0102000020E6100000040000002A3D2E05FF7A26405166834C32E44540001AA54BFF7A26400910AA7933E44540236019C0007B26405CACA8C134E4454031ABC145387B264065BB8CAC46E44540 | 35.08714657232104
10 | 2198 | 1.4906648918820278 | Via Benedetto Marcello | 23.004087837685613 | LINESTRING(11.2403372 43.7825978,11.2402808 43.7826527,11.2402471 43.7827116,11.2402269 43.782785) | 0102000020E61000000400000041063C7A0D7B2640F5752A2A2CE44540A4B6C315067B26402450B3F62DE44540EDEAFAAA017B26409419CAE42FE445402A3D2E05FF7A26405166834C32E44540 | 329.4930081007772
11 | 16948 | 0.8215669146050691 | Via Benedetto Marcello | 12.678501768596746 | LINESTRING(11.2404731 43.7825421,11.2403885 43.7825683,11.2403372 43.7825978) | 0102000020E610000003000000AF22484A1F7B2640209FEB562AE4454043AB9333147B264073B1B3322BE4454041063C7A0D7B2640F5752A2A2CE44540 | 292.286771149483
12 | 2088 | 0.6763200598152991 | Via Benedetto Marcello | 10.43703796011264 | LINESTRING(11.2406004 43.7825267,11.240518 43.7825323,11.2404731 43.7825421) | 0102000020E6100000030000001DCFC2F92F7B2640975FBCD529E44540DB32E02C257B26402648B6042AE44540AF22484A1F7B2640209FEB562AE44540 | 276.89778529525006
13 | 13998 | 18.79038739642043 | Via Benedetto Marcello | 173.98506848537437 | LINESTRING(11.2427272 43.7823941,11.2426883 43.7824064,11.2425528 43.7824407,11.2423616 43.7824849,11.2422043 43.7825125,11.2420152 43.7825405,11.2417881 43.7825621,11.2416072 43.7825719,11.2414327 43.7825727,11.2411956 43.7825646,11.2406004 43.7825267) | 0102000020E61000000B00000005B353BD467C2640AB0A687D25E44540613E0FA4417C26402E1796E425E44540411B6FE12F7C264099C7500427E44540CB9CD3D1167C2640928E177728E44540B1E6B633027C2640091B9E5E29E445401245926AE97B2640D3A57F492AE44540BC1F5CA6CB7B2640674BB1FE2AE44540CEF45CF0B37B264061A2E6502BE44540B65E1D119D7B2640089F9C572BE44540D1E05BFD7D7B2640F000AA132BE445401DCFC2F92F7B2640975FBCD529E44540 | 273.56761289254706
14 | 12767 | 3.069583931533398 | Via Benedetto Marcello | 28.42207344012406 | LINESTRING(11.2429819 43.7822307,11.242932 43.7822967,11.242898 43.7823263,11.2428703 43.7823432,11.242835 43.7823599,11.2427272 43.7823941) | 0102000020E610000006000000360AA41F687C2640AE36B52220E44540C24D4695617C264066225B4C22E4454012876C205D7C26407DA6A84423E44540E456F77E597C2640BE1F6DD223E44540F8A57EDE547C2640D619845E24E4454005B353BD467C2640AB0A687D25E44540 | 302.6817575072028
15 | 28749 | 2.9686331469632457 | Viale Belfiore | 45.81223992227231 | LINESTRING(11.242772 43.7818549,11.2428631 43.7819664,11.2429286 43.782052,11.2429477 43.7820821,11.24296 43.7821079,11.2429683 43.7821308,11.2429761 43.7821556,11.242982 43.7821936,11.2429819 43.7822307) | 0102000020E610000009000000DFC4909C4C7C2640D2DB44D213E4454073CF5F8D587C26401249997917E44540B1863023617C2640BDE2A9471AE44540DF4614A4637C2640BC2429441BE44540EA78CC40657C2640BC38961C1CE44540EFED4C57667C2640DF98AFDC1CE44540546B065D677C26400F31B9AC1DE445408908FF22687C2640FC917DEB1EE44540360AA41F687C2640AE36B52220E44540 | 29.185182967440053
16 | 43310 | 0.2807360602729991 | Viale Belfiore | 4.33234660915122 | LINESTRING(11.2427459 43.7818208,11.242772 43.7818549) | 0102000020E610000002000000E679CB30497C264091AA37B412E44540DFC4909C4C7C2640D2DB44D213E44540 | 37.43029494602663
17 | 24442 | 5.632991060399256 | Viale Belfiore | 86.9288743888774 | LINESTRING(11.2422376 43.7811306,11.2425172 43.7815218,11.2427459 43.7818208) | 0102000020E6100000030000001AB91391067C2640D2736616FCE345405B6FE5362B7C2640370E06E808E44540E679CB30497C264091AA37B412E44540 | 36.3699075019309
18 | 12705 | 0.6517322656717872 | Viale Belfiore | 10.057596692465852 | LINESTRING(11.2421771 43.7810514,11.2422376 43.7811306) | 0102000020E61000000200000024AE08A3FE7B26405DBF057EF9E345401AB91391067C2640D2736616FCE34540 | 37.375807497396664
19 | 10248 | 4.545751912926044 | Viale Belfiore | 70.1504924834266 | LINESTRING(11.2417945 43.7804843,11.2420965 43.7809442,11.2421771 43.7810514) | 0102000020E61000000300000091B41B7DCC7B26404EC5D7E8E6E34540BFF38B12F47B26401D80C3FAF5E3454024AE08A3FE7B26405DBF057EF9E34540 | 34.00598672487236
20 | 9960 | 6.5660890231644355 | Viale Belfiore | 101.32853430809314 | LINESTRING(11.2412705 43.7796551,11.2417945 43.7804843) | 0102000020E610000002000000A9FA95CE877B26406E5402BDCBE3454091B41B7DCC7B26404EC5D7E8E6E34540 | 32.29020037633244
21 | 14068 | 4.903828512020357 | Viale Belfiore | 75.67636592624007 | LINESTRING(11.2410198 43.778999,11.2410351 43.7790461,11.2410573 43.7790983,11.2411057 43.7791992,11.2412705 43.7796551) | 0102000020E6100000050000007E607DF2667B2640F04E3E3DB6E345404D60DFF3687B2640C6C958C8B7E3454093ECC7DC6B7B2640426F3B7EB9E3454025C2D034727B2640E188A4CCBCE34540A9FA95CE877B26406E5402BDCBE34540 | 20.912175975579675
22 | 6629 | 4.34144985158024 | Piazzale di Porta al Prato | 66.99768289475679 | LINESTRING(11.2415179 43.7786225,11.2414569 43.7786106,11.241417 43.7786099,11.241374 43.778617,11.2413188 43.7786336,11.2412715 43.7786511,11.2412071 43.7786865,11.2411455 43.7787298,11.2410839 43.7787867,11.2410537 43.77883,11.2410263 43.7788866,11.2410185 43.77892,11.2410161 43.7789563,11.2410198 43.778999) | 0102000020E61000000E00000015CCF33BA87B264002B7EEE6A9E345407EC9213DA07B2640D3A81B83A9E3454099654F029B7B2640C16B3C7DA9E345409C35785F957B2640088ECBB8A9E34540E7D143238E7B26408BC80B44AAE34540EAE923F0877B264049BFD8D6AAE3454042203C7F7F7B264019ABCDFFABE34540B727486C777B2640D7B5076BADE345402C2F54596F7B2640A6875748AFE34540DB28FC636B7B2640649291B3B0E34540A7F397CC677B264075255D8EB2E345404276DEC6667B2640A4198BA6B3E34540729E5676667B2640AFC10CD7B4E345407E607DF2667B2640F04E3E3DB6E34540 | 307.08462504974585
23 | 18299 | 5.23076911024865 | Viale Fratelli Rosselli | 80.72174552852854 | LINESTRING(11.2424382 43.7789108,11.2423517 43.7788865,11.2415179 43.7786225) | 0102000020E6100000030000002B9A18DC207C264027405E59B3E345409042A385157C2640E065868DB2E3454015CCF33BA87B264002B7EEE6A9E34540 | 252.60592648403812
24 | 6625 | 1.1174625437452774 | Viale Fratelli Rosselli | 17.24479234174811 | LINESTRING(11.2426358 43.7788648,11.2426191 43.7788746,11.2425964 43.7788871,11.242572 43.778897,11.2425437 43.7789046,11.2425029 43.7789094,11.2424382 43.7789108) | 0102000020E61000000700000077AD73C23A7C2640B7007ED7B1E3454019C51792387C2640B157B329B2E3454032416898357C26405DE38E92B2E34540C2D9AD65327C2640ECF99AE5B2E34540A1B316B02E7C26401BDA5B25B3E34540CD5E1157297C264004C69F4DB3E345402B9A18DC207C264027405E59B3E34540 | 283.1046868691804
25 | 29446 | 1.8779322766851585 | Via Jacopo da Diacceto | 28.980436368598127 | LINESTRING(11.242914 43.7787,11.2428302 43.7787406,11.2426358 43.7788648) | 0102000020E610000003000000297B4B395F7C264096B20C71ACE3454058F66E3D547C2640A188A0C5ADE3454077AD73C23A7C2640B7007ED7B1E34540 | 300.6416345081347
26 | 20625 | 15.816037616740076 | Via Jacopo da Diacceto | 244.07465457932216 | LINESTRING(11.2454268 43.7774709,11.2441684 43.7780921,11.242914 43.7787) | 0102000020E610000003000000B61FDF94A87D2640BC8B9C2A84E34540EC6EF9A3037D264053639D8598E34540297B4B395F7C264096B20C71ACE34540 | 296.0649040714764
27 | 14012 | 0.955194315035928 | Via Luigi Alamanni | 14.740653009813704 | LINESTRING(11.2455796 43.7773978,11.2454268 43.7774709) | 0102000020E6100000020000002821FD9BBC7D2640BE7D67C581E34540B61FDF94A87D2640BC8B9C2A84E34540 | 295.5665989296672
28 | 6037 | 1.2824562821795171 | Via Luigi Alamanni | 19.790992008943167 | LINESTRING(11.2457316 43.7772724,11.2457277 43.7772997,11.2457138 43.7773292,11.2456869 43.7773486,11.2455796 43.7773978) | 0102000020E61000000500000000304388D07D2640AE0A79A97DE345404E716605D07D264066587B8E7EE345400E5AFE32CE7D2640E81CF2857FE345407B1C61ACCA7D2640B34BAF2880E345402821FD9BBC7D2640BE7D67C581E34540 | 309.52263127156954
29 | 9999 | 0.24817950103501585 | Via Luigi Alamanni | 3.8299305715280223 | LINESTRING(11.2457175 43.7772396,11.2457232 43.7772576,11.2457316 43.7772724) | 0102000020E610000003000000191C25AFCE7D2640FC9353967CE34540A8BC676ECF7D2640A248522D7DE3454000304388D07D2640AE0A79A97DE34540 | 23.26180760366172
30 | 2878 | 4.846588097258784 | Via Luigi Alamanni | 74.79302619226519 | LINESTRING(11.2461217 43.7766359,11.2460028 43.7767864,11.2457294 43.7771941,11.2457178 43.7772304,11.2457175 43.7772396) | 0102000020E610000005000000FEABD8A9037E264024B31FCE68E34540E8723914F47D264021FD9BBC6DE34540D754713ED07D26407412A5187BE34540131736B9CE7D26407FBA26497CE34540191C25AFCE7D2640FC9353967CE34540 | 326.19619410324947
31 | 8425 | 3.542347121955435 | Via Luigi Alamanni | 54.66585064746042 | LINESTRING(11.2465792 43.7762724,11.246347 43.7764517,11.2461217 43.7766359) | 0102000020E61000000300000068BFFFA03F7E2640CB64DDE45CE3454078EFA831217E26403936F1C462E34540FEABD8A9037E264024B31FCE68E34540 | 308.46838914958346
32 | 14231 | 0.12504166743516618 | Via Luigi Alamanni | 1.9296553616537993 | LINESTRING(11.2465954 43.7762596,11.2465792 43.7762724) | 0102000020E61000000200000026B094C0417E2640609A7D795CE3454068BFFFA03F7E2640CB64DDE45CE34540 | 308.31309067286264
33 | 13205 | 3.7302344664754954 | Via Luigi Alamanni | 57.56534670486876 | LINESTRING(11.2470792 43.7758781,11.2468273 43.7760767,11.2467312 43.7761525,11.2465954 43.7762596) | 0102000020E6100000040000002F0B372A817E264060973CF94FE345401C85DA25607E264003D8367B56E3454040CE458D537E2640B51A12F758E3454026B094C0417E2640609A7D795CE34540 | 308.25750989922614
34 | 18445 | 0.24289591947767922 | Piazza della Stazione | 3.7483938190999884 | LINESTRING(11.24711 43.7758528,11.2470792 43.7758781) | 0102000020E6100000020000007407B133857E2640494101254FE345402F0B372A817E264060973CF94FE34540 | 309.40066066101303
35 | 18322 | 0.2492903617694875 | Piazza della Stazione | 3.847073484097029 | LINESTRING(11.2471414 43.7758267,11.24711 43.7758528) | 0102000020E610000002000000AEF94C51897E26408BEE0F4A4EE345407407B133857E2640494101254FE34540 | 309.7337043620762
36 | 17711 | 4.63994505701933 | Piazza della Stazione | 71.60409038610076 | LINESTRING(11.2476822 43.7753311,11.2476174 43.7753552,11.2475694 43.7753812,11.24748 43.7754517,11.2474375 43.7754934,11.2473975 43.7755427,11.2473452 43.7756283,11.247302 43.7756938,11.2472708 43.7757288,11.2472299 43.7757623,11.2471414 43.7758267) | 0102000020E61000000B000000489A8933D07E26402E09AB0C3EE3454052D735B5C77E26404B64D5D63EE345400EFB986AC17E264074F7EFB03FE3454002D4D4B2B57E26405590550042E34540A69BC420B07E2640C6A1235E43E345406D3997E2AA7E26406693B2FB44E3454029A5B107A47E2640112DC3C947E345408578245E9E7E2640E05A37EF49E34540F3823E479A7E26405D48D1144BE34540CC2FDEEA947E264020FCD52D4CE34540AEF94C51897E26408BEE0F4A4EE34540 | 312.5027700232734
37 | 26701 | 6.720495649051744 | Piazza della Stazione | 103.7113526088232 | LINESTRING(11.2489693 43.7752924,11.2480605 43.7753197,11.2477291 43.7753297,11.2476822 43.7753311) | 0102000020E610000004000000816A72E7787F26402E6B07C83CE34540DBDB2DC9017F2640E6B809AD3DE34540F8883D59D67E26400A8FEC003EE34540489A8933D07E26402E09AB0C3EE34540 | 271.72222735194464
38 | 19974 | 0.8468851471683307 | Piazza della Stazione | 13.069215234079177 | LINESTRING(11.2491316 43.77529,11.2489693 43.7752924) | 0102000020E610000002000000E1CC542D8E7F26403A75E5B33CE34540816A72E7787F26402E6B07C83CE34540 | 270.84719561994746
39 | 13079 | 1.9289230314471795 | Piazza della Stazione | 29.767330732209558 | LINESTRING(11.2495011 43.7752803,11.2491316 43.77529) | 0102000020E610000002000000CEA1B19BBE7F2640D5DD86623CE34540E1CC542D8E7F26403A75E5B33CE34540 | 271.5037657492953
40 | 28649 | 0.4142902197769721 | Piazza della Stazione | 6.393367589150804 | LINESTRING(11.2495802 43.7752752,11.2495011 43.7752803) | 0102000020E6100000020000005275D9F9C87F26402FB3BE373CE34540CEA1B19BBE7F2640D5DD86623CE34540 | 273.68905906213246
41 | 27689 | 2.1769850601145753 | Piazza della Stazione | 33.595448458558266 | LINESTRING(11.2498164 43.7750416,11.2497227 43.7751843,11.2496851 43.7752316,11.2496462 43.7752582,11.2496077 43.7752707,11.2495802 43.7752752) | 0102000020E610000006000000480268EFE77F26400F852A9034E345403C235BA7DB7F2640B36F383D39E34540D498B5B9D67F2640B26900CA3AE34540302471A0D17F2640597A23A93BE34540D9A89894CC7F26400506FF113CE345405275D9F9C87F26402FB3BE373CE34540 | 314.6829129293553
42 | 28640 | 0.3507667157850087 | Piazza dell'Unità Italiana | 5.413066601620504 | LINESTRING(11.2498808 43.7750556,11.2498164 43.7750416) | 0102000020E610000002000000F0CB4F60F07F2640744A9B0535E34540480268EFE77F26400F852A9034E34540 | 257.73522627184514
43 | 27686 | 0.20484949058571325 | Piazza dell'Unità Italiana | 3.16125757076718 | LINESTRING(11.2499184 43.7750638,11.2498808 43.7750556) | 0102000020E6100000020000005956F54DF57F264020A8644A35E34540F0CB4F60F07F2640744A9B0535E34540 | 257.6972736802688
44 | 27703 | 0.23993486285003354 | Piazza dell'Unità Italiana | 3.7026985007721223 | LINESTRING(11.2499624 43.7750735,11.2499184 43.7750638) | 0102000020E61000000200000097755A12FB7F2640853FC39B35E345405956F54DF57F264020A8644A35E34540 | 257.56774262247706
45 | 28645 | 0.20085655932921234 | Piazza dell'Unità Italiana | 3.099638261253277 | LINESTRING(11.2499992 43.7750817,11.2499624 43.7750735) | 0102000020E610000002000000650D28E5FF7F2640329D8CE035E3454097755A12FB7F2640853FC39B35E34540 | 257.4382257879712
46 | 20445 | 0.19032478605369407 | Piazza dell'Unità Italiana | 2.9371108958903407 | LINESTRING(11.2500341 43.7750894,11.2499992 43.7750817) | 0102000020E61000000200000004C5347804802640F63C242136E34540650D28E5FF7F2640329D8CE035E34540 | 257.55813574796525
47 | 795 | 5.413087175614006 | Piazza della Stazione | 83.53529591996923 | LINESTRING(11.2497195 43.7758058,11.249736 43.7757636,11.2499455 43.7752983,11.2500341 43.7750894) | 0102000020E610000004000000D158FB3BDB7F26400886BD9A4DE345408944A165DD7F2640AFB6BD384CE34540939048DBF87F26407C9285F93CE3454004C5347804802640F63C242136E34540 | 156.2917937653566
48 | 17702 | 0.7634432858722316 | Piazza della Stazione | 11.781532189386292 | LINESTRING(11.2496896 43.7759096,11.2497195 43.7758058) | 0102000020E6100000020000007A4DB450D77F264083537A0151E34540D158FB3BDB7F26400886BD9A4DE34540 | 163.93074515519763
49 | 13130 | 2.7164418119941116 | Piazza della Stazione | 41.92039833324247 | LINESTRING(11.2495531 43.7762737,11.2496896 43.7759096) | 0102000020E610000002000000183B866CC57F2640591FC5EF5CE345407A4DB450D77F264083537A0151E34540 | 159.44912852559335
50 | 5183 | 3.9929048956551463 | Piazza della Stazione | 61.61890271072756 | LINESTRING(11.2493525 43.7768089,11.2495531 43.7762737) | 0102000020E610000002000000085A8121AB7F2640F15E5A796EE34540183B866CC57F2640591FC5EF5CE34540 | 159.4533409916088
51 | 13097 | 4.58892752876374 | Piazza della Stazione | 70.81678285129229 | LINESTRING(11.2491215 43.7774239,11.2491444 43.7773628,11.2493525 43.7768089) | 0102000020E610000003000000FF756EDA8C7F26407CD058A082E345408DF6D3DA8F7F26404190CD9F80E34540085A8121AB7F2640F15E5A796EE34540 | 159.41333170503012
52 | 13210 | 0.9823364658701556 | Piazza della Stazione | 15.159513362193758 | LINESTRING(11.2490627 43.7775528,11.2490779 43.7775337,11.2490883 43.7775152,11.2491215 43.7774239) | 0102000020E610000004000000924E6E25857F2640E574A3D986E345400E507523877F2640D9846A3986E34540EAA16C80887F26404B123A9E85E34540FF756EDA8C7F26407CD058A082E34540 | 155.47906629943728
53 | 13204 | 0.5153875247169427 | Piazza della Stazione | 7.953511183903437 | LINESTRING(11.2490138 43.777615,11.2490627 43.7775528) | 0102000020E61000000200000060819EBC7E7F264084F068E388E34540924E6E25857F2640E574A3D986E34540 | 141.82650428939607
54 | 2877 | 0.5403966409889869 | Piazza della Stazione | 8.339454336249798 | LINESTRING(11.2489685 43.7776825,11.2490138 43.777615) | 0102000020E610000002000000E6779ACC787F2640F415A4198BE3454060819EBC7E7F264084F068E388E34540 | 146.13399921067472
55 | 19982 | 0.2081786548959193 | Piazza della Stazione | 3.212633563208631 | LINESTRING(11.2489685 43.7776825,11.2490066 43.7776911) | 0102000020E610000002000000E6779ACC787F2640F415A4198BE34540EFF906CB7D7F2640F471C8618BE34540 | 77.28026010114702
56 | 26751 | 0.07228188041112218 | Piazza della Stazione | 1.1154611174555893 | LINESTRING(11.2490066 43.7776911,11.2490204 43.777692) | 0102000020E610000002000000EFF906CB7D7F2640F471C8618BE34540DC12149A7F7F2640302E55698BE34540 | 86.2686029866306
57 | 13203 | 0.18004858277631242 | Piazza Adua | 2.77852751198013 | LINESTRING(11.2490204 43.777692,11.2490531 43.7777) | 0102000020E610000002000000DC12149A7F7F2640302E55698BE3454051EF4EE3837F2640B30C71AC8BE34540 | 76.25270974093915
58 | 12857 | 1.0867563175383887 | Piazza Adua | 16.770930826209703 | LINESTRING(11.2490531 43.7777,11.2492507 43.7777478) | 0102000020E61000000200000051EF4EE3837F2640B30C71AC8BE345409D02AAC99D7F26409AC46A3D8DE34540 | 76.40122475415983
59 | 13058 | 0.5060969326843554 | Piazza Adua | 7.810137850067213 | LINESTRING(11.2492507 43.7777478,11.2493405 43.7777744) | 0102000020E6100000020000009D02AAC99D7F26409AC46A3D8DE34540F722DA8EA97F264040D58D1C8EE34540 | 73.4999834879164
60 | 12658 | 1.7506504123486788 | | 27.016210067109242 | LINESTRING(11.2493405 43.7777744,11.2493475 43.7780175) | 0102000020E610000002000000F722DA8EA97F264040D58D1C8EE34540C1ADBB79AA7F26409B1BD31396E34540 | 1.649361021362276
61 | -1 | 0 | | | | |
(61 rows)
For walk_net
SELECT 64
seq | id | seconds | name | length_m | route_readable | route_geom | azimuth
-----+-------+--------------------+------------------------+--------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------
1 | 43211 | 1.3116923164799217 | | 2.6233846329598434 | LINESTRING(11.2383768 43.7838709,11.2383758 43.7838945) | 0102000020E610000002000000114020860C7A26409EE4B3E155E44540D05092640C7A2640D481ACA756E44540 | 357.57366417080544
2 | 37230 | 4.779692008596035 | | 9.55938401719207 | LINESTRING(11.238495 43.7838792,11.2384484 43.7838761,11.2383768 43.7838709) | 0102000020E610000003000000E08442041C7A2640E001542756E445402A919FE8157A2640DACE520D56E44540114020860C7A26409EE4B3E155E44540 | 265.98328557113854
3 | 37229 | 1.9170359492729079 | | 3.8340718985458158 | LINESTRING(11.238495 43.7838792,11.238496 43.7838447) | 0102000020E610000002000000E08442041C7A2640E001542756E445402174D0251C7A26404CD2EB0555E44540 | 178.3397176321706
4 | 22514 | 2.2390039112786053 | | 4.478007822557211 | LINESTRING(11.238496 43.7838447,11.2384967 43.7838044) | 0102000020E6100000020000002174D0251C7A26404CD2EB0555E4454069684D3D1C7A2640FF3ADCB353E44540 | 179.00488801693066
5 | 36988 | 6.296128676126751 | | 12.592257352253503 | LINESTRING(11.2384967 43.7838044,11.2384672 43.7836931) | 0102000020E61000000200000069684D3D1C7A2640FF3ADCB353E445405F56725F187A2640E94C350E50E44540 | 194.84487257002095
6 | 36941 | 1.9008486156924607 | | 3.8016972313849213 | LINESTRING(11.2384672 43.7836931,11.2384417 43.7836643) | 0102000020E6100000020000005F56725F187A2640E94C350E50E445405A01CF07157A264078C59D1C4FE44540 | 221.52221347912885
7 | 11303 | 50.7777357596536 | Via Gioacchino Rossini | 101.5554715193072 | LINESTRING(11.2384417 43.7836643,11.23948 43.7831451) | 0102000020E6100000020000005A01CF07157A264078C59D1C4FE445409817601F9D7A2640E64240193EE44540 | 116.56725842640839
8 | 11292 | 3.369602811765626 | Via Gioacchino Rossini | 6.739205623531252 | LINESTRING(11.2395497 43.7831115,11.23948 43.7831451) | 0102000020E61000000200000081881E42A67A26408DCF64FF3CE445409817601F9D7A2640E64240193EE44540 | 295.73713511354975
9 | 11294 | 28.95473683997625 | Via Gioacchino Rossini | 57.9094736799525 | LINESTRING(11.2401502 43.7828245,11.2395497 43.7831115) | 0102000020E61000000200000077418EF7F47A2640F700DD9733E4454081881E42A67A26408DCF64FF3CE44540 | 295.5447704874303
10 | 2131 | 3.78755100706449 | Via Gioacchino Rossini | 7.57510201412898 | LINESTRING(11.2402269 43.782785,11.240176 43.7828112,11.2401502 43.7828245) | 0102000020E6100000030000002A3D2E05FF7A26405166834C32E4454075914259F87A2640A4784B2833E4454077418EF7F47A2640F700DD9733E44540 | 297.24817221699476
11 | 17879 | 18.366970069720285 | Via Benedetto Marcello | 36.73394013944057 | LINESTRING(11.2402269 43.782785,11.2402664 43.7827663,11.2406085 43.7826037) | 0102000020E6100000030000002A3D2E05FF7A26405166834C32E44540C2A79432047B26409974A5AF31E445407C478D09317B2640439DA85B2CE44540 | 115.4126181411689
12 | 16679 | 78.70340680918738 | Via Benedetto Marcello | 157.40681361837477 | LINESTRING(11.2406085 43.7826037,11.2412562 43.7826352,11.2415087 43.7826425,11.2416316 43.7826403,11.2417375 43.7826349,11.2418279 43.7826299,11.2419329 43.7826202,11.2420726 43.782603,11.2422763 43.7825717,11.2425457 43.782522) | 0102000020E61000000A0000007C478D09317B2640439DA85B2CE445401BEAC1EE857B26406659E6632DE4454022664007A77B2640D7FA22A12DE445403D5C1723B77B26400C84AE8E2DE44540006F8104C57B2640A71A62612DE445404E85D3DDD07B264096AF70372DE4454023A70AA1DE7B2640301812E62CE44540F08398F0F07B26403160C9552CE445401831A2A30B7C26403723394F2BE44540249232F32E7C264044334FAE29E44540 | 92.41497666164345
13 | 20591 | 8.523925939632322 | Via Benedetto Marcello | 17.047851879264645 | LINESTRING(11.2425457 43.782522,11.2426105 43.782525,11.2426722 43.7825356,11.242746 43.7825638) | 0102000020E610000004000000249232F32E7C264044334FAE29E4454019558671377C2640B5A679C729E44540F74BD5873F7C264056FA64202AE445403A782634497C26404904F40C2BE44540 | 78.21229341734312
14 | 25246 | 2.696565928476483 | | 5.393131856952966 | LINESTRING(11.2427915 43.7825286,11.2427701 43.7825467,11.2427607 43.7825559,11.242746 43.7825638) | 0102000020E6100000040000005A7EE02A4F7C2640A397ACE529E44540AFE4CF5C4C7C2640DE0B827D2AE44540158266214B7C26405BE5AECA2AE445403A782634497C26404904F40C2BE44540 | 307.72648142974776
15 | 29306 | 4.940553267663226 | | 9.881106535326452 | LINESTRING(11.2429139 43.7825353,11.2427915 43.7825286) | 0102000020E610000002000000D57CF0355F7C264097BBE01D2AE445405A7EE02A4F7C2640A397ACE529E44540 | 266.86683822720937
16 | 26680 | 4.939319433575375 | | 9.87863886715075 | LINESTRING(11.2430343 43.7825525,11.2429139 43.7825353) | 0102000020E610000002000000CD9CE4FD6E7C2640977329AE2AE44540D57CF0355F7C264097BBE01D2AE44540 | 261.8698976448972
17 | 25273 | 3.8998059645162853 | | 7.7996119290325705 | LINESTRING(11.2431303 43.782562,11.2430343 43.7825525) | 0102000020E61000000200000056551E937B7C2640D28BDAFD2AE44540CD9CE4FD6E7C2640977329AE2AE44540 | 264.3485051201374
18 | 25274 | 1.0365383766089769 | Viale Francesco Redi | 2.0730767532179537 | LINESTRING(11.2431303 43.782562,11.243151 43.7825509) | 0102000020E61000000200000056551E937B7C2640D28BDAFD2AE44540B9FAB1497E7C2640497ABDA02AE44540 | 118.20162822428448
19 | 28898 | 4.739411644506103 | Viale Belfiore | 9.478823289012206 | LINESTRING(11.243151 43.7825509,11.2431872 43.7825344,11.2432261 43.7825193,11.2432187 43.7824976) | 0102000020E610000004000000B9FAB1497E7C2640497ABDA02AE44540939C5D08837C26405CFF53162AE445403711A221887C264091FEA89729E44540208D5429877C26406899A0E128E44540 | 128.21324877596683
20 | 28897 | 2.2895532236363922 | | 4.5791064472727845 | LINESTRING(11.2432187 43.7824976,11.243205 43.7824576) | 0102000020E610000002000000208D5429877C26406899A0E128E445408672A25D857C2640DA40159227E44540 | 198.9063320360431
21 | 20593 | 3.075749881952195 | | 6.15149976390439 | LINESTRING(11.243205 43.7824576,11.2431864 43.7824039) | 0102000020E6100000020000008672A25D857C2640DA40159227E44540F9A985ED827C2640A5619DCF25E44540 | 199.10448504908499
22 | 29314 | 1.9476323124750692 | | 3.8952646249501384 | LINESTRING(11.2431864 43.7824039,11.2431746 43.7823699) | 0102000020E610000002000000F9A985ED827C2640A5619DCF25E445408E6F9461817C2640F9EF66B224E44540 | 199.1397822606333
23 | 45176 | 4.874468898301136 | | 9.748937796602272 | LINESTRING(11.2431746 43.7823699,11.2431451 43.7822848) | 0102000020E6100000020000008E6F9461817C2640F9EF66B224E44540845DB9837D7C2640361488E821E44540 | 199.11892493444896
24 | 43315 | 0.9753984120190019 | | 1.9507968240380038 | LINESTRING(11.2431451 43.7822848,11.2431675 43.7822781) | 0102000020E610000002000000845DB9837D7C2640361488E821E4454071E65773807C264042F053B021E44540 | 106.65229973022379
25 | 43316 | 1.8583670030735653 | | 3.7167340061471306 | LINESTRING(11.2431675 43.7822781,11.2432101 43.7822652) | 0102000020E61000000200000071E65773807C264042F053B021E44540211DC308867C264042661D4421E44540 | 106.84719943819317
26 | 27086 | 1.1193704730393281 | | 2.2387409460786563 | LINESTRING(11.2432101 43.7822652,11.2432358 43.7822575) | 0102000020E610000002000000211DC308867C264042661D4421E44540CC6E1C67897C26407EC6850321E44540 | 106.67878875702806
27 | 43317 | 8.304478072326086 | | 16.608956144652172 | LINESTRING(11.2432358 43.7822575,11.243308 43.7822358,11.2434073 43.7821771) | 0102000020E610000003000000CC6E1C67897C26407EC6850321E44540D9B5BDDD927C264055617D4D20E445401F37B2E19F7C26400E1714611EE44540 | 115.11740266893703
28 | 24443 | 6.049459389608191 | | 12.098918779216381 | LINESTRING(11.2434073 43.7821771,11.2435238 43.7821083) | 0102000020E6100000020000001F37B2E19F7C26400E1714611EE445406598C926AF7C26400F37F11F1CE44540 | 120.56431213899724
29 | 43313 | 5.04411235598151 | | 10.08822471196302 | LINESTRING(11.2435238 43.7821083,11.243607 43.7821762) | 0102000020E6100000020000006598C926AF7C26400F37F11F1CE445404227840EBA7C2640D35A87591EE44540 | 50.781917203634954
30 | 37485 | 3.4712776850440012 | | 6.9425553700880025 | LINESTRING(11.243607 43.7821762,11.2436643 43.7822229) | 0102000020E6100000020000004227840EBA7C2640D35A87591EE44540CD672F91C17C264055D746E11FE44540 | 50.81966549751536
31 | 22646 | 2.2281377174116686 | | 4.456275434823337 | LINESTRING(11.2436643 43.7822229,11.2437068 43.7822486) | 0102000020E610000002000000CD672F91C17C264055D746E11FE4454029A03F23C77C2640C02BDDB820E44540 | 58.83839970942431
32 | 37488 | 26.834077810605287 | | 53.66815562121057 | LINESTRING(11.2437068 43.7822486,11.244219 43.7825578) | 0102000020E61000000200000029A03F23C77C2640C02BDDB820E44540A71FD4450A7D2640671D9FDA2AE44540 | 58.88186090094099
33 | 28756 | 3.3557368341429052 | | 6.7114736682858105 | LINESTRING(11.2442829 43.7825966,11.244219 43.7825578) | 0102000020E610000002000000AFF1F4A5127D2640FB7A19202CE44540A71FD4450A7D2640671D9FDA2AE44540 | 238.7339285575152
34 | 37545 | 2.167055295020997 | | 4.334110590041994 | LINESTRING(11.2443201 43.7826248,11.2442829 43.7825966) | 0102000020E610000002000000CA822E86177D2640EF84A80C2DE44540AFF1F4A5127D2640FB7A19202CE44540 | 232.83552510349003
35 | 44312 | 2.633620162470708 | | 5.267240324941416 | LINESTRING(11.2443565 43.7826638,11.2443352 43.7826363,11.2443201 43.7826248) | 0102000020E6100000030000004B21904B1C7D2640AD61D0532EE44540F385DA80197D2640CB94206D2DE44540CA822E86177D2640EF84A80C2DE44540 | 223.025065989025
36 | 37484 | 7.8936826784946685 | | 15.787365356989337 | LINESTRING(11.2444917 43.7827614,11.2444599 43.7827506,11.2444136 43.7827262,11.244386 43.782702,11.2443565 43.7826638) | 0102000020E61000000500000071491F042E7D26401CC98A8631E44540EB5D17D9297D264052F6F12B31E445402F6585C7237D2640765C435F30E4454055336B29207D2640C44142942FE445404B21904B1C7D2640AD61D0532EE44540 | 234.17472729250022
37 | 25569 | 0.4977722943142728 | | 0.9955445886285456 | LINESTRING(11.2445029 43.7827652,11.2444917 43.7827614) | 0102000020E610000002000000E88DEE7B2F7D264034396BA631E4454071491F042E7D26401CC98A8631E44540 | 251.25865954854987
38 | 44310 | 27.77164777699904 | | 55.54329555399808 | LINESTRING(11.2451578 43.7829226,11.2451056 43.78291,11.2450997 43.7829086,11.2445029 43.7827652) | 0102000020E610000004000000F7B7BA52857D26404F26C9CE36E445400722307B7E7D26400EDB166536E44540D28437B57D7D2640EA60585936E44540E88DEE7B2F7D264034396BA631E44540 | 256.4857382093002
39 | 24574 | 9.392273488747787 | | 18.784546977495573 | LINESTRING(11.2453793 43.7829758,11.2451578 43.7829226) | 0102000020E610000002000000123B095BA27D26409C470F8D38E44540F7B7BA52857D26404F26C9CE36E44540 | 256.49448377251065
40 | 16880 | 1.608391132399291 | | 3.216782264798582 | LINESTRING(11.2454175 43.7829843,11.2453793 43.7829758) | 0102000020E6100000020000006FBBD05CA77D264007E45CD438E44540123B095BA27D26409C470F8D38E44540 | 257.4553120866691
41 | 7913 | 13.909044171748311 | | 27.818088343496623 | LINESTRING(11.2456875 43.7828938,11.2456648 43.7829152,11.2456529 43.7829425,11.245624 43.7829719,11.2455779 43.7829915,11.2455333 43.7830006,11.2454902 43.7830006,11.2454175 43.7829843) | 0102000020E6100000080000006F1283C0CA7D2640DE9E31DD35E44540888ED3C6C77D264049C5B59036E44540CA558737C67D26400113B87537E44540B439CE6DC27D2640EF17586C38E44540A03DF262BC7D2640E3C5C21039E445406D286B8AB67D2640CBDF185D39E445401DFA38E4B07D2640CBDF185D39E445406FBBD05CA77D264007E45CD438E44540 | 288.5303886794287
42 | 16743 | 0.6742478133732702 | | 1.3484956267465404 | LINESTRING(11.2457038 43.782891,11.2456875 43.7828938) | 0102000020E6100000020000007F0173E3CC7D264097AAB4C535E445406F1283C0CA7D2640DE9E31DD35E44540 | 279.7470901303261
43 | 19564 | 1.7475520843556684 | | 3.495104168711337 | LINESTRING(11.2457038 43.782891,11.245746 43.7828836) | 0102000020E6100000020000007F0173E3CC7D264097AAB4C535E44540E23E726BD27D26409149A18735E44540 | 99.94600494375914
44 | 25424 | 2.5893070646521927 | | 5.1786141293043855 | LINESTRING(11.245746 43.7828836,11.2458082 43.7828717) | 0102000020E610000002000000E23E726BD27D26409149A18735E44540612D8892DA7D2640623BCE2335E44540 | 100.83085226249031
45 | 5993 | 1.143926166927714 | | 2.287852333855428 | LINESTRING(11.2458082 43.7828717,11.2458357 43.7828665) | 0102000020E610000002000000612D8892DA7D2640623BCE2335E44540E860472DDE7D264026512FF834E44540 | 100.70768648274607
46 | 6015 | 9.386892361276956 | | 18.773784722553913 | LINESTRING(11.2457543 43.7827083,11.2457901 43.7827875,11.2458357 43.7828665) | 0102000020E610000003000000E7B3F281D37D264065671BC92FE44540745C3233D87D2640DA1B7C6132E44540E860472DDE7D264026512FF834E44540 | 27.22756711384799
47 | 16879 | 33.21412537227705 | | 66.4282507445541 | LINESTRING(11.2458856 43.7821304,11.245865 43.7821716,11.2457691 43.7823758,11.2457481 43.7824298,11.2457363 43.7824779,11.2457286 43.7825436,11.2457271 43.7825823,11.2457272 43.7826339,11.2457325 43.7826586,11.2457543 43.7827083) | 0102000020E61000000A0000005B1DA5B7E47D26408C9A54D91CE445404B766C04E27D264014EEF0321EE4454016BC8D72D57D26404617E5E324E44540B81BE9B1D27D26403A35E1A826E445404EE1F725D17D2640E02B5F3C28E445403C629923D07D2640D8D880632AE445405A7B44F1CF7D2640D87624A82BE44540AD799FF4CF7D2640D79EFE582DE44540EF2076A6D07D2640717731282EE44540E7B3F281D37D264065671BC92FE44540 | 347.19959070702953
48 | 6501 | 14.178484135661893 | | 28.356968271323787 | LINESTRING(11.2460174 43.7818939,11.2459289 43.7820407,11.2458856 43.7821304) | 0102000020E610000003000000707E1EFEF57D264090B86C1915E4454052488D64EA7D26400B52DFE819E445405B1DA5B7E47D26408C9A54D91CE44540 | 330.8693441485164
49 | 13216 | 72.8670557750872 | | 145.7341115501744 | LINESTRING(11.2467276 43.7806874,11.2465258 43.7810305,11.2463035 43.7814081,11.2460174 43.7818939) | 0102000020E610000004000000880A7A14537E26401BB39190EDE34540903D31A1387E2640DA56B3CEF8E34540DAC70A7E1B7E26402D2A3D2E05E44540707E1EFEF57D264090B86C1915E44540 | 329.5170251291712
50 | 9473 | 29.827198336047665 | | 59.65439667209533 | LINESTRING(11.2470546 43.7802209,11.2469974 43.7802345,11.2467868 43.7805867,11.2467276 43.7806874) | 0102000020E61000000400000019A7C6F07D7E2640EE934847DEE34540E1647671767E2640FF5A5EB9DEE34540432BE6D65A7E2640A618D643EAE34540880A7A14537E26401BB39190EDE34540 | 324.97090315861357
51 | 15595 | 50.55088475688777 | | 101.10176951377554 | LINESTRING(11.2479181 43.7800818,11.2473679 43.7798911,11.247329 43.7798804,11.247278 43.7798736,11.2472459 43.7798862,11.247199 43.7799251,11.2470893 43.7802082,11.2470546 43.7802209) | 0102000020E610000008000000442C071FEF7E2640379A6DB8D9E3454010296101A77E26408278B878D3E345406CB41CE8A17E26404D65F61ED3E34540630AD6389B7E2640C481EBE5D2E34540E223BD03977E264005CD9D4FD3E34540333509DE907E26402EEAEE95D4E3454011621D7D827E26401789BFDCDDE3454019A7C6F07D7E2640EE934847DEE34540 | 279.1510814909787
52 | 18417 | 4.3768158242801505 | | 8.753631648560301 | LINESTRING(11.2479658 43.780011,11.2479181 43.7800818) | 0102000020E6100000020000008E0D935FF57E264098C28366D7E34540442C071FEF7E2640379A6DB8D9E34540 | 326.0307154846835
53 | 18099 | 3.694343698655724 | | 7.388687397311448 | LINESTRING(11.2480097 43.7799526,11.2479658 43.780011) | 0102000020E6100000020000007A2E9D20FB7E264010B79E7CD5E345408E0D935FF57E264098C28366D7E34540 | 323.0673640488919
54 | 40443 | 7.467509584698271 | | 14.935019169396542 | LINESTRING(11.2480839 43.7798294,11.2480097 43.7799526) | 0102000020E61000000200000009545ADA047F2640CABA2473D1E345407A2E9D20FB7E264010B79E7CD5E34540 | 328.9405911717229
55 | 27280 | 17.765059815245223 | | 35.53011963049045 | LINESTRING(11.2483437 43.7796859,11.2482841 43.7798262,11.2480997 43.7797954,11.2480839 43.7798294) | 0102000020E610000004000000D455CBE7267F26407FD360BFCCE34540CC3BF3171F7F264030C84C58D1E34540794B83EC067F26401E49EE55D0E3454009545ADA047F2640CABA2473D1E34540 | 298.91397593417906
56 | 27279 | 1.2381222966132326 | | 2.476244593226465 | LINESTRING(11.2483437 43.7796859,11.2483734 43.7796917) | 0102000020E610000002000000D455CBE7267F26407FD360BFCCE3454085645CCC2A7F2640383B08F0CCE34540 | 78.94999474215888
57 | 20103 | 1.501766449556516 | | 3.003532899113032 | LINESTRING(11.2483734 43.7796917,11.2484094 43.7796988) | 0102000020E61000000200000085645CCC2A7F2640383B08F0CCE34540B80952842F7F26407F5D972BCDE34540 | 78.84318255644877
58 | 27284 | 2.1436462955080122 | | 4.2872925910160244 | LINESTRING(11.2484094 43.7796988,11.2484608 43.7797089) | 0102000020E610000002000000B80952842F7F26407F5D972BCDE345400EAD0441367F264038F35080CDE34540 | 78.88312632484534
59 | 27285 | 0.8793122180726864 | | 1.758624436145373 | LINESTRING(11.2484608 43.7797089,11.2484819 43.779713) | 0102000020E6100000020000000EAD0441367F264038F35080CDE34540BF4B0405397F26400EA2B5A2CDE34540 | 79.00372742371663
60 | 27283 | 62.02452250415488 | | 124.04904500830976 | LINESTRING(11.2484819 43.779713,11.2486633 43.7791666,11.2488699 43.7786327) | 0102000020E610000003000000BF4B0405397F26400EA2B5A2CDE345404E6ECACB507F264059912CBBBBE34540E7EA22E06B7F2640500C7F3CAAE34540 | 160.24376742496278
61 | 31969 | 10.27270114103584 | | 20.54540228207168 | LINESTRING(11.2488699 43.7786327,11.248918 43.7784511) | 0102000020E610000002000000E7EA22E06B7F2640500C7F3CAAE345407EC51A2E727F264082042049A4E34540 | 165.16484844296673
62 | 24757 | 22.282554804848157 | | 44.565109609696314 | LINESTRING(11.248918 43.7784511,11.2490224 43.7780572) | 0102000020E6100000020000007EC51A2E727F264082042049A4E345405FF12FDD7F7F26406B35DA6097E34540 | 165.15553039795506
63 | 45525 | 11.059829115896502 | | 22.119658231793004 | LINESTRING(11.2490224 43.7780572,11.2490518 43.7779461,11.2491704 43.777944) | 0102000020E6100000030000005FF12FDD7F7F26406B35DA6097E345401605B0B7837F26407FC6E0BC93E3454032433E43937F2640490F43AB93E34540 | 127.41110402635734
64 | -1 | 0 | | | | |
(64 rows)