Catalogação

From OpenStreetMap Wiki
Jump to: navigation, 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