# Is there a way to tell, in a project, which plant has been visited by the most arthropods?

**URL:** <https://forum.inaturalist.org/t/is-there-a-way-to-tell-in-a-project-which-plant-has-been-visited-by-the-most-arthropods/85554>\
**Category:** General\
**Tags:** question\
**Created:** [September 18, 2026, 1:57am UTC](https://forum.inaturalist.org/t/is-there-a-way-to-tell-in-a-project-which-plant-has-been-visited-by-the-most-arthropods/85554 "2026-09-18T01:57:48Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![digitalbio](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.inaturalist.org/digitalbio/32/64840_2.png) [@digitalbio](https://forum.inaturalist.org/u/digitalbio)\
**Post date:** [September 18, 2026, 1:57am UTC](https://forum.inaturalist.org/t/is-there-a-way-to-tell-in-a-project-which-plant-has-been-visited-by-the-most-arthropods/85554/1 "2026-09-18T01:57:48Z")

</div>

I have a project (Ballard oasis) where I’ve been keeping track of everything I can that shows up in my yard. I’ve been wondering if there’s a way to count the number of species that visit a certain species of plant. I know can count these manually or maybe try to download my data and use Excel but I was wondering if there’s a better way to do this.

---

<div class="post-metadata">

**Author:** ![pisum](https://avatars.discourse-cdn.com/v4/letter/p/91b2a8/32.png) [@pisum](https://forum.inaturalist.org/u/pisum)\
**Post date:** [September 18, 2026, 4:09am UTC](https://forum.inaturalist.org/t/is-there-a-way-to-tell-in-a-project-which-plant-has-been-visited-by-the-most-arthropods/85554/2 "2026-09-18T04:09:43Z")

</div>

you don’t have that many records. so then you could just download your data, making sure you download the taxon field and the “url for partner observation” observation field that you’re using to tie your insects to your plants.

in Excel, i would start by pulling out your observations with the observation field, and use that as your primary set. the rest will be a secondary set for lookup purposes. in your primary set, use a lookup formula to get the taxon of the “partner” observation, matching the url in the observation field (or the observation id extracted from that url) to a record in the secondary set. that will give you a plant taxon tied to an arthropod taxon in the primary set.

from there, you can count distinct arthropod taxa for each plant taxon in the primary set, and just sort by that distinct count.

---

<div class="post-metadata">

**Author:** ![alternative](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.inaturalist.org/alternative/32/76942_2.png) [@alternative](https://forum.inaturalist.org/u/alternative)\
**Post date:** [September 18, 2026, 5:20am UTC](https://forum.inaturalist.org/t/is-there-a-way-to-tell-in-a-project-which-plant-has-been-visited-by-the-most-arthropods/85554/3 "2026-09-18T05:20:55Z")

</div>

Hi! You can easily do this through my free to use web app that I created that interprets your CSV file and added observation fields into a visual chart. This must be done from a (Desktop or Laptop browser). If you happen to load the sample file on accident, just refresh the page to upload your own file.

[https://stratified.william-dawson0526.workers.dev/](https://stratified.william-dawson0526.workers.dev/)

Once you upload your CSV (with field observations) head to the “Interaction Network” Chart Tab up at the top of the browser. Then refer to the “How to use this” button on the far right.

Now there are multiple ways in which you could do this, but you have to make sure that you are keeping the same format across all observations. In this case - on your insect IDs you would use the field observation “associated plant” and then enter the Plant ID. Once all the FOs are setup in your observations then you export and plop it into stratified and follow the directions above. You can head over to data and columns and it will immediately tell you the number of observations with that field. The chart will break it down by utilizing the Main Menu Sidebar which is all explained in the “How to”.

If you happen to do plain text and no IDs you must make sure they are all the same entry or the field will parse separately. (for example, say you did a text field “crawling” - then if you want to use that repeatedly for others.) there is no limit to the number of text fields you make, they can be added from the sidebar menu if you scroll to the bottom.

These are all the observations that the app covers:

1. name of associated plant
2. eating (ID)
3. host plant id
4. insect host plant (ID)
5. multiple life stages - adult
6. number of individuals
7. # of birds
8. % of fresh flowers open?
9. behavior of bird
10. bird using habitat
11. copulating
12. diseased or infected
13. evidence of predation
14. flower or flower buds?
15. glaucous leaves
16. how was it found? (under cover, on the crawl, basking, dead on road, etc.)
17. insect behavior
18. insect on flower
19. insect on plant part
20. insects
21. interaction (predation)
22. interaction → behaviour
23. interaction-\>mutualism with
24. interaction-\>parasitoid of
25. larvae or pupae
26. lek posturing
27. mating behavior
28. mating behavior observed?
29. mating specimens?
30. multiple life stages - larva
31. multiple species
32. multiple species observed?
33. nectar / pollen delivering plant
34. nest construction
35. nest placement
36. on leaf
37. perching on
38. plant family
39. plant id
40. plant phenophase
41. pollen on insect
42. pollination interaction
43. predating
44. predation observed
45. seeds present?
46. what was it eating?

---

<div class="post-metadata">

**Author:** ![pisum](https://avatars.discourse-cdn.com/v4/letter/p/91b2a8/32.png) [@pisum](https://forum.inaturalist.org/u/pisum)\
**Post date:** [September 18, 2026, 5:56am UTC](https://forum.inaturalist.org/t/is-there-a-way-to-tell-in-a-project-which-plant-has-been-visited-by-the-most-arthropods/85554/4 "2026-09-18T05:56:24Z")

</div>

> [@alternative](#):
>
> You can easily do this through my free to use web app

> [@alternative](#):
>
> on your insect IDs you would use the field observation “associated plant” and then enter the Plant ID

doesn’t sound easy / efficient if the user has to redo all the source data.

---

<div class="post-metadata">

**Author:** ![DianaStuder](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.inaturalist.org/dianastuder/32/43358_2.png) [@DianaStuder](https://forum.inaturalist.org/u/DianaStuder)\
**Post date:** [September 18, 2026, 6:28am UTC](https://forum.inaturalist.org/t/is-there-a-way-to-tell-in-a-project-which-plant-has-been-visited-by-the-most-arthropods/85554/6 "2026-09-18T06:28:48Z")

</div>

> [@alternative](#):
>
> (you seem to think you are the authority on everything here, this needs to stop) - Do you have something against me

pisum speaks out of long experience on iNat. I am sorry you perceive his discussion as ‘against you’. There is an earlier thread where he asked a few questions, to understand what _that_ iNatter wanted to do with their data. Not an ‘attack’ but refining the question to get the right answer for them.

I prefer a graphic to a table of data, but I also prefer words, _a paragraph of text_ to strings of numbers.

---

<div class="post-metadata">

**Author:** ![Naelin](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.inaturalist.org/naelin/32/45174_2.png) [@Naelin](https://forum.inaturalist.org/u/Naelin)\
**Post date:** [September 18, 2026, 4:04pm UTC](https://forum.inaturalist.org/t/is-there-a-way-to-tell-in-a-project-which-plant-has-been-visited-by-the-most-arthropods/85554/8 "2026-09-18T16:04:06Z")

</div>

As long as they make sure to always use the same URL for that observation field, they can simply click the name of the observation field on any of the insect obs and click “Observations with this field and value”, which willl take them here: [https://www.inaturalist.org/observations?verifiable=any&place\_id=any&field:URL%20for%20"partner"%20observation=https:%2F%2Fwww.inaturalist.org%2Fobservations%2F388588757](https://www.inaturalist.org/observations?verifiable=any&place_id=any&field:URL%20for%20%22partner%22%20observation=https:%2F%2Fwww.inaturalist.org%2Fobservations%2F388588757)

Then they can navigate the species and observations tab and use any of the regular inat filters in it without needing to fiddle with downloads and spreadsheets

---

<div class="post-metadata">

**Author:** ![alternative](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.inaturalist.org/alternative/32/76942_2.png) [@alternative](https://forum.inaturalist.org/u/alternative)\
**Post date:** [September 18, 2026, 4:30pm UTC](https://forum.inaturalist.org/t/is-there-a-way-to-tell-in-a-project-which-plant-has-been-visited-by-the-most-arthropods/85554/9 "2026-09-18T16:30:45Z")

</div>

Actually, its quite easy to create a project (digital fence) to contain the set of observations that you want to narrow down on. Then you can flip through those quickly adding annotations and using arrow keys (specifically from the “identification” tab in iNat) to add the field observations. I did this with about 6 hours of work for ~750 observations in a project called “East Austin Yard Project”. My main goal was to connect Bombus species to the pollinator plants they visited, but of course there were many other insects that I added observations to. Not everything is going to be immediate, some things take a little patience and work.

---

<div class="post-metadata">

**Author:** ![pisum](https://avatars.discourse-cdn.com/v4/letter/p/91b2a8/32.png) [@pisum](https://forum.inaturalist.org/u/pisum)\
**Post date:** [September 18, 2026, 5:43pm UTC](https://forum.inaturalist.org/t/is-there-a-way-to-tell-in-a-project-which-plant-has-been-visited-by-the-most-arthropods/85554/10 "2026-09-18T17:43:25Z")

</div>

> [@Naelin](#):
>
> As long as they make sure to always use the same URL for that observation field, they can simply click the name of the observation field

i don’t think the URL will always be the same because the plants will be found in different observations. it’s a useful feature for other reasons, but i don’t think it addresses the thing described in the original post.

---

<div class="post-metadata">

**Author:** ![Naelin](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.inaturalist.org/naelin/32/45174_2.png) [@Naelin](https://forum.inaturalist.org/u/Naelin)\
**Post date:** [September 18, 2026, 6:14pm UTC](https://forum.inaturalist.org/t/is-there-a-way-to-tell-in-a-project-which-plant-has-been-visited-by-the-most-arthropods/85554/11 "2026-09-18T18:14:56Z")

</div>

Ah, I just realised that I read the description and ignored the title, thanks. I thought OP just wanted to see the details for one individual plant.

---

<div class="post-metadata">

**Author:** ![stockslager](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.inaturalist.org/stockslager/32/33106_2.png) [@stockslager](https://forum.inaturalist.org/u/stockslager)\
**Post date:** [September 19, 2026, 3:17am UTC](https://forum.inaturalist.org/t/is-there-a-way-to-tell-in-a-project-which-plant-has-been-visited-by-the-most-arthropods/85554/12 "2026-09-19T03:17:40Z")

</div>

if you decide to switch over from using “url for partner observation” to an observation field of type taxon… you could probably use the meta data tool to add the new observation field since many of your “url for partner observation” repeat. then you could see close to what I think you want to see on inat itself rather than in excel.

if you’d like me to add obs fields to a few of your observations to show u what I mean, i’d be happy to.

Example from my yard…  
[Butterfly Milkweed (_Asclepias tuberosa_)](https://www.inaturalist.org/observations?place_id=9853&project_id=133007&field:plant%20that%20the%20organism%20was%20found%20on=47912&subview=grid)  
[False Solomon’s Seal (_Maianthemum racemosum_)](https://www.inaturalist.org/observations?place_id=9853&project_id=133007&field:plant%20that%20the%20organism%20was%20found%20on=51062&subview=grid)  
[Anise Hyssop (_Agastache foeniculum_)](https://www.inaturalist.org/observations?place_id=9853&project_id=133007&field:plant%20that%20the%20organism%20was%20found%20on=158076&subview=grid)  
etc…

Maybe this isn’t what you’re talking about tho. Not sure.

---

<div class="post-metadata">

**Author:** ![digitalbio](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.inaturalist.org/digitalbio/32/64840_2.png) [@digitalbio](https://forum.inaturalist.org/u/digitalbio)\
**Post date:** [September 19, 2026, 2:16pm UTC](https://forum.inaturalist.org/t/is-there-a-way-to-tell-in-a-project-which-plant-has-been-visited-by-the-most-arthropods/85554/13 "2026-09-19T14:16:54Z")

</div>

This is exactly what I want. I definitely prefer being able to see the results in iNaturalist and have the data continually updated without having to download and manipulate data every time I want an answer to a question. Thanks!

---

<div class="post-metadata">

**Author:** ![digitalbio](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.inaturalist.org/digitalbio/32/64840_2.png) [@digitalbio](https://forum.inaturalist.org/u/digitalbio)\
**Post date:** [September 19, 2026, 2:21pm UTC](https://forum.inaturalist.org/t/is-there-a-way-to-tell-in-a-project-which-plant-has-been-visited-by-the-most-arthropods/85554/14 "2026-09-19T14:21:38Z")

</div>

I can also see which fields to add from your examples. There are so many features in iNaturalist that aren’t obvious to inexperienced users like me. Once again, thanks!

---

<div class="post-metadata">

**Author:** ![stockslager](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.inaturalist.org/stockslager/32/33106_2.png) [@stockslager](https://forum.inaturalist.org/u/stockslager)\
**Post date:** [September 19, 2026, 2:35pm UTC](https://forum.inaturalist.org/t/is-there-a-way-to-tell-in-a-project-which-plant-has-been-visited-by-the-most-arthropods/85554/15 "2026-09-19T14:35:32Z")

</div>

you may want to be somewhat careful when choosing a specific field. I use “plant that the organism was found on” because others in my yard umbrella use the same field. In Seattle, the most common one being used in 2026 is [associated species with names lookup](https://www.inaturalist.org/observations?d1=2026-01-01&d2=2026-09-19&place_id=119121&subview=map&field%3Aassociated%20species%20with%20names%20lookup=)

But the number of uses can be heavily influenced by a small number of power users. What I like about “associated species with names lookup” is others in your region are using it and it’s very broad. This helps if you want to further filter by more granular observation fields (now that I know the plant that the insect was on… what did I perceive the insect to be doing there?)

e.g.  
[Insects visiting the flower of Butterfly Milkweed](https://www.inaturalist.org/observations?place_id=9853&project_id=133007&field:plant%20that%20the%20organism%20was%20found%20on=47912&subview=grid&field:location%20on%20plant=flower) vs.  
[Larva visiting Butterfly Milkweed](https://www.inaturalist.org/observations?place_id=9853&project_id=133007&field:plant%20that%20the%20organism%20was%20found%20on=47912&subview=grid&term_id=1&term_value_id=6) vs.  
[All visitors to Butterfly Milkweed](https://www.inaturalist.org/observations?place_id=9853&project_id=133007&field:plant%20that%20the%20organism%20was%20found%20on=47912&subview=grid)

There are sooo many taxon type observation fields that conflate “found on” with an insect interaction, the part of the plant where it was found, etc. It _seems_ like it would be better to do it this way but it means that it’s difficult to see the holistic value of a plant without extracting the data and doing an external join.
