DOI: 10.15468/dl.2bd9yj
title: Occurrence Download

description: A dataset containing 3419 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.countrycode = 'DK'
 AND (occurrence.decimallatitude &gt;= 54.71304 AND occurrence.decimallatitude &lt;= 55.24345 AND (occurrence.decimallongitude &gt;= 10.73169 AND occurrence.decimallongitude &lt;= 12.32109) AND GBIF_WITHIN('POLYGON ((10.97867 54.7802, 11.00985 54.82259, 11.05231 54.79924, 11.10325 54.81303, 11.10007 54.82789, 11.04275 54.87141, 11.02259 54.86186, 11.01728 54.91281, 11.23593 54.97118, 11.31978 54.9266, 11.37285 54.90962, 11.36754 54.9542, 11.41637 54.94596, 11.41106 54.97037, 11.46413 54.96506, 11.49491 54.98948, 11.54692 54.9916, 11.57345 54.97249, 11.53737 54.9449, 11.49491 54.9778, 11.45564 54.95976, 11.48005 54.94171, 11.42592 54.93959, 11.40788 54.91836, 11.38665 54.92792, 11.3686 54.89289, 11.46838 54.86529, 11.47368 54.87803, 11.4705 54.89395, 11.49173 54.9035, 11.52569 54.88334, 11.48111 54.88121, 11.47156 54.83876, 11.57982 54.82496, 11.56072 54.84513, 11.57239 54.85362, 11.64032 54.85892, 11.64669 54.88228, 11.63289 54.91199, 11.73479 54.87485, 11.75389 54.87697, 11.74434 54.92049, 11.70941 54.93611, 11.76848 54.96723, 11.80215 54.93801, 11.82311 54.94817, 11.81358 54.96469, 11.832 54.9666, 11.91838 54.91896, 11.91457 54.94436, 11.97682 54.93738, 12.00921 54.89482, 12.07083 54.89418, 12.07273 54.90435, 11.99207 54.93738, 11.98381 54.95834, 12.00413 54.93928, 12.06448 54.94563, 12.08988 54.9234, 12.07781 54.89164, 12.10767 54.89482, 12.11783 54.9469, 12.15912 54.98311, 12.18452 54.98629, 12.21247 54.9666, 12.26011 54.98502, 12.28679 54.96596, 12.32109 54.98629, 12.28361 54.97866, 12.26837 54.99137, 12.28107 55.01487, 12.24868 55.0371, 12.24868 55.02821, 12.22962 55.04536, 12.22136 55.03075, 12.17817 55.04472, 12.14641 55.04345, 12.17309 54.99454, 12.15403 54.99772, 12.10957 54.97041, 12.10513 54.94754, 12.05749 54.95135, 12.0956 54.96215, 12.10449 54.97612, 12.11338 54.98247, 12.10449 54.98438, 12.01938 54.95834, 11.95268 54.99454, 11.9241 55.00216, 11.90949 54.98883, 11.81704 55.0324, 11.63451 55.07252, 11.62247 55.08756, 11.82206 55.04243, 11.83409 55.04945, 11.69769 55.14373, 11.64053 55.17181, 11.49711 55.19688, 11.46501 55.17582, 11.39782 55.2029, 11.3256 55.17883, 11.24658 55.21337, 11.23053 55.23944, 11.19041 55.16523, 11.14227 55.14015, 11.13024 55.16121, 11.17537 55.17927, 11.16534 55.24345, 10.957 55.15067, 10.84435 54.92969, 10.73169 54.71304, 10.97867 54.7802))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE)
 AND occurrence.occurrencestatus = 'PRESENT'
 AND (CAST(occurrence.taxonkey AS INTEGER) = 44 OR CAST(occurrence.acceptedtaxonkey AS INTEGER) = 44 OR CAST(occurrence.kingdomkey AS INTEGER) = 44 OR CAST(occurrence.phylumkey AS INTEGER) = 44 OR CAST(occurrence.classkey AS INTEGER) = 44 OR CAST(occurrence.orderkey AS INTEGER) = 44 OR CAST(occurrence.familykey AS INTEGER) = 44 OR CAST(occurrence.genuskey AS INTEGER) = 44 OR CAST(occurrence.specieskey AS INTEGER) = 44)
 AND (occurrence."year" &gt;= 2010 AND occurrence."year" &lt;= 2025)
 AND occurrence.hasgeospatialissues = FALSE
 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.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 3419 records were derived from 24 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0067811-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.