|
|
| Line 1: |
Line 1: |
| The '''Join Table to Layer''' command, available when right-clicking on a layer in the Project Explorer, allows you to join the attributes of one database file (.dbf) to the features of a GIS layer based on a key attribute field. This is particularly important when dealing with NRCS soils data since the features are stored in a shapefile with a minimal set of attributes, and the hydrologic soil group and other soil classifications are stored in a separate .dbf file. The two files are related based on an attribute field named MUID. Other GIS data layers may be similar where the features contain some kind of key indexing field and the attributes are stored in a separate table that can be joined to the features based on the index field values.
| | #REDIRECT [[WMS:GIS Tables]] |
| | |
| After selecting the '''Join Table to Layer''' command you will be prompted for the database file you wish to join using the standard select file dialog. The Join Table dialog will then appear and you will be asked to select the Join Field from the GIS data layer attributes and the Join Field from the table you are joining to the GIS data layer. Often these field names will be the same as in the example below, but they are not required to be the same. The important thing is that they contain similar information from which a join can be made. Finally, you can select to join all of the attributes from the join table or just add a specific field, as is shown in the example below where we are only interested in adding the field representing hydrologic soil groups.
| |
| | |
| [[Image:image94.jpg]] | |
| | |
| The join does not permanently alter the GIS data layer on the hard drive of your computer, it only exists within the WMS application.
| |
| | |
| | |
| ==Related Topics==
| |
| * [[WMS:Open Attribute Table|Opening Attribute Tables]]
| |
| * [[WMS:Soil|Soil Coverages]]
| |
| * [[WMS:Mapping to Feature Objects|Mapping GIS to Feature Objects]]
| |
| | |
| | |
| {{WMSMain}}
| |
