DOI: 10.15468/dl.vhtwju
title: Occurrence Download

description: A dataset containing 381 records in GBIF matching the query:
SELECT
 kingdom,
 kingdomkey,
 phylum,
 phylumkey,
 class,
 classkey,
 "order",
 orderkey,
 family,
 familykey,
 genus,
 genuskey,
 species,
 specieskey,
 PRINTF('%04d-%02d', "year", "month") yearmonth,
 countrycode countrycode,
 IF(ISNULL(kingdomkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY kingdomkey, countrycode, PRINTF('%04d-%02d', "year", "month"))) kingdomcount,
 IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY phylumkey, countrycode, PRINTF('%04d-%02d', "year", "month"))) phylumcount,
 IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY classkey, countrycode, PRINTF('%04d-%02d', "year", "month"))) classcount,
 IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY orderkey, countrycode, PRINTF('%04d-%02d', "year", "month"))) ordercount,
 IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY familykey, countrycode, PRINTF('%04d-%02d', "year", "month"))) familycount,
 IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY genuskey, countrycode, PRINTF('%04d-%02d', "year", "month"))) genuscount,
 COUNT(*) occurrences,
 MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty,
 MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters
FROM
 occurrence
WHERE
 occurrence.decimallatitude &gt;= 15.36194
 AND occurrence.decimallatitude &lt;= 56.12087
 AND (occurrence.decimallongitude &gt;= 71.01794 AND occurrence.decimallongitude &lt;= 136.01326)
 AND GBIF_WITHIN('POLYGON ((101.14234 15.36194, 109.79343 17.77404, 125.08076 23.75036, 124.20219 34.11346, 123.98551 38.23028, 129.40237 41.69707, 134.38587 39.96367, 136.01326 48.45853, 123.52031 56.12087, 113.60925 48.87496, 99.70044 43.04492, 99.03415 52.95599, 82.53134 48.57678, 72.09301 39.88859, 71.01794 36.72047, 81.03646 29.26762, 94.75168 26.34889, 101.14234 15.36194))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND occurrence.occurrencestatus = 'PRESENT'
 AND (occurrence.taxonkey = 7705930 OR occurrence.acceptedtaxonkey = 7705930 OR occurrence.kingdomkey = 7705930 OR occurrence.phylumkey = 7705930 OR occurrence.classkey = 7705930 OR occurrence.orderkey = 7705930 OR occurrence.familykey = 7705930 OR occurrence.genuskey = 7705930 OR occurrence.specieskey = 7705930)
 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.hascoordinate = TRUE)
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', "year", "month"),
 occurrence.countrycode

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