DOI: 10.15468/dl.7bd8k7
title: Occurrence Download

description: A dataset containing 155 records in GBIF matching the query:
SELECT
 kingdom,
 kingdomkey,
 phylum,
 phylumkey,
 class,
 classkey,
 "order",
 orderkey,
 family,
 familykey,
 genus,
 genuskey,
 species,
 specieskey,
 PRINTF('%04d-%02d-%02d', "year", "month", "day") yearmonthday,
 IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY familykey, PRINTF('%04d-%02d-%02d', "year", "month", "day"))) familycount,
 IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY genuskey, PRINTF('%04d-%02d-%02d', "year", "month", "day"))) genuscount,
 COUNT(*) occurrences,
 MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty,
 MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters
FROM
 occurrence
WHERE
 occurrence.decimallatitude &gt;= 44.96936
 AND occurrence.decimallatitude &lt;= 45.25507
 AND (occurrence.decimallongitude &gt;= 38.61095 AND occurrence.decimallongitude &lt;= 39.35651)
 AND GBIF_WITHIN('POLYGON ((38.61095 45.08851, 38.6218 45.08135, 38.62608 45.07006, 38.64203 45.05917, 38.64943 45.0654, 38.66927 45.0724, 38.68445 45.0759, 38.70508 45.06384, 38.71674 45.0503, 38.72219 45.04057, 38.73464 45.04446, 38.74359 45.05341, 38.75449 45.06003, 38.76772 45.05653, 38.76538 45.04952, 38.75604 45.0394, 38.76071 45.03162, 38.7755 45.02306, 38.78562 45.0036, 38.80858 44.99815, 38.82414 45.00788, 38.84944 45.00672, 38.86501 45.00399, 38.87084 45.011, 38.85995 45.02617, 38.87396 45.03201, 38.88641 45.03979, 38.90198 45.0503, 38.90198 45.04252, 38.89419 45.02617, 38.90042 45.01878, 38.91248 45.02189, 38.92805 45.02851, 38.94323 45.03473, 38.95335 45.02851, 38.94439 45.01761, 38.95257 44.99893, 38.97086 44.99309, 38.97358 45.00749, 38.98487 45.00633, 39.00043 45.00438, 39.01328 44.99893, 39.01678 44.98103, 39.02106 44.96936, 39.02767 44.97169, 39.03974 44.98453, 39.05102 44.97986, 39.06464 44.97597, 39.06659 44.98337, 39.07827 44.98804, 39.09189 44.98648, 39.10395 44.99309, 39.1308 44.99893, 39.14637 45.00088, 39.15376 45.01022, 39.16349 45.01216, 39.18373 45.01216, 39.2028 45.00749, 39.22264 45.01722, 39.25417 45.01255, 39.26973 45.02851, 39.29269 45.02189, 39.32811 45.03785, 39.3211 45.04991, 39.33278 45.05692, 39.35651 45.0682, 39.34095 45.0861, 39.22186 45.07482, 39.174 45.0861, 39.15454 45.10401, 39.11763 45.19047, 39.07599 45.21382, 39.00828 45.17607, 38.93628 45.18774, 38.86157 45.20331, 38.89815 45.25507, 38.81915 45.24223, 38.76505 45.2072, 38.7238 45.12665, 38.6269 45.13054, 38.61095 45.08851))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND occurrence.occurrencestatus = 'PRESENT'
 AND (CAST(occurrence.taxonkey AS INTEGER) = 789 OR CAST(occurrence.acceptedtaxonkey AS INTEGER) = 789 OR CAST(occurrence.kingdomkey AS INTEGER) = 789 OR CAST(occurrence.phylumkey AS INTEGER) = 789 OR CAST(occurrence.classkey AS INTEGER) = 789 OR CAST(occurrence.orderkey AS INTEGER) = 789 OR CAST(occurrence.familykey AS INTEGER) = 789 OR CAST(occurrence.genuskey AS INTEGER) = 789 OR CAST(occurrence.specieskey AS INTEGER) = 789)
 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 AND occurrence."month" IS NOT NULL AND occurrence."day" 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,
 PRINTF('%04d-%02d-%02d', "year", "month", "day")

 The dataset's 155 records were derived from 2 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0054246-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.