Geospatial with BigQuery

• Homework
• Lecture
  • Slide deck
  • Lecture notes
• Lab

Homework

• Continue working on Homework 2 (due on Oct 6th at 11:59pm ET)
• Intro to BigQuery GIS tutorial
• BigQuery covid blog post - I encourage you to follow along and recreate all the work, up to the forecasting part.
• Practice some BQ queries
  • If you were born in the United States, try to find yourself in the natality dataset. If you weren't born in the US, try to find a friend if they don't mind sharing some of their personal details.
  • What was the average weather in the world on your birthday? Use the gsod dataset of weather readings around the world. E.g., what was the total amount of precipitation measured?

Lab Outline

1. Query public datsets
2. Visualize using the GeoViz tool
3. Create a new dataset from a dataset in Google Storage
4. Mix public and private datasets in a query