Calculate multiple shapefiles inside of other shapefiles for area

1798
6
Jump to solution
11-10-2018 01:06 PM
BaileyFredlund1
New Contributor III

Hello,

   I am wondering if there is anyway to combine shapefiles (or calculate or join) to a layer of different shapefiles to calculate total area inside of them.

   For example, I have a buildings footprint layer which has company name and other building information in each shapefile (black outlined polygons in image). I have calculated suitable locations for solar panels on the rooftop(pink color in image) which has the calculated area and would like to calculate the total solar panel potential for each building footprint shapefile. 

   I was thinking something along the lines of somehow grouping the solar shapefiles that are inside each building shapefile and combining them and calculating total area. Then possibly calculating a new row in the attribute table of the building shapefiles so I can display that in color coordination. 

Any help would be great, thanks in advance!!!

0 Kudos
1 Solution

Accepted Solutions
MervynLotter
Occasional Contributor III

The Summarize Within GP tool should do this for you. Do take a look at Summarize Within—Help | ArcGIS Desktop 

You should be able to use a building name or number (if you have one, or anything similar) if you want to calculate the extent of solar panels for each building as well, just make sure to use the Group Field option. You can then link the output table back to building layer if needed.

View solution in original post

6 Replies
MervynLotter
Occasional Contributor III

The Summarize Within GP tool should do this for you. Do take a look at Summarize Within—Help | ArcGIS Desktop 

You should be able to use a building name or number (if you have one, or anything similar) if you want to calculate the extent of solar panels for each building as well, just make sure to use the Group Field option. You can then link the output table back to building layer if needed.

BaileyFredlund1
New Contributor III

Thank you so much for your reply. Unfortunately, I do not have this tool on the license that I have. Do you know if it only works for Arc Pro? I tried looking for this answer but couldnt find a straight forward answer. Thanks!!!

0 Kudos
MervynLotter
Occasional Contributor III

What license do you have? ArcGIS Desktop Advanced? Tabulate Intersection requires the advanced license and can do the same thing. 

But if you have a Basic license, then you may need to do this in a few steps: (1) an Intersection, then (2) use Summary Statistics to extract the statistics you require. 

You could optionally Calculate Geometry between steps 1 and 2 if you are not saving to a geodatabase. 

0 Kudos
MervynLotter
Occasional Contributor III

You could also try a Spatial Join, with the option to summarise the attributes from your solar panels (see below screenshot). You will need to right-click on your Buildings layers and then select Joins and Relates > Joins...

0 Kudos
BaileyFredlund1
New Contributor III

Thanks for your replies! I had a buddy lend me her login to ArcGIS Pro and the Summarize Within worked perfectly! I appreciate your advice.

0 Kudos
MervynLotter
Occasional Contributor III

Pleasure

0 Kudos