Catalogação e quantificação por tag
Jump to navigation
Jump to search
A query para saber a catalogação da rede viária é a seguinte:
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 |