DOI: 10.15468/dl.8ev6ye
title: Occurrence Download

description: A dataset containing 3431 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.decimallatitude &gt;= 47.23583
 AND occurrence.decimallatitude &lt;= 47.34131
 AND (occurrence.decimallongitude &gt;= -1.70147 AND occurrence.decimallongitude &lt;= -1.55412)
 AND GBIF_WITHIN('POLYGON ((-1.55629 47.29686, -1.55894 47.30202, -1.5601 47.30678, -1.56281 47.31269, -1.56669 47.3183, -1.57167 47.32348, -1.57764 47.32816, -1.57767 47.32817, -1.58462 47.33229, -1.59235 47.33571, -1.60071 47.33837, -1.60953 47.34021, -1.61864 47.3412, -1.62786 47.34131, -1.63702 47.34056, -1.64593 47.33895, -1.65443 47.33651, -1.66234 47.33329, -1.66952 47.32935, -1.6698 47.32915, -1.67182 47.32837, -1.67915 47.32455, -1.68563 47.32007, -1.69112 47.31502, -1.69553 47.3095, -1.69555 47.30946, -1.69865 47.30388, -1.70064 47.29806, -1.70147 47.29212, -1.70115 47.28615, -1.69966 47.28026, -1.69705 47.27456, -1.69335 47.26915, -1.69332 47.26912, -1.68828 47.26379, -1.68232 47.2591, -1.68224 47.25897, -1.67681 47.25335, -1.67021 47.24834, -1.6626 47.24405, -1.66255 47.24403, -1.65466 47.24077, -1.64619 47.23829, -1.6373 47.23663, -1.62815 47.23583, -1.61893 47.23591, -1.60981 47.23686, -1.60097 47.23867, -1.60092 47.23868, -1.59278 47.24122, -1.58521 47.24448, -1.57835 47.24841, -1.57234 47.25294, -1.56728 47.25798, -1.56714 47.25814, -1.5668 47.2586, -1.56493 47.26025, -1.56488 47.26031, -1.56236 47.26336, -1.56225 47.26349, -1.56218 47.26357, -1.56182 47.264, -1.56177 47.26407, -1.56123 47.26498, -1.558 47.26989, -1.55532 47.27644, -1.55413 47.28319, -1.55412 47.2833, -1.55444 47.29014, -1.55629 47.29686))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND occurrence.publishingorgkey = '1928bdf0-f5d2-11dc-8c12-b8a03c50a862'
 AND (occurrence."year" &gt;= 2010 AND occurrence."year" &lt;= 2026)
 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.classificationdetails['d7dddbf4-2cf0-4f39-9b2a-bb099caae36c']['specieskey'] &lt;&gt; '' 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 3431 records were derived from 77 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031902-260208012135463/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.