One of the most common map visualizations is to show a collection of features and an associated numeric value, for example annual rainfall or income levels in different places. Color-coding each feature based on its value is often the easiest way to visualize the data. But how to assign colors …

In late September and early October, Hurricane Matthew caused devastation in the Caribbean, especially in Haiti, before continuing up the Florida coast. Using data from Weather Underground, we show how to map its trajectory and visualize its intensity and storm status. 1. Create a new spreadsheet with Geosheets enabled. Either …

The recent earthquake in central Italy that devastated the town of Amatrice got us thinking about other earthquakes in general and visualizing where else they’ve occurred recently. The US Geological Survey has among its great data sets an exportable list of recent earthquakes at https://earthquake.usgs.gov/earthquakes/. Handily, one of the formats they provide …

San Francisco recently saw direct service begin to Singapore on United and soon on Singapore Airlines, bringing back service from North America to Singapore and creating one of the world’s longest flights. We wanted to see how this route measures up to others from SFO in terms of distance, so we …

There’s been an explosion of open data made available by all levels government, but much of it is still in a pretty raw form and can be hard to manipulate and visualize. However, with the data import functions in Google Sheets and the mapping functions in Geosheets it’s possible to …

Wikipedia has an astounding wealth of information including location data, and much of it is semi-structured due to the use of tables and information cards. It’s possible to take advantage of that structure to quickly extract location data and attributes and then use Geosheets to create a map. The secret …