Summary
In ArcGIS Pro, when working with zoning files that display parcel data, the total number of parcels may be expressed in terms of percentage. Displaying the parcel count in the map legend as percentage data is useful for statistical analysis and land use planning.
To get the percentage of parcels in each zone, the values must be calculated and updated manually. The instructions provided describe how to display the total number of parcels as percentages when using a zoning table for ArcGIS Pro.
Procedure
- Start ArcGIS Pro and open the project.
- In the Contents pane, right-click the feature class and click Attribute Table to open the attribute table of the feature class.
- Click Clear Selection to deselect all selected rows.
- Right-click the target field and click Summarize.
- In the Summary Statistics dialog box, configure the parameters.
- For Output Table, specify a name for output table to store the calculated statistics. In this example, the output table is ZONE_COUNT.
- For Statistics Fields, select the Field and Statistic Type drop-down menu to be calculated. In this example, ZONE_CODE and Count are selected.
- For Case Field, select the same field from Step 5(b).
- Click OK.
- In the attribute table, right-click the target field and click Summarize.
- In the Summary Statistics dialog box, configure the parameters.
- For Output Table, specify a name for output table to store the calculated statistics. In this example, the output table is ZONE_SUM.
- For Case Field, click Remove.
- Click OK.
- In the Contents pane, right-click the stand-alone table created in Step 7 and click Open to open the table.
- Take note of the sum of parcels calculated. In this example it is 195.
- In the Contents pane, right-click the feature class, click Joins and Relates, and click Add Join to open the Add Join dialog box of the feature class.
- In the Add Join dialog box, configure the parameters.
- For Input Field, select the same field from Step 5(b).
- For Join Table, select the stand-alone table created from Step 5. In this example, the stand-alone table is ZONE_COUNT.
- For Join Field, select the same field from Step 5(b).
- Click Validate Join to determine if the layer and table have valid field names and Object ID fields.
- Click OK.
- In the attribute table, click Add to add a new field.
- In the fields view, specify a name for the new field, alias, and set the data type to Double.
- Click Save on the ribbon to save all edits to fields.
- Return to the attribute table, and click the newly created field to highlight it. In this example, the newly created field is ZONE_PERCENTAGE.
- Click Calculate to open the Calculate Field and configure the parameters.
- For Expression Type, select Arcade.
- Specify the following Arcade expression in the Expression section:
$feature['<fieldName>'] / <sumOfParcelsCalculated> * 100
The code block below shows the full expression.
$feature['ZONE_COUNT.COUNT_ZONE_CODE'] / 195 * 100
- Click Verify to run a test of the expression. If the expression is valid, click OK.
The image below shows the total number of parcels as percentages in the attribute table.