DOI: 10.15468/dl.9h995d
title: Occurrence Download

description: A dataset containing 1666 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.countrycode = 'GE'
 AND (occurrence.decimallatitude &gt;= 42.02517 AND occurrence.decimallatitude &lt;= 42.41527 AND (occurrence.decimallongitude &gt;= 41.54862 AND occurrence.decimallongitude &lt;= 42.03692) AND GBIF_WITHIN('POLYGON ((41.71255 42.04015, 41.73973 42.02517, 41.77666 42.03075, 41.81308 42.04088, 41.84925 42.06402, 41.89722 42.09974, 41.94639 42.11734, 41.99827 42.12771, 42.02929 42.14765, 42.03692 42.17278, 42.01534 42.19312, 41.9965 42.19904, 41.95486 42.20259, 41.86843 42.19375, 41.81649 42.22033, 41.7871 42.23537, 41.77718 42.2642, 41.78269 42.27399, 41.80821 42.28366, 41.84099 42.30537, 41.83745 42.32088, 41.8199 42.32553, 41.74077 42.33214, 41.72091 42.3412, 41.65981 42.35715, 41.6361 42.37421, 41.61528 42.39171, 41.60156 42.40973, 41.58982 42.41527, 41.55305 42.40951, 41.54862 42.39556, 41.57251 42.35056, 41.57739 42.31822, 41.57827 42.28632, 41.58536 42.26594, 41.60131 42.18575, 41.63232 42.13391, 41.69656 42.06746, 41.71255 42.04015))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE)
 AND (occurrence.taxonkey = 212 OR occurrence.acceptedtaxonkey = 212 OR occurrence.kingdomkey = 212 OR occurrence.phylumkey = 212 OR occurrence.classkey = 212 OR occurrence.orderkey = 212 OR occurrence.familykey = 212 OR occurrence.genuskey = 212 OR occurrence.specieskey = 212)
 AND occurrence.hasgeospatialissues = FALSE
 AND NOT GBIF_STRINGARRAYCONTAINS(occurrence.issue, 'TAXON_MATCH_FUZZY', TRUE)
 AND (occurrence.distancefromcentroidinmeters &gt;= 2000.0 OR occurrence.distancefromcentroidinmeters IS NULL)
 AND NOT occurrence.basisofrecord IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN')
 AND occurrence.occurrencestatus = 'PRESENT'
 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 1666 records were derived from 12 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0000192-250515123054153/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.