Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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...

I am using ArcGIS 10 (ArcInfo) SP4 with all extensions, ArcPy, Excel 2007

share|improve this question

You could try merging 7 DBFs, summarize based on the pointid, then joining the resulting table back to one of the point shapefiles.

@nmpeterson:

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.

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! – Brach Apr 22 '12 at 5:31

Your Answer

 
discard

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