AnsweredAssumed Answered

Creating a Model for a Geoprocessing Task

Question asked by evanmacdonald9 on Jul 11, 2012
Latest reply on Jul 12, 2012 by Hornbydd
Hello All,

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