Michael EntinDivide the query to improve cost and performanceLet’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 11Oct 11
Michael EntinMigrating Geospatial Data to BigQueryA review of common hurdles one may stumble at when moving data from another system to BigQuery Geospatial.Nov 3, 20231Nov 3, 20231
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?Jul 20, 2023Jul 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…Feb 26, 2023Feb 26, 2023
Michael EntinAnalyze Fitbit Exercise inBigQueryHow to upload and analyze Fitbit activity’s track data in BigQuery.Jan 8, 2023Jan 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…Apr 19, 20222Apr 19, 20222
Michael EntinBigQuery Geospatial query tricksToday we’ll explore two useful tricks that came up during a discussion on how to implement some complex query.Sep 27, 20213Sep 27, 20213
Michael EntininGeospatial AnalyticsSquaring the sphereLet’s talk about geographical bounding boxes.Sep 17, 20212Sep 17, 20212
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, …May 21, 20212May 21, 20212