A Utility for Crash Data Translation between Dissimilar Resolution Networks

The crashes were mapped using two separated and independent Linear Reference Systems (LRSs) to meet different traffic business needs within the Wisconsin Department of Transportation (WisDOT). The State Trunk Network (STN) is the early-developed LRS for the interstate and state roads, while the Wisconsin Information System for Local Roads (WISLR) includes all roads with a detail for the local roads. A link_link table has been developed to easily translate the data from the high-resolution STN to the lower-resolution WISLR network. However, the reverse translation is more challenge due to the ambiguities. This paper presents a utility to realize the opposite translation automatically without influencing other existing business programs. In this utility, rules are set to partially avoid the ambiguities. The results of the quality assurance/quality control indicate that the proposed utility is feasible and accurate.