This lab will teach you how to perform spatial measurements and spatial transformations in BigQuery GIS using Python and Jupyter notebooks. The lab uses New York City landmark geospatial points to demonstrate the distance measurement function within BigQuery GIS and Google public census places data to demonstrate the area measurement function on a geospatial polygon. Spatial transformation functions are demonstrated by calculating the centroid of geospatial polygons from the Google zip code public data and combining single geospatial points into multipoint GEOGRAPHY
objects using the aggregate union transformation function from the Google New York tree census public data.
Upon completion of this lab, you will be able to:
GEOGRAPHY
dataGEOGRAPHY
dataThis lab is intended for:
You should possess:
GEOGRAPHY
datatype is beneficial but not requiredAugust 20th, 2025 - Resvoled issue connecting to the lab's notebook
June 23rd, 2025 - Resolved environment errors and missing permissions
May 28th, 2025 - Migrated lab environment
August 7th, 2024 - Added password protection to notebook