AI Data Platform Series: Gold Layer Vehicle Movements
This is the seventh post in the AI Data Platform series. The previous post built tfl.gold.arrivals_board, a live view of the next buses at every stop, and connected it to Oracle Analytics Cloud. What it couldn't do was say where anything is: TfL's arrivals feed carries stop IDs and names, but no coordinates. This post adds them. First a reference table with the location of every stop on every bus line, then an estimate of where each bus on line 25 actually is right now, drawn along the real road it drives on.
