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

Daylight Earth Table

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

Theme: water

Water features. Including oceans, as determined from the OSM Coastline tool.

Metadata keys

key name description of values
is_in_relation true if the feature has a relation in OSM
is_intermittent true if intermittent=true in OSM
layer value of layer in source
length_m Length of feature in meters (if a line)
relation_id value of _id in the feature’s OSM relation
relation_is_prominent true if the feature’s OSM relation has wikipedia or wikidata populated
relation_type value of type in the feature’s OSM relation
relation_waterway value of waterway in the feature’s OSM relation
surface_area_sq_m Area of feature in square meters (if a polygon)
salt value of salt in OSM
theme Earth Tables theme (in this case, water)
tunnel assumed (if layer < 0), culvert, flooded, yes
wikidata Wikidata ID

OSM tags included (filter)

tag name required? values included
natural optional water
water optional any (not NULL)
basin optional any (not NULL)
landuse optional basin, reservoir
waterway optional canal, ditch, drain, river, stream, tidal_channel, river, riverbank, fairway, fish_pass, dock

Feature counts per class and subclass in Daylight v1.45

ClassSubclassFeature CountExample Feature in OSM
canal ditch 3,777,386 w651458185@1
canal canal 1,066,992 w442569495@1
canal moat 2,031 w340215847@1
human_made swimming_pool 2,139,176 w1011935128@1
human_made drain 1,638,073 w1150611874@2
human_made fish_pass 2,541 w1024036181@2
human_made reflecting_pool 1,046 w219655306@4
lake lake 584,733 w769000906@1
lake oxbow 41,199 w913132508@1
lake lagoon 12,084 w1064431516@1
ocean ocean 53,242 17625_0
physical cape 48,339 n8938711632@1
physical strait 3,158 n2294956118@2
physical shoal 474 n5864105148@1
physical fairway 20 w878802114@1
pond pond 2,599,496 w490212341@2
pond fishpond 9,520 w1072522698@1
reservoir reservoir 704,583 w1195414688@1
reservoir basin 236,509 w956035807@1
reservoir water_storage 16,165 w589631974@3
river river 2,220,132 r12788301@3
stream stream 20,772,899 w1243309448@1
water water 10,524,772 w1254758236@1
water wastewater 82,984 w371769941@2
water tidal_channel 11,955 w876129781@1
water dock 7,011 n5019923966@1
water sewage 5,683 w159655975@3
water lock 3,625 w950301017@1
water salt_pool 3,393 w377508156@1

Zoom level recommendations for feature rendering

when feature
minzoom		 feature
maxzoom		 style_rank
area greater than 30,000,000,000 0 16 2
area between 2,000,000,000 and 30,000,000,000 0 16 3
area between 1,000,000,000 and 2,000,000,000 2 16 4
area between 300,000,000 and 1,000,000,000 4 16 5
area between 20,000,000 and 300,000,000 6 16 6
area between 2,000,000 and 20,000,000 7 16 6
area between 500,000 and 2,000,000 8 16 7
area between 200,000 and 500,000 9 16 7
area between 100,000 and 200,000 10 16 8
area between 50,000 and 100,000 11 16 8
area less than 50,000 12 16 9

Other notes