Page History

...

...

1. On the Desktop, double-click the Computer icon > gisdata This PC > GISData (\\file-rnassmb.rdf.rice.edu\research\FondrenGDC) (RO:) >  > GDCTraining > 1_Short_Courses >  >  Mapping_Tabular_Data.
2. To create a personal copy of the tutorial data, drag the Tabular folder onto the Desktop.
3. Close all windows.

...

1. Click Tabular.zip above to download the tutorial data.
2. Open the Downloads folder.
3. Right-click ProjectionsTabular.zip and select Extract All....
4. In the 'Extract Compressed (Zipped) Folders' window, accept the default location into the Downloads folder and click Extract.
5. Drag the unzipped Tabular folder onto your Desktop.
6. Close all windows.

...

You will now add a feature class to a new map that depicts all of the land parcels in downtown Houston. This feature class was originally obtained from the Harris County Appraisal District (HCAD) Public Data GIS website at http://pdata.hcad.org/GIS/index.html. The original parcels shapefile contained all of the parcels in Harris County, but working with such a large file can be time consuming, so, for the purposes of this tutorial, the layer was clipped to contain only those parcels in downtown Houston.

...

The HCAD_NUM field 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 no other information. Fortunately, a tremendous amount of information about the parcels can be obtained from HCAD in standalone tabular format. In this case, you would like to know the particular land use for each parcel, such as residential, commercial, or industrial. This information is contained in a separate Land table, which was originally obtained from the HCAD Public Data Download website at the the http://pdata.hcad.org/download/index.html.

...

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

Joining Tabular Data

1. button. (Note: if using a newer version of ArcGIS Pro than version 2.1.0, then you may receive a warning about version incompatibility here. You can confirm the save without any issues.)
   
   Image Added

Joining Tabular Data

Now that you have examined all of the data tablesNow 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 name and select Joins and Relates > Add Join.

The Geoprocessing pane should open on the right in a new tab overlaying the Catalog paneA tool titled Add Join should pop up on the screen. In the Add Join tool, notice that 'Layer Name or Input 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 to select the HCAD_NUM field.
2. For ‘Join Table’, use the drop-down menu to select the Land table.
3. For ‘Output Join ‘Join Field’, use the drop-down menu to to select the ACCOUNT field.
4. Ensure that the ‘Add Join' tool settings match those shown below and click Run  OK at the bottom of the Geoprocessing panetool.
   Image Removed
   Image Added
   
   
5. In the Contents pane, right-click the DowntownParcels layer and select Attribute Table.
6. Scroll to the right and browse through all fields.

...

1. In the Contents pane, right-click the DowntownParcels layer and select Joins and Relates > Add Join.
2. For ‘Input Join Field’, use the drop-down menu to to select the Land.LAND_USE_C field. If that field does not appear in the list, you may have skipped the step above and are still viewing the previous run of the Add Join tool, which has not been refreshed to load the newly joined field names.

...

1. names.
2. For ‘Join Table’, use the drop-down menu to select the LandUseCode_LookupTable table.
3. For ‘Output Join ‘Join Field’, use the drop-down menu to select the LANDUSE_CODE field.
4. Click RunOK.
5. Once the join is complete, scroll to the far right in the DowntownParcels attribute table.

...

In order to successfully perform a join, the corresponding join fields in both tables must be of the same field type. Unlike in Excel, you cannot simply convert an existing field from one type to another. Instead, you must create a new field of the correct field type and copy the data over into the new field. In this case, you will convert the LAND_USE_C field in the Land table to a text field type to match the text field type used in the LandUseCode_LookupTable table.

1. In the Catalog Contents pane, right-click the Land table and select Design > Fields select Open to open the attribute table.
2. At the top right of the Land table view, click the collapsed menu icon (or hamburger button) and select Fields View.
3. At the bottom of the attribute table, click ‘Click here to add a new field.’
4. For the new ‘Field Name’, type “LAND_USE_C_Text” and press Enter.
5. For ‘Data Type’, click once to highlight Long and activate the field and then click Long a second time and use the drop-down menu to select Text instead.
6. On the ribbon, the Fields tab should now be active. In the Changes group on the far rightManage Edits group, click the Save button to save the changes to the design of the Land table fields.

...

1. Close both table Fields: views.
2. In the Contents pane, right-click If not already selected, navigate to the Land attribute table and select Open.
3. Right-click the LAND_USE_C_Text field name and select Calculate Field.

The On the right, in the Geoprocessing pane, the Calculate Field tool will openshould pop-up on the screen.

1. In the 'Fields' list under the 'Expression' subsection of the tool, double-click the LAND_USE_C field.

Notice that the box below 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 into the new LAND_USE_C_Text text field.

1. Click Run OK.

In the Land table view, 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, rather than right-aligned as numbers.

...

1. In the Contents pane, right-click the DowntownParcels layer name and select Joins and Relates > Remove Join.

In the Geoprocessing pane, the The Remove Join tool will openpop up on the screen.

1. For 'Layer Name or Table View', leave the default DowntownParcels layer selected.
2. For 'Join', use the drop-down menu to select the LandUseCode_LookupTable table.
3. Click Run OK.

You will now repeat the process of joining the lookup table.

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 LANDUSE_CODE field.
   Ensure that the ‘Add Join’ pane matches that shown below and click RunOK.
   Image Removed
   Image Added
   
   
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.

...

1. Right-click the DowntownParcels layer and select Data > Export Features.
2. For ‘Output Feature Class’, click the Browse button.
3. Double-click the Tabular.gdb geodatabase.
4. For 'Name', type “DowntownParcels_WithLandUse” and click Save.
5. Click Run OK.
6. Right-click the DowntownParcels_WithLandUse layer name and select Attribute Table.

...

1. In the Contents pane, right-click the DowntownParcels_WithLandUse layer name and select Symbology.
2. In the Symbology pane that opens over the Catalog pane, use the 'Symbology' drop-down menu to select Unique Values.
3. For ‘Value field’‘Field 1’, use the drop-down menu to to select the GROUP_DSCR field.
4. 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 you will be symbolizing all values.

...

1. Right-click column B and select Insert to add a new column in which to work.
2. In cell B2, type “=” to indicate the start of a formula.
3. Type “=trim(”.
4. Click cell A2 (Alabama).
5. Type “)” (close parenthesis).
6. Ensure your cell says “=trim(A2)” and press Enter to finish the formula.
7. Copy the formula down the table.

...