Page 1

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