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'm just a rookie when it comes to creating models in ArcGIS. I have two shapefiles from which I need to calculate an AVG and a MAX erosion rate for individual properties.

The two shapefiles are:

Coastal_Properties & Coastal_Change

Coastal_Properties has a Property ID (PID), and Coastal_Change has a Rate of erosion in metres per year (RChngMYr).

I'd like to retrieve an Average and a Max RChngMYr for each individual PID in the data-set.

I have no problem running this query using SQL select in MapInfo, but am unsure how to go about it in ArcGIS. It will be better in the long run to create a model in Arc as Property boundaries are dynamic, and it would be terrible to have to run the query in MapInfo everyday. I'd like to create a Geoprocess service from this model and use it in a web application where it would return a phrase such as "The Max erosion rate for PID 12345 is 3.1 m/yr".

Any help is appreciated! Thanks in advance

share|improve this question
What type of database back-end do you want to run this on? Only Personal Geodatabase (Access) or an ArcSDE RDBMS Geodatabase support Average, Max, Min, Distinct, etc. File geodatabase does not support these functions. – Jakub Jul 11 '12 at 16:57
File geodatabases do support at least the MAX() function via subqueries: "yourField" = (SELECT MAX("yourField") FROM yourFeatureClass). – AHigh Jul 11 '12 at 17:08
I'm not really familiar with the use of File and Personal Geodatabases. I just assumed I could input shapefiles in the model and add the necessary tools to perform the function? – user1504200 Jul 11 '12 at 17:32
Have a look at the Summary Statistics tool. – blah238 Jul 11 '12 at 18:52
Thanks very much for the help everyone. The Summary Statistics tool is the one I am looking for! – user1504200 Jul 12 '12 at 12:14

As @blah238 said the best way to do this is by using the Summary Statistics tool.

share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.