Finding the Closest Weather Stations — BigQuery Public Datasets

Google Maps measuring the distance between 2 points with a weather icon.

Use BigQuery Public Datasets, Geography Functions, Wildcard Tables, and ARRAY_AGG & UNNEST to locate and query local historical weather data near any address.

While working on a smart home data project, I found myself searching for public weather data. It turns out that Google BigQuery has a ton of weather data in the NOAA GSOD (Global Surface Summary of