Catalogação
Jump to navigation
Jump to search
A query para saber qual a catalogação da rede viária é:
select distinct highway from planet_osm_line
O resultado da query:
highway |
---|
<null> |
unclassified |
unsurfaced |
footway |
motorway |
proposed |
raceway |
motorway_link |
steps |
junction |
pedestrian |
bridleway |
secondary_link |
primary_link |
planned |
services |
incline |
Rotunda |
rotunda |
service |
trunk_link |
cycleway |
living_street |
path |
residential |
road |
Rua 25 de Abril |
rest_area |
construction |
Rua Dona Filomena |
minor |
residential;secondary |
secondary |
primary |
track |
mini_roundabout |
tertiary |
trunk |
Rua Campus Village |
Rot |
tertiary_link |
PNOA |
Quantificação por tag (por ordem decrescente)
select highway, count (*) as contagem from planet_osm_line group by highway order by contagem desc
Resultado da query
highway | contagem |
---|---|
residential | 51350 |
unclassified | 9580 |
tertiary | 9118 |
<null> | 6764 |
primary | 6424 |
secondary | 6306 |
service | 5068 |
motorway | 3306 |
motorway_link | 3129 |
road | 2980 |
track | 2970 |
footway | 2857 |
trunk | 2376 |
trunk_link | 2040 |
path | 1484 |
primary_link | 1016 |
steps | 936 |
pedestrian | 678 |
living_street | 150 |
cycleway | 105 |
secondary_link | 101 |
tertiary_link | 89 |
construction | 68 |
bridleway | 20 |
raceway | 14 |
proposed | 9 |
rest_area | 8 |
minor | 4 |
unsurfaced | 3 |
planned | 2 |
Rotunda | 2 |
Rot | 2 |
PNOA | 1 |
junction | 1 |
services | 1 |
incline | 1 |
rotunda | 1 |
Rua 25 de Abril | 1 |
Rua Dona Filomena | 1 |
residential;secondary | 1 |
mini_roundabout | 1 |
Rua Campus Village | 1 |