Project Tracker, Reports, & Applications

1. Project Tracker, Reports, & Applications Michael Chamberlain – TPP, Data Management November 17, 2017

2. Table of contents 1 Data Management 3 2 Project Tracker 4 - 11 3 Reports 12 4 Applications 13 5 Statewide Planning Map 14 6 Open Data Portal 15 7 Closing 16

3. Data Management • Mapping Branch – Chris Bardash • GIS linework (313,656 miles of measured linework) • City Streets • County Roads • State Highways • Base Map layers • Administrative Boundaries (City, MPO, County, Maintenance) • Railroad Lines • Cemeteries • County Road Inventory • Statewide Planning Map • Open Data Portal • Project Tracker • ArcGIS Online • Statewide GIS Coordination • Roadway Inventory Branch – David Freidenfeld • Geo-spatial Roadway Inventory Database (GRID) • Training/User Management • Enhancements and Testing • Highway Performance Monitoring System (HPMS) • Annual Reports • Functional Classification • National Highway System • Texas Trunk • Urbanized Areas • Highway Designations (Minute Orders) • Statewide Roadway Inventory Coordination

4. Project Tracker • Why does Project Tracker Exist • When Senate Bill 1420 passed in 2011 during the 82nd Legislative Session, the intent was for the Texas Department of Transportation (TxDOT) to become a more accountable, informative, and transparent agency. To achieve this goal, TxDOT created Project Tracker, a website for the general public and stakeholders to track TxDOT transportation projects. • Where does Project Tracker get Data • Design and Construction Information System (DCIS) • Primavera (P6) • Site Manager • PeopleSoft • ArcGIS Online (AGO) • *** If data is incorrect in Project Tracker it’s also incorrect in the parent system *** • Key Points • Project scores and locations are updated weekly • Control Section Job based (CSJ, not CCSJ) • 12,000+ Projects in the system • Available to the public

5. Project Tracker • How do you Get to Project Tracker • The hard way • TxDOT.gov…..Inside TxDOT…..Projects…..Project Tracker • Secret coded Project Tracker link in the Looking for These? section on the main page of TxDOT.gov • The easy way • www.txdot.gov/pt • Google it • Search for TxDOT Project Tracker • How the App Works • Pick a Category • Pick an Area, Highway, or Project ID • Click on a project from the table or map for more information • Help Me • We prepared a user guide to help explain terms, process and detail about Project Tracker. Project Tracker Help

6. Project Tracker • Simple Start • Clean map (without projects) • Search by Area, Highway, or Project ID

7. Project Tracker • Second Dropdown • Select Area Name, Highway Number, or Project ID

8. Project Tracker • Search Results • Table • Filtering • Sorting

9. Project Tracker • Search Results • Map • Project Linework • Project Details • Demonstration • Project Tracker

10. Project Tracker • Surveys and Focus Groups • The Project Tracker team conducted surveys and focus groups to better understand what users wanted from Project Tracker. The team used your input to create the next version of project tracker. • Survey Responses • 1,759 Employees • 567 External • Results (similar breakdown for internal and external) • 66% of respondents never heard of Project Tracker • Overall ratings from respondents that used Project Tracker (about 800) • Very Poor 2% • Poor 9% • Fair 33% • Good 45% • Excellent 11% • Focus Groups • Hands on exercises using Project Tracker were conducted in Abilene, Fort Worth, Houston, San Marcos, El Paso, Corpus Christi

11. Project Tracker Key Improvements

12. Reports • Attributes and Locations Summarized • At the end of the reporting year, we summarize the full body of attributes and location information into a series of reports. These reports are made available on TxDOT.gov and are the basis for all inventory related public information requests and statewide analysis within the next data year. The federal reporting deadline is June 15th. • Standard Reports • Highway Performance Monitoring System (HPMS), key ingredient for motor fuel tax reimbursements from FHWA • Annual Reports (PDF and GIS Version) • Multi-Year Roadway Data Tables (Excel Version) • County Road Inventory • Interesting Facts for 2016 Annual Reports

13. Applications • Applications allow users to visualize and query Attributes, Locations, and Systems • Think of applications as the finish line. All the work by Districts and TPP – Data Management maintaining the roadway inventory attributes, locations, and systems is put to use in applications. • Applications Available to the Public: • Statewide Planning Map • Open Data Portal

14. Applications - Statewide Planning Map Statewide Planning Map

15. Applications – Open Data Portal Open Data Portal Think of the Open Data Portal as a Card Catalog. Direct access to services, data, and metadata.

16. Closing • Important Links (you should know these by heart) • Statewide Planning Map • Open Data Portal • Annual Reports • ArcGIS Online • Project Tracker Email Contacts GIS: TPP-GIS@TxDOT.gov Roadway Inventory: GRID@TxDOT.gov Project Tracker: Project.Tracker@TxDOT.gov Michael.Chamberlain@txdot.gov Phone (my direct line) 512.486.5054 Thanks for your time!