Please ensure no record is selected in the attribute table of the buffer layer.
Here is what I get executing Zonal Statistics as Table on your dataset.
Zonal Statistics as Table should work. Choose "MAJORITY" as the statistics type.
Without any data to experiment with, I wonder if the Zonal Statistics As Table GP tool would do the job here. Are you able to share a sample of the data to experiment with?
Alright. I can't vouch on the accuracy, but here is how you can work it out.
1. Use Zonal Statistics (Not Zonal Statistics as Table) with "MAJORITY" statistics type. This will result in the buffer shaped rasters with the value of the Majority value for the whole buffer part.
2. Use Raster Calculator between the Original LandUse Raster and the Zonal Statistics Output Raster.
Expression:
Con( "CAML_LU_1945_ClipBuff" == "ZonalSt_Ras", "CAML_LU_1945_ClipBuff")
3. Use Zonal Statistics as Table with "MAJORITY" Statistics Type, using the output Raster of the Field Calculator as the Value Raster.
The resulting table looks something like this
This did finally work - thank you so much. One more quick thing - is it possible to know not just the majority category but the area of that majority (the sum of the area in the majority of a circle/buffer)?
You are awesome - yes that was the problem. Is there any way to make it tell me the area of the majority along with the category. Like next to Majority 2 in the first line if it would also tell me the total area of Land use category 2. A million thank yous.
Yes, but that does not preserve the category that the maximum came from which is what I am really after. I could do it for each line of data manually but I have hundreds. Thank you for your help and congrats on imminent retirement:)
Thanks again. I did try but the output table only has one line with the majority identified. And the area is the area of the buffer (circle 500m radius) not the area of the majority. Regardless it is only for one ORIG_FID see screenshot. I really appreciate your help.
I have used Tabulate Area tool but that just gives each land use area for each clip and I only want the dominant land use in the buffer area.
So can't you just sort on what ever field got populated by the Tabulate Area tool and find the maximum?
Thank you for your reply. I tried that and it looks promising but could not get it to work. I'm new to this so I am not sure what sample data to provide.
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.