Combining State Route and Local Road Linear Referencing System Information
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.
- Record URL:
- Summary URL:
-
Availability:
- Find a library where document is available. Order URL: http://trb.org/Main/Blurbs/Data_Systems_and_Travel_Survey_Methods_2009_162816.asp
-
Authors:
- Graettinger, Andrew J
- Qin, Xiao
- Spear, Gabriel
- Parker, Steven T
- Forde, Susie
- Publication Date: 2009
Language
- English
Media Info
- Media Type: Print
- Features: Figures; References;
- Pagination: pp 152-159
- Monograph Title: Data Systems and Travel Survey Methods 2009
-
Serial:
- Transportation Research Record: Journal of the Transportation Research Board
- Issue Number: 2121
- Publisher: Transportation Research Board
- ISSN: 0361-1981
Subject/Index Terms
- TRT Terms: Case studies; Databases; Geographic information systems; Quality assurance; Quality control; State highways
- Identifier Terms: Wisconsin Department of Transportation
- Uncontrolled Terms: Data transfers; Linear referencing systems; Local roads
- Subject Areas: Data and Information Technology; Highways; I10: Economics and Administration;
Filing Info
- Accession Number: 01147887
- Record Type: Publication
- ISBN: 9780309126380
- Files: TRIS, TRB, ATRI
- Created Date: Jan 21 2010 7:58PM