DOI: 10.15468/dl.rk4r2y
title: Occurrence Download

description: A dataset containing 5882 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.95235
 AND occurrence.decimallatitude &lt;= 47.05507
 AND (occurrence.decimallongitude &gt;= -1.81855 AND occurrence.decimallongitude &lt;= -1.66993)
 AND GBIF_WITHIN('POLYGON ((-1.7057 46.96074, -1.70556 46.96079, -1.69757 46.96453, -1.69682 46.96494, -1.68971 46.96944, -1.68905 46.96993, -1.68299 46.97509, -1.68244 46.97564, -1.67755 46.98135, -1.67712 46.98195, -1.67351 46.98809, -1.67321 46.98872, -1.67096 46.99516, -1.6708 46.99582, -1.66995 47.00242, -1.66993 47.00308, -1.67004 47.00639, -1.6702 47.00826, -1.67064 47.01141, -1.67076 47.01204, -1.6726 47.01826, -1.67285 47.01887, -1.67595 47.02484, -1.67632 47.02542, -1.67833 47.02828, -1.67847 47.02847, -1.68109 47.03158, -1.68165 47.03219, -1.68794 47.03794, -1.68863 47.03848, -1.69618 47.04347, -1.69699 47.04393, -1.7056 47.04804, -1.70651 47.0484, -1.71597 47.05152, -1.71695 47.05178, -1.72701 47.05383, -1.72804 47.05398, -1.73322 47.05459, -1.73468 47.05472, -1.73961 47.05503, -1.7406 47.05507, -1.75048 47.05493, -1.75147 47.05487, -1.76121 47.05372, -1.76217 47.05356, -1.77155 47.05142, -1.77246 47.05116, -1.78127 47.04809, -1.78212 47.04774, -1.79015 47.04381, -1.79091 47.04337, -1.79799 47.03866, -1.79865 47.03815, -1.80461 47.03276, -1.80515 47.03219, -1.80987 47.02626, -1.81027 47.02564, -1.81213 47.02251, -1.8129 47.02107, -1.8137 47.01964, -1.81542 47.0162, -1.81573 47.0155, -1.81792 47.00838, -1.81806 47.00766, -1.81855 47.00039, -1.81851 46.99966, -1.81728 46.99243, -1.81707 46.99172, -1.81416 46.98472, -1.81379 46.98404, -1.80926 46.97745, -1.80873 46.97682, -1.80272 46.97081, -1.80205 46.97025, -1.7947 46.96499, -1.79391 46.96451, -1.78542 46.96012, -1.78452 46.95973, -1.77512 46.95634, -1.77414 46.95606, -1.76406 46.95375, -1.76303 46.95358, -1.75253 46.95241, -1.75147 46.95235, -1.74085 46.95236, -1.73979 46.95242, -1.7293 46.95359, -1.72827 46.95377, -1.71819 46.95609, -1.71721 46.95637, -1.70781 46.95977, -1.70692 46.96016, -1.7057 46.96074))', 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 5882 records were derived from 81 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0018445-250914085247600/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.