Skript to sum up attribute values and copy them into a table

MatthiasAbele

Hallo,

I ve a lot of gdb-features in different feature datasets. I would like to sum up all "shape_area" values of each feature and copy the result of the sum in an output table.
To identify the source of the number in the output table, I need an additional column with the name of the source file.

How can I do this?

Thanx

Matthias

markdenil

create an output table with name and area fields
get a list of the data sets
get a list of the feature classes in each data set
cycle through the feature classes, one data set at at time
create a search cursor on the first feature class
run through the records, adding the area of that record to a running total
You have the feature class name already
write the name and total area to a python list
add that list as a member of a list of lists
do the next feature class in that data set
after that, do the next data set
... and so on
then
create an insert cursor for the output table
cycle through the list of lists, adding each name and total area sub list as a new record

all done.