SFMTA speeding up mobility data using Talend Software and spatial ETL plugin from Disy

In tandem, they accelerate the processes for the various SFMTA services.

Around 800,000 people live in San Francisco, and almost 9.5 million people live in the Bay Area, on the West Coast of the USA. Every day, hundreds of thousands of residents and commuters coming into the city from the surrounding districts use the public transportation system and services of the San Francisco Municipal Transportation Agency (SFMTA). However, construction sites and disruptions are commonplace. To overcome these local obstacles in real life, the SFMTA works with a sophisticated data system. All the available data flows together in a so-called data lake. This includes data from the individual events (accidents, access to the individual means of transport, or temporary construction sites), but also location-specific data of individual stops, temporarily closed bus stops, and even the location of curbs that limit accessibility to the stops. Data about the behavior of passengers and residents is also included. This entire data management is operated by the software Talend Real-Time Big Data.

“Using GeoSpatial Integration for Talend from Disy, we are able to manage all data, including spatial data, in one single platform, Talend. We achieve much faster data processes, while reaching a higher data quality level.” Cheong-Tseng Eng, Data Services Manager at SFMTA.