Tutorial Understanding Objects Tables and Elements

Understanding NASIS Objects, Tables, and Elements Chapter 6 NSSC, Lincoln NE 1 Objectives • Understand a database “Object” • Understand database “Tables” • Navigate between various Objects and Tables • Understand the loading of data NSSC, Lincoln NE 2 Navigate within the Area Type Object • Open the Area Type table by selecting the View menu, Area Types, then Area Type. • The Area Type window is displayed in the next screen. In a later lesson, you will examine the columns of the tables in the Area Type object. This lesson focuses exclusively on navigating and understanding the NASIS structure • NASIS stores more than just traditional soil survey areas. Because there are several kinds of areas, they are organized by area type. NSSC, Lincoln NE 3 Screen Navigation Object Status Edit Setup Group Cell Status Row Status More columns may be visible, if your screen is set wider than the example NSSC, Lincoln NE 4 NASIS Area Types This national query is available to load the Areas NSSC, Lincoln NE 5 NASIS Area Types NSSC, Lincoln NE 6 Click in the Non-MLRA Soil Survey Area row, then click the Down table button Use the arrows to view the other Area types and Areas associated with them NSSC, Lincoln NE 7 Crossing Object Boundaries to the Legend Table NSSC, Lincoln NE 8 Area to Legend Purple lines identify relationships Crossing object boundaries requires the use of the Load Related command or running the query again with a different target table NSSC, Lincoln NE 9 Area to Legend • • • • • Click on View/Legends/Legend Verify the Legend table is empty Return to the Area table Locate an Area Name of Interest Then, to load the Legend for that Area – File, Load Related, Legend NSSC, Lincoln NE 10 Area to Legend NSSC, Lincoln NE 11 Legend Object To look at the legend, on the View menu choose Legends, then Legend. You see the legend associated with the survey area you selected. NSSC, Lincoln NE 12 Area to Legend Purple lines identify relationships Crossing object boundaries requires the use of the Load Related command or running the query again with a different target table NSSC, Lincoln NE 13 Mapunit Table NSSC, Lincoln NE 14 Legend to DMU Crossing object boundaries requires the use of the Load Related command or running the query again with a different target table NSSC, Lincoln NE 15 Correlation Table Highlight the Representative DMU, then File/Load Related. Then, View/Find Related/Datamapunit NSSC, Lincoln NE 16 Correlation to Datamapunit Crossing object boundaries requires the use of the Load Related command or running the query again with a different target table NSSC, Lincoln NE 17 Data Mapunit Table The Data Mapunit Object contains the component properties, qualities and interpretations NSSC, Lincoln NE 18 Component Table • A Data Mapunit contains the components for the map unit. NSSC, Lincoln NE 19 http://nasis.usda.gov/documents/metadata/ NSSC, Lincoln NE 20 Questions?? • What are the three objects and the major tables of the aggregated data? • What is the purpose of the Area Object? • What is the purpose of the Legend Object? • What is the purpose of the Correlation table? • What does the Data Mapunit Object contain (in general)? NSSC, Lincoln NE 21