GraphRAG on vehicle database for route selection

GraphRAG is a rising player in intelligent of domain specific databases. Current route suggestors are not equipped to meaningfully respond to abstract transit desires such as, “How can I most quickly get from Ocean Beach to a coffee shop near the Embarcadero BART station?”

This feature in my SFMTA MUNI App will require the creation of a database where bus stops are enriched by OpenStreetMap data and embedded in a way that indicates sequential order and connects everything to a route.

I will begin by simply addressing two routes: Judah-N and 38.

To assemble the database for this I will have to build profiles for each stop along each route.