DOI: 10.15468/dl.nt5tvq
title: Occurrence Download

description: A dataset containing 5862 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.49274
 AND occurrence.decimallatitude &lt;= 44.5827
 AND (occurrence.decimallongitude &gt;= 6.23428 AND occurrence.decimallongitude &lt;= 6.36006)
 AND GBIF_WITHIN('POLYGON ((6.36004 44.53582, 6.36006 44.53935, 6.35969 44.54288, 6.35893 44.54637, 6.35779 44.54981, 6.35628 44.55318, 6.3544 44.55645, 6.35217 44.5596, 6.3496 44.56262, 6.34671 44.56548, 6.34351 44.56818, 6.34003 44.57069, 6.33628 44.57299, 6.33228 44.57508, 6.32808 44.57693, 6.32368 44.57854, 6.31911 44.57991, 6.31441 44.58101, 6.30961 44.58184, 6.30473 44.5824, 6.2998 44.58269, 6.29485 44.5827, 6.28992 44.58243, 6.28503 44.58189, 6.28022 44.58107, 6.27552 44.57998, 6.27094 44.57864, 6.26653 44.57704, 6.26231 44.5752, 6.2583 44.57313, 6.25454 44.57084, 6.25104 44.56834, 6.24782 44.56566, 6.2449 44.5628, 6.24231 44.55979, 6.24006 44.55665, 6.23816 44.55339, 6.23663 44.55003, 6.23546 44.54659, 6.23468 44.5431, 6.23429 44.53958, 6.23428 44.53604, 6.23466 44.53252, 6.23542 44.52903, 6.23657 44.52559, 6.23809 44.52223, 6.23997 44.51896, 6.2422 44.51581, 6.24478 44.51279, 6.24767 44.50993, 6.25087 44.50724, 6.25436 44.50473, 6.25811 44.50243, 6.2621 44.50035, 6.2663 44.4985, 6.2707 44.49688, 6.27525 44.49552, 6.27995 44.49443, 6.28475 44.49359, 6.28962 44.49303, 6.29454 44.49275, 6.29948 44.49274, 6.3044 44.493, 6.30928 44.49355, 6.31409 44.49436, 6.31879 44.49545, 6.32335 44.49679, 6.32776 44.49839, 6.33198 44.50022, 6.33598 44.50229, 6.33975 44.50458, 6.34325 44.50707, 6.34647 44.50975, 6.34938 44.5126, 6.35198 44.51561, 6.35423 44.51876, 6.35614 44.52202, 6.35768 44.52537, 6.35885 44.52881, 6.35964 44.5323, 6.36004 44.53582))', 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 5862 records were derived from 129 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0033234-251025141854904/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.