A data storage and retrieval model for Louisiana traffic operations data.

PDFTech ReportFHWA/LA-29794-5SS(B)Data storageIndexingInformation retrievalGeographic information systemsDatabasesTransportation planningSignalized intersectionsHighwaysLouisianaLouisiana State University. Remote Sensing and Image Processing LaboratoryBullock, DarcyQuiroga, CesarLouisiana State University. Remote Sensing and Image Processing LaboratoryLouisiana Transportation Research CenterUnited States. Federal Highway AdministrationUS Transportation CollectionThe type and amount of data managed by the Louisiana Department of Transportation and Development (DOTD) are huge. In many cases, these data are used to perform traffic engineering studies and highway safety analyses, among others. At the present time, however, no shared indexing or archiving system is available for retrieving these data.This report describes the results of a pilot project aimed at developing a prototype computer-based indexing model for reports and engineering data in the Louisiana DOTD. The model is based on a procedure that links signalized intersections and road segments in a Geographic Information System (GIS) environment. The database developed in this project covers data from East Baton Rouge Parish for the past 10 years. Five categories of engineering reports were created: engineering studies, traffic services work orders, inspection reports, Chief Engineers' Orders, and others.A paper form was developed to facilitate the engineering data extraction process. This form will constitute the basis for a standard report cover form to be submitted with future traffic engineering studies to permit rapid indexing. A computerized version of the paper form and a computerized query form were also developed