DOI: 10.15468/dl.yw3y9p
title: Occurrence Download

description: A dataset containing 15 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.75923
 AND occurrence.decimallatitude &lt;= 45.18196
 AND (occurrence.decimallongitude &gt;= 38.68547 AND occurrence.decimallongitude &lt;= 40.76679)
 AND GBIF_WITHIN('POLYGON ((38.68547 45.04381, 38.68547 44.96074, 38.75038 44.95554, 38.78413 44.97891, 38.83865 44.93477, 38.89836 44.88025, 39.01082 44.81183, 39.09827 44.82833, 39.29871 44.8225, 39.45749 44.81206, 39.55986 44.80788, 39.55359 44.84548, 39.62463 44.85384, 39.65614 44.8913, 39.57657 44.92488, 39.49927 44.98964, 39.55777 45.04187, 39.65179 45.03351, 39.61 44.9792, 39.62045 44.95412, 39.66698 44.98773, 39.69566 44.96039, 39.77505 44.9792, 39.86772 45.01191, 39.92756 44.92279, 39.94846 44.85384, 39.98268 44.84328, 39.94428 44.80579, 40.01505 44.78833, 40.00487 44.7264, 39.92339 44.71595, 39.89623 44.64283, 39.92965 44.58015, 39.87951 44.5906, 39.87951 44.49658, 39.8628 44.38377, 39.84449 44.32656, 39.91506 44.34884, 39.96888 44.32353, 39.98405 44.25375, 40.05727 44.28818, 40.0781 44.22038, 40.069 44.12936, 40.00525 44.07256, 39.89607 44.1506, 39.83842 44.18397, 39.76864 44.1779, 39.80153 44.12931, 39.82415 44.0959, 39.78988 44.00497, 39.78685 43.92609, 39.88393 43.92002, 39.90214 43.9807, 39.94461 43.94126, 40.09327 43.85631, 40.18732 43.87755, 40.20856 43.7926, 40.27227 43.77136, 40.35115 43.75923, 40.39969 43.81687, 40.40879 43.91092, 40.46037 43.98373, 40.42093 44.07778, 40.37845 44.24161, 40.47554 44.29622, 40.43307 44.41758, 40.40273 44.47219, 40.41183 44.54197, 40.33901 44.56017, 40.37081 44.63671, 40.36329 44.67546, 40.40879 44.71793, 40.46947 44.77558, 40.54835 44.7422, 40.56352 44.66332, 40.67274 44.56321, 40.63027 44.48129, 40.76679 44.47826, 40.72735 44.52376, 40.74027 44.6094, 40.67969 44.6491, 40.66715 44.70968, 40.52926 44.92696, 40.43942 44.998, 40.20125 45.12962, 39.94219 45.07948, 39.84609 45.11708, 39.71237 45.14633, 39.68312 45.14391, 39.65776 45.18196, 39.58927 45.14645, 39.55375 45.07288, 39.52852 45.0565, 39.43869 45.00844, 39.30289 44.94786, 39.20887 44.90398, 39.13366 44.92905, 39.05218 44.97502, 38.95816 45.00427, 38.8349 45.01471, 38.79181 44.99282, 38.74519 45.01785, 38.74778 45.06458, 38.68547 45.04381))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND GBIF_STRINGARRAYCONTAINS(occurrence.issue, 'OCCURRENCE_STATUS_INFERRED_FROM_INDIVIDUAL_COUNT', TRUE)
 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 (occurrence."year" &gt;= 2005 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.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 15 records were derived from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0028683-250426092105405/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.