A technique for merging state and non-state linear referencing systems.

摘要

The Wisconsin Department of Transportation (WisDOT) maintains two separate linear referencing systems (LRS) for managing state roads and local roads. The State Trunk Network (STN) only represents statewide routes such as interstates, state highways, and county highways. The Wisconsin Information System for Local Roads (WISLR) system includes all roads, but focuses on local roads. These systems are not related and some significant differences between the systems exist. Therefore, the focus of this project was to develop a technique to relate the two systems.;Merging STN and WISLR is advantageous because it allows the transfer of transportation data between the two systems. To move this data, a table, called the link_link table, was created that relates the two systems based on link IDs and lengths of links. Point data in STN (in the form of link IDs and offset distances) can be programmatically moved using the link_link table to create an equivalent table of WISLR link IDs and offset distances. The merge technique was implemented on a statewide scale. This thesis presents the link_link table design and coding methodology, quality checks for the link_link table, the results of moving data between the systems, and recommendations for future work related to this project.