Data Integration and Partnership for Statewide Transportation Planning

The goal of this study was to investigate the data availability, accessibility, and interoperability issues arisen from the statewide transportation planning activities undertaken at the Wisconsin Department of Transportation (WisDOT) and to identify possible approaches for addressing these issues. A survey and a series of interviews were conducted with data users (planners) to identify current data use practices and the issues encountered when dealing with WisDOT-owned and non-WisDOT-owned datasets. Interviews were also conducted with data custodians and IT support staff to obtain information regarding the collection, maintenance and updating of frequently used planning data. The interview process confirmed some of the survey findings but also revealed differing views and data users’ misconceptions of the availability and quality of planning data. The information collected about existing datasets was used to develop a catalog of planning data (with a focus on nonhighway data) and a series of data flow diagrams to help documenting and informing data users of existing datasets. Based on the findings through the various stages of this project, five recommendations were generated to help WisDOT in addressing the data challenges and opportunities relating to transportation planning: (1) information dissemination, (2) centralized data platform, (3) designated data coordinator, (4) data access tool for long range planning, and (5) data standardization. Information dissemination and centralized data platform are the low-hanging fruit that would address several data challenges with a relatively short timeframe. The remaining three recommendations require more financial and time investment and also stronger agency commitment to changing the current business practices. However, they are expected to yield high benefits in the long term.

  • Corporate Authors:

    University of Wisconsin, Madison

    Department of Civil and Environmental Engineering
    1415 Engineering Drive
    Madison, WI  United States  53706

    Wisconsin Department of Transportation

    Division of Business Management, Bureau of Business Services
    Research and Communications Section, 4802 Sheboygan Avenue, P.O. Box 7957
    Madison, WI  United States  53707-7957

    Federal Highway Administration

    1200 New Jersey Avenue, SE
    Washington, DC  United States  20590
  • Authors:
    • Guo, Jessica Y
    • Gandavarapu, Sasanka
  • Publication Date: 2010-2


  • English

Media Info

  • Media Type: Web
  • Edition: Final Report
  • Features: Appendices; Figures; References; Tables;
  • Pagination: 91p

Subject/Index Terms

Filing Info

  • Accession Number: 01155118
  • Record Type: Publication
  • Report/Paper Numbers: WHRP 10-02
  • Contract Numbers: WHRP# 0092-07-23
  • Created Date: Apr 22 2010 10:56AM