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 …