Minimum value selection from multiple points with same location

12-05-2012 07:10 AM
New Contributor
I have a database of water wells where some wells have the same location however, some have unique locations. At each point (unique or not) I need to select the minimum value. In my case, it is "static water level". Ultimately, I want to interpolate these values. I am trying query builder without success.
Tags (2)
0 Kudos
1 Reply
Esri Contributor
You should be able to do this with the Summary Statistics tool available in the Analysis Tools > Statistics toolset. Select the static water level field as Statistic Field and Min as Statistics type, and as case field(s) a field or combination of fields that uniquely define each location (E.g. X/Y field, locationid - do not use shape for the case field) .

Christine Dartiguenave
Esri Water Resources Team
0 Kudos