Determinação de comprimento das vias por distrito
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 |