Michael EntinMigrating Geospatial Data to BigQueryA review of common hurdles one may stumble at when moving data from another system to BigQuery Geospatial.5 min read·Nov 3, 2023--1--1
Michael EntinST_Transform in BigQuery — Project Any Coordinates to Lng/Lat and BackBigQuery only supports WGS84 geodesic coordinates, but my data is in another coordinate system. How can I convert it?2 min read·Jul 20, 2023----
Michael EntinSubdivide and Conquer Any GeometryLet’s write a geospatial function that BigQuery does not currently provide: analogue of PostGIS’s ST_Subdivide. We’ll use SQL UDF, and…4 min read·Feb 26, 2023----
Michael EntinAnalyze Fitbit Exercise inBigQueryHow to upload and analyze Fitbit activity’s track data in BigQuery.3 min read·Jan 8, 2023----
Michael EntinExtra geography simplification in BigQueryWe had a discussion with a customer about BigQuery’s ST_Simplify that turned into a helper function I want to share. BigQuery has…2 min read·Apr 19, 2022--2--2
Michael EntinBigQuery Geospatial query tricksToday we’ll explore two useful tricks that came up during a discussion on how to implement some complex query.3 min read·Sep 27, 2021--3--3
Michael EntininGeospatial AnalyticsSquaring the sphereLet’s talk about geographical bounding boxes.4 min read·Sep 17, 2021--2--2
Michael EntinHowTo: Group By Geography columnLet’s look at how to aggregate data by a geography column. BigQuery refuses to GROUP BY using geography, so let’s consider alternatives, …3 min read·May 21, 2021--2--2
Michael EntinBigQuery geospatial visualization: more options, more dataBigQuery geospatial visualization story has been updated with important features.3 min read·May 7, 2021----