Loading Geospatial data to Google BigQuery


Speaker(s):
Dong Sun
Sean Jensen-Grey

Loading Geospatial data to Google BigQuery

By Dong Sun Sean Jensen-Grey
Jun-14 16:15-16:40 in Upper Bay
Add to Calendar 06/14/2023 4:15 PM 06/14/2023 4:40 PM America/Los_Angeles AS24: Loading Geospatial data to Google BigQuery

With decreasing costs for cloud computing and storage, numerous traditional Geographic Information System (GIS) workloads are being shifted to cloud-based platforms such as Google Cloud Platform (GCP). Consequently, there is a surge in the adoption of GCP for GIS-related tasks such as data ingestion, storage, and visualization.

During this session, we will provide an introduction to two of the most frequently utilized GIS data formats: Shapefile (shp) and Tag Image File Format (TIFF). We will also discuss the reasons and methods for loading these formats into Google BigQuery, including a serverless approach using geobeam for ingesting GIS files into BigQuery. Furthermore, we will offer some best practices and highlight things to avoid.

 Upper Bay

  Download slides

With decreasing costs for cloud computing and storage, numerous traditional Geographic Information System (GIS) workloads are being shifted to cloud-based platforms such as Google Cloud Platform (GCP). Consequently, there is a surge in the adoption of GCP for GIS-related tasks such as data ingestion, storage, and visualization.

During this session, we will provide an introduction to two of the most frequently utilized GIS data formats: Shapefile (shp) and Tag Image File Format (TIFF). We will also discuss the reasons and methods for loading these formats into Google BigQuery, including a serverless approach using geobeam for ingesting GIS files into BigQuery. Furthermore, we will offer some best practices and highlight things to avoid.