DOI: 10.15468/dl.gsepdn
title: Occurrence Download

description: A dataset containing 17 records in GBIF matching the query:
SELECT
 kingdom,
 kingdomkey,
 phylum,
 phylumkey,
 class,
 classkey,
 "order",
 orderkey,
 family,
 familykey,
 genus,
 genuskey,
 species,
 specieskey,
 "year",
 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;= 43.75269
 AND occurrence.decimallatitude &lt;= 45.20017
 AND (occurrence.decimallongitude &gt;= 38.68502 AND occurrence.decimallongitude &lt;= 40.77643)
 AND GBIF_WITHIN('POLYGON ((38.69179 45.01088, 38.68502 44.94993, 38.76968 44.9567, 38.82582 44.92785, 38.87625 44.89558, 39.00736 44.84918, 39.10822 44.82296, 39.22925 44.83103, 39.24337 44.89759, 39.35633 44.93592, 39.57015 45.03678, 39.60691 45.03258, 39.59839 44.97626, 39.62865 44.94891, 39.66698 44.97514, 39.66698 44.97514, 39.69724 44.94891, 39.77187 44.97312, 39.7638 45.00136, 39.88282 45.0175, 39.92316 44.94488, 39.95543 44.89041, 39.95342 44.84604, 39.9635 44.79762, 40.02402 44.74114, 39.97157 44.7129, 39.93325 44.72299, 39.90702 44.69071, 39.89895 44.65239, 39.91711 44.59591, 39.8687 44.58784, 39.87878 44.43453, 39.85458 44.39822, 39.85054 44.33972, 39.90774 44.34941, 39.96228 44.34082, 39.9768 44.2653, 40.09879 44.25078, 40.07265 44.15494, 40.08717 44.11428, 40.0476 44.12943, 39.98561 44.08651, 39.9403 44.11036, 39.864 44.1795, 39.81154 44.18427, 39.76147 44.16997, 39.80439 44.11512, 39.82585 44.07697, 39.80678 43.99114, 39.77101 43.95775, 39.833 43.91483, 39.895 43.94345, 39.92123 43.96729, 39.93553 43.94583, 40.00707 43.90291, 40.07383 43.85046, 40.10721 43.85761, 40.16921 43.87191, 40.20497 43.86953, 40.19543 43.79323, 40.25981 43.75269, 40.30273 43.77177, 40.36473 43.75985, 40.40288 43.85046, 40.40765 43.93629, 40.48156 43.95298, 40.40526 44.05313, 40.42911 44.09605, 40.40765 44.15327, 40.3695 44.23196, 40.46982 44.3021, 40.45741 44.38895, 40.41399 44.44787, 40.39538 44.48509, 40.40779 44.51611, 40.33955 44.57504, 40.33955 44.64637, 40.40158 44.64947, 40.36747 44.72391, 40.42329 44.73941, 40.45741 44.76733, 40.58767 44.73631, 40.57527 44.65257, 40.6404 44.63707, 40.66211 44.55022, 40.65901 44.5037, 40.61303 44.46882, 40.77643 44.46882, 40.69977 44.65844, 40.56664 44.89445, 40.34475 45.06793, 40.16926 45.13046, 40.0341 45.09011, 39.89492 45.09729, 39.75372 45.13158, 39.669 45.20017, 39.6105 45.18403, 39.552 45.11343, 39.45114 45.00854, 39.45114 45.00854, 39.38054 44.98837, 39.29985 44.9339, 39.29985 44.9339, 39.28589 44.95485, 39.25951 44.92987, 39.2111 44.91373, 39.16067 44.91776, 39.11966 44.99271, 39.05577 44.98231, 39.0114 45.0045, 38.96097 45.01862, 38.87019 45.00652, 38.78547 45.00249, 38.73504 45.06098, 38.68663 45.07712, 38.69179 45.01088))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND occurrence.occurrencestatus = 'PRESENT'
 AND (occurrence.taxonkey = 839 OR occurrence.acceptedtaxonkey = 839 OR occurrence.kingdomkey = 839 OR occurrence.phylumkey = 839 OR occurrence.classkey = 839 OR occurrence.orderkey = 839 OR occurrence.familykey = 839 OR occurrence.genuskey = 839 OR occurrence.specieskey = 839)
 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 17 records were derived from 3 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0028106-250426092105405/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.