Two independent liner referencing systems are being used simultaneously by Wisconsin Department of Transportation (WisDOT) for business data management and analysis in transportation sector. The State Trunk Network (STN) representing only state route is used for analysis and planning purposes. Wisconsin Information for Local Roads (WISLR) representing all roads (State and local roads) of Wisconsin and having comparatively lower resolution than STN is used in Incident Location Tools for storing crash data. A functional merge link_link table was developed to define relationship between these two systems. The link_link table updating is required yearly not only to reflect the changes in line work and attributes of STN and WISLR but also to make updated crash map and to translate data between STN to WISLR. Data translation from STN to WISLR is acceptably well while data translation in reverse direction is ambiguous where the resolution is dissimilar between STN and WISLR. To control these ambiguities some rules and guidelines were proposed. In this research those rules and guidelines were implemented to control all ambiguities. Research was also done to use link_link table to provide name to the ramps dynamically. The thesis consists of link_link table update methodology, QA/QC procedure of link_link table, data translation between STN and WSLR in both directions, application of link_link table for giving name to ramps and recommendations for future work