DOI: 10.15468/dl.w89jyj
title: Occurrence Download

description: A dataset containing 4788 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.50412
 AND occurrence.decimallatitude &lt;= 44.59408
 AND (occurrence.decimallongitude &gt;= 6.20188 AND occurrence.decimallongitude &lt;= 6.32769)
 AND GBIF_WITHIN('POLYGON ((6.32767 44.54722, 6.32769 44.55076, 6.32731 44.55428, 6.32656 44.55777, 6.32542 44.56121, 6.3239 44.56458, 6.32202 44.56784, 6.31979 44.571, 6.31722 44.57402, 6.31432 44.57688, 6.31112 44.57958, 6.30763 44.58208, 6.30388 44.58438, 6.29989 44.58647, 6.29568 44.58832, 6.29128 44.58993, 6.28671 44.59129, 6.28201 44.59239, 6.2772 44.59323, 6.27232 44.59379, 6.26739 44.59407, 6.26244 44.59408, 6.25751 44.59381, 6.25262 44.59326, 6.24781 44.59245, 6.2431 44.59136, 6.23853 44.59001, 6.23412 44.58841, 6.2299 44.58657, 6.22589 44.5845, 6.22213 44.58221, 6.21863 44.57971, 6.21541 44.57703, 6.2125 44.57417, 6.20991 44.57116, 6.20766 44.56801, 6.20576 44.56475, 6.20422 44.56139, 6.20306 44.55796, 6.20228 44.55447, 6.20189 44.55094, 6.20188 44.54741, 6.20227 44.54388, 6.20303 44.54039, 6.20418 44.53695, 6.2057 44.53359, 6.20759 44.53033, 6.20982 44.52717, 6.2124 44.52416, 6.2153 44.5213, 6.2185 44.5186, 6.22199 44.5161, 6.22574 44.5138, 6.22973 44.51172, 6.23394 44.50987, 6.23833 44.50826, 6.24289 44.5069, 6.24759 44.5058, 6.25239 44.50497, 6.25726 44.50441, 6.26218 44.50413, 6.26712 44.50412, 6.27205 44.50439, 6.27693 44.50493, 6.28173 44.50575, 6.28643 44.50684, 6.291 44.50818, 6.29541 44.50978, 6.29962 44.51162, 6.30363 44.51369, 6.30739 44.51598, 6.31089 44.51847, 6.31411 44.52115, 6.31703 44.524, 6.31962 44.52701, 6.32187 44.53016, 6.32378 44.53342, 6.32532 44.53678, 6.32649 44.54021, 6.32727 44.5437, 6.32767 44.54722))', 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 4788 records were derived from 124 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0033240-251025141854904/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.