DOI: 10.15468/dl.zaw5kz
title: Occurrence Download

description: A dataset containing 2052 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.88057
 AND occurrence.decimallatitude &lt;= 46.98313
 AND (occurrence.decimallongitude &gt;= -1.86094 AND occurrence.decimallongitude &lt;= -1.71283)
 AND GBIF_WITHIN('POLYGON ((-1.85263 46.90913, -1.85155 46.90743, -1.85108 46.90682, -1.84572 46.90099, -1.84512 46.90043, -1.83853 46.89523, -1.83781 46.89474, -1.83014 46.89029, -1.82932 46.88988, -1.82075 46.88628, -1.81985 46.88597, -1.81058 46.88331, -1.80962 46.88309, -1.79986 46.88143, -1.79887 46.88132, -1.79388 46.88088, -1.79195 46.88076, -1.78673 46.88058, -1.78569 46.88057, -1.77527 46.88107, -1.77424 46.88117, -1.76406 46.88279, -1.76307 46.88301, -1.75339 46.88572, -1.75246 46.88604, -1.74354 46.88976, -1.74269 46.89018, -1.73474 46.89482, -1.734 46.89533, -1.72722 46.90078, -1.72661 46.90136, -1.72117 46.90748, -1.7207 46.90812, -1.71675 46.91475, -1.71644 46.91543, -1.71407 46.92241, -1.71391 46.92312, -1.71334 46.92668, -1.71299 46.93023, -1.71283 46.93363, -1.71284 46.93431, -1.71365 46.94109, -1.71381 46.94176, -1.71611 46.94838, -1.71641 46.94903, -1.72014 46.95533, -1.72058 46.95594, -1.72565 46.96179, -1.72622 46.96235, -1.73253 46.96761, -1.73322 46.9681, -1.74061 46.97265, -1.7414 46.97306, -1.74971 46.97679, -1.75058 46.97712, -1.75961 46.97995, -1.76055 46.98019, -1.77011 46.98206, -1.77108 46.98219, -1.78094 46.98305, -1.78193 46.98309, -1.78691 46.98313, -1.78811 46.98311, -1.79319 46.98289, -1.79421 46.98282, -1.80423 46.98157, -1.80521 46.98139, -1.81483 46.9791, -1.81576 46.97882, -1.82475 46.97553, -1.82561 46.97516, -1.82768 46.97421, -1.82823 46.97396, -1.82817 46.9739, -1.83497 46.97046, -1.83578 46.96997, -1.84135 46.96622, -1.84207 46.96568, -1.8427 46.96519, -1.84852 46.96007, -1.84905 46.95952, -1.85373 46.95388, -1.85414 46.95329, -1.85758 46.94724, -1.85786 46.94662, -1.86 46.94029, -1.86014 46.93965, -1.86093 46.93318, -1.86094 46.93253, -1.86082 46.92928, -1.86081 46.92919, -1.86027 46.92557, -1.86012 46.92486, -1.85916 46.92128, -1.85908 46.92104, -1.85786 46.91789, -1.85758 46.91727, -1.85604 46.9142, -1.85592 46.91398, -1.85382 46.91065, -1.85336 46.91, -1.85263 46.90913))', 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 2052 records were derived from 42 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0018565-250914085247600/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.