Determinação de comprimento das vias por distrito

From OpenStreetMap Wiki
Jump to navigation Jump to search

Neste caso pretendeu-se saber, pelo comprimento e tipo de via, se era possível detetar erros de catalogação.

A query para saber quais as vias com comprimento inferior a 20 m é a seguinte:

select osm_id, distrito_, highway, round(cast(st_length(way) as numeric),3) as comprimento
from planet_osm_line, cont_aad_caop2010
where st_contains (st_transform(wkb_geometry, 900913), way)
and distrito_ ilike 'porto%'
and st_length(way) <= 20
order by comprimento asc

O resultado da query:

osm_id distrito_ highway comprimento
26764614 PORTO residential 0.247
99185212 PORTO unclassified 2.759
37014844 PORTO residential 4.260
99016697 PORTO service 4.957
74013764 PORTO steps 5.009
36966148 PORTO residential 5.549
99185285 PORTO service 5.595
74013799 PORTO steps 6.551
63844518 PORTO residential 6.557
99016333 PORTO footway 6.761
74013777 PORTO footway 6.883
103015417 PORTO footway 7.073
74013780 PORTO footway 7.122
98754745 PORTO footway 7.374
99016596 PORTO service 7.571
99016496 PORTO service 7.809
35916378 PORTO residential 7.865
105885549 PORTO residential 8.251
74013771 PORTO footway 8.370
99256709 PORTO service 8.928
98835848 PORTO residential 8.956
100748369 PORTO footway 9.267
28617915 PORTO residential 9.376
99016614 PORTO <null> 9.516
26248548 PORTO unclassified 9.525
23142426 PORTO residential 9.607
35331294 PORTO secondary 9.613
102789510 PORTO residential 9.721
95392727 PORTO primary 9.781
99016662 PORTO unclassified 9.946
74013816 PORTO footway 10.015
99016764 PORTO service 10.022
74013759 PORTO footway 10.265
40769487 PORTO service 10.781
38455460 PORTO steps 10.852
100748374 PORTO footway 10.991
105671670 PORTO residential 10.992
54565073 PORTO residential 11.135
28617916 PORTO residential 11.704
100748368 PORTO footway 11.754
12297977 PORTO motorway_link 11.866
97721376 PORTO trunk_link 12.146
106462244 PORTO residential 12.149
99016364 PORTO service 12.188
35447219 PORTO secondary 12.420
14326608 PORTO secondary 12.463
27103823 PORTO footway 12.657
98754583 PORTO steps 12.987
25700880 PORTO <null> 13.168
100748364 PORTO footway 13.207
54748724 PORTO residential 13.215
99238809 PORTO service 13.226
95362251 PORTO footway 13.354
37112934 PORTO residential 13.391
98754303 PORTO residential 13.427
37338732 PORTO residential 13.519
39992051 PORTO footway 13.746
65714343 PORTO footway 13.797
74013775 PORTO footway 13.854
82289656 PORTO residential 13.974
98882752 PORTO residential 14.062
103922041 PORTO residential 14.121
98835929 PORTO pedestrian 14.254
63844515 PORTO <null> 14.256
98754553 PORTO service 14.438
96187930 PORTO primary 14.553
31060139 PORTO steps 14.582
100639177 PORTO service 14.619
98754679 PORTO service 14.741
48174593 PORTO tertiary 14.778
99016541 PORTO service 14.828
28617917 PORTO residential 14.924
99116438 PORTO service 15.003
100748340 PORTO footway 15.018
106466600 PORTO primary 15.208
95799833 PORTO secondary 15.211
100748343 PORTO footway 15.268
40905684 PORTO steps 15.390
28617914 PORTO residential 15.537
98835970 PORTO residential 15.792
26650400 PORTO unclassified 15.862
100748377 PORTO steps 15.945
99256769 PORTO unclassified 16.154
95362252 PORTO footway 16.207
99256706 PORTO unclassified 16.248
102393515 PORTO residential 16.256
99256698 PORTO service 16.368
95984862 PORTO trunk_link 16.545
54773805 PORTO secondary 16.549
49895468 PORTO secondary 16.575
97721364 PORTO trunk_link 16.589
99016744 PORTO footway 16.746
107482971 PORTO residential 16.850
14333841 PORTO footway 16.909
36005758 PORTO residential 16.909
103850080 PORTO residential 16.980
95841132 PORTO secondary 17.080
99016741 PORTO service 17.143
103332367 PORTO residential 17.232
98675910 PORTO track 17.266
28618050 PORTO residential 17.391
37092544 PORTO service 17.483
54773804 PORTO secondary 17.540
99016724 PORTO footway 17.717
39992052 PORTO footway 17.779
99256742 PORTO unclassified 17.810
103319875 PORTO residential 17.887
77607326 PORTO primary 17.927
95660745 PORTO motorway_link 17.950
54567663 PORTO residential 17.966
28618054 PORTO residential 17.976
95209079 PORTO residential 18.029
105671669 PORTO steps 18.153
105882832 PORTO residential 18.335
103091353 PORTO residential 18.467
102792352 PORTO footway 18.545
63844511 PORTO steps 18.573
105880312 PORTO primary 18.661
97721309 PORTO residential 18.717
98754518 PORTO unclassified 18.896
99185246 PORTO residential 18.934
105880315 PORTO primary 19.067
105882831 PORTO residential 19.134
98754712 PORTO residential 19.145
50855905 PORTO residential 19.192
40590082 PORTO residential 19.321
99016678 PORTO service 19.335
39924872 PORTO secondary 19.419
39657916 PORTO residential 19.460
106462238 PORTO tertiary 19.530
98836065 PORTO primary_link 19.561
107430883 PORTO service 19.609
61328574 PORTO residential 19.614
35770755 PORTO residential 19.634
36928623 PORTO residential 19.638
106462277 PORTO secondary 19.657
102492173 PORTO residential 19.688
41379105 PORTO residential 19.699
40701427 PORTO residential 19.738
103850076 PORTO residential 19.752
99016758 PORTO service 19.777
104657807 PORTO residential 19.781
41379110 PORTO residential 19.806
99016647 PORTO footway 19.855