nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Zonal Statistics as Table - exclude values?

IsraelShpindel

Hi,

Is there a way to exclude certain values when running the zonal statistics tool? More specifically, I need to get the sum of the raster cells in each zone, and that works fine, but I also want to calculate the number of the cells that their values are higher than zero (zero in my data is equivalent to "no data"), regardless of their value.
When I run the tool, the output table contains a "Count" column, but it counts all the cells in the zone, including the zeros, so it doesn't give me any valuable information.
I know that theoretically I can use the Raster Calculator and replace the zeros with NoData, but I have dozens of rasters, and I don't want to use this option.

Thanks,
Israel

Find more posts tagged with

Accepted answers

DanPatterson_Retired

SetNull will allow you to specify 0 as your nodata value. If you have many grids to process consider writing a model/script to process all the rasters in a folder at once.

All comments

IsraelShpindel

Great, that is exactly what I need.
Thank you!

curtvprice

SetNull doesn't create a new raster?

Nested in map algebra it may make a "throw away" temp raster behind the scenes that is deleted when the map algebra expression is processed -- or it may be able to just do it in memory as it is processing. Depends on the combination of operators.

Does it change the original raster permanently?

Nope, the input raster is unmodified.

IsraelShpindel

However, you may want to look into this. Using Python map algebra you can set values to NoData before the tool sees them (no extra raster creation required).

SetNull doesn't create a new raster? Does it change the original raster permanently?

curtvprice

Ideally,the best solution would be to somehow "get into" the zonal statistcs tool through python and change its settings, but I guess that can't be done.

Israel,

Tool syntax and parameter interfaces are the same in the dialog interface or from ModelBuilder. This is actually a huge strengh of 10.0 over 9.x raster tools.

However, you may want to look into this. Using Python map algebra you can set values to NoData before the tool sees them (no extra raster creation required).

Here's an example:

valras = Raster("value_grid.img")
zonras = Raster("zones.img")
outZSaT = ZonalStatisticsAsTable(zonras, "VALUE", 
    SetNull(valras == 98 or valras == 99, valras)
                                 "stats_tbl", "NODATA", "MEAN")

IsraelShpindel

I'm aware of this option, but I was just wondering if there is any better way. I do work with python, but the problem is that this solution will take a lot of time (the grids are quite large) and I will also have to join the data into one table in the end of the process, which would make it even longer.
Ideally,the best solution would be to somehow "get into" the zonal statistcs tool through python and change its settings, but I guess that can't be done.

Thanks anyway!

DanPatterson_Retired

SetNull will allow you to specify 0 as your nodata value. If you have many grids to process consider writing a model/script to process all the rasters in a folder at once.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.