blocklys/bigquery-maps-api

Google Maps API and BigQuery Codelab

Synopsis

This is not an official Google product.

This project demonstrates how to perform simple geospatial queries against a Google BigQuery table that contains latitude, longitude data in columns. It also shows how to use the Google Maps Platform's Maps JavaScript API to present a visual interface for the queries and the query results. The code accompanies a codelab which can be found on the Codelabs page at the Google Developers site. The files are arranged in sequential order to demonstrate progress through the codelab, but if you want you can jump straight in to the finished example.

Motivation

The project and accompanying Codelab aim to illustrate some ways to work with and visualize geospatial and location data in BigQuery tables without needing specialized libraries, ETL workflows or spatial data formats.

Installation

The repo consists of static HTML files that can be run from a local computer or any web server.

To get it working, you'll need to sign up for BigQuery and the Google Maps API. See the codelab for more detailed instructions, but the basic steps to get this running are:

• Sign up for a Google Cloud Platform account and create or use an existing project.
• Enable the BigQuery API and the Google Maps Javascript API in the Developer Console.
• Enable the Maps JavaScript API) for your project.
• Create a new API Key for use with the Google Maps Platform, with a Browser restriction.
• Create OAuth 2.0 credentials for use with BigQuery.
• Choose a BigQuery dataset to query. There are several public datasets with latitude/longitude data.
• modify the code to replace the placeholders for API keys, OAuth 2.0 credentials, and BigQuery dataset and table name parameters with your own specific values for these.

API Reference

For a general overview of Google BigQuery see What Is BigQuery?

You may find it helpful to refer to the Google Maps Platform documentation, the Google BigQuery reference, and the Google Client API for JavaScript reference.

License

This project is licensed under the Apache 2.0 license.