Skip to content

A Big Query project that displays location data on a map and uses SQL User Defined Functions and the BigQuery API

License

Notifications You must be signed in to change notification settings

algarecu/big-query-location-data-prototype

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

19 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

big-query-location-data-prototype

A Big Query project that displays location data on a map and uses SQL queries, user defined functions and the BigQuery API

Requirements:

  • Clone this repo.
  • Enable the Google APIs required with your Google account (otherwise this will not work, I am saving my own API calls ;-) ).
  • Create some Google credentials within your organization (only works with internal credentials) and insert them in the clienID and Key fields of the code (YOUR_MAPS_KEY, YOUR_CLIENT_ID)
  • Create or select a project on Google Cloud Platform.
  • Deploy app.yaml with: gcloud app deploy app.yaml --project PROJECT-NAME --version VERSION-NAME
  • Enjoy!

Results: you will get your input rendered automatically by Google JS Maps and sent to the BigQuery API backend.

Polygon Big Query with air quality dataset in France

Testing it: https://location-geodb.appspot.com/

About

A Big Query project that displays location data on a map and uses SQL User Defined Functions and the BigQuery API

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages