DOI: 10.15468/dl.5tkv3d
title: Occurrence Download

description: A dataset containing 47 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;= 39.99995
 AND occurrence.decimallatitude &lt;= 43.00056
 AND (occurrence.decimallongitude &gt;= -104.05321 AND occurrence.decimallongitude &lt;= -95.30809)
 AND GBIF_WITHIN('MULTIPOLYGON (((-104.05245 41.39323, -104.05321 41.00164, -102.05176 41.00233, -102.05171 40.00317, -95.30809 39.99995, -95.41589 40.04143, -95.39319 40.11833, -95.4797 40.18649, -95.47738 40.24258, -95.55096 40.26071, -95.56349 40.29781, -95.65572 40.30998, -95.62317 40.34447, -95.70043 40.50521, -95.66175 40.51739, -95.65581 40.54662, -95.67852 40.56259, -95.70869 40.5214, -95.76553 40.52996, -95.77421 40.57478, -95.7499 40.60685, -95.8859 40.72284, -95.83466 40.78099, -95.84842 40.86318, -95.80935 40.89164, -95.88248 41.05944, -95.86243 41.09037, -95.8829 41.15477, -95.84133 41.17592, -95.92792 41.19798, -95.91076 41.23268, -95.92775 41.29868, -95.90622 41.30129, -95.9037 41.27423, -95.87205 41.30253, -95.95578 41.34269, -95.92918 41.368, -95.92056 41.45182, -96.01263 41.47714, -96.00047 41.54001, -96.04822 41.51609, -96.09407 41.53852, -96.0813 41.57658, -96.11813 41.61547, -96.09484 41.65309, -96.12227 41.68462, -96.07286 41.70494, -96.10644 41.73894, -96.06449 41.79504, -96.16219 41.90263, -96.13011 41.97145, -96.1889 41.97822, -96.19438 42.00942, -96.24166 41.99913, -96.22222 42.02977, -96.27421 42.04773, -96.27112 42.11659, -96.34927 42.17011, -96.35986 42.21081, -96.32363 42.23001, -96.32917 42.25477, -96.41747 42.35218, -96.38579 42.47528, -96.50037 42.48249, -96.54862 42.51986, -96.61255 42.50555, -96.70867 42.60204, -96.70027 42.65465, -96.79382 42.66645, -96.80726 42.70233, -96.8979 42.73263, -96.95522 42.71814, -96.97533 42.75749, -97.13216 42.77229, -97.2117 42.81054, -97.21975 42.84633, -97.31693 42.86885, -97.44928 42.84571, -97.49371 42.86814, -97.59111 42.84262, -97.61624 42.86606, -97.67471 42.83121, -97.71618 42.86155, -97.77746 42.83668, -97.84329 42.86805, -97.87613 42.85738, -97.92051 42.78913, -98.01567 42.76224, -98.14674 42.83954, -98.44416 42.92873, -98.49857 42.99867, -104.05308 43.00056, -104.05245 41.39323)))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND (occurrence.taxonkey = 9606290 OR occurrence.acceptedtaxonkey = 9606290 OR occurrence.kingdomkey = 9606290 OR occurrence.phylumkey = 9606290 OR occurrence.classkey = 9606290 OR occurrence.orderkey = 9606290 OR occurrence.familykey = 9606290 OR occurrence.genuskey = 9606290 OR occurrence.specieskey = 9606290)
 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 47 records were derived from 7 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0060396-250525065834625/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.