Office of Operations
21st Century Operations Using 21st Century Technologies
Table of Contents

U.S. Department of Transportation Roadway Transportation Data Business Plan (Phase 3): Data Business Plan Development for State and Local Departments of Transportation

Appendix D. Example Stakeholder Survey

Survey Introduction

Imagine a world where mobility data is easily accessible and ready to be analyzed in a user-friendly manner, and where there is ongoing collaboration with no waste of resources or duplicative efforts. Though it might sound like Utopia, we can get closer to that goal by implementing a data business plan to improve the way we manage and govern mobility data in our region.

With this effort, <Agency Name> seeks to develop an actionable plan for improving our data management practices. The plan will focus on mobility data sets and data systems that support performance measurement for our region. An initial step is to gather information on current data management practices for these datasets, including the way data is collected, stored, accessed, used, and governed. This is a shared effort and we hope you can participate in the process by responding to the survey below by <DATE>.

We appreciate your input!

Organizational Questions:

  1. Please identify the organization under which you are employed, and what your title is.
    1. Name: <text box>
    2. Division: <text box>
    3. Title: <text box>
    4. Email: <text box>
  2. What mobility datasets does your division directly collect, develop, maintain, or use? For the purposes of this study, mobility data is defined as volume, speed, VMT, and operational performance data for vehicle, freight, bicycle/pedestrian, and transit modes.
    1. Bicycle volume
    2. Pedestrian volume
    3. Bike/Pedestrian other—please specify
    4. Transit On-time arrival
    5. Transit Ridership
    6. Transit Speed or travel time
    7. Transit Other—please specify
    8. Vehicular Speed or travel time
    9. Vehicular volume
    10. VMT
    11. Incident/crash data
    12. Vehicular other—please specify
    13. Freight Speed or travel time
    14. Freight volume
    15. Freight other—please specify

    <IF none are selected, respondent will be sent to DATA COLLABORATION (q. 19)>

Questions 3—16 will appear for each of the data types
  1. What is your role with respect to [data type]? (select all that apply)
    No Value I am responsible for collecting or updating the data I use and/or analyze the data I generate metadata and/or resolve data quality issues I am an IT professional responsible for technical application I am an administrator and/or designer for databases and systems Other (please specify)
    Bicycle volume Unchecked. Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Pedestrian volume Unchecked. Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Bike/Ped Other Unchecked. Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Transit On-time arrival Unchecked. Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Transit Ridership Unchecked. Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Transit Speed or travel time Unchecked. Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Transit Other Unchecked. Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Vehicular Speed or travel time Unchecked. Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Vehicular volume Unchecked. Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    VMT Unchecked. Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Incident/crash data Unchecked. Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Vehicular other Unchecked. Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Freight Speed or travel time Unchecked. Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Freight volume Unchecked. Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Freight other Unchecked. Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.

Data Collection

  1. Who collects the data? (Check all that apply)
    No Value We collect it internally (please specify) We obtain it from another agency (please specify) We purchase it from vendors (please specify) Other (please specify)
    Bicycle volume Unchecked. Unchecked. Unchecked. Unchecked.
    Pedestrian volume Unchecked. Unchecked. Unchecked. Unchecked.
    Bike/Ped Other Unchecked. Unchecked. Unchecked. Unchecked.
    Transit On-time arrival Unchecked. Unchecked. Unchecked. Unchecked.
    Transit Ridership Unchecked. Unchecked. Unchecked. Unchecked.
    Transit Speed or travel time Unchecked. Unchecked. Unchecked. Unchecked.
    Transit Other Unchecked. Unchecked. Unchecked. Unchecked.
    Vehicular Speed or travel time Unchecked. Unchecked. Unchecked. Unchecked.
    Vehicular volume Unchecked. Unchecked. Unchecked. Unchecked.
    VMT Unchecked. Unchecked. Unchecked. Unchecked.
    Incident/crash data Unchecked. Unchecked. Unchecked. Unchecked.
    Vehicular other Unchecked. Unchecked. Unchecked. Unchecked.
    Freight Speed or travel time Unchecked. Unchecked. Unchecked. Unchecked.
    Freight volume Unchecked. Unchecked. Unchecked. Unchecked.
    Freight other Unchecked. Unchecked. Unchecked. Unchecked.

  2. On what network?
    No Value Freeways Highways Arterials Other (please specify) [for bike/ped only] trails (please specify)
    Bicycle volume Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Pedestrian volume Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Bike/Ped Other Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Transit On-time arrival Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Transit Ridership Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Transit Speed or travel time Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Transit Other Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Vehicular Speed or travel time Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Vehicular volume Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    VMT Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Incident/crash data Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Vehicular other Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Freight Speed or travel time Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Freight volume Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Freight other Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.

  3. On what geographic boundary? (e.g., Johnson County)
    Bicycle volume Empty long box for writing in.
    Pedestrian volume Empty long box for writing in.
    Bike/Ped Other Empty long box for writing in.
    Transit On-time arrival Empty long box for writing in.
    Transit Ridership Empty long box for writing in.
    Transit Speed or travel time Empty long box for writing in.
    Transit Other Empty long box for writing in.
    Vehicular Speed or travel time Empty long box for writing in.
    Vehicular volume Empty long box for writing in.
    VMT Empty long box for writing in.
    Incident/crash data Empty long box for writing in.
    Vehicular other Empty long box for writing in.
    Freight Speed or travel time Empty long box for writing in.
    Freight volume Empty long box for writing in.
    Freight other Empty long box for writing in.

  4. Are data collection standards in place for the data?
    No Value Yes If yes, are they adequate? No I don't know
    Bicycle volume Unchecked. Yes/No Unchecked. Unchecked.
    Pedestrian volume Unchecked. Yes/No Unchecked. Unchecked.
    Bike/Ped Other Unchecked. Yes/No Unchecked. Unchecked.
    Transit On-time arrival Unchecked. Yes/No Unchecked. Unchecked.
    Transit Ridership Unchecked. Yes/No Unchecked. Unchecked.
    Transit Speed or travel time Unchecked. Yes/No Unchecked. Unchecked.
    Transit Other Unchecked. Yes/No Unchecked. Unchecked.
    Vehicular Speed or travel time Unchecked. Yes/No Unchecked. Unchecked.
    Vehicular volume Unchecked. Yes/No Unchecked. Unchecked.
    VMT Unchecked. Yes/No Unchecked. Unchecked.
    Incident/crash data Unchecked. Yes/No Unchecked. Unchecked.
    Vehicular other Unchecked. Yes/No Unchecked. Unchecked.
    Freight Speed or travel time Unchecked. Yes/No Unchecked. Unchecked.
    Freight volume Unchecked. Yes/No Unchecked. Unchecked.
    Freight other Unchecked. Yes/No Unchecked. Unchecked.

  5. What steps can be taken to improve the quality of the data?
    Bicycle volume Empty long box for writing in.
    Pedestrian volume Empty long box for writing in.
    Bike/Ped Other Empty long box for writing in.
    Transit On-time arrival Empty long box for writing in.
    Transit Ridership Empty long box for writing in.
    Transit Speed or travel time Empty long box for writing in.
    Transit Other Empty long box for writing in.
    Vehicular Speed or travel time Empty long box for writing in.
    Vehicular volume Empty long box for writing in.
    VMT Empty long box for writing in.
    Incident/crash data Empty long box for writing in.
    Vehicular other Empty long box for writing in.
    Freight Speed or travel time Empty long box for writing in.
    Freight volume Empty long box for writing in.
    Freight other Empty long box for writing in.

  6. Are these data redundant with any other data system, or are there any issues with multiple sources for the same data?
    1. Yes (please specify)
    2. No
    3. I don't know

Data Storage and Access

  1. Where are the data stored? (PC, server, data warehouse, legacy system)
    No Value On individual personal computers On a server within our organization/division In a data warehouse or database management system such as Oracle or Microsoft SQL server In a specialized software application or legacy mainframe data system Other (please specify)
    Bicycle volume Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Pedestrian volume Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Bike/Ped Other Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Transit On-time arrival Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Transit Ridership Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Transit Speed or travel time Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Transit Other Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Vehicular Speed or travel time Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Vehicular volume Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    VMT Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Incident/crash data Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Vehicular other Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Freight Speed or travel time Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Freight volume Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Freight other Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.

  2. Is the database linked to data in any other data system?
    Bicycle volume Yes/No/I don't know
    Pedestrian volume Yes/No/I don't know
    Bike/Ped Other Yes/No/I don't know
    Transit On-time arrival Yes/No/I don't know
    Transit Ridership Yes/No/I don't know
    Transit Speed or travel time Yes/No/I don't know
    Transit Other Yes/No/I don't know
    Vehicular Speed or travel time Yes/No/I don't know
    Vehicular volume Yes/No/I don't know
    VMT Yes/No/I don't know
    Incident/crash data Yes/No/I don't know
    Vehicular other Yes/No/I don't know
    Freight Speed or travel time Yes/No/I don't know
    Freight volume Yes/No/I don't know
    Freight other Yes/No/I don't know

Data Access and Use

  1. Please indicate with whom is this data shared or made available to:
    No Value Other divisions/business units within my organization (please specify) Other external organizations (please specify) General public We currently do not share this with anyone
    Bicycle volume Unchecked. Unchecked. Unchecked. Unchecked.
    Pedestrian volume Unchecked. Unchecked. Unchecked. Unchecked.
    Bike/Ped Other Unchecked. Unchecked. Unchecked. Unchecked.
    Transit On-time arrival Unchecked. Unchecked. Unchecked. Unchecked.
    Transit Ridership Unchecked. Unchecked. Unchecked. Unchecked.
    Transit Speed or travel time Unchecked. Unchecked. Unchecked. Unchecked.
    Transit Other Unchecked. Unchecked. Unchecked. Unchecked.
    Vehicular Speed or travel time Unchecked. Unchecked. Unchecked. Unchecked.
    Vehicular volume Unchecked. Unchecked. Unchecked. Unchecked.
    VMT Unchecked. Unchecked. Unchecked. Unchecked.
    Incident/crash data Unchecked. Unchecked. Unchecked. Unchecked.
    Vehicular other Unchecked. Unchecked. Unchecked. Unchecked.
    Freight Speed or travel time Unchecked. Unchecked. Unchecked. Unchecked.
    Freight volume Unchecked. Unchecked. Unchecked. Unchecked.
    Freight other Unchecked. Unchecked. Unchecked. Unchecked.

  2. In what format are the databases shared with other entities?
    No Value Copies of the raw database Summary tabulations Periodic reports Other (please specify) Not applicable
    Bicycle volume Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Pedestrian volume Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Bike/Ped Other Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Transit On-time arrival Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Transit Ridership Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Transit Speed or travel time Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Transit Other Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Vehicular Speed or travel time Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Vehicular volume Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    VMT Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Incident/crash data Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Vehicular other Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Freight Speed or travel time Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Freight volume Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.
    Freight other Unchecked. Unchecked. Unchecked. Unchecked. Unchecked.

  3. What are obstacles to sharing this data with other entities?
    No Value Proprietary restrictions (please specify) Data sharing platform (please specify) Other (please specify) Not applicable
    Bicycle volume Unchecked. Unchecked. Unchecked. Unchecked.
    Pedestrian volume Unchecked. Unchecked. Unchecked. Unchecked.
    Bike/Ped Other Unchecked. Unchecked. Unchecked. Unchecked.
    Transit On-time arrival Unchecked. Unchecked. Unchecked. Unchecked.
    Transit Ridership Unchecked. Unchecked. Unchecked. Unchecked.
    Transit Speed or travel time Unchecked. Unchecked. Unchecked. Unchecked.
    Transit Other Unchecked. Unchecked. Unchecked. Unchecked.
    Vehicular Speed or travel time Unchecked. Unchecked. Unchecked. Unchecked.
    Vehicular volume Unchecked. Unchecked. Unchecked. Unchecked.
    VMT Unchecked. Unchecked. Unchecked. Unchecked.
    Incident/crash data Unchecked. Unchecked. Unchecked. Unchecked.
    Vehicular other Unchecked. Unchecked. Unchecked. Unchecked.
    Freight Speed or travel time Unchecked. Unchecked. Unchecked. Unchecked.
    Freight volume Unchecked. Unchecked. Unchecked. Unchecked.
    Freight other Unchecked. Unchecked. Unchecked. Unchecked.

Data Documentation

  1. What documentation of the database or data system currently exists?
    1. <text box for each data type>
  2. What additional documentation would be helpful, both for yourself and for users of the data?
    1. <text box for each data type>

Questions 17—22 appear only once

  1. Which of the following types of improvements would you like to see for mobility data? Please rank them in priority order, with 1 being the most important and 5 being the least important.
    1. A "one stop shop" for all mobility data instead of data storage on multiple network connections.
    2. A Web-based system where users can search, view, and query up-to-date data.
    3. Data dictionaries or "how to use this data" directions associated with all data.
    4. Better data quality (please specify)
    5. Other (please specify)
  2. What significant changes are planned for the data systems you work with? Include changes in data collection, dissemination, data uses, or storage of the data.
    1. <text box>

Data Governance & Collaboration

  1. Are data management responsibilities formalized and documented as part of job descriptions or standard operating procedures within your organization/division?
    1. Yes (please specify)
    2. No
    3. I don't know
    4. Not applicable
  2. Is there a formal structure for managing and governing the data? This could include formally defined roles and responsibilities, formation of a data governance council, or development of a data governance manual and data catalog.
    1. Yes (please specify)
    2. No
    3. I don't know
    4. Not applicable
      1. If no, would setting one be helpful?
  3. Do you collaborate with other organizations in the region on other topics? (e.g., sharing Requests for Proposals (RFPs) for current and upcoming initiatives, procurement plans, program roadmaps, vision/objective documents, sharing of current initiatives, activities, and best practices related to specific types of mobility data)
    1. Yes (please specify)
    2. No
      1. If yes, how does collaboration take place?
  4. Please indicate any additional comments that would help us understand your current data management practices or needs. For instance, are there aspects of agency culture that need to be changed? Are there untapped opportunities for collaboration with other divisions or organizations that you are aware of? Are there opportunities for automation that could make data management easier?
    1. <text box>

Thank you Page

Thank you for taking this survey. Your input will be crucial in developing an effective and relevant Data Business Plan!

Office of Operations