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

The work plan is divided into four parts:

  • Literature review.
  • Needs analysis.
  • Database design.
  • Development of training materials for users.


Principal Investigator(s):

P.S. Sriraj


P.S. Sriraj
Paul Metaxatos
Piyushimita (Vonu) Thakuriah




This project has six main objectives:

  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 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.


The research will focus on scoping data access and integration for Wisconsin Department of Transportation (WisDOT). 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 appropriate system for WisDOT.

Expected Results or Products:

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.

Part 1 Scoping Data WisDOT-WHRP-project-0092-07-16-final-report

Part 2 Scoping Data WisDOT-WHRP-project-0092-07-16-final-report-2


P.S. Sriraj
Urban Transportation Center
University of Illinois at Chicago
412 South Peoria Street, Suite 340
Chicago, IL 60607
Voice: (312) 413-7568
Fax: (312) 413-0006


Midwest Regional University Transportation Center

University of Wisconsin-Madison
MW Univ Trans Center-banner