DOI: 10.15468/dl.tm55kz
title: Occurrence Download

description: A dataset containing 6445 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;= 44.48975
 AND occurrence.decimallatitude &lt;= 44.57971
 AND (occurrence.decimallongitude &gt;= 6.23896 AND occurrence.decimallongitude &lt;= 6.36473)
 AND GBIF_WITHIN('POLYGON ((6.36472 44.53283, 6.36473 44.53637, 6.36436 44.53989, 6.3636 44.54338, 6.36247 44.54682, 6.36096 44.55019, 6.35908 44.55346, 6.35685 44.55661, 6.35428 44.55963, 6.35139 44.5625, 6.34819 44.56519, 6.3447 44.5677, 6.34095 44.57, 6.33696 44.57209, 6.33275 44.57395, 6.32835 44.57556, 6.32379 44.57692, 6.31909 44.57802, 6.31429 44.57886, 6.30941 44.57942, 6.30448 44.57971, 6.29953 44.57971, 6.2946 44.57945, 6.28971 44.5789, 6.2849 44.57808, 6.2802 44.577, 6.27562 44.57566, 6.27121 44.57406, 6.26699 44.57222, 6.26299 44.57015, 6.25922 44.56786, 6.25572 44.56536, 6.2525 44.56268, 6.24959 44.55982, 6.247 44.55681, 6.24474 44.55367, 6.24284 44.5504, 6.24131 44.54704, 6.24015 44.54361, 6.23936 44.54012, 6.23897 44.5366, 6.23896 44.53306, 6.23934 44.52954, 6.2401 44.52605, 6.24125 44.52261, 6.24276 44.51925, 6.24465 44.51598, 6.24688 44.51283, 6.24945 44.50981, 6.25235 44.50695, 6.25555 44.50425, 6.25903 44.50175, 6.26278 44.49945, 6.26677 44.49737, 6.27098 44.49551, 6.27537 44.4939, 6.27993 44.49254, 6.28462 44.49144, 6.28942 44.49061, 6.29429 44.49005, 6.29922 44.48976, 6.30415 44.48975, 6.30908 44.49002, 6.31395 44.49056, 6.31876 44.49138, 6.32346 44.49246, 6.32803 44.49381, 6.33243 44.4954, 6.33665 44.49724, 6.34065 44.49931, 6.34442 44.50159, 6.34792 44.50409, 6.35114 44.50677, 6.35406 44.50962, 6.35665 44.51263, 6.35891 44.51577, 6.36081 44.51903, 6.36235 44.52239, 6.36352 44.52582, 6.36431 44.52931, 6.36472 44.53283))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND (occurrence."year" &gt;= 2010 AND occurrence."year" &lt;= 2025)
 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 6445 records were derived from 135 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0033222-251025141854904/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.