DOI: 10.15468/dl.4rnzv3
title: Occurrence Download

description: A dataset containing 3688 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;= 46.3063
 AND occurrence.decimallatitude &lt;= 46.39679
 AND (occurrence.decimallongitude &gt;= -0.46625 AND occurrence.decimallongitude &lt;= -0.33528)
 AND GBIF_WITHIN('POLYGON ((-0.46022 46.37051, -0.46042 46.37022, -0.46389 46.36366, -0.46585 46.3568, -0.46625 46.34982, -0.46509 46.34288, -0.4624 46.33615, -0.45823 46.32979, -0.45269 46.32395, -0.44592 46.31877, -0.43808 46.31438, -0.42935 46.31089, -0.41994 46.30837, -0.41907 46.30819, -0.40907 46.30669, -0.39884 46.3063, -0.38866 46.30703, -0.37877 46.30886, -0.36941 46.31174, -0.36082 46.3156, -0.35322 46.32035, -0.34678 46.32587, -0.34167 46.33202, -0.33802 46.33865, -0.33789 46.33896, -0.33579 46.34587, -0.33528 46.35293, -0.33637 46.35995, -0.33903 46.36677, -0.34321 46.37322, -0.34879 46.37913, -0.35563 46.38437, -0.36358 46.3888, -0.37244 46.39232, -0.38198 46.39483, -0.38279 46.395, -0.39287 46.39645, -0.40317 46.39679, -0.41341 46.396, -0.42334 46.3941, -0.43271 46.39113, -0.44128 46.38718, -0.44885 46.38235, -0.45522 46.37674, -0.46022 46.37051))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND (occurrence."year" &gt;= 2006 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 3688 records were derived from 74 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0000044-260126135527185/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.