Development of an Integrated System for Evaluation of Oregon’s Truck Data Phase 2-Evaluation of Data

Oregon Department of Transportation's Permits and Weighmaster section has been increasing the automation of its data collection procedures for many years. Recently, this has included developing computerized records for all the routeinely collected data of the six Ports of entry (POEs). Data for every truck passing through the POEs has been recorded since 1989. In addition, Oregon has 95 other weigh sities, many of which are only open occasionally, but nevertheless annually produce considerable data concerning trucks. PDOT has introduced computerized record keeping for these weigh sites more recently. Effective use of truck data stored in computer databases requires ease of accessibility and data analysis in a form that is easily understood by users not familiar with the data system. This report describes the design of user interfaces for the database. The interface will allow users to interact with the system effectively. Various reports summarizing general truck data and collection information can be generated. A second objective of this report is to demonstrate new and effective use of the data. Particular emphasis is on commodity data. Commodity movements can only be tracked on a limited basis because of the way such data is recorded. A new commodity coding scheme is described; its uses shows significant enhancement in the quality of data analysis.