The ADS-B Massive Visualizer now maps 1.5 billion eBird observations. This powerful, interactive geospatial tool shows where and when different bird species have been observed by eBird users around the world.
At first glance, the map may look like just a collection of dots - but click the selector button (the square with an arrow in the bottom left corner), and you can draw a region to explore in more detail. A sidebar will appear, listing all the bird species recorded in the selected area. For example, around my own neighborhood, the map reveals sightings of the Common Wood Pigeon, European Robin, Rock Pigeon, Eurasian Blackbird, Great Tit, House Sparrow, Eurasian Blue Tit, and Black-headed Gull (though oddly, no Parakeets or Magpies).
The map also supports filtering results using ClickHouse SQL, a dialect of SQL designed specifically for the ClickHouse database. It can be a little tricky to use, but I was able to run a few queries by selecting some of the provided examples and simply replacing the 'vernacularname' with the common name of the bird species I wanted to visualize.
The ADS-B Massive Visualizer also allows you to explore a number of other large databases. These include Planes (130 billion records), Places (from Foursquare), and Photos (seemingly sourced from Flickr).
No comments:
Post a Comment