nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Summarizing Point Attributes Within A Polygon

HankArnold

I'm using ArcGIS Desktop 10.6, have a layer with 35k points representing the location of each individual bird in a drone based wildlife study, and several polygons representing areas within the overall map.

What I'm looking for is a list of all the birds that fall within a particular polygon, with a total for each species.

With the entire database of all birds, I can summarize and get the totals, so I'm thinkin that's the direction I need to go, but I can't get a subset database of points within a polygon.

If I do a join from the polygon to the species database, I get a single line representing the total for all birds within the polygon that sounds about right, but only a single line. This also gives me the idea that both the polygon and the database are properly defined and positioned.

When I do a join from the species database to the polygon, I get every bird in the original database, 35k.

I've looked through the other "Polygon/Point" discussions and searched the web, and my fear is that my question is so simple that I can't find it somewhere else

Any suggestions appreciated

Polygon Example.jpg

SebastianKrings_0-1779309388708.png

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

MervynLotter

You are almost there. Do a join from species to polygon so that you have 35k records, then just open attribute table and the the Summarize tool on the unique polygon number/name. In the option to choose one or more summary stats to be included, make sure you select your unique bird name. It will list the relevant species and provide a count.

Mike Miller also created a similar online tool to do this, with added diversity indices. Do see Diversity Calculator - Geospatial Brainstorming

MervynLotter

Sorry, one small change in my suggestion, you will need to run the Summary Statistics tool.

Statistics Field is species name with stats type as count. The case field will be both your species and polygon name/number fields.

HankArnold

Mervyn,

Thanks very much for the response.

When I do the join from the 35k layer to one of the area polygons, and get the new 35k table, I do get a bunch of new fields, but none that I can see that has any information of individual points being in the polygon

I'm attaching a screen shot of the table.

Except for the species, lat, lon, etc that are defined in the original dataset, none of the new fields shows any difference, all the way down.

If I could get a 35k table with some way to delineate the points in the polygon, there are several options to get the totals, including exporting the data and working with something I'm more familiar with.

How can I tell in the newly create 35k table, which records were within the boundary of the join?

Thanks in advance Screenshot of the table created by a join from a master dataset to a polygon

MervynLotter

You will have to open up your polygon layer to check whether it has a

unique identifier, whether it be a grid name, farm or reserve name, etc.

The way I understand it, you want a species list with abundances (counts)

for each polygon (or one polygon in your case), so each polygon requires a

unique name. From the table you provided, I can not easily see if you in

fact do have a unique name or number.

If not, add a unique name to your polygon then summarize as in my second

post.

DanPatterson_Retired

Do a Select by Location

http://pro.arcgis.com/en/pro-app/tool-reference/data-management/select-layer-by-location.htm

The polygon is your selector. It will select all the points in the polygon.

Then right-click on the layer, Data, export features.... you will now have a separate point layer which represents the points in those polygons.

You are done.

Repeat if you only have a few, because I know at some stage you are going to want to split the data up into its separate components, so do it up front and keep the original data intact, unjoined and unspoiled

HankArnold

Dan,

This worked perfectly.

I want to learn how to get Mervyn's suggestion to work, because I need to learn how to properly import and work with different types of data, but your method is independent of identifiers, Object IDs, etc.

Thanks very much

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.