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)

Exercise 6: Many Pedestrians going to different destinations summarizing the total costs per departure

 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)

Exercise 3: Nearest Vertex

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 WARNING message:

      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)