02 / Data Engineering / Data Analytics / May 2026
ChronoRoute
Geospatial analytics dashboard for NYC taxi and ride-hailing data using DuckDB-WASM, static Gold artifacts, Deck.gl, and MapLibre.
01
Overview
ChronoRoute is an end-to-end geospatial analytics platform for NYC taxi and ride-hailing records.
02
Challenge
The challenge was avoiding unnecessary backend infrastructure while still supporting analytical exploration over millions of raw records.
03
Outcome
The result is a public analytics product with no dedicated query backend: static deployment, prepared data files, and SQL running locally where users interact with the map.
Project background
Why this project exists
ChronoRoute started from an architectural question: if the data is already precomputed and safe to publish, does a dashboard really need a dedicated query backend? The project explores that question through NYC TLC taxi and ride-hailing records.
The system combines a batch data engineering pipeline with a static React dashboard. Gold-layer artifacts are served as files, then queried directly in the browser with DuckDB-WASM. Deck.gl and MapLibre turn those query results into a geospatial exploration experience.
Build notes
How it was shaped
Processed raw NYC TLC records through a batch pipeline into Gold-layer dashboard artifacts.
Served compact Parquet and JSON files as static assets for browser-side querying.
Used DuckDB-WASM for client-side SQL and Deck.gl/MapLibre for geospatial visual exploration.