Blog
Full stack map control
Self-service tiling and webmap app from Github Pages
Fast de/serialization with numerical arrays
Efficiently pass through lists of floats between languages via Redis
Simultaneously explode multiple array cells in SQL
Trino/Presto pattern for row-wise expansion of multiple grouped arrays with UNNEST
Trino/Presto spherical distance capabilities
AWS Engine V3 now supports full Trino geospatial functions from coordinate data
Running Selenium on AWS Lambda
Lambda supports custom Docker images but container behavior is inconsistent on AWS infra
Upcoming transit stop arrivals data parsing
Merging static and real time GTFS data for upcoming stop arrivals insights
Calculating turn angles
Notes on how to determine turn direction
More efficient spatial intersection in Spark
A poor man's R-tree spatial index solution