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.


  • English

Media Info

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

Subject/Index Terms

Filing Info

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