DOI: 10.15468/dl.a6s92w
title: Occurrence Download

description: A dataset containing 5251 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.9233
 AND occurrence.decimallatitude &lt;= 47.0247
 AND (occurrence.decimallongitude &gt;= -1.86631 AND occurrence.decimallongitude &lt;= -1.71734)
 AND GBIF_WITHIN('POLYGON ((-1.84027 46.93632, -1.8398 46.93603, -1.83581 46.93376, -1.83499 46.93333, -1.82628 46.92945, -1.82537 46.92912, -1.81588 46.92623, -1.8149 46.92599, -1.80487 46.92417, -1.80385 46.92404, -1.79353 46.92332, -1.79249 46.9233, -1.78213 46.9237, -1.7811 46.9238, -1.77096 46.92531, -1.76997 46.92551, -1.7603 46.9281, -1.75936 46.92841, -1.75041 46.932, -1.74956 46.93241, -1.74542 46.93456, -1.74372 46.93551, -1.7397 46.93797, -1.73893 46.93848, -1.73184 46.94403, -1.73119 46.94463, -1.72552 46.95089, -1.72503 46.95155, -1.72092 46.95837, -1.7206 46.95907, -1.71817 46.96626, -1.71802 46.96699, -1.71734 46.97435, -1.71736 46.97508, -1.71844 46.98242, -1.71864 46.98315, -1.72146 46.99026, -1.72183 46.99096, -1.72631 46.99766, -1.72684 46.99831, -1.73286 47.00442, -1.73353 47.005, -1.73708 47.00778, -1.73802 47.00846, -1.74089 47.01042, -1.74148 47.01079, -1.74452 47.01262, -1.74586 47.01338, -1.74999 47.01553, -1.75084 47.01594, -1.75977 47.01954, -1.7607 47.01985, -1.77034 47.02245, -1.77133 47.02266, -1.78146 47.02418, -1.78248 47.02428, -1.79283 47.0247, -1.79387 47.02469, -1.80419 47.02399, -1.80521 47.02387, -1.81524 47.02207, -1.81622 47.02184, -1.82571 47.01899, -1.82662 47.01865, -1.82909 47.01766, -1.82976 47.0174, -1.83002 47.01729, -1.83109 47.01685, -1.8315 47.01667, -1.83428 47.01534, -1.83827 47.01352, -1.83908 47.01309, -1.84661 47.00835, -1.8473 47.00784, -1.85367 47.00236, -1.85424 47.00178, -1.85928 46.99569, -1.85972 46.99506, -1.86332 46.98851, -1.86361 46.98784, -1.86568 46.98099, -1.86581 46.9803, -1.86631 46.97331, -1.86628 46.97261, -1.86519 46.96565, -1.86501 46.96496, -1.86236 46.9582, -1.86202 46.95754, -1.85787 46.95115, -1.85738 46.95053, -1.85184 46.94466, -1.85122 46.9441, -1.84442 46.93888, -1.84368 46.9384, -1.84027 46.93632))', 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 5251 records were derived from 68 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0018591-250914085247600/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.