Tag: GIS

BigQuery Data Science GIS Nov. 8, 2021

Spatial Binning with Google BigQuery - Binning geographical coordinates into square tiles with Google BigQuery.

BigQuery GIS Oct. 4, 2021

BigQuery Geospatial query tricks - Two useful tricks on how to implement some complex GIS queries in BigQuery.

BigQuery GIS July 19, 2021

Simplified tileset creation for streamlined app development - Using Carto to create tiles on top of BigQuery data.

BigQuery GIS Official Blog June 28, 2021

Leveraging BigQuery Public Boundaries datasets for geospatial analytics - Here we’ll show you how to join first party data onto the BigQuery Public Boundaries Datasets for comprehensive geospatial analytics.

BigQuery Data Science GIS June 22, 2021

A Primer on JavaScript UDFs for Spatial Analysis in BigQuery - Succinct guide to writing JavaScript User-Defined Functions for Geospatial Operations in BigQuery.

BigQuery Data Science GIS Python May 31, 2021

Transforming GeoJSON’s Geometric Features into BigQuery’s Polygon Format with Simple Python Script - Bridging the geometric data available in GeoJson.io into analytics use cases.

BigQuery GIS May 24, 2021

How To: Group By Geography column - Aggregating data by a geography column in BigQuery.

BigQuery Data Studio GIS April 12, 2021

Exploring hail reports with BigQuery and Data Studio - Using the new geospatial capabilities in Data Studio.

BigQuery Data Analytics GIS Google Maps Platform Official Blog April 5, 2021

Unlock geospatial insights with Data Studio and BigQuery GIS - Learn how to create arbitrary-polygon choropleth maps in Data Studio with BigQuery GIS and Google Maps.

BigQuery Cloud Dataflow GIS Feb. 8, 2021

GeoBeam - Use DataFlow to move shp and gdb files to BigQuery GIS, an also process geotiffs in flight and write results to BigQuery.

BigQuery GIS Feb. 1, 2021

Invert polygons for fun and new functionality - Creating an aggregate version of ST_Intersect or STIntersection in BigQuery GIS.

Cloud Firestore Firebase GIS Dec. 28, 2020

Geo queries with Firestore - This guide describes how to do Geo queries in Firestore.

BigQuery GIS Nov. 16, 2020

Dasymetric Spatial Interpolation in BigQuery - Achieving spatial interpolation using BigQueries geospatial functions.

BigQuery GIS Nov. 2, 2020

A Quick Experiment with the CARTO BigQuery Tiler! - Using CARTO’s new BigQuery Tiler to visualize GIS data.

BigQuery GIS Oct. 19, 2020

New options for BigQuery GIS geospatial data ingestion - Introducing ST_GeogFromText and ST_GeogFromGeoJson functions to convert geospatial data in BigQuery.

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: [email protected]