I have 3 shapefiles with me. They are a flooded layer, District layer and Village layer. To estimate flooding village wise, I have to do intersecting the features and get the layer. Then I calculate the flooded layer.
Raw village shapefile contains the attributes 'Village_Name' and 'Area'.
District layer contains 'District_name' and 'Revenue_Circle'
After intersecting the area for the flooded layer is calculated as 'flooded_area'. So the intersected layer will have 'District_nam','Revenue_Circle', 'Village_area' and 'flooded_Area'.
After doing all these I have to convert all the attributes to excel file and using Pivot table all the data need to be sorted district wise. In the excel I have to remove underscore, change the field name, adding a percentage of the village area got flooded and display summation at the last and all these are done in separate sheets for each district.
Is there any automatic workflow for this if I have to do this every day?