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.
scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.
customersupport@researchsolutions.com
10624 S. Eastern Ave., Ste. A-614
Henderson, NV 89052, USA
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Copyright © 2024 scite LLC. All rights reserved.
Made with 💙 for researchers
Part of the Research Solutions Family.