Tag: GIS

BigQuery Data Science GIS Sept. 21, 2020

A beginner’s Guide to Google’s BigQuery GIS - Get started free with Google Big Query GIS with this step by step tutorial.

BigQuery GIS Public Datasets Aug. 31, 2020

Enable business data with BigQuery for geospatial analysis and map visualization - Demonstrating BigQuery GIS capabilities.

BigQuery GIS Public Datasets June 22, 2020

Creating an Enhanced NYT COVID-19 Data Set - Adding Demographic, Electoral, and Mobility Information in BigQuery.

BigQuery Cloud SQL GIS May 25, 2020

Call PostgreSQL from BigQuery for extra GIS powers - Combining PostgreSQL and BigQuery queries to validate GIS data.

BigQuery Cloud Dataprep GIS May 11, 2020

Road risk analysis with Google Cloud serverless tools - Road risk analysis of recorded vehicles speed and overspeed levels correlation in Google Cloud.

BigQuery GIS April 20, 2020

How to find the interior centroid of US counties using BigQuery GIS - How to handle the problem of centroids being in the Great Lakes.

BigQuery Data Studio GIS Machine Learning Public Datasets Visualization April 6, 2020

Analyzing COVID-19 with BigQuery - Exploring, visualizing and predicting COVID-19 data using BigQuery.

BigQuery GIS March 16, 2020

Yet another GeoJson to Ndjson converter - You might have already seen many ways to convert GeoJson files to something BigQuery can understand. Let’s invent one more wheel!

BigQuery GIS March 9, 2020

How to query geographic raster data in BigQuery efficiently - Working with raster images for GIS data in BigQuery.

BigQuery GIS Feb. 3, 2020

BigQuery Geography Clustering - Example of using clustering with geo data in BigQuery.

BigQuery GIS Feb. 3, 2020

OpenStreetMap BigQuery Public Dataset - The OpenStreetMap planet-wide dataset loaded to BigQuery.

BigQuery GIS Jan. 27, 2020

A Continent On Fire - Visualizing wildfires with BigQuery Geo Viz.

BigQuery GIS Jan. 13, 2020

Mapping statistics between different spatial hierarchies - BigQuery recipe for a problem when you have some geospatial statistics collected for one set of spatial hierarchy, but you need to do some data analysis using another hierarchy.

BigQuery GCP Certification GIS Dec. 16, 2019

Nearest neighbor using BQ Scripting - GIS BigQuery script to find the nearest neighbor for a specific geo point.

BigQuery GIS Dec. 16, 2019

Puppies & BigQuery: Analyzing Geospatial Data - Pet density analysis and visualization in BigQuery GIS.


Latest Issues


Zdenko Hrček
Třebanická 183
Prague, Czech Republic
Phone: +420 777 283 075
Email: zdenko@gcpweekly.com