Home / Data: Planet, Coastlines, Buildings, Admins, Roads / Attribution

Daylight Earth Table

Overview: Building, Infrastructure, Land, Landuse, Placename, POI, Road, Transit, Water

Theme: road

Vehicular transportation and pedestrian walkways

Metadata keys

key name	description of values
`disused:highway` is not null
`is_bridge`	`true` if `bridge` in (`aqueduct`, `boardwalk`, `cantilever`, `covered`, `low_water_crossing`, `movable`, `trestle`, `viaduct`, `yes`)
`is_covered`	`true` if `covered=yes`
`is_oneway`	`true` if `oneway` in (`yes`, `1`) and `false` if `oneway=no`
`is_pedestrian`	`true` if (`foot` is not NULL and `foot != no`) or (`bicycle` is not NULL and `bicycle != no`)
`is_tunnel`	`true` if `tunnel` in (`building_passage`, `covered`, `yes`)
`lanes`	value of `lanes`
`layer`	value of `layer`
`level`	value of `level`
`length_m`	length of feature in meters (if a line)
`maxspeed`	value of `maxspeed`
`relation_distance`	value of `distance` in the feature’s OSM relation
`relation_id`	value of `_id` in the feature’s OSM relation
`relation_name`	value of `name` in the feature’s OSM relation
`relation_network`	value of `network` in the feature’s OSM relation
`relation_ref`	value of `ref` in the feature’s OSM relation
`relation_route`	value of `route` in the feature’s OSM relation
`relation_symbol`	value of `symbol` in the feature’s OSM relation
`relation_toll`	value of `toll` in the feature’s OSM relation
`relation_type`	value of `type` in the feature’s OSM relation
`relation_wikidata`	value of `wikidata` in the feature’s OSM relation
`surface`	value of `surface`
`surface_area_sq_m`	area of the feature in square meters (if a polygon)
`theme`	Earth Tables theme (in this case, `road`)
`width`	value of `width:carriageway` or `width`
`wikidata`	Wikidata ID (if present)

OSM tags included (filter)

tag name	required?	values included
`amenity`	optional	`parking`
`bicycle_road`	optional	`yes`
`cycleway`	optional	any
`foot`	optional	`no` (if `highway=bridleway`)
`footway`	optional	`access_aisle`, `crossing`, `path`, `sidewalk`
`highway`	optional	`bridleway`, `crossing`, `cycleway`, `footway`, `living_street`, `motorway`, `motorway_link`, `path`, `pedestrian`, `primary`, `primary_link`, `raceway`, `residential`, `road`, `secondary`, `secondary_link`, `service`, `steps`, `tertiary`, `tertiary_link`, `track`, `trunk`, `trunk_link`, `unclassified`, `via_ferrata`
`indoor`	required	NULL or `no`
`man_made`	optional	`bridge`
`place`	optional	`square`
`service`	optional	`alley`, `driveway`, `parking_aisle`

Feature counts per class and subclass in Daylight v1.45

Class	Subclass	Feature Count	Example Feature in OSM
cycleway	bicycle	1,593,227	w87342797@3
cycleway	crossing	133,285	w1041352788@1
local	residential	66,053,780	w332346975@4
local	track	26,148,009	w82291454@7
local	unclassified	17,101,833	w845247101@2
local	living_street	1,818,157	w554541421@3
local	road	53,141	w1125528844@2
motorway	trunk	1,714,566	w881989835@3
motorway	motorway	1,200,545	w895576337@1
motorway	motorway_link	837,714	w40343525@4
motorway	trunk_link	522,914	w867861880@2
parking	parking	4,914,749	w155374795@4
pedestrian	footway	14,448,858	w1157288922@1
pedestrian	path	13,939,427	w1046344924@1
pedestrian	crossing	12,211,473	n6709540654@5
pedestrian	sidewalk	4,610,472	w870854205@3
pedestrian	steps	1,631,717	w206647349@1
pedestrian	pedestrian_mall	773,126	w455974672@9
pedestrian	access_aisle	54,682	w1150150310@1
pedestrian	bridleway	50,955	w941886894@1
pedestrian	square	10,517	n5031137551@1
primary	primary	3,515,194	w130771128@4
primary	primary_link	440,252	w1215578753@2
recreation	raceway	39,336	w548226499@1
recreation	via_ferrata	2,618	w633116536@1
secondary	secondary	5,090,435	w1182050835@1
secondary	secondary_link	345,086	w47397671@17
service	service	32,688,805	w189057346@3
service	driveway	14,790,670	w742782564@1
service	parking_aisle	6,230,470	w744410054@1
service	alley	1,695,051	w121870059@1
tertiary	tertiary	7,938,696	w383396921@2
tertiary	tertiary_link	249,980	w658865111@1

Zoom level recommendations for feature rendering

when	feature minzoom	feature maxzoom
`subclass` in (`motorway`, `trunk`)	5	16
`subclass` in (`motorway_link`, `trunk_link`)	7	16
`subclass=primary`	8	16
`subclass` in (`primary_link`, `secondary`, `tertiary`)	10	16
`subclass` in (`access_aisle`, `secondary_link`, `tertiary_link`, `living_street`, `pedestrian_mall`, `residential`, `square`, `track`, `unclassified`)	12	16
`subclass` in (`bicycle`, `bridleway`, `crossing`, `footway`, `path`, `road`, `raceway`, `service`, `sidewalk`, `steps`)	13	16
`subclass=parking_aisle`	14	16

Other notes

To be included, a feature must have one of these tags populated: amenity, footway, highway, leisure, man_made, place, service