Scripts

Description of Scripts

Calculate Residential Development Fields

This script was created in ArcGIS Model Builder and

flowchart TB
  id1([Input: Residential Development Layer]) --> id2(Calc Units Remaining) --> id3(Calc Percent Complete) --> id4(Set % complete to 100 if greater) --> id5(Status to Built if 100%)

---

Calc Units Remaining

• Field Name: UnitsRemaining
• Expression Type: Python 3

!Units_Entitled! - !Units!

Calc Percent Complete

• Field Name: Percent Complete
• Expression Type: Arcade

iif(IsEmpty($feature.Units_Entitled) == true, 0, 100 * ($feature.Units / $feature.Units_Entitled));

Set % complete to 100 if greater

• Field Name: Percent Complete
• Expression Type: Arcade

Set % complete to 100 if greater

iif($feature.PercentComplete > 100, 100, $feature.PercentComplete);

Status to Built if 100%

• Field Name: Status
• Expression Type: Arcade

if( $feature.Status != 3 && $feature.PercentComplete == 100){
    return 3;
}
else{
    return $feature.Status;
}