I am fairly new to GIS and I am using ArcGIS Desktop 10.4.
The wildlife monitoring company I work for uses camera pods to sample fisheries population and uses side scan sonar to collect habitat data. Together this data is entered into ArcMap and analyzed for further study where Camera Sites = point and Habitat = Polygon.
What I want to do for each camera site (point) is create a buffer (50 meters). After creating a buffer I would like to calculate how much area (sq. meters) of what type of habitat fall within each buffer.
To do this I have:
- Created a buffer around Camera sites
- Performed an Intersect between Buffer and Habitat layers
Originally I had 184 records (184 camera sites). After I run the Intersect I have close to 700 records resulting in many rows for each camera site. This makes sense because there is often more than one polygon per habitat type within each buffer
Reference = Camera Site
Below is an example of the resulting attribute table where Reference = GMM120304501:
What I want is to have one line for each camera site showing area for each habitat. To do this I used the Pivot Table tool to make Geoforms column headings and the Area_50 field to fill the values.
The Pivot table result is below. My issue is that there are multiple lines for individual camera sites.
Example image of my issue where Reference is same as above ex. (GMM120304501).
Is there a way to Merge these values in the table above based on Reference and have the habitat types add together into one row?
Once this problem is resolved I plan on repeating the process with 3 buffers total and joining all the tables together based on the Reference Field.