RES2016-23: GIS Legacy Database (Phase III)

TDOT has embarked on an initiative to develop data analytics and visualization capabilities using the Microsoft Power BI platform to serve the agency’s needs. Critical to the success of this initiative is the ability to identify, develop and serve a range of applications across TDOT’s various divisions, covering a variety of operating modes within the state. However, to date only a few Power BI applications have been developed by agency staff, largely due to the lack of opportunity to design, develop and implement Power BI in ways that leverage information that TDOT obtains and manages. As a result, there are missed opportunities associated with performing both basic and comprehensive data analytics that become possible once TDOT staff become more aware and proficient in the use of Power BI. The objective of this project was to create Power BI applications that enable more informed decision-making by TDOT in providing safe, secure, efficient and environmentally-friendly passenger and freight transport. This was accomplished by working in collaboration with TDOT staff to conceive, develop and implement Power BI applications for various TDOT divisions. An added goal of this research was to help mainstream the use of Power BI across the organization by providing the necessary knowledge, skills and experience to TDOT staff in support of workforce development. This report contains a description of the following Power BI applications that were developed as part of this project. The Tennessee Crash and Safety Analytics Tool (TCAST) can be used to facilitate comprehensive safety analyses for Tennessee roadways. The Tennessee Pavement Analytics Tool (TPAT) enables users to explore the impact of pavement projects on roadway safety for Tennessee roadways.

• Record URL:
  https://www.tn.gov/content/dam/tn/tdot/long-range-planning/research/researchsummary/res2016-research-summaries/RES2016-23%20Summary.pdf
• Record URL:
  https://www.tn.gov/content/dam/tn/tdot/long-range-planning/research/final-reports/res2016-final-reports/RES2016-23_Phase3_Final_Report_Approved.pdf

Language

• English

Project

• Status: Completed
• Funding: $239995
• Contract Numbers:

  RES2016-23

• Sponsor Organizations:

  Tennessee Department of Transportation

  James K. Polk Building
  Fifth and Deaderick Street
  Nashville, TN  United States  37243-0349
• Managing Organizations:

  Tennessee Department of Transportation

  James K. Polk Building
  Fifth and Deaderick Street
  Nashville, TN  United States  37243-0349
• Performing Organizations:

  Vanderbilt University

  Box 96-B
  Nashville, TN  United States  37235
• Principal Investigators:

  Abkowitz, Mark

• Start Date: 20200301
• Expected Completion Date: 20220831
• Actual Completion Date: 20221001
• USDOT Program: Transportation, Planning, Research, and Development

Subject/Index Terms

• TRT Terms: Data quality; Databases; Geographic information systems; Infrastructure; Operations
• Identifier Terms: Tennessee Department of Transportation
• Subject Areas: Data and Information Technology; Highways; Operations and Traffic Management;

Filing Info

• Accession Number: 01832136
• Record Type: Research project
• Source Agency: Tennessee Department of Transportation
• Contract Numbers: RES2016-23
• Files: RIP, STATEDOT
• Created Date: Dec 29 2021 7:47PM