DOI: 10.15468/dl.6sy7bj
title: Occurrence Download

description: A dataset containing 7392 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.15214
 AND occurrence.decimallatitude &lt;= 47.24518
 AND (occurrence.decimallongitude &gt;= -1.72204 AND occurrence.decimallongitude &lt;= -1.58097)
 AND GBIF_WITHIN('POLYGON ((-1.67609 47.15659, -1.67263 47.15553, -1.67232 47.15544, -1.66706 47.15416, -1.66166 47.15318, -1.65616 47.15252, -1.6506 47.15218, -1.65036 47.15217, -1.64535 47.15214, -1.64036 47.15237, -1.64015 47.15238, -1.63529 47.15285, -1.63049 47.15357, -1.62578 47.15453, -1.62119 47.15573, -1.61674 47.15715, -1.61246 47.1588, -1.60837 47.16066, -1.60834 47.16067, -1.60443 47.16275, -1.60077 47.16502, -1.59736 47.16748, -1.59423 47.1701, -1.5914 47.17287, -1.58889 47.17578, -1.5867 47.17881, -1.58484 47.18194, -1.58334 47.18516, -1.58333 47.1852, -1.58216 47.18857, -1.58137 47.192, -1.58098 47.19545, -1.58097 47.19892, -1.58136 47.20238, -1.58214 47.20581, -1.5833 47.20918, -1.58484 47.21249, -1.58675 47.2157, -1.58902 47.21881, -1.59163 47.22179, -1.59166 47.22182, -1.59412 47.22421, -1.59417 47.22426, -1.59736 47.22695, -1.60085 47.22946, -1.60461 47.23178, -1.60863 47.2339, -1.60932 47.23424, -1.61473 47.23661, -1.61559 47.23695, -1.61638 47.23725, -1.61743 47.23765, -1.6188 47.23814, -1.62101 47.23903, -1.62166 47.23927, -1.62301 47.23974, -1.62338 47.23987, -1.62777 47.24124, -1.63071 47.24198, -1.63071 47.24198, -1.63146 47.24217, -1.63152 47.24219, -1.63178 47.24225, -1.63181 47.24226, -1.63229 47.24238, -1.63245 47.24242, -1.63256 47.24244, -1.63346 47.24266, -1.63362 47.24269, -1.63683 47.24337, -1.63735 47.24347, -1.64354 47.24445, -1.64367 47.24447, -1.64882 47.24496, -1.65401 47.24518, -1.65416 47.24518, -1.66011 47.24509, -1.66601 47.24464, -1.66612 47.24463, -1.67103 47.24396, -1.67585 47.24305, -1.68056 47.24189, -1.68064 47.24187, -1.68523 47.24046, -1.68966 47.23881, -1.69388 47.23695, -1.69789 47.23486, -1.70165 47.23258, -1.70514 47.23011, -1.70835 47.22746, -1.71125 47.22465, -1.71382 47.2217, -1.71606 47.21863, -1.71795 47.21545, -1.71948 47.21218, -1.71964 47.21179, -1.72071 47.20874, -1.72147 47.20564, -1.72191 47.20251, -1.72192 47.20241, -1.72204 47.19907, -1.72179 47.19573, -1.72118 47.19242, -1.72116 47.19233, -1.72071 47.19067, -1.7207 47.19062, -1.71956 47.1874, -1.71808 47.18425, -1.71626 47.18118, -1.71412 47.17821, -1.71167 47.17535, -1.70891 47.17263, -1.70587 47.17005, -1.70583 47.17002, -1.70287 47.16784, -1.70278 47.16777, -1.69875 47.16522, -1.69443 47.16291, -1.68984 47.16084, -1.68502 47.15905, -1.68495 47.15902, -1.67975 47.15746, -1.67969 47.15745, -1.67609 47.15659))', 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 7392 records were derived from 101 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0018107-250914085247600/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.