DOI: 10.15468/dl.v6f2wd
title: Occurrence Download

description: A dataset containing 2561 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(kingdomkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY kingdomkey, PRINTF('%04d-%02d-%02d', "year", "month", "day"))) kingdomcount,
 IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY phylumkey, PRINTF('%04d-%02d-%02d', "year", "month", "day"))) phylumcount,
 IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY classkey, PRINTF('%04d-%02d-%02d', "year", "month", "day"))) classcount,
 IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY orderkey, PRINTF('%04d-%02d-%02d', "year", "month", "day"))) ordercount,
 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;= 47.84594
 AND occurrence.decimallatitude &lt;= 47.90149
 AND (occurrence.decimallongitude &gt;= 1.02987 AND occurrence.decimallongitude &lt;= 1.09278)
 AND GBIF_WITHIN('POLYGON ((1.04157 47.84765, 1.04296 47.84716, 1.04424 47.8464, 1.0468 47.84623, 1.04947 47.84754, 1.04936 47.8477, 1.05303 47.8494, 1.05606 47.85051, 1.05728 47.84911, 1.05773 47.849, 1.05943 47.84811, 1.06268 47.84594, 1.06356 47.84632, 1.0691 47.84733, 1.06853 47.84753, 1.06722 47.84835, 1.06561 47.85046, 1.06504 47.85111, 1.06436 47.85166, 1.06478 47.85315, 1.06488 47.85403, 1.06474 47.85506, 1.06481 47.85591, 1.06511 47.8567, 1.06575 47.8576, 1.06635 47.85809, 1.06729 47.85863, 1.06749 47.85925, 1.06779 47.85959, 1.06911 47.86039, 1.06949 47.86118, 1.07098 47.86059, 1.07148 47.86098, 1.07274 47.86281, 1.07312 47.86251, 1.07576 47.86299, 1.07481 47.86379, 1.08637 47.86596, 1.09082 47.86706, 1.09114 47.86801, 1.09118 47.86871, 1.09145 47.86948, 1.09257 47.87148, 1.09262 47.87228, 1.09238 47.8731, 1.09249 47.87369, 1.09278 47.87431, 1.09133 47.87457, 1.09035 47.87627, 1.0896 47.8772, 1.08912 47.87765, 1.08975 47.87782, 1.08971 47.87806, 1.08855 47.88122, 1.08706 47.8825, 1.08353 47.88525, 1.07984 47.88786, 1.0807 47.88936, 1.07485 47.88953, 1.07498 47.89094, 1.07428 47.89216, 1.07407 47.89382, 1.07326 47.8967, 1.073 47.89832, 1.07037 47.90149, 1.06643 47.90056, 1.0671 47.89979, 1.06401 47.89807, 1.06364 47.89812, 1.06145 47.89911, 1.06085 47.89862, 1.0618 47.89605, 1.06182 47.89511, 1.06152 47.89371, 1.06196 47.89332, 1.06179 47.89229, 1.06078 47.89014, 1.0606 47.88832, 1.05981 47.88662, 1.05643 47.88253, 1.05532 47.88049, 1.05389 47.87929, 1.05102 47.87724, 1.04959 47.8768, 1.04797 47.87673, 1.04539 47.87612, 1.0439 47.87488, 1.04373 47.87426, 1.04392 47.87337, 1.04074 47.87298, 1.04024 47.87301, 1.03975 47.8726, 1.03858 47.87102, 1.03028 47.86729, 1.03156 47.86695, 1.03016 47.86597, 1.02987 47.86538, 1.03014 47.86453, 1.03053 47.86402, 1.0314 47.86324, 1.03099 47.86305, 1.03157 47.86221, 1.03188 47.862, 1.03113 47.86054, 1.03075 47.85871, 1.03073 47.85818, 1.031 47.85626, 1.03143 47.85533, 1.03375 47.85302, 1.03199 47.85253, 1.03464 47.85047, 1.0353 47.8485, 1.03824 47.84956, 1.0407 47.84786, 1.04157 47.84765))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND occurrence.publishingorgkey = '1928bdf0-f5d2-11dc-8c12-b8a03c50a862'
 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 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 2561 records were derived from 36 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0018735-250920141307145/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.