blank space

South Dakota Department of Transportation
Project Synopsis
SD1998-11


Title: A Location Referencing System Pilot Study
Project Researcher: Mary Storsteen, SDDOT
Project Manager: Daris Ormesher
Research Period: -
Status:
Cost: $0.00

Problem Statement:The South Dakota Department of Transportation (SDDOT) recently completed the research study SD96-04 A Location Referencing System to Support Data Integration. The study identified 13 distinct location referencing systems in use within SDDOT. It also identified the functional requirements and the specific changes necessary to implement a standard location referencing system. A relational Database Management System (DBMS) was identified as the preferred DBMS. SQL/Server is currently the standard DBMS for all state agencies. The project recommended a specific LRS implementation strategy.

The primary storage utility for the majority of the information that is collected on South Dakotas highway system is the Roadway Environment Subsystem (RES). Eight key files are contained in the RES system:

  • MRM Inventory

  • Bridge Inventory

  • Traffic Inventory

  • Dynaflect, Roughometer, and Pavement Friction Inventory

  • Roadway Features Inventory

  • Intersection Inventory

  • Railroad Crossing Inventory

  • Maintenance Cost Inventory

  • A minimum of ten other files exist that are associated to RES with varying location referencing systems. The majority of RES data is updated by personnel from Data Inventory and Operations Support. Planning and Programs is the primary user of the data but it is difficult to determine the total number of users of the data. The list of users is expected to increase as the ease of access to the data increases.



    Findings:

    Research Objectives:
    1  Develop a standard location referencing system that will address SDDOTs data integration needs.

    Research Tasks:
    1  Meet with the project's technical panel to review project scope and work plan.
    2  Review and summarize literature regarding location referencing systems and related issues.
    3  Identify existing applications and data that will be affected by conversion to a relational database with LRS capability.
    4  Determine which applications and data should be converted and prioritize the list.
    5  Resolve data quality issues concerning scale, accuracy and precision of location-referenced data.
    6  Develop guidelines for the coordinate transformation interface.
    7  Define a method to provide appropriate metadata to data consumers.
    8  Develop and verify transformation implementation methodologies from tasks four, five and six. The verification should include but not be limited to data from the RES Roadway Features Inventory File, MRM Inventory File, Traffic Inventory File and Acci
    9  Provide a detailed plan including costs for enhancement of remaining systems and applications to utilize a standard location referencing system and relational database.
    10  Prepare a final report and executive summary of the literature review, research methodology, findings, conclusions, and recommendations.
    11  Make an executive presentation to the SDDOT Research Review Board at conclusion of the project.

    Documents Available:
    blank space