Skip to content

Instantly share code, notes, and snippets.

@rainhead
Created February 13, 2025 18:15
Show Gist options
  • Save rainhead/43beae0579c7b7369b1d6714213b9998 to your computer and use it in GitHub Desktop.
Save rainhead/43beae0579c7b7369b1d6714213b9998 to your computer and use it in GitHub Desktop.
Natural Features from OSM in Puget Sound
[local] rainhead@osm=# select nat, count(*) from (select "natural" from planet_osm_point union all select "natural" from planet_osm_line union all select "natural" from planet_osm_polygon) as v (nat) group by 1;
nat | count
------------+---------
anthill | 2
bare_rock | 218
bay | 179
beach | 314
birds_nest | 3
cape | 79
cliff | 56
earth_bank | 233
forest | 1
garden | 1
grass | 11
grassland | 121
heath | 25
hill | 5
island | 1
islet | 1
isthmus | 1
land | 1
log | 1
mud | 7
peak | 187
peninsula | 5
ravine | 2
reef | 96
ridge | 4
rock | 65
saddle | 6
sand | 1573
scree | 5
scrub | 1222
shingle | 25
shoal | 2
shrub | 472
shrubbery | 250
spring | 36
stone | 567
strait | 25
tree | 35300
tree_row | 994
tree_stump | 45
valley | 5
water | 3454
wetland | 2003
wood | 6768
yes | 70
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment