Medium

Michael Entin

Pinned

Michael Entin

·

Jul 18, 2023

Index of posts

Index of my posts for easy reference

Michael Entin

·

Aug 14, 2025

Maps in BigQuery Studio

I’m happy to announce BigQuery now has visualization right in the BigQuery Studio.

Geography visualization in BigQuery Studio example

Michael Entin

·

Oct 11, 2024

Divide the query to improve cost and performance

Let’s take a look at a typical query where we search some spatial objects in some region. E.g. consider the first query in Dekart.xyz’s…

Divide the query to improve cost and performance

Michael Entin

·

Nov 3, 2023

Migrating Geospatial Data to BigQuery

A review of common hurdles one may stumble at when moving data from another system to BigQuery Geospatial.

Michael Entin

·

Jul 20, 2023

ST_Transform in BigQuery — Project Any Coordinates to Lng/Lat and Back

BigQuery only supports WGS84 geodesic coordinates, but my data is in another coordinate system. How can I convert it?

Michael Entin

·

Feb 26, 2023

Subdivide and Conquer Any Geometry

Let’s write a geospatial function that BigQuery does not currently provide: analogue of PostGIS’s ST_Subdivide. We’ll use SQL UDF, and…

Subdivide and Conquer Any Geometry

Michael Entin

·

Jan 8, 2023

Analyze Fitbit Exercise inBigQuery

How to upload and analyze Fitbit activity’s track data in BigQuery.

GeoViz visualization of the track

Michael Entin

·

Apr 19, 2022

Extra geography simplification in BigQuery

We had a discussion with a customer about BigQuery’s ST_Simplify that turned into a helper function I want to share. BigQuery has…

Michael Entin

·

Sep 27, 2021

BigQuery Geospatial query tricks

Today we’ll explore two useful tricks that came up during a discussion on how to implement some complex query.

In

Geospatial Analytics

by

Michael Entin

·

Sep 17, 2021

Squaring the sphere

Let’s talk about geographical bounding boxes.

Squaring the sphere

Michael Entin

Michael Entin

Hi, I'm TL of BigQuery Geospatial project. Posting small recipes and various notes for BQ Geospatial users.

Following

Help

Status

About

Careers

Press

Blog

Store

Privacy

Rules

Terms

Text to speech