Select to view content in your preferred language

Zonal Statistics as Table - Missing Zones

3437
1
08-11-2015 04:23 PM
JacksonVoelkel
Deactivated User

Hi all, first time poster here!

I'm currently running zonal statistics as table on 126 different raster layers. The 'zones' are also a raster. The cells are all snapped, the datums/projections are the same, and I can actually get SOME results in my table... however not all.

Out of ~1.4 million zones, I get 90k results using a unique ID field. Because there are actually 10 different zone files, I needed a unique ID for each zone, so these zone #'s get up to ~13.4 million. When I use the VALUE field (unique within each data set, however not unique within all 10 data sets), i get all of the results returned. I calculated this field within the raster attribute table after the raster was already created, if that helps at all.

Any ideas of how to make this work? I've already tried converting to a shapefile (same, ~90k polygons), using the "Lookup" Spatial Analyst tool (only gives me ~80k zones in the new raster), and screaming.

0 Kudos
1 Reply
DanPatterson_Retired
MVP Emeritus

sample output would help...but...using each value field from each file makes sense, what are you summarizing?  I presume that there is some overlap in the classes.  I might be oversimplifying but I think that you just want a stack of the tables and a recalculation of the ID like so assuming 4 zones per file

0 stats               table 1

1 more stats

2 get it

3 and so on

0 stats               table 2

1 more stats

2 get it

3 and so on

0 stats               table 3

1 more stats

2 get it

3 and so on

desired output???

0  0 stats               table 1

1  1 more stats

2  2 get it

3  3 and so on

4  0 stats               table 1

5  1 more stats

6  2 get it

7  3 and so on

8  0 stats               table 1

9  1 more stats

10  2 get it

11  3 and so on

...

This can be accomplished in several arrays if you have the results in tabular form for example, the data could be stacked into numpy arrays should wish to perform further stats analysis on them

0 Kudos