Divide raster values based on municipality boundaries

[Deepa]

Hi,

I have a raster file of a county with value 1 (Best sites to build rails) and NoData (unsuitable areas for rails). I also have a shape file of all the municipalities within this county. I would like to combine these files such that the final attribute table of the raster will have the cell counts with value 1 for each municipality. I can export each municipality and then combine with the raster to solve this. But is there a better and easy way to solve this?

Thank you!

[DavidPike]

Can you better describe your intended final output and possibly provide screenshots.

[Deepa]

Right now, i have raster file with values 1 for a county. There are some NoData within the county which i am not interested in further analysis. Attribute table looks like this :

OBJECTID	VALUE	COUNT
1	1	20

Within the county there are 3 municipalities and i have a shape file of this. Attribute table looks like this:

OBJECTID	Shape	Municipality_names
1	Polygon	ABC
2	Polygon	DEF
3	Polygon	GHI

I would like to combine them spatially such ´that i  get a final attribute table like this:

OBJECTID	Municipality_names	Value	Count
1	ABC	1	10
2	DEF	1	5
3	GHI	1	5

[DavidPike · Accepted solution]

You could possibly vectorise your raster data and utilise Tabulate Intersection (Analysis)—ArcGIS Pro | Documentation

or Zonal Statistics as Table (Spatial Analyst)—ArcGIS Pro | Documentation

[JeffHouser · Accepted solution]

I have not tried this, but have you looked into "Spatial Analyst Tools - Zonal - Zonal Statistics as Table". 
https://gis.stackexchange.com/questions/251796/extract-raster-information-based-on-polygon-features

 Last step, is to do a tabular join back to the Raster data.  Again, I have not done this, but it seemed appropriate to what you're trying to do?  This functionality, if it works, may prevent the need to vectorize the raster date set.

[Deepa · Accepted solution]

Thanks David and Jeff 🙂 

It worked with Zonal statistics as table using my polygon file of municipalities and raster file with values.