Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

So I have 490 consecutive daily rainfall shapefiles/.dbf files in a single directory. Each consists of a uniform even-spaced grid of 220 points having uniform pointIDs, number of records, field names and datatypes, and a field containing a daily recorded rainfall value (in inches) for each point/record.

I'm trying to read in the first 7 .dbf's from a list, read their rainfall values, sum them up for each record/point, create a new shapefile (ie. weeksum1.shp) having the same table structure as the daily files and containing weekly calculated sums for each record. Repeat for the next 7 .dbf's until 70 weeks (490/7) of data are created.

I've successfully done this by converting the shapefile's to raster, but I have to keep associated attributes for each point which I didn't foresee before spending a lot of time building scripts/models to work with rasters...

USING: ArcGIS 10 (ArcInfo) SP4 with all extensions, ArcPy, Excel 2007

share|improve this question

1 Answer 1

Couldn't you just merge 7 DBFs, summarize based on the pointid, then join the resulting table back to one of the point shapefiles?

share|improve this answer
    
This. The specific tools are Merge (obviously) and then Summary Statistics, with pointid as the Case field and rainfall as a Statistic field, using the SUM option. –  nmpeterson Apr 22 '12 at 1:51
    
Works great! Thanks for the advice! –  Brachabre Apr 22 '12 at 5:31

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.