Michael Entin – Medium

Michael Entin

Pinned

Index of posts

Index of my posts for easy reference

Jul 18, 2023

Jul 18, 2023

Divide the query to improve cost and performance

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

Oct 11

Divide the query to improve cost and performance

Oct 11

Migrating Geospatial Data to BigQuery

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

Nov 3, 2023

Nov 3, 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?

Jul 20, 2023

Jul 20, 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…

Feb 26, 2023

Subdivide and Conquer Any Geometry

Feb 26, 2023

Analyze Fitbit Exercise inBigQuery

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

Jan 8, 2023

GeoViz visualization of the track

Jan 8, 2023

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…

Apr 19, 2022

Apr 19, 2022

BigQuery Geospatial query tricks

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

Sep 27, 2021

Sep 27, 2021

Published in
Geospatial Analytics

Squaring the sphere

Let’s talk about geographical bounding boxes.

Sep 17, 2021

Squaring the sphere

Sep 17, 2021

HowTo: Group By Geography column

Let’s look at how to aggregate data by a geography column. BigQuery refuses to GROUP BY using geography, so let’s consider alternatives, …

May 21, 2021

May 21, 2021

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
Privacy
Terms
Text to speech
Teams