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