Scoping Data Access and Integration Needs to Facilitate Better Management of Research Innovation

Available Documents
Quarterly Report September 2007
Quarterly Report December 2007
Quarterly Report March 2008
Quarterly Report June 2008
Quarterly Report September 2008
Quarterly Report December 2008
Quarterly Report March 2009
Quarterly Report June 2009
Quarterly Report September 2009
Quarterly Report March 2010
Quarterly Report June 2010
Quarterly Report September 2010
Quarterly Report December 2010
Quarterly Report March 2011
Quarterly Report June 2011

Primary Investigator
P.S. Sriraj , Ph.D.
Urban Transportation Center
University of Illinois at Chicago
412 S. Peoria Street, Suite 340
Chicago, IL 60607

Project Objective
The objectives are as follows:

  1. Identify current WisDOT design/construction/traffic databases and department strategies or efforts to integrate them.
  2. Help raise awareness of WisDOT staff and partners of the intended use and value of these databases.
  3. Identify existing access procedures – for department staff, investigators and contractors – to WisDOT databases and other technical information; develop improvements needed to enhance accessibility and document these improvements in a handbook for users; develop training for users.
  4. Evaluate referencing systems used in these databases; define advantages and disadvantages of each in order to develop, or select, a common effective referencing system.
  5. Develop procedures required for transition to a new referencing system including tools and methods for recording reference attributes.
  6. Identify software and other approaches to convert existing referencing systems to the selected common system.

Project Abstract
This research will focus on scoping data access and integration for Wisconsin Department of Transportation. The research team will scan the published literature on data integration to understand the progress made and the challenges faced in integrating data. This will be followed with a needs analysis of stakeholders to get a listing of databases, the various queries/uses of databases, gaps in knowledge about existing data, all with an eye toward integrating the available data. The survey will also strive to capture the different perspectives offered by the different stakeholders – staff, investigators/researchers, and contractors. Various referencing systems and their advantages/disadvantages will be studied in selecting the most appropriate system for Wisconsin DOT. A training handbook will be prepared documenting the ways in which the new referencing system will facilitate queries along with recommendations for future data collection and data maintenance efforts.

Task Descriptions

  1. Review Literature
  2. Evaluation of the State of Practice (Needs Analysis)
    • Sample Selection
    • Develop Questionnaire
    • Synthesize the Results
  3. Database Design
    • Database Architecture
    • Guidelines for data access and dissemination of data
  4. Develop Training Material for Users

Project Information

  • Milestones, Dates: 12 months; project end 5/31/08
  • Budget: $85,873
  • Student Involvement: One graduate student
  • Modal Orientation: Highway
  • Project ID: 08-10