01147887

Component

https://doi.org/10.3141/2121-17

http://scholar.google.com...orde&publication_year=2009

The Wisconsin Department of Transportation maintains two separate geographic information system databases: one for state roads and one for local roads. Both databases employ linear referencing system (LRS) theory to manage and locate information. Combining data from state and local roads into one system is desirable for the purpose of data management and analysis. This paper’s approach combines information from the state route LRS (link ID and offset distance) with information from the local road LRS (node ID) to produce a table that can be employed to transfer data between the systems. A computer program was developed to use this table, along with existing tables in each LRS, to move information from the state route system to the local road system. Quality assurance and quality control techniques are presented along with a long-term implementation approach; both help to update the table bridging these two systems. The approach described does not interfere with the current operation of either system; therefore, no interruption of business practice will occur as this data transfer approach is deployed. Although this approach can transfer any LRS data, a case study of crash data for Dane County, Wisconsin, is used to demonstrate and test the approach. In the case study, crash points on the state routes are combined with local road crashes to produce a complete data set of crashes within the county.

01147424

English

pp 152-159

2009

Transportation Research Record: Journal of the Transportation Research Board

9780309126380

Print

Figures (8) ; References (5)

Case studies; Databases; Geographic information systems; Quality assurance; Quality control; State highways

Wisconsin Department of Transportation

Data transfers; Linear referencing systems; Local roads

Data and Information Technology; Highways; I10: Economics and Administration

TRIS, TRB, ATRI

Jan 21 2010 7:33PM

• Adding Green Performance Metrics to a Transportation Data Archive
• Analyzing Multimodal Public Transport Journeys in London with Smart Card Fare Payment Data
• Commodity-Specific Disaggregation of 2002 Freight Analysis Framework Data to County Level in New Jersey
• Detecting Differential Drift in Weigh-in-Motion Wheel Track Sensors
• Estimation for Seasonal Factors of Similarity-Based Traffic for Urban Roads in Florida
• Estimation of Travel Time on Urban Networks with Midlink Sources and Sinks
• Examining Common Distributional Assumptions of Travel Characteristics for Data Simulation
• Geographic Information System Framework for Stormwater Drainage Asset Management
• Intercity Person Trip Tables for Nationwide Transportation Planning in Israel Obtained from Massive Cell Phone Data
• Life-Cycle Cost Approach to Infrastructure Cost Calculation and Allocation
• Making Asset Management Work: Innovative Components for Successful Implementation by Local Agencies in Michigan
• Measuring Freeway Traffic Conditions with Transit Vehicles
• Paso Del Norte Regional Mobility Information System: Creating Archived Transportation Data User Services and an Advanced Traveler Information System
• Real-Time Estimation of Arterial Travel Times with Spatial Travel Time Covariance Relationships
• Tracking Large Trucks in Real Time with License Plate Recognition and Text-Mining Techniques
• Video-Based Vehicle Detection and Tracking Using Spatiotemporal Maps