osm_id   |  ref  |    st_length     
-----------+-------+------------------
 186513186 | A 2   | 60.7825520784268
  15805453 | A 45  | 588.648913298605
 147718537 | A 46  | 191.209207792675
 184108993 | A 81  |  264.95349129404
  23094939 | A 9   |  94.233882215336
 178722935 | B 205 | 280.728062193308
  46426779 | B 205 | 601.736368325739
 184489051 | B 88  | 214.461727831518
 163626002 | L 600 | 62.1820069512085
 163625998 | L 600 | 351.054689226882
 108251948 | L 600 | 611.849512536514
  95978837 |       |  430.62460330694
  95978843 |       | 259.384087676063
  95995608 |       | 296.987602649399
  58548640 |       | 121.394300525113
  23225579 |       | 117.797491060344
 152204616 |       | 82.4089630023695
 152204623 |       | 346.105476231462
 173693170 |       | 145.254162805705
 173693172 |       | 188.293739947655
 126495954 |       | 234.231111203987
   8493219 |       | 220.702272280509
   8058792 |       | 219.232127701098
 182556974 |       | 151.968273960054
 182556971 |       | 194.364146501957
  27832692 |       | 280.792729403833
 156994184 |       | 67.7479829959354
  24057433 |       | 230.130031808148
   4740391 |       | 225.024996212282
   3678330 |       | 247.191219190987
 172299058 |       |   286.6375210863
 172299064 |       | 157.891337951036
 171957492 |       | 140.116656040535
 178006081 |       | 228.672417615758
 171953548 |       | 210.440070586244
 184594377 |       | 449.709614290984
 173450787 |       | 293.815638990708
 173450785 |       | 308.209845302361
 157750363 |       |  85.282472994611
 157750364 |       | 83.5437974960827
 174341391 |       | 28.9582354434561
 183785564 |       | 217.345045150135
 176934950 |       | 181.590127992288
 176934948 |       | 221.234666230695
  22529453 |       | 15.1740831684636
   3214136 |       | 23.5358471278247
  23495306 |       | 390.900777150692
  14124532 |       | 276.273216989677
  14124527 |       | 196.599575924583
  93726518 |       | 334.791436809928
  49588586 |       | 692.763793676326
  49588588 |       | 177.948028367722
  30239307 |       | 852.905426439041
  23388874 |       | 426.691304287359
  23388876 |       | 430.879683349813
 185152979 |       | 32.0408364433872
  25883665 |       | 268.765832709278
  88843981 |       | 373.430482934461
  88843979 |       | 68.5377707268407
 103220396 |       | 298.574044999397
  27710820 |       | 135.620160283903
 172257197 |       | 76.5274258028904
  19358150 |       | 562.344515788111
 184109001 |       | 202.789892050307
 145354799 |       | 283.818152154037
 145354790 |       | 149.814373007942
  25683029 |       | 239.651728428761
(67 rows)