Occurrence Download

Read full text Summarise with VIRAT
Authors: GBIF.org User
Cited by: 0

Summary

No summary yet. VIRAT can read this paper and write a plain-language summary of its aim, methods, key findings and limitations.

Summarise with VIRAT Free to try with your Science Catalogs account.

Abstract

A dataset containing 27 records in GBIF matching the query: SELECT kingdom, kingdomkey, phylum, phylumkey, class, classkey, "order", orderkey, family, familykey, genus, genuskey, species, specieskey, "year", IF(ISNULL(kingdomkey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY kingdomkey, "year")) kingdomcount, IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY phylumkey, "year")) phylumcount, IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY classkey, "year")) classcount, IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY orderkey, "year")) ordercount, IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY familykey, "year")) familycount, IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY genuskey, "year")) genuscount, COUNT(*) occurrences, MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty, MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters FROM occurrence WHERE occurrence.basisofrecord = 'HUMAN_OBSERVATION' AND occurrence.continent = 'AFRICA' AND occurrence.countrycode = 'KE' AND GBIF_STRINGARRAYCONTAINS(occurrence.classifications['d7dddbf4-2cf0-4f39-9b2a-bb099caae36c'], '2441034', TRUE) AND (occurrence."year" >= 2000 AND occurrence."year" = 2000.0 OR occurrence.distancefromcentroidinmeters IS NULL) AND occurrence.occurrencestatus = 'PRESENT' AND (occurrence.classificationdetails['d7dddbf4-2cf0-4f39-9b2a-bb099caae36c']['specieskey'] '' 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 27 records were derived from 14 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0062754-260226173443078/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.

Fields of Study & Subjects

Species Distribution and Climate Change Wildlife Ecology and Conservation Avian ecology and behavior

Publication details

Journal / source
Global Biodiversity Information Facility
Publication date
1 January 2026
Language
EN
Document type
Dataset