Automation

Cutting down on repetitive tasks, mitigating human error, and ensuring data completeness was made possible through geoprocessing tools created with Python scripts using ArcPy and other libraries.

Addressing
Water
Data Quality
Webmaps

Addressing Task

Using seven Python scripts, this three part task calculates and transfers attributes into street, parcels, and address point feature layers for entire blocks and subdivisions.

Here are demos of two GP Tools within the task.

Generating Lot and Address Numbers

1) Generate Lot Number

The script reads a feature layer and a target field, along with a start and end value for numbering. It calculates centroids for each feature, then sorts by descending spatial order and optionally reverses the order based on user input. The script assigns sequential values to the target field using an update cursor and writes each value with updateRow. Finally, it copies the numeric values into a text field for labeling or display purposes.

2) Generate Address Number

The script reads a feature layer and parameters defining a start and end house number, the number of units, desired parity (even, odd, or any), a reverse flag, and a target field to populate. It calculates a numeric step size based on the range and unit count, then adjusts the starting value so it matches the requested parity. Using an update cursor ordered by lot number, the script assigns house numbers to each feature and writes them to the target field with updateRow, either increasing or decreasing the value depending on whether reverse is false or true. After each assignment, the script increments or decrements by the step size and corrects for parity as needed, appending the street direction to each value before moving to the next feature.

Next
Next

Water