1 of 18

Missouri Data & Knowledge Management Repository Project

Dr. Heath Pickerill

Missouri RTAP Manager

Missouri University of Science and Technology

2 of 18

Center Programs

Missouri Local Training & Resource Center (MLTRC)�Workforce & Professional Development Training

Rural Transit Assistance Program (RTAP)

Train rural transit providers on safety related topics
No cost trainings

Local Technical Assistance Program (LTAP)

Training city/county road crews on construction, �maintenance, safety, and technical topics
Low (or no) cost trainings

Community Resilience Workforce Development Program

New program under development

3 of 18

Missouri RTAP

April 2012 moved to Missouri S&T from Missouri DOT

Provide on-site delivery of transit driver training
Participate in National RTAP networking activities to make the RTAP Office more efficient and effective
Produce quarterly Missouri RTAP eNewsletter
Manage reimbursement to rural transit providers through the Scholarship Reimbursement Program
Provide technical assistance and technology transfer
Develop data & knowledge management repository for Missouri rural transit agencies

4 of 18

Transit Data Repository

Missouri RTAP Website & Data Tools

5 of 18

Missouri RTAP Data Repository

Data repository is being coordinated by the �Missouri RTAP staff and developed by ESX, Inc.

Part of Missouri Local Training and Resource Center’s (MLTRC) �online learning management system (LMS)

Purpose & Key Features:

Collect essential financial and service information �on each of the transit providers in Missouri
Web-based platform allow providers direct access to input data

help minimize the number of input errors and �extensive personnel hours to clear the errors

Providers can obtain analytical reports and operational statistics

Can be easily packaged and submitted FTA requirements

6 of 18

Missouri RTAP Data Repository

Primary information being gathered:

• Vehicle Data

Rosters, years in service, conditions mileage, �basic state of good repair (SGR), analysis data, etc.

Passenger Data

Yearly volumes, origin / destinations, payment types, trip purposes, pick up times / drop off times) and passengers per mile, hour, etc.

Funding and Finance Data

Source of funds, expenditures, budgets (capital/operating), etc.

Agency Information

Number of employees and breakdown of workforce, hourly �rates for operators, operator shortages per agency, etc.

7 of 18

Background Discovery

Met with the following agencies:

Kansas RTAP on Apr. 13, 2023
Florida’s DOT and RTAP on Apr. 28, 2023
Kansas DOT and Nebraska DOT on May 11, 2023
North Carolina DOT on May 15, 2023
North Carolina State University on June 1, 2023

8 of 18

Kansas & Nebraska DOTs

Kansas data repository initial discussion:

People can find transit provider in their area
Housed on KU website
Kansas did a feasibility study with KDOT
Moving to a trip planner
KDOT uses a Blackcat system

Nebraska trip planner initial discussion:

Trips.nebraskatransit.com
Started 5 years ago – �pilot planning started Q1 2022, pilot began 2023
CTFS Flex is state supported
Many smaller agencies do not have funding or expertise

9 of 18

Florida DOT

Florida trip planner initial discussion:

Program called Trancip – a version of Blackcat
Used for grant management, vehicle inventory, oversight
Agencies can access the system
Can generate reports but not very user friendly
North Carolina has a system they created and may be willing to share

10 of 18

NC State University

North Carolina data repository discussion:

Operations statistics (OP-STATS)

https://connect.ncdot.gov/business/transit/pages/OPSTATS.aspx

NC State developed the database for NCDOT
Covers much of what is in the NTTD report – �the workbook flows into the OP-STATS database
Started in 2004 & complete in 2006, NC State U houses the data
Trip Maker a part of the system
This system seems to be a great starting point!

Missouri RTAP was given the spreadsheet and database to work from

11 of 18

North Carolina�OP-STATS

Report Examples

12 of 18

North Carolina�OP-STATS

Report Examples

13 of 18

North Carolina�OP-STATS

Report Examples

14 of 18

Missouri Data Repository Timeline

15 of 18

MLTRC Website & Learning �Management System (LMS)

16 of 18

Website & LMS

Currently available

New website is “live”
Approximately 76 classes listed

Broken down by LTAP, RTAP, �Community Resilience, & soft skills
Virtual and in-person courses

Can register for classes online
Training request form
Training cancelation form

Current tasks

Online courses being developed

MLTRC Website Screenshot

17 of 18

Missouri RTAP Trainings

Active Shooter Prevention and Response
Aggressive Driving
Assault Awareness and Prevention for Transit Operators
Backing Safety
Basic First Aid
Bloodborne Pathogens
CPR (National Safety Council Course)
Dealing with Difficult Passengers
Defensive Driving
Distracted Driving
Diversity & Awareness Training
Driven to Extremes
Drug and Alcohol Awareness
Emergency and Evacuation Procedures
Fatigue Awareness for Drivers
HIPAA Training
Night Driving
Operation Lifesaver – Highway-Rail Crossing Safety
Passenger Assistance/Mobility Aid Securement
Reasonable Suspicion Training for Supervisors
Safe & Secure Proper Infant and Child Seat Installation
Sensitivity Awareness
Sexual Harassment
Slips, Trips, and Falls Prevention
Violence in the Transit Workplace - Prevention, Response and Recovery
Wheelchair Securement
Winter Driving Safety

18 of 18

Missouri RTAP Contacts

Dr. Heath A Pickerill

MLTRC/LTAP Director & �CArE Assistant Teaching Professor

pickerillh@mst.edu

573.341.7637

Ms. Patricia Diaku

Office Support Assistant

diakup@mst.edu

573.341.6155