We need County level information for species in a state. How do we download that into a column in excel or see it in the table that your website has. We can't go through tens of thousands of records to see which county the were from?

[gbif-portal]

We need County level information for species in a state. How do we download that into a column in excel or see it in the table that your website has. We can't go through tens of thousands of records to see which county the were from?

---

User: See in registry - Send email System: Firefox 120.0.0 / Windows 10.0.0 Referer: https://www.gbif.org/search?q=county Window size: width 1248 - height 585 API log&_a=(columns:!(_source),filters:!(),index:'3390a910-fcda-11ea-a9ab-4375f2a9d11c',interval:auto,query:(language:kuery,query:''),sort:!())) Site log&_a=(columns:!(_source),filters:!(),index:'5c73f360-fce3-11ea-a9ab-4375f2a9d11c',interval:auto,query:(language:kuery,query:''),sort:!())) System health at time of feedback: OPERATIONAL

[ManonGros]

Replied by email

Unfortunately, there is no easy way to visualize the occurrence of a species on our website (other than looking at the map).

That being said, you can use our occurrence search API to have the occurrences for a specific selection by GADM area. This requires a bit of programming. For example, here is how to get the preserved specimen of Ophisaurus attenuatus Baird, 1880 per state: https://api.gbif.org/v1/occurrence/search?taxonKey=5226648&basisOfRecord=PRESERVED_SPECIMEN&limit=0&facet=gadmLevel1Gid&facetLimit=300. You will need to match the GADM identifiers to their values. For example, USA.17_1 is the identifier for Kansas, see: https://api.gbif.org/v1/geocode/gadm/USA.17_1

If you aren’t familiar with the API, I suggest watching our Data Use Club recorded webinar on the topic here.

[ManonGros]

Could we add the GADM areas to the custom metrics drop down list? https://www.gbif.org/occurrence/charts?occurrence_status=present