DOI: 10.15468/dl.fwtffn
title: Occurrence Download

description: A dataset containing 1941 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.96517
 AND occurrence.decimallatitude &lt;= 47.0667
 AND (occurrence.decimallongitude &gt;= -1.79289 AND occurrence.decimallongitude &lt;= -1.64407)
 AND GBIF_WITHIN('POLYGON ((-1.74037 46.96763, -1.7395 46.9674, -1.73855 46.9672, -1.73435 46.96656, -1.73265 46.96626, -1.73242 46.96623, -1.73241 46.96627, -1.7288 46.96572, -1.72781 46.96562, -1.71785 46.96517, -1.71685 46.96517, -1.70691 46.96576, -1.70592 46.96587, -1.69622 46.96747, -1.69527 46.96768, -1.68603 46.97027, -1.68514 46.97058, -1.68216 46.9718, -1.68212 46.97175, -1.6812 46.97209, -1.67897 46.97311, -1.67672 46.97403, -1.67609 46.97433, -1.67615 46.97439, -1.67245 46.97607, -1.67162 46.97651, -1.66391 46.98139, -1.6632 46.98192, -1.65979 46.98465, -1.65944 46.98496, -1.65637 46.98787, -1.65579 46.98846, -1.65071 46.99473, -1.65027 46.99539, -1.64671 47.00213, -1.64643 47.00282, -1.64448 47.00987, -1.64437 47.01058, -1.64407 47.01775, -1.64413 47.01846, -1.6455 47.02557, -1.64572 47.02627, -1.64873 47.03314, -1.64911 47.03381, -1.65367 47.04026, -1.6542 47.04088, -1.66021 47.04676, -1.66088 47.04731, -1.66817 47.05246, -1.66896 47.05293, -1.67181 47.05439, -1.6763 47.05703, -1.67718 47.05747, -1.68647 47.06133, -1.68744 47.06166, -1.69754 47.06442, -1.69858 47.06464, -1.7092 47.06623, -1.71028 47.06633, -1.72114 47.0667, -1.72223 47.06667, -1.73303 47.06582, -1.7341 47.06567, -1.74455 47.06361, -1.74557 47.06334, -1.75057 47.06188, -1.75159 47.06155, -1.75606 47.05994, -1.75693 47.05959, -1.76527 47.05569, -1.76606 47.05526, -1.77342 47.05054, -1.7741 47.05003, -1.78032 47.04459, -1.78088 47.04401, -1.78581 47.03799, -1.78624 47.03736, -1.78976 47.03089, -1.79004 47.03023, -1.79125 47.02688, -1.79143 47.02627, -1.79223 47.02298, -1.79236 47.02232, -1.79289 47.01568, -1.79287 47.01502, -1.79197 47.0084, -1.79181 47.00774, -1.78949 47.00128, -1.78919 47.00065, -1.78752 46.99753, -1.78725 46.99707, -1.78689 46.99648, -1.78681 46.99636, -1.78644 46.99578, -1.78616 46.99534, -1.78385 46.99213, -1.78335 46.9915, -1.77767 46.98551, -1.77703 46.98494, -1.77004 46.97964, -1.76928 46.97915, -1.76534 46.9768, -1.76446 46.97632, -1.76073 46.97441, -1.75996 46.97404, -1.75196 46.97079, -1.75113 46.97051, -1.74254 46.96806, -1.74166 46.96785, -1.74037 46.96763))', 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 1941 records were derived from 55 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0018440-250914085247600/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.