Run SQL output final 2024 water standby report. Copy SQL result Paste into Excel file
Step 1
Total Assessment for ID-2
![](https://transparentgov.net/data/img5/standby_vv684.png)
Step 2
Total Parcel Count for ID-2
![](https://transparentgov.net/data/img5/standby_vv685.png)
Step 3
Calculate ID-1 Fee Amount. Multiply Prorated Acres Field by 10
![](https://transparentgov.net/data/img5/standby_vv688.png)
Step 4
Total Parcel Count for ID-1
![](https://transparentgov.net/data/img5/standby_vv689.png)
Step 5
Total Assessment for ID-1
![](https://transparentgov.net/data/img5/standby_vv695.png)
Step 6
ID-1 Property Listing
![](https://transparentgov.net/data/img5/standby_vv696.png)
Step 7
ID-2 Property Listing
![](https://transparentgov.net/data/img5/standby_vv697.png)
Step 8
ID-1 Mailing List
![](https://transparentgov.net/data/img5/standby_vv698.png)
Step 9
ID-2 Mailing List
![](https://transparentgov.net/data/img5/standby_vv699.png)
Step 10
ID-1 Lien List
![](https://transparentgov.net/data/img5/standby_vv701.png)
Step 11
ID-2 Lien List
![](https://transparentgov.net/data/img5/standby_vv702.png)
Step 12
Unmatched parcels between COV_POD and current parcel layer (COV_STANDBY_AVAILABILITY)
![](https://transparentgov.net/data/img5/standby_vv703.png)