calculate acres column value on both water district



Step 1

add following 3 field to both district 1,2 table





Step 2

populate standby year and district id




Step 3

calculate acres



Step 4

ready to append district 1, 2 



use append tool to combine water district 1 and 2  


Step 1

search 'append' in geoprocessing tab, history, I will use these 2 append tool




Step 2

use this append for water district 1



Step 3

manully mapping following field, water district





Step 4

manully mapping following field, standby year





Step 5

Following field leave it as unmapped, because I will calculate after








Step 6

Warning. ArcPro bug, append tool does append 5962 rows, however, only district number and standby year 2 column get copied. The other colum are all value in target table COV_standby_availability. You can check in SQL server





Step 7

or you can check in ArcPro




Step 8

To fix ArcPro bug, you need to start a new arcPro project just do this append tool only


use load function to load previously saved exported fieldmap file, so you don't have to spend half hour again to map each field. To save you time


Step 8.1




Step 8.2

repeat step 6 and 7 to check whether this time success. In my case, this fix the bug, no more null value




Step 9

Repeat step 4 to 8 again, but against water district 2











Please log in or register