calculate some critical field, output report
Step 0
PARCEL CLEAN UP
![](https://transparentgov.net/data/img5/standby_vv675.png)
Step 1
FULLADDRESS Field Calculation
![](https://transparentgov.net/data/img5/standby_vv676.png)
Step 2
Prorate Acreage (Rounds PRCACREAGE to nearest whole number and populates in PRORATEACRES field)
![](https://transparentgov.net/data/img5/standby_vv677.png)
![](https://transparentgov.net/data/img5/standby_vv678.png)
Step 3
Calculate APN11 Field
![](https://transparentgov.net/data/img5/standby_vv679.png)
Step 4
Calculate PRCSQFEET Field
![](https://transparentgov.net/data/img5/standby_vv680.png)
Step 5
Unmatched parcels between COV_POD and current parcel layer (COV_STANDBY_AVAILABILITY)
Paste to Excel Document
![](https://transparentgov.net/data/img5/standby_vv681.png)
Step 6
Calculate ID-2 FEEAMOUNT
![](https://transparentgov.net/data/img5/standby_vv682.png)
![](https://transparentgov.net/data/img5/standby_vv683.png)
Step 7
Prep Excluded Accounts for ID-1
TRUNCATE TABLE VPISPROD.dbo.STANDBY_ACTIVE_ID1_ACCOUNTS
Then Execute an append from VPISPROD.dbo.VW_ACTIVE_WATER_ID1_ACCOUNT_PARCELS into VPISPROD.dbo.STANDBY_ACTIVE_ID1_ACCOUNTS using ArcCatalog
Details see part 3
But here need to fix the APN value has multiple space problem. APN_staging is column I created which trim all empty space after APN value. Now I want to use APN_staging value to replace APN column.
![](https://transparentgov.net/data/img5/standby_vv687.png)
There are 2 way to do it.
Option 1, do it in ArcPro. use field calculator in attribute table.
Option 2. do it in SQL server with SQL query.