Page History

...

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 ‘Add Join' tool settings match those shown below and click Run.
   

...

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

Notice the four new fields added to the end of the DowntownParcels attribute table showing the land use for every parcel. Because you want to symbolize the parcels using the generalized land use categories, you will now also join the LandUseCode_LookupTable table using the land use code as the common field.

...

At this point, the table is mostly cleaned up, so you will add two new columns to calculate the percent of the total land area that is developed and forest.

1. In cell F1, type “Per “Per_Forest”Forest”.
2. In cell G1, type “Per “Per_Developed”Developed”.

Now you will calculate the formula where Per_Forest = Forest/(Total-Water).

1. In cell F2, type “=” to indicate the start of a formula.
2. Click cell C2 (Alabama Forest).
3. Type “/(” (divided by, open parenthesis).
4. Click cell B2 (Alabama Total).
5. Type “-” (minus sign).
6. Click cell E2 (Alabama Water).
7. Type “)*100” 100” (close parenthesis, times 100).
8. Ensure your cell says “=C2/(B2-E2)*100” 100” and press Enter to finish the formula.
9. Click cell F2 containing the formula you just entered.

...

1. In cell G2, use the same formula building techniques to enter “=D2/(B2-E2)*100” 100” and copy the formula down the table.

One last problem with this worksheet, which is difficult to detect, is that there is actually a space stored after every state name. This space will prevent the table from joining properly to another table whose state names do not have a trailing space. You will now perform a series of automated operations to remove this extra space.

1. Click column B.
2. Hold down Shift and click column D.
3. Right-click column D and select Insert to add three new columns in which to work.

First, you will use the Text to Columns tool, which splits the information contained in one column into multiple columns based on a delimiter. The delimiter is the character which is used to signal when to shift the data to the next column. As a result, the delimiter itself is removed and all characters following the delimiter are shifted to the next column. In this case you will use the space as the delimiter to remove it.

1. Click column A.
2. Click the Data tab at the top of the Excel window.
3. Under the Data Tools section, click the Text to Columns button.
4. In the ‘Convert Text to Columns Wizard’, click Next >.
5. In the Delimiters box, uncheck Tab and check Space and click Next >.
6. Click Finish.
7. When asked if you want to replace the contents of the destination cells, click OK.

The extra spaces have been removed, but the state names with two words have been separated into two columns. You will need to concatenate them back together into a single column separated by a space, but only for those states with two words. Performing a concatenation on all the states with an added space in between the two words would end up adding the trailing space again. The formula below basically says, if column B is blank, then copy the state name from column A; otherwise, if column B contains text, then concatenate the first part of the state name in column A with the second part of the state name in column B and add a space in between them.

1. In cell C2, use your formula building techniques to enter “=IF(B2="",A2,CONCATENATE(A2," ",B2))”. Ensure that there is no space between the first set of quotation marks and a single space between the second set of quotation marks.

...

At this point it looks good, but the values contained in column C are actually formulas, not text, and ArcGIS will not be able to interpret the formulas.

1. Right-click column C and select Copy.
2. Right-click column D and select Paste Special….
3. In the ‘Paste Special’ window, select to Paste Values Values and click OK.

Now the states listed in column D are stored as text, rather than as formulas, so you can now delete columns A through C.

1. Click column A.
2. Hold down Shift and click column C.
3. Right-click column C and select Delete.
4. In cell A1, type “State” “State”.

Removing all formatting in Excel

At this point your table has everything you need and nothing extra, but it is always recommended to clear all formatting and programming, including special fonts, background colors, borders, formulas, etc., before bringing the Excel file into ArcGIS.  To get rid of all formatting and programming, you will copy all of the data into a new blank worksheet.

1. Click the Select All button in the top left corner of the spreadsheet.

1. In the Home tab, click Copy.

1. Click the File tab and select New.
2. Ensure that Blank Workbook is selected and click Create.
3. In the new workbook, right-click cell A1 and select Paste Special….
4. Select to paste Values and click OK.

You should now have a clean version of your data with no special formatting. The last step is to expand the cells to ensure that all of their content is displayed.

1. Click column A.
2. Hold down Shift and click column G.

Hover your cursor over one of the lines between any two of the column letters. Notice that your cursor changes from a single arrow pointing down to a double arrow pointing left and right.

1. Double-click the dividing line between column A and B.

The width of all your columns should now be expanded to show all of the cells’ content. You are finished formatting your table.

1. Click the File tab and select Save As.
2. Navigate to the TabularTutorialData folder on the desktop Desktop.
3. For ‘File name:’, type “US“US_LandCover”LandCover”.
4. For ‘Save as type:’, use the drop-down box to select Excel 97-2003 Workbook.
5. Click Save.
6. Close Excel.

...

Now you will return to ArcGIS to map the land cover data by state.

1. Maximize ArcGIS Pro.

Because you already have the map document from the prior exercise set up with the correct default database, you will use this map document as a template, rather than starting a new one.

1. Click the Insert menu and select New Map.

This creates a new map in the project in which you will map your state land cover data.

...

1. In the Catalog pane, double-click the Maps folder and right-click Map2.
2. Select Rename and change the File name to “USLandCover”“USLandCover”.

You will now explore the state data.

1. In the Catalog pane, expand the Databases folder.
2. In the TabularData geodatabase, drag the US_States feature class into the Map Displayview.
3. In the Contents pane, right-click the US_States layer and select Attribute Table.

...