I am working on a land suitability analysis in ArcGIS Pro. I wanted to find out the total count of the are that I am working in. I was very exciting to see that when I right click on the Count field in the attribute table, the statistics option is back. I ran the statistics on the field, however when I went to look at them the total count that was calculated is WAY larger than what is possible for the area. Is this issue happening for anyone else? Does anyone have suggestions how to fix this?

For reference the largest number I have is 151941, the second largest number I have is 58608 and they are increasingly smaller from there. There is no way these numbers could sum to a total of 850924

Hi Natalie Robbins

I’ve spoken to my developer and I think we’ve uncovered the issue.

When looking at raster tables the COUNT field is the number of pixels for each value, and serves as a multiplier of the other fields. For example, if you ran statistics on the VALUE field, each value in the VALUE field would be multiplied by COUNT (e.g., there are 100 pixels with value 1, 200 pixels with value 2, etc) and then all summed up. So, running a statistic on the COUNT field doesn’t really make sense for rasters. Essentially, the Sum statistic for the COUNT field in the Statistics table ends up being the sum of COUNTs squared (each count value is multiplied by the number of pixels with that value (COUNT), and summed).

If I understand you correctly you are looking for the total number of non-null pixels in your dataset. If you were to subtract the number of Nulls in the statistics table from the Count number in the statistics table (Count includes nulls), then you would get the number of non-null pixels. Another way to do this would be to run the Summary Statistics tool on that COUNT field, which would return a table with the sum of the values in that column.

Let me know if you need further clarification, it's a tricky issue!

Thank you,

Flora