NTL Record

Title A Location Referencing System to Support Data Integration
Record ID 11996
Personal Name
Creator
Vogt, Tim J.; Svalstad, Darrell K.; Chieslar, Jack D.; Cooper, Frank F.
Source 151p. in various pagings
Corporate Creator RE/SPEC Inc.; Cooper Technology
Corporate
Contributor
South Dakota. Department of Transportation
Publisher South Dakota. Department of Transportation
Publication Date 19970500
Language English
Abstract An investigation of South Dakota Department of Transportation (SDDOT) location referencing practices and procedures identified the functional requirements of and specific changes that should be implemented to establish a standard location referencing system that will address SDDOT data integration needs. Critical elements of the proposed location referencing system include a relational database to enhance data access and data management capabilities, coordinate transformation interfaces to enable integration of data from diverse referencing systems, and a time data attribute to enable historical data management. A review of literature on recent developments in location referencing and related issues as well as a review of ongoing activities in states actively addressing location referencing issues revealed that the principal referencing method used in the transportation industry is linear. Further, the use of multiple referencing systems to support transportation management is common. Databases used to manage location-referenced data are predominantly relational, and historical data management is essential for effective transportation management. Interestingly, the states exploring the use of Geographic Information Systems (GIS) are addressing location referencing issues because of associated needs for coordinates; increased data sharing; and increased emphasis on open systems, standards, and cooperation. Management commitment/support was identified as critical to ensure success in data integration and GIS implementation efforts. The study identified 13 discrete location referencing systems in use, provided insight on data sharing needs and uses of location-referenced data, and provided a basis for recommended changes that should be implemented to address SDDOT data integration needs. Implementation alternatives were investigated, and a recommended implementation strategy was defined. A relational DBMS was identified as the preferred DBMS based on comparative analyses of system functionality and life cycle cost and SDDOT institutional constraints. Preliminary design investigations, recommended as the first phase in the recommended implementation strategy, will resolve technical uncertainties that will have a direct impact on how the system will function and on the direction and cost of design and implementation efforts. The remaining implementation phases involve development of detailed system functional and design specifications to guide subsequent implementation of a standard location referencing system specific to SDDOT data integration needs.
Rosap ID dot:4866
Rosap URL https://rosap.ntl.bts.gov/view/dot/4866
TRT Terms Location; Referencing; Transportation; Management; Geographic information systems; Specifications
General Subjects Data access; Data integration; Data management; Data sharing; Historic data; Relational databases; South Dakota
Classification NTL - GEOGRAPHIC INFORMATION SYSTEMS - GEOGRAPHIC INFORMATION SYSTEMS;
NTL - INTELLIGENT TRANSPORTATION SYSTEMS - INTELLIGENT TRANSPORTATION SYSTEMS;
NTL - PLANNING AND POLICY - Management Systems
Geographical
Coverage
United States
OCLC 37280961
TRIS Online
Accession No
00762972
Report Number Report No. SD96-04-F
Resource type Tech Report
URL https://ntlrepository.blob.core.windows.net/lib/11000/11900/11996/SD1996-04_Final_Report_OCR.PDF
Format PDF
Database NTL Digital Repository