I have multiple polygons that have zero to 4 points (sampling sites with a list of species) in them. I need all the information from these sampling sites ONCE per catchment. So instead of up to 4 times the same species I need ONE list of species per polygon. My only idea is to aggregate or merge the points per polygon (no idea how, the points dont have a common field I could use), then export it to Access, erase repetitive species and then import it back to GIS. Maybe there is an easier way.

I am using ArcGIS 10.4.

EDIT: With spatial join, I added a column to my points shape with the ID of the polygon. That means if 2 sampling sites (points) are in one polygon, they now have the same polygon-ID. In one column I have the species names, with one line per species. That means that for each polygon there are multiple lines (as many as different species) but for the ones where more than 1 sampling site are located, some species are double or three of four times in this list. That I have to change.

  • As mentioned by @Josep Pinyol, you must first use a spatial join. For the second step, please edit your question with an example of field. Do you have one field per species with 0/1 for presence/absence or one large text field with species names separated with commas, or ??
    – radouxju
    Commented Jun 20, 2018 at 12:14

1 Answer 1


You can use the tool join by location:


Doing that, a new field for each point attribute will appear in the polygon feature class. After that if you want to erase the repeated species you can use the tool delete field in a model to run it several times with your needs.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.