Hi @gmontgomery,
GBIF doesn’t deduplicate the occurrences between the datasets.
In fact, it seems like this observation is indeed twice in GBIF:
- from iNaturalist: Occurrence Detail 1802603122
- from BugGuide: Occurrence Detail 1847194152
As far as I can see, the observation from BugGuide isn’t associated with any coordinate. This is why it didn’t come up with the query you tried (the administrative area is inferred from coordinates).