Home

Awesome

<p align="center"> <img src="public/images/site-logo.png" width="400"/> </p>

Transit Resilience for Essential Commuting (TREC)

<p align="center"> <img src="public/images/TREC_screenshot.png" width="800"/> </p>

In the fall of 2022, Data Clinic took part in The Opportunity Project, a semi-annual sprint organized by the U.S. Census in partnership with federal agencies to demonstrate the value of open data, as part of the Building Climate Change Resilience Through Public Transit sprint sponsored by the U.S. Department of Transportation.

Across our many conversations with transit officials, researchers, and community organizers from across the country about the climate-related challenges and opportunities transportation systems face, a recurring theme was the desire to enable a better understanding of climate's intersectional impact on both transit and communities. In other words, a flooded bus stop doesn't just mean that the bus and passengers can't access the stop, but it may also impede access to a hospital or community support, or to a large amount of essential jobs. How can we share that insight more effectively?

In response, we built Transit Resilience for Essential Commuting (TREC), an open source tool that allows users to efficiently assess the climate risk for transit stations within the context of the access it provides to vital services and regions. Initially focused on flooding, the most prevalent climate event facing transit officials across the country, and access to hospital and jobs, TREC allows users to explore our open data-derived, station-specific risk and access ratings, and easily filter those with the highest climate risk and highest importance for access.

Our hope is that this human-centered and geospatial approach to the intersectional impact of climate change on transit and communities will give transit planners a more holistic picture to inform their infrastructure improvement decision-making. Further, we hope that making localized climate resilience tools like this open source, user-friendly, and publicly available, will empower community organizations to advocate for their underserved constituents.

The climate crisis we face requires collective intelligence and creative problem solving, and democratizing access to these kinds of tools will be crucial in making progress.

Processed Data Files

Our app relies on two data files that we process using the data sources (listed below).

Derived Metrics Data Dictionary

VariableDescriptionTypeLicenseSource
stop_idGTFS feed stop idstrApache 2.0GTFS Feeds
stop_nameGTFS feed stop namesstrApache 2.0GTFS Feeds
routes_servicedList of all routes servicing a stoplistApache 2.0GTFS Feeds
climate_risk_categoryScore 0/1/2 indicating low/medium/high climate risk around transit stopintCC BY-NC-SA 4.0First Street Climate-Adjusted Flood Risk,<br>GTFS Feeds
hospital_access_cateogoryScore 0/1/2 indicating low/medium/high hospital access from transit stopintApache 2.0Geographic Names Information System National File 2021,<br>GTFS Feeds
job_access_categoryScore 0/1/2 indicating low/medium/high number of jobs around transit stopintApache 2.0LEHD Origin-Destination Statistics,<br>GTFS Feeds
vulnerable_worker_categoryScore 0/1/2 indicating low/medium/high vulnerability of people working around transit stopintApache 2.0LEHD Origin-Destination Statistics,<br>OpenStreetMap,<br>CDC/ATSDR Social Vulnerability Index,<br>GTFS Feeds
geometryLatitude/longitude point location of stopwktApache 2.0GTFS Feeds

Contributing

To contribute to this project, refer to more details on

You can also submit Bug reports or Feature requests with Github issues using the respective templates.

To discuss tailored adaptations of TREC to your team/city, please email us at dataclinic@twosigma.com

Data Sources

All data accessed as of June 26th, 2023.

For list of GTFS feeds used and ther respective terms, refer to the file.

Data Clinic

Data Clinic is the data and tech-for-good arm of Two Sigma, a financial sciences company headquartered in NYC. Since Data Clinic was founded in 2014, we have provided pro bono data science and engineering support to mission-driven organizations around the world via close partnerships that pair Two Sigma's talent and way of thinking with our partner's rich content-area expertise. To scale the solutions and insights Data Clinic has gathered over the years, and to contribute to the democratization of data, we also engage in the development of open source tooling and data products.