Introduction to BigQuery Geographic Information Systems (GIS)

In a data warehouse like BigQuery, location information is very common. Many critical business decisions revolve around location data. For example, you may record the latitude and longitude of your delivery vehicles or packages over time. You may also record customer transactions and join the data to another table with store location data.

You can use this type of location data to determine when a package is likely to arrive or to determine which customers should receive a mailer for a particular store location. BigQuery GIS allows you to analyze and visualize geospatial data in BigQuery by using geography data types and standard SQL geography functions.

Limitations

BigQuery GIS is subject to the following limitations:

  • Geography functions are available only in standardSQL.
  • The BigQuery Client Libraries do not currently support the GEOGRAPHY data type.
  • Data Manipulation Language statements do not support the GEOGRAPHY data type.

BigQuery GIS quotas

Quotas and limits on BigQuery GIS apply to the different types of jobs you can run against tables that contain GIS data, including:

For more information on all quotas and limits, see Quotas and Limits.

BigQuery GIS pricing

When you use BigQuery GIS, your charges are based on:

  • How much data is stored in the tables that contain GIS data
  • The queries you run against the data

For information on storage pricing, see Storage pricing.

For information on query pricing, see Query pricing.

Many table operations are free, including loading data, copying tables, and exporting data. Though free, these operations are subject to BigQuery's Quotas and Limits. For information on all free operations, see Free operations on the pricing page.

Next steps

Was this page helpful? Let us know how we did:

Send feedback about...