WMS:GIS Tables: Difference between revisions

From XMS Wiki
Jump to navigationJump to search
Line 4: Line 4:


==Joining Tables==
==Joining Tables==
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.
The '''Join Table to Layer''' command, available when right-clicking on a layer in the ''Project Explorer'', allows users 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.


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.
After selecting the '''Join Table to Layer''' command, the user will be prompted for the database file to join using the standard select file dialog. The ''Join Table'' dialog will then appear and the user will be asked to select the ''Join Field'' from the GIS data layer attributes and the ''Join Field'' from the table to be joined 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, users 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.


[[File:Join Table.jpg|thumb|none|left|250 px|''Join Table'' dialog]]
[[File:Join Table.jpg|thumb|none|left|250 px|''Join Table'' dialog]]


The join does not permanently alter the GIS data layer on the hard drive of your computer, it only exists within the WMS application.
The join does not permanently alter the GIS data layer on the hard drive of the computer, it only exists within the WMS application.


==Related Topics==
==Related Topics==

Revision as of 16:15, 29 August 2014

Open Attribute Table

The Open Attribute Table command, available by right-clicking on a GIS layer, opens up a spreadsheet dialog that shows all of the attribute names (as columns) and the values associated with each feature in the layer (as rows). Tables cannot be edited within WMS; this is only a way to explore and discover the nature of the database associated with the GIS layer. It is important to understand both the names of attribute fields and feature values in order to better understand how the data might be mapped to feature objects in a map coverage.

Joining Tables

The Join Table to Layer command, available when right-clicking on a layer in the Project Explorer, allows users 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.

After selecting the Join Table to Layer command, the user will be prompted for the database file to join using the standard select file dialog. The Join Table dialog will then appear and the user will be asked to select the Join Field from the GIS data layer attributes and the Join Field from the table to be joined 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, users 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.

File:Join Table.jpg
Join Table dialog

The join does not permanently alter the GIS data layer on the hard drive of the computer, it only exists within the WMS application.

Related Topics