HELP!!How to write the python script?

wiz

Here is the question:

There are two geodatabases (Village.gdb and Town.gdb). Village.gdb contains 277 feature classes, and every feature class has 10 fields (only Shape_area will be used) and many records. Town.gdb has only one feature class called town277, which has 6 fields (only town_name and Sum_area will be used) and 277 records.

Now, I want to sum the Shape_area of every feature class in village.gdb, and then assign the values to Sum_area, which the values of town_name equal to the name of 277 feature class in village.gdb.

So, how to write the python script?

TKS!!!

JaiSiva1

Hi Wi,

This is a sample code , that does the job . You can still modify it , to make things efficient

import arcpy
from arcpy import env

#Configuration goes here
vill_fields = ['Shape_area']
town_fields = ['Sum_area']


env.workspace = r'D:\Geonet\geodbase\village.gdb'
village_List =  arcpy.ListFeatureClasses()   #pushing all the fc's into a list
town = r'D:\Geonet\geodbase\town.gdb\base'

def findTotalArea(fc):
  with arcpy.da.SearchCursor(fc,vill_fields) as cursor:
      varea = 0
      for row in cursor:
          varea = varea+row[0]
      return varea

for fc in village_List:
  farea =  findTotalArea(fc)
  with arcpy.da.UpdateCursor(town,town_fields,"town_name = '" + fc + "'" ) as cursor:
      for row in cursor:
          row[0] = farea
          cursor.updateRow(row)