This report describes an initial effort to develop intelligent transportation system (ITS) data archives that can be linked and accessed through a single, Web accessible, geographic information system (GIS) interface. This project was designed to test where this approach of linking disparate databases can help resolve some of the key issues associated with making transportation system performance data available throughout the Washington State Department of Transportation (WSDOT). These include 1) keeping the basic data structures manageably simple to reduce database cost and complexity, 2) allowing data archive control and primary management to remain at the local level to improve the quality control function, 3) providing easy access to staff throughout the organization, 4) providing an interface that allows staff unfamiliar with the data to easily learn what data are available in each database, and 5) providing a simple way to allow staff to combine disparate datasets that share geographic characteristics.
To test the concepts developed for this project, the project team created three specific databases and linked those databases through the spatial identifiers stored in WSDOT's GIS. Summaries of statistics from each of the three databases were developed to be useful to a wide range of WSDOT staff, and they are available through the Internet.