Page History

...

1. In the Catalog pane on the right, expand the Databases folder.
2. Expand the Tabular.gdb geodatabase.
3. Drag the DowntownParcels feature class into the mapRight-click the DowntownParcels feature class and select Add To New Map.

You will now examine the DowntownParcels layer’s attribute table.

1. In the Contents pane on the left, right-click the DowntownParcels layer name and select Attribute Table.
2. Scroll down and browse Browse through all of fields in the attributesattribute table.

Notice that in the The HCAD_NUM field , you are provided with contains the unique 13-digit HCAD account number for each parcel. You are also provided with the owner name and address for each parcel, but not very much other information. Fortunately, a tremendous amount of other information about the parcels can be obtained from HCAD in stand-alone tabular format. In this case, you would like to know the particular land use for each parcel, for example such as residential, commercial, or industrial. This information is contained in a separate table, which you will now explore.

1. Close the DowntownParcels attribute table.
2. Under In the Catalog pane, in within the TabularData geodatabase, drag the right-click the Land table into the Map Displayand select Add To Current Map.
3. In the Contents pane, right-click the Land table and select Open.
4. Scroll down and browse through all of the attributesfields.

Notice that you are again provided with the unique HCAD account number, but this time the field is labeled ACCOUNT, rather than HCAD_NUM, as it was in the DowntownParcels feature class attribute table. You are also provided with the land use code and the land use description for each parcel. In order to symbolize the parcels by land use, you will first need to join the land use table to the parcels feature class.

...

1. Right-click the LAND_USE_C field and select Sort Ascending.
2. Scroll down and browse through all of the land use codes and descriptions.

Notice how many different land use categories there are. For example, commercial land use is divided into very specific categories, such as Restaurant, Ice House, Bar/Lounge, Department Store, Medical Office, and Bank. While it is great to have this information available, symbolizing so many different categories on a single map can make the map difficult to understandinterpret. Instead, you would prefer to symbolize the parcels using more generalized land use categories.

Fortunately, the City of Houston has created a lookup table that assigns each appraisal district land use code to one of ten generalized land use categories. You will now explore this lookup table.

1. On the right side of the ArcGIS Pro window, click the Catalog pane.
2. In In the Catalog pane, within the TabularData geodatabase, drag the  right-click the LandUseCode_LookupTable table into the Map Display table and select Add To Current Map.
3. In the Contents pane, right-click the LandUseCode_LookupTable table and select Open.
4. Scroll down and browse through all of the attributes through the land use descriptions and the associated group descriptions.

Notice that the COUNTY field tells you which county uses the particular land use code listed.   “HCAD” is stands for Harris County. If you scroll down to the bottom of the table, you will notice “FBCAD” and “MCAD” for Fort Bend County and Montgomery County, respectively. The LANDUSE_CODE and LANDUSE_DESCRIPTION fields should look familiar, since they contain the same information as the Land table you looked at previously. The GROUP_CODE and GROUP_DSCR fields store one of ten general land use categories that correspond to each specific land use code. In order to symbolize the parcels using these generalized land use categories, you will also need to join the lookup table to the land use table and the parcels feature class. You will perform the join using the land use code field that is common to both your land use table and your lookup table.

1. Close the  all attribute tables.

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 add join both land use tables to the back of the your DowntownParcels attribute table for your parcels layer, 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 name and select Joins and Relates > Add Join.

The Geoprocessing pane should open on the right in a new tab over the Catalog pane. In

...

the Add Join tool, notice that 'Layer Name or Table View' is already set to the DowntownParcels layer, since that was the layer used to open the tool.

1. For ‘Input Join Field’, use the drop-down menu to select the HCAD_NUM field.
2. For ‘Join Table’, use the drop-down menu to select the Land table.
3. For ‘Output Join Field’, use the drop-down menu to select the ACCOUNT field.
4. Ensure that the ‘Join Data’ window matches that shown below and click Run.

1. Right-click the DowntownParcels layer and select Open  Attribute Table.
2. Scroll to the right and browse through all of the attributes.

...

1. Close the attribute table.
2. In the Contents pane, right-click the DowntownParcels layer and select Joins and Relates > Add Join.
3. For ‘Input Join Field’, select the Land.LAND_USE_C field.
4. For ‘Join Table’, select the LandUseCode_LookupTable table.

For ‘Output Join Field’, notice that the LANDUSE_CODE field that you want to base the join on cannot be selected. This is an indicator that the two join fields are probably not of the same type and cannot be joined as is.

...

1. In the Contents pane, right-click the Land table and select Open.
2. Right-click the LandUseCode_LookupTable table and select Open.

Notice at the top left of the ‘Table’ window, you see one tab for each of the two tables that are open, but you want to be able to examine both tables simultaneously.

...

1. In the Land table, right-click the LAND_USE_C field and select Fields. Notice that the Data Type is “Long”, which stands for long integer.
2. Close the ‘Fields’ window.
3. In the LandUseCode_LookupTable table, right-click the LANDUSE_CODE field and select Fields. Notice that the field type is “Text”.
4. Close the ‘Fields’ window.

...

1. In the Catalog pane, right-click the Land table>Design>Fields table > Design > Fields.
2. At the bottom, click ‘Click here to add a new field’.
3. For ‘Field Name’, type “LAND “LAND_USE_C_Text”Text”.
4. For ‘Data Type’, select Text. On the Fields tab, click Save.

The new LAND_USE_C_Text field has now been added to the end of the Land table.

1. Close the ‘Fields’ window.
2. In the Catalog pane, right-click the Land table and select ‘Open’ Open.
3. Right-click the LAND_USE_C_Text field and select Calculate Field.

Over the Catalog pane, the Calculate Field geoprocessing pane will appear.,

...

Notice that the box at the bottom of the ‘Field Calculator’ pane now reads LAND_USE_C_Text = [LAND_USE_C], as shown below. This statement will copy all of the content from the original LAND_USE_C integer field to the new LAND_USE_C_Text text field.

1. Click Run.

Ensure that the land use codes have indeed been copied over into the new LAND_USE_C_Text field and that they are left-aligned as text.

...

1. In the Contents Pane, right-click the DowntownParcels layer and select Joins and Relates > Add Join.
2. For ‘Input Join Field’, select the HCAD_NUM field.
3. For ‘Join Table’, select the Land table.
4. For ‘Output Join Field’, select the ACCOUNT field.
5. Ensure that the ‘Add Join’ pane matches that shown below and click OK.

1. Right-click the DowntownParcels layer and select Attribute Table.
2. Scroll to the right and ensure that the four land use code fields were added.
3. Close the attribute table.
4. In the Contents pane, right-click the DowntownParcels layer and select Joins and Relates > Add Join.
5. For ‘Input Join Field’, select the new Land.LAND_USE_C_Text field.
6. For ‘Join Table’, select the LandUseCode_LookupTable table.
7. For ‘Output Join Field’, select the LANDUSE_CODE field.
8. Ensure that the ‘Add Join’ pane matches that shown below and click OK.

1. Right-click the DowntownParcels layer and select Attribute Table.
2. Scroll to the right and browse through all of the attributes.

...

1. Close the attribute table.
2. Right-click the DowntownParcels layer and select Remove.
3. Right-click the Land table and select Remove.
4. Right-click the LandUseCode_LookupTable table and select Remove.
5. In the toolbar at the top of the document, click Save.

You have successfully joined tabular data in ArcGIS Pro!

...

1. In the Contents pane, right-click the DowntownParcels_WithlandUse layer and select Symbology.
2. In the Symbology pane that appears over the Catalog pane, under the Symbology drop-down menu, select Unique Values.
3. In the ‘Value Field’ drop-down box, select the GROUP_DSCR field.
4. At the top right of the list of values, click the More drop-down menu and uncheck Show all other values, since there are none in this case.

...