Update of the Non-State Trunk Inventory

Geographical Information System (GIS)/Trans Ltd. provided consultant services to integrate the existing Non-state Trunk Roadway Inventory System (NSTRI) database with updated information from a recently completed Global Positioning System (GPS) inventory. The first step was to review the current environment of the NSTRI and the data items contained in it, as well as the data items contained in the GPS inventory. Recommendations were made regarding the suitability of retaining certain data items and all data items were ranked in order of importance. Since there was no common key field in the databases, they could not be joined using standard database techniques. It was determined that using a GIS to join the databases based on the location of the attribute sections was the most appropriate method to use. The GPS Inventory collected the road centerlines (basemap) with accurate road lengths (measures), and certain road characteristics as attributes. The GPS attributes could be placed directly on the basemap since their measures matched those of the basemap. The NSTRI method of locating attribute sections however, had to be converted into the same measurement system as the GPS. A Linear Referencing System (LRS) was created for the NSTRI which allowed the researchers to place the NSTRI data on the same basemap as the GPS data. Finally, the two databases could be joined by matching the route identifiers, and the measures for each attribute record. Upon determining that the databases could in-fact be joined, procedures for maintaining and updating the combined database were recommended. Resources required to maintain the database were also recommended.

• Record URL:
  http://www.sddot.com/business/research/projects/docs/SD2000_03_Final_Report.pdf
• 
• Corporate Authors:

  GIS/Trans, Limited

  12414 Alderbook Drive, Suite 102
  Austin, TX  United States  78758

  South Dakota Department of Transportation

  Office of Research, 700 East Broadway Avenue
  Pierre, SD  United States  57501-2586

  Federal Highway Administration

  1200 New Jersey Avenue, SE
  Washington, DC  United States  20590
• Authors:
  • Collier, Christian
  • Saxena, Somitra
  • Kuykendall, William K
• Publication Date: 2000-10-23

Language

• English

Media Info

• Media Type: Print
• Edition: Final Report
• Features: Appendices; Maps; Tables;
• Pagination: 78p

Subject/Index Terms

• TRT Terms: Center lines; Databases; Geographic information systems; Global Positioning System; Inventory; Measurement; Recommendations
• Uncontrolled Terms: Linear referencing system; Miles of road (Road length); Non-state trunk system; Road characteristics
• Subject Areas: Freight Transportation; Highways; Planning and Forecasting; Research; I72: Traffic and Transport Planning;

Filing Info

• Accession Number: 01044309
• Record Type: Publication
• Report/Paper Numbers: SD2000-03-F
• Contract Numbers: 310710
• Files: TRIS, USDOT, STATEDOT
• Created Date: Mar 12 2007 7:54PM