Selected work
A transportation analytics platform that combines a high-performance crash-data API, Snowflake-backed reporting, and a modern mapping-heavy frontend.
Project work by Daniel Kennedy at DK Logics, a software development and technology consulting business based in Rhode Island.
TForce V2 splits the system cleanly between a .NET 9 analytics API and a React 19 + Vite frontend built for geospatial exploration, filtering, and operational reporting around crash and inspection data.
Make crash and inspection data usable for map-based exploration and operational reporting, rather than leaving it in separate datasets.
Separate the analytics API from the mapping interface. Load reporting data from Snowflake, cache it for API access, and refresh it through background jobs.
A transportation analytics application with interactive maps, spatial overlays, filtering, and dashboard workflows backed by a dedicated data API.
What this involved
Backend services load crash and inspection datasets from Snowflake views into an in-memory cache, then expose fast API endpoints for dashboard and map workflows.
The service layer includes background refresh jobs, reference-data services, and auth handling for portal-style access instead of a thin CRUD wrapper.
The frontend uses React, TypeScript, Vite, MapLibre GL, and deck.gl to support interactive map rendering, spatial data overlays, and analytics-oriented user flows.
Capabilities shown
Technology stack