Maximum/Minimum attribute value

shivagugila

Hi All,

Can anyone, please let me know if we can use 'queryfilter' to find max/min value in attribute table of a featureclass(Shape OR GDB). Any other suggestions/help ?

Regards,
Shiva

GregRieck

Hi,

You can use IDataStatistics interface.
See the IDataStatistics Example in the Developer help.
In your case, use IStatisticsResults.Minimum & IStatisticsResults.Maximum properties instead of the Mean property proposed in the code.

Regards,
Nir

This IDataStatistics Example helped me find the min and max:

http://forums.arcgis.com/threads/4826-Bind-attribute-field-to-drop-down-list

If you scroll down and look at response #13 it includes the following:

pCursor = pTableSort.Rows
Dim pQFilter As IQueryFilter
pQFilter = New QueryFilter
pQFilter.WhereClause = pQF

Dim pData As IDataStatistics
pData = New DataStatistics
pData.Field = fieldname
pCursor = pFeatureclass.Search(pQFilter, False)
'pCursor = pLayer
pData.Cursor = pCursor

While it doesn't specifically show the use of min and max you can still get to it from this example by using

double dMax = pData.Statistics.Maximum;
double dMin = pData.Statistics.Minimum;

The key thing here is that the pData.Field must be populated with the field you want to retrieve statistics on.

Hope, this helps someone else. I found this information to be somewhat lacking and felt it needed just that little extra to complete the thread. Who knows, I may search on this again sometime and be able to use my own comments.