transportation contains roads and railways.
This layer is directly derived from the OSM road hierarchy.
Only at zoom level 4 to 6 some major highways from Natural Earth
are used.
It contains all roads from motorways to primary, secondary and
tertiary roads to residential roads and
foot paths. Styling the roads is the most essential part of the map.
The transportation
layer also contains polygons for things like plazas.
Fields
brunnel
Mark whether way is a tunnel or bridge.
Possible values:
ramp
Mark with 1
whether way is a ramp (link or steps)
or not with 0
.
Possible values:
class
Distinguish between more and less important roads or railways.
Class is derived from the value of the
highway
or
railway
tag.
Possible values:
motorway
trunk
primary
secondary
tertiary
minor
service
track
path
raceway
rail
transit
service
Original value of the service
tag.
Possible values:
spur
yard
siding
crossover
driveway
alley
parking_aisle
oneway
Mark with 1
whether way is a oneway (in the direction of the way)
or not with 0
.
Possible values:
Mapping Diagram
ETL Diagram
SQL
SELECT geometry, class, oneway, ramp, brunnel, service FROM layer_transportation(ST_SetSRID('BOX3D(-20037508.34 -20037508.34, 20037508.34 20037508.34)'::box3d, 3857 ), 14)