Blog
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
Modeling a 40% budget increase w/ GTFS
Allocating new service based on routes by headway and trip runtime
Notes from challenges during parsing of AWS access logs
Regex conditionals and non-capturing groups for the win
RAPTOR algorithm with caching
Notes on suggested optimizations