Page History

...

1. Close all table views.
2. Above the ribbon, on the Quick Access toolbar, click the Save button.
   
   Image Added

Joining Tabular Data

Now that you have examined all of the data tables, you are ready to join them all together. It is possible to join tables together in any order, but you will want to join both land use tables to the back of your DowntownParcels attribute table, so that you can later symbolize the parcels based on their land use. You will first join the Land table to the DowntownParcels feature class using the unique HCAD account number as the common join field.

...

1. In the Contents pane, right-click the DowntownParcels layer and select Joins and Relates > Add Join.
2. For ‘Input Join Field’, select the new Land.LAND_USE_C_Text field.
3. For ‘Join Table’, select the LandUseCode_LookupTable table.
4. For ‘Output Join Field’, select the LANDUSELANDUSE_CODE field.
   Ensure that the ‘Add Join’ pane matches that shown below and click OK.
   
   
   
   
5. If your DowntownParcels table view is not already open, right-click the DowntownParcels layer name and select Attribute Table.
6. In the DowntownParcels table view, scroll to the right and browse through all of the attributes.

...

The joins that you have created are only stored in this particular map documentview. In other words, none of the original tables have been modified. If you were to add the DowntownParcels layer to another new map document, you would no longer see the joined tables at the back of the layer’s attribute table. In addition, if your joined data tables were ever moved or deleted, the joined data would no longer be visible in this map documentview. For this reason, it is often a good idea to export data containing successful tabular joins, so that you do not have to worry about losing the joined data in the future.

1. Right-click the DowntownParcels layer and select Data > Export Features.
2. For ‘Output Feature Class’, click the Browse button.
3. Navigate to the Tutorial geodatabase (C:\Users\gistrain\Desktop\TabularTutorialData\TabularData.gdb).
4. Double-click the Tabular.gdb geodatabase.
5. For 'Name', type “Rename the feature class “DowntownParcels_WithLandUse” and click Save.
6. Click Run.

...

2. Right-click the DowntownParcels_WithLandUse layer name and select Attribute Table.

Notice that all of the joined attributes are now a permanent part of this new feature class attribute table. Since this permanent feature class contains everything you need in one layer, you may now remove your original parcels layer and both joined tables.

1. Close the attribute table. the DowntownParcels_WithLandUse table view.
2. In the Contents pane, rightRight-click the DowntownParcels layer name and select Remove.
3. Right-click the Land table and select Remove.
4. Right-click the LandUseCode_LookupTable table and select Remove.
5. Above the ribbon, on the Quick Access toolbar, click the Save button.

...

1. In the Contents pane, right-click the DowntownParcels_WithlandUse layer name and select Symbology.
2. In the Symbology pane that appears opens over the Catalog pane, under use the 'Symbology' drop-down menu , to select Unique Values.
3. In the ‘Value Field’ For ‘Value field’, use the drop-down box, menu to select the GROUP_DSCR field.
4. At To the top right of the tabular list of symbols, values, and labels, click the More drop-down menu and uncheck Show all other values, since there are none in this caseyou will be symbolizing all values.

You will want to group “Commercial” and “Office” into one land use category.

1. Click In the table, click the Commercial value to select it.
2. Hold down Ctrl and click the Office value to select it too.
3. Right-click the Commercial value and select Group Valuesvalues to combine the two categories into one.
4. Click on each of the symbol patches to change the colors to those commonly used by planners to indicate the various land uses, as displayed below. Once the ‘Format Polygon Symbol’ pane appears, click on Properties and change each color. Click Apply to apply each symbol formatting.

...

1. Above the ribbon, on the Quick Access toolbar, click the Save button.
2. Minimize ArcGIS Pro.

...