1 / 26

Interactive Web-Based Mapping for Title VI Analysis and Public Transit System Data Management

Interactive Web-Based Mapping for Title VI Analysis and Public Transit System Data Management. Nicholas Lownes , PhD, PE October 16, 2013. Organization. Context Motivation t-HUB Application Example Looking forward. CONNECTICUT Population 3.5 million

verne
Download Presentation

Interactive Web-Based Mapping for Title VI Analysis and Public Transit System Data Management

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Interactive Web-Based Mapping for Title VI Analysis and Public Transit System Data Management Nicholas Lownes, PhD, PE October 16, 2013

  2. Organization • Context • Motivation • t-HUB • Application Example • Looking forward

  3. CONNECTICUT Population 3.5 million Land Area 5,500 mi2 (14,300 km2) SEATTLE METRO AREA Population 3.5 million Land Area 5,900 mi2 (14,400 km2) MINNEAPOLIS METRO AREA Population 3.4 million Land Area 6,300 mi2 (8,800 km2) MELBOURNE METRO AREA Population 4.2 million Land Area 3,400 mi2 (8,800 km2) SE QUEENSLAND METRO AREA Population 3.05 million Land Area 8,700 mi2 (22,400 km2)

  4. Connecticut’s 14 Regional Planning Organizations (RPOs) And their 18+ fixed route bus transit agencies…

  5. Direct and Primary report to FTA Title VI Reporting FTA Planning 5303 & 5304 UZA Formula 5307 Bus Fac./Good repair 5337, 5339 Enhanced Mob/Rural 5310 /5311 Large Operators Large RPOs DOT Transit Districts Depends Subrecipients Non-profits Small and Rural Operators/RPOs Towns Report to primary

  6. Connecticut is aging… …and Urbanizing

  7. Motivation Why is a university research team interested in Title VI compliance?

  8. Motivation • June 2011: Discussions with Transit Working Group • Title VI & data management pressing concerns • April 2012: Meeting with CTDOT Commissioner • August 2012: Begin t-HUB prototype development • November 2012: First Title VI workshop • Lectures, breakouts and survey to ID needs • February 2013: Second Title VI Workshop • t-HUB demo & feedback

  9. Why measure equity? • Quality of Life (Glaeser et al., 2009) • Higher crime rates in more unequal cities • Higher likelihood of political unrest and uprisings • People are more likely to report they are unhappy when living in more unequal cities • It’s the law • Title VI of the Civil Rights Act of 1964 • It is federal policy • Executive Order 12898 on Environmental Justice Signing of the Civil Rights Act 1964 (http://en.wikipedia.org/wiki/File:Lyndon_Johnson_signing_Civil_Rights_Act,_July_2,_1964.jpg)

  10. Title VI and network planning Source: HiTrans (2005)

  11. Value of Access • Cost of owning an additional vehicle: • $6,200/year (Bailey, 2007) • $8,000 – 10,000 K/year (AAA, 2013) • A “thrifty” family of four in the U.S. spends about $6,500 on food every year (USDA 2013)

  12. Equity in connectivity • LIHCO HH (Currie and Senbergs, 2007) • 2+ vehicles and $0-20K HH income • 3+ vehicles and $20-30K HH income. • Focus on urban core – reasonable expectation of transit service Note: Numbers on map represent aggregate number of LIHCO households in each block group for a total of 1,241

  13. Targeted access Low-income, high vehicle ownership households correlated to a lack of job access and late night service. Hart and Lownes (in press), Transportation Research Record

  14. t-HUB Vision: Statewide public transit system data hub Web Application User edit features Level the GIS playing field

  15. Connecticut Transport Data Hub (t-HUB) The Public Transport Network Emergency Response Title VI Rider Survey Data Active Transport Mgmt Public Health Land Use A web application for Connecticut transit planners, operators and analysts

  16. A multi-disciplinary team Public Transportation Systems Nicholas Lownes (CEE faculty) Kelly Bertolaccini (PhD student) SinaKahrobaei (MS student) Transportation Databases Eric Jackson (CTSRC Director) Timothy Becker (PhD student) Database design Dong-Guk Shin (CSE faculty) Timothy Becker (PhD student) GIS Development Jeffrey Osleeb (Geography faculty) Curtis Denton (PhD candidate) Michael Howser (Director, CTSDC)

  17. T-HUB architecture Source: Timothy Becker

  18. Agency • Agency • Fare Attributes • Fare ID • Routes • Agency • Route ID • Fare Rules • Contains • Destination Zone • Fare ID • •Origin Zone • Route ID • Trips • Block • Direction • Route ID • •Service ID • Shape ID • •Trip ID • Stop Times • Stop ID • Trip ID • Stops • Stop ID • •Zone • Shapes • Shape ID • Frequencies • Trip ID • Transfers • From stop ID • To stop ID • Calendar • Service ID • Days & Times • Calendar Dates • Service ID • Seasons/holidays GTFS File Structure Source: Curtis Denton

  19. t-HUB Tools Vision File_Tools GZIP, ZIP, CSV Reading & Writing Analysis_ Tools Quantifying Functions & Algorithms MSSQL drv,srv, uid,pwd, conn, SQL, V stats csv conn trans gzip exe seg zip close LEHD2 MSSQL mssql_conn lehd_files ACS5YR2 MSSQL mssql_conn acsfiveyr_files GTFS2 MSSQL mssql_conn gtfs_files

  20. Output

  21. Input parameters

  22. Identifying Minority-serving routes

  23. Identifying Low Income routes

  24. Identifying LEP-serving routes

  25. Looking ahead • O – D based accessibility metrics (TOI) • CTDOT Service Equity Analysis • Transit Service Analyses for RPOs • Real-time data incorporation • We will be at the poster session!

  26. Questions? Nick Lownes nlownes@engr.uconn.edu • Thank you to: • Center for Transportation and Livable Systems • New England University Transportation Center • Connecticut DOT • University of Connecticut

More Related