DOI: 10.15468/dl.axeff7
title: Occurrence Download

description: A dataset containing 2059 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.87954
 AND occurrence.decimallatitude &lt;= 46.98125
 AND (occurrence.decimallongitude &gt;= -1.86153 AND occurrence.decimallongitude &lt;= -1.71469)
 AND GBIF_WITHIN('POLYGON ((-1.85902 46.94347, -1.85926 46.94283, -1.86041 46.93912, -1.86053 46.93866, -1.86128 46.9344, -1.86137 46.93354, -1.86153 46.92925, -1.86148 46.92789, -1.86118 46.92446, -1.86108 46.92377, -1.85933 46.91701, -1.85908 46.91634, -1.85584 46.90984, -1.85545 46.90921, -1.85081 46.90312, -1.85028 46.90253, -1.84435 46.897, -1.84369 46.89648, -1.8366 46.89162, -1.83584 46.89118, -1.82775 46.88712, -1.8269 46.88676, -1.81801 46.88359, -1.81708 46.88332, -1.80759 46.88112, -1.80662 46.88095, -1.79675 46.87976, -1.79576 46.87969, -1.78574 46.87954, -1.78474 46.87958, -1.7748 46.88048, -1.77382 46.88062, -1.76421 46.88255, -1.76327 46.88279, -1.75777 46.88448, -1.75483 46.8853, -1.75388 46.88563, -1.74475 46.88946, -1.74388 46.8899, -1.73578 46.8947, -1.73503 46.89522, -1.72817 46.90086, -1.72756 46.90146, -1.72213 46.90779, -1.72166 46.90845, -1.7178 46.91529, -1.7175 46.916, -1.71531 46.92318, -1.71518 46.92391, -1.71474 46.92757, -1.7147 46.92809, -1.71469 46.93156, -1.71472 46.93226, -1.71586 46.93916, -1.71605 46.93984, -1.71705 46.94234, -1.71789 46.94511, -1.71817 46.94578, -1.72176 46.95228, -1.7222 46.95291, -1.72721 46.95896, -1.72777 46.95954, -1.73409 46.96499, -1.73478 46.9655, -1.74225 46.97022, -1.74304 46.97065, -1.75148 46.97452, -1.75237 46.97486, -1.76158 46.9778, -1.76253 46.97804, -1.76736 46.97914, -1.76842 46.97934, -1.77355 46.98021, -1.77459 46.98035, -1.78509 46.98122, -1.78615 46.98125, -1.79671 46.98095, -1.79776 46.98086, -1.80812 46.97941, -1.80914 46.97921, -1.81903 46.97663, -1.81998 46.97632, -1.82913 46.9727, -1.83 46.97229, -1.83819 46.9677, -1.83895 46.9672, -1.8454 46.96228, -1.84607 46.96168, -1.84818 46.95971, -1.84874 46.95915, -1.85373 46.95329, -1.85416 46.95268, -1.85781 46.94638, -1.8581 46.94573, -1.85887 46.94344, -1.85902 46.94347))', 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 2059 records were derived from 41 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0018593-250914085247600/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.