Occurrence Download
The Global Biodiversity Information Facility
A dataset containing 1 records in GBIF matching the query: SELECT occurrence.kingdom kingdom, occurrence.kingdomkey kingdomkey, occurrence.phylum phylum, occurrence.phylumkey phylumkey, occurrence.class class, occurrence.classkey classkey, occurrence."order" "order", occurrence.orderkey orderkey, occurrence.family family, occurrence.familykey familykey, occurrence.genus genus, occurrence.genuskey genuskey, occurrence.species …
Read full excerpt
A dataset containing 1 records in GBIF matching the query: SELECT occurrence.kingdom kingdom, occurrence.kingdomkey kingdomkey, occurrence.phylum phylum, occurrence.phylumkey phylumkey, occurrence.class class, occurrence.classkey classkey, occurrence."order" "order", occurrence.orderkey orderkey, occurrence.family family, occurrence.familykey familykey, occurrence.genus genus, occurrence.genuskey genuskey, occurrence.species species, occurrence.specieskey specieskey, "year", SUM(COUNT(*)) OVER ( PARTITION BY occurrence.kingdomkey, "year") kingdomcount, SUM(COUNT(*)) OVER ( PARTITION BY occurrence.phylumkey, "year") phylumcount, SUM(COUNT(*)) OVER ( PARTITION BY occurrence.classkey, "year") classcount, SUM(COUNT(*)) OVER ( PARTITION BY occurrence.orderkey, "year") ordercount, SUM(COUNT(*)) OVER ( PARTITION BY occurrence.familykey, "year") familycount, SUM(COUNT(*)) OVER ( PARTITION BY occurrence.genuskey, "year") genuscount, COUNT(*) occurrences, MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty, MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters FROM occurrence WHERE ARRAYS_OVERLAP(occurrence.taxonkeys, ARRAY('44FPX')) AND occurrence.occurrencestatus IN ('PRESENT') AND occurrence."year" = 2025 AND occurrence.hasgeospatialissues = FALSE AND NOT GBIF_STRINGARRAYCONTAINS(occurrence.taxonomicissue, 'TAXON_MATCH_FUZZY', TRUE) AND (occurrence.distancefromcentroidinmeters >= 2000.0 OR occurrence.distancefromcentroidinmeters IS NULL) AND NOT occurrence.basisofrecord IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN') AND (occurrence.specieskey IS NOT NULL AND occurrence."year" IS NOT NULL) GROUP BY occurrence.kingdom, occurrence.kingdomkey, occurrence.phylum, occurrence.phylumkey, occurrence.class, occurrence.classkey, occurrence."order", occurrence.orderkey, occurrence.family, occurrence.familykey, occurrence.genus, occurrence.genuskey, occurrence.species, occurrence.specieskey, occurrence."year" The dataset's 1 records were derived from 40 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0013822-260928105237408/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.
