DOI: 10.15468/dl.j8zkae
title: Occurrence Download

description: A dataset containing 2097 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.87359
 AND occurrence.decimallatitude &lt;= 46.9757
 AND (occurrence.decimallongitude &gt;= -1.84913 AND occurrence.decimallongitude &lt;= -1.70124)
 AND GBIF_WITHIN('POLYGON ((-1.82085 46.88477, -1.81976 46.88409, -1.81893 46.88365, -1.81015 46.87974, -1.80923 46.8794, -1.79965 46.87649, -1.79866 46.87626, -1.78853 46.87443, -1.7875 46.87431, -1.77708 46.87361, -1.77603 46.87359, -1.76558 46.87404, -1.76454 46.87414, -1.75433 46.87572, -1.75333 46.87593, -1.74361 46.87861, -1.74267 46.87893, -1.73369 46.88262, -1.73284 46.88304, -1.7287 46.88524, -1.72697 46.88624, -1.72324 46.88857, -1.72252 46.88906, -1.7159 46.89427, -1.7153 46.89482, -1.70992 46.90066, -1.70944 46.90127, -1.70543 46.90761, -1.7051 46.90827, -1.70254 46.91495, -1.70236 46.91563, -1.70233 46.91575, -1.70225 46.91605, -1.70128 46.92221, -1.70124 46.9229, -1.70162 46.92976, -1.70173 46.93044, -1.70205 46.93209, -1.70239 46.93363, -1.70303 46.93607, -1.70325 46.93677, -1.70619 46.94364, -1.70656 46.9443, -1.71105 46.95076, -1.71158 46.95138, -1.71751 46.95727, -1.71817 46.95783, -1.72539 46.963, -1.72617 46.96347, -1.7345 46.9678, -1.73538 46.96818, -1.7446 46.97155, -1.74556 46.97183, -1.75545 46.97415, -1.75646 46.97433, -1.76676 46.97555, -1.7678 46.97561, -1.77825 46.9757, -1.77929 46.97565, -1.78963 46.9746, -1.79065 46.97444, -1.80061 46.97228, -1.80158 46.97201, -1.81092 46.96879, -1.81181 46.96842, -1.81617 46.96644, -1.81658 46.96625, -1.81976 46.96453, -1.81989 46.96446, -1.82 46.9644, -1.82093 46.9639, -1.82177 46.9634, -1.8226 46.96287, -1.8277 46.95988, -1.82842 46.95938, -1.83508 46.95402, -1.83569 46.95345, -1.84105 46.94745, -1.84151 46.94682, -1.84544 46.94032, -1.84576 46.93965, -1.84816 46.9328, -1.84832 46.93211, -1.84913 46.92509, -1.84913 46.92439, -1.84834 46.91737, -1.84818 46.91668, -1.84718 46.91322, -1.84687 46.91233, -1.84547 46.90891, -1.84516 46.90823, -1.84121 46.90168, -1.84074 46.90105, -1.83534 46.895, -1.83473 46.89442, -1.82801 46.88903, -1.82728 46.88853, -1.82085 46.88477))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND occurrence.publishingorgkey = '1928bdf0-f5d2-11dc-8c12-b8a03c50a862'
 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 2097 records were derived from 48 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0018598-250914085247600/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.