National Transit Database and Asset Inventory Module

1. National Transit Database and Asset Inventory Module Murtaza Naqvi Federal Transit Administration 18th Biennial State Programs Meeting and Public Transportation Partnerships Conference August 14-16, 2019

2. FY 2017 Rural Areas Program (5311) 1,327 rural transit providers • 1,196 rural general public operators among States/Territories • 131 Tribes (Tribal Transit Program) 288 urban providers of rural service • 222 providers receiving both 5307 and 5311 funds • 80 Intercity Bus providers Source: 2017 Agency Information

3. Counties Served by 5311 Reporters Source: 2017 Recipient Counties and Admin.

4. Growth In Rural Transit - Ridership

5. Active Vehicles by Year Built • Not pictured: • Two ferryboats, manufactured 1946 & 1963 • One bus, manufactured1967 • 83% built after 2007 • 48% built after 2011 Source: 2017 Revenue Vehicle Inventory

6. 5311 Funds Expended (Millions)

7. 2017 Rural Transit Funding – Capital and Operating Source: 2017 Funding Sources

8. 2017 Rural Transit Operating Funding Sources Source: 2017 Funding Sources

9. 2017 Rural Transit Capital Funding Sources Source: 2017 Funding Sources

10. Rural Ridership – Top States * In millions Source: 2017 NTD Rural Only Federal Funding Allocation

11. Rural vs. Urban Cost Effectiveness • Bus Operating $ per Vehicle Revenue Mile • Urban = $11.37/mile • Rural = $4.04/mile • Demand Response $ per ride (UPT) • Urban = $35.96/ride • Rural = $18.00/ride Source: 2017 Federal Funding Allocation

12. Rural Bus Operating Costs Rural Average $4.04 Source: 2017 Federal Funding Allocation (Rural and Tribes)

13. Rural DR Operating Costs Urban Average $37.75 Rural Average $18.00 Source: 2017 Federal Funding Allocation (Rural and Tribes)

14. Rural Safety Data Source: 2017 Safety Data

15. Rural Safety Data

16. Required in RY 2018 Expanded Asset inventory For State DOTs

17. Transit Asset Management (TAM) and NTD • State DOTs are required to sponsor a Group TAM Plan for all of their Chapter 53 funding subrecipients which are not 5307 beneficiaries. • The NTD Reporting System has been updated to accommodate Group TAM Plan reporting. • Recipients or subrecipients that receive Ch 53 funds outside of 49 U.S.C. §5307 and §5311 remain exempt from NTD reporting requirements unrelated to transit asset management.

18. Asset Inventory Modules

19. What is Reported to the NTD?

20. Capital Responsibility • An agency has direct capital responsibility for an asset if any of the following are true: • The agency owns the asset, • The agency jointly owns the asset with another entity, or • The agency is responsible for replacing, overhauling, refurbishing, or conducting major repairs on an asset, or the cost of those activities is itemized as a capital line item in the agency’s budget. • Performing minimal preventive maintenance work on an asset, like cleaning, does not in itself indicate direct capital responsibility for the asset. An agency must have direct capital responsibility or management or oversight responsibilities for the line item project.

21. TAM Performance Measures

22. TAM Phase-In Schedule

23. A-90 – Narrative Report • Required beginning Report Year 2019. • Outlines performance targets and progress towards those targets. • Includes changes in transit system conditions that affect progress towards targets. • No prescribed format. • Uploaded at the bottom of form A-90.

24. Group Plan Sponsor Responsibilities • Develop a group TAM plan for its Tier II provider subrecipients, except those subrecipients that are also direct recipients under the 49 U.S.C. 5307 Urbanized Area Formula Grant Program. • Comply with the requirements of this part for a TAM plan when developing a group TAM plan. • Coordinate the development of a group TAM plan with each participant’s Accountable Executive. • Make the completed group TAM plan available to all participants in a format that is easily accessible.

25. Role of Group TAM Plan Sponsors Outside of NTD Within NTD Completing the A-90 for the group plan Uploading the narrative report (required in RY2019) Completing report packages for all managed participants B-10, A-15, A-30, A-35 • Coordinate a Group Plan • Ensure all elements of their Group TAM Plan are complete • Subject to the 4 Elements of the TAM Plan • Asset Inventory • Condition Assessment • Decision Support Tools • Investment Prioritization

26. Group Plan Sponsor Report Identification (B-10) Transit Asset Management Performance Measure Targets (A-90)

27. TAM Implications for DOTs in NTD • All data will still be reported within the existing “Asset Module” of NTD (the “A” forms of each report package). • Introduces a new subrecipient type: Asset Only reporter • DOTs should manage asset forms for their participants.

28. Group TAM Plan Participant Responsibilities • A Tier II provider may participate in only one group TAM plan. • A Tier II provider must provide written notification to a sponsor if it chooses to opt-out of a group TAM plan. A provider that opts-out of a group TAM plan must either develop its own TAM plan or participate in another sponsor's group TAM plan. • A participant must provide a sponsor with any information that is necessary and relevant to the development of a group TAM plan.

29. TAM Plan Participant Types in NTD Managed Participants • For DOTs, these include all existing 5311 subrecipients as well as Ch 53 subrecipients previously not required to report to NTD. • Sponsors will complete forms on their behalf. • Asset only report contains forms A-15, A-30, A-35. Independent Participants • Currently submit data directly to NTD. • Tier II agencies that are choosing to be in a group plan • Sponsor will have view-only access to the asset forms. • Participant will report to NTD directly, as usual. • Sponsor only completes the A-90 Form on their behalf, can view other Asset forms.

30. Viewing Subrecipient Reports

31. Submitting the Report • Group Plan Sponsors CAN submit if: • All issues with managed participants have been resolved • Sponsor’s own annual forms have no open issues • Contact assigned validation analyst for assistance resolving any open item

32. How do you use data in your line of work? • What are some of the biggest reporting challenge? • What metrics best support the administration of state programs?

33. Recent NTD System Updates

34. New Asset Data • Expanded Asset Inventory • Mandatory with the 2018 NTD Report • Projected targets for the next fiscal year • First targets reported for 2019 with 2018 report • Condition assessments and performance results • First condition assessments and performance results were due with the 2018 NTD Report • Narrative on changes in transit system conditions and progress toward achieving previous performance targets • First narrative report is due with your 2019 NTD Report

35. NTD Functionality Improvements (RY18) • Update to A-30 Revenue Vehicles Form • Fleets can now be assigned to more than one mode • Data Upload/Download – • Agencies can now upload most forms using an excel template • Response to validation issues can be uploaded in bulk • Print Entire Report Package

36. Importing Data • Excel templates are available for all forms • Forms can be completed in excel then uploaded into the system

37. ImportingValidation Responses • Validation issue comments can be uploaded in bulk

38. Print Entire Report Package – Steps 1&2

39. Print Entire Report Package – Step 3 Select Report Package from Drop Down Click “Print” to create HTML copy

40. Print Entire Report Package – Step 4 • You will then need to wait a few minutes (3-5) and click on “Refresh” • The HTML file will then appear and can either: • Be viewed in the browser • Printed from the browser Click “Refresh” HTML Link

41. Upcoming NTD changes

42. Background • This notice proposes clarifications to NTD reporting guidance • Guidance clarifications are identified through: • Frequently asked questions from reporters • Direct reporter requests for changes or additional clarification • Validation analysts identifying gaps in documentation

43. FRN Information • Docket Number – FTA-2018-0010 • https://www.regulations.gov/document?D=FTA-2018-0010-0001 • Published on April 9, 2019 • Comment period ends on June 10, 2019 • Changes are proposed to be effective for report year 2019 beginning September 2019

44. Overview

45. Changes to the A-30 – Revenue Vehicles Form Proposal Overview: Agencies would check a box to indicate that a fleet is ‘automated’. Proposed definition would align with “level 4” of the SAE International standard - automated or autonomous vehicle: a vehicle that is capable of sensing its environment and navigating without human input.

46. Changes to the A-30 – Revenue Vehicles Form • Proposal Overview: • This proposal would require agencies to report the number of vehicles in each rail vehicle fleet that are equipped with the following: • Event data recorders based on IEEE 1482.1 standard • Emergency Lighting System Design based on APTA RT-S-VIM-20-10 standard • Emergency signage based on APTA RT-S-VIM-021-10 standard • Low-location Emergency Path Marking based on APTA RT-S-VIM-022-10 standard 

47. Changes to the A-20 – Special Track Work Categories • Proposal Overview: • After the optional Asset Inventory reporting year in 2017, FTA received several requests to adjust the special trackwork categories to better reflect the industry. In response, FTA is proposing removing one category, adding four new categories and renaming one category. Below is an overview of the changes: • Single Turnout – Keep Existing • Single Crossover – Keep Existing • Double Diamond Crossover – Rename as “Double Crossover” • Slip Switch (Single or Double) – New Category • Lapped Turnout – New Category • Single Crossing – New Category • Half Grand Union – Remove (would be reported as separate elements)

48. Changes to the D-10 – CEO Certification Proposal Overview: Proposal would include two yes/no check boxes for each mode for agencies to report the use of APCs. NTD analyst will record the date of the last APC certification approval.

49. Informative Item Changes to Safety Reporting Proposal Overview: Proposed definition of attempted suicide: self-inflicted harm where death does not occur, but the intention of the person was to cause a fatal outcome. The attempt and intent must be accounted for by a third party in the form of police reports, security personnel reports, or other eyewitness statements. This proposal further clarifies that an event where an individual is transported from transit property for mental health evaluation without a documented suicide attempt is not reportable as a Major Event. Rather, this type of event should be reported on the Non-Major Monthly Summary report.

50. Changes to Safety Reporting Proposal Overview: Agencies currently report vehicle type and manufacturer for vehicles involved in a Major Event. This change would link the asset inventory to the major event reporting and allow agencies to select the vehicle involved in a major event directly from their asset inventory. This would greatly improve the quality of the vehicle data available for analysis while minimizing the data entry.