DOI: 10.15468/dl.dwaz3v
title: Occurrence Download

description: A dataset containing 2 records in GBIF matching the query:
SELECT
 kingdom,
 kingdomkey,
 phylum,
 phylumkey,
 class,
 classkey,
 "order",
 orderkey,
 family,
 familykey,
 genus,
 genuskey,
 species,
 specieskey,
 "year",
 IF(ISNULL(kingdomkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY kingdomkey, "year")) kingdomcount,
 IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY phylumkey, "year")) phylumcount,
 IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY classkey, "year")) classcount,
 IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY orderkey, "year")) ordercount,
 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;= 4.83855
 AND occurrence.decimallatitude &lt;= 5.61518
 AND (occurrence.decimallongitude &gt;= -72.86713 AND occurrence.decimallongitude &lt;= -72.19011)
 AND GBIF_WITHIN('POLYGON ((-72.26401 5.61518, -72.30493 5.60477, -72.29793 5.57421, -72.30892 5.54127, -72.30435 5.52151, -72.30968 5.50258, -72.31705 5.49789, -72.34473 5.50674, -72.37482 5.53779, -72.38325 5.5599, -72.39584 5.57046, -72.42007 5.5632, -72.4419 5.51904, -72.4896 5.48144, -72.50612 5.43911, -72.53617 5.41579, -72.54519 5.41871, -72.56907 5.4022, -72.57956 5.35547, -72.62453 5.34455, -72.6803 5.28641, -72.70061 5.27772, -72.70089 5.24129, -72.7472 5.21897, -72.75499 5.1878, -72.77287 5.17632, -72.77401 5.1525, -72.80477 5.13885, -72.81961 5.14441, -72.84308 5.12877, -72.86713 5.08964, -72.86333 5.05583, -72.85333 5.05375, -72.84917 5.04542, -72.85709 5.03, -72.84854 5.01207, -72.82532 4.98937, -72.82611 4.94988, -72.81458 4.94417, -72.80625 4.95, -72.78333 4.93375, -72.73542 4.9225, -72.73666 4.905, -72.71208 4.9125, -72.70541 4.90833, -72.6725 4.91292, -72.63517 4.89293, -72.62972 4.87966, -72.61329 4.86706, -72.57083 4.86782, -72.56214 4.85739, -72.52855 4.85363, -72.50855 4.84453, -72.49229 4.8587, -72.46455 4.85906, -72.45828 4.86473, -72.43978 4.852, -72.4187 4.8607, -72.39903 4.83855, -72.38164 4.84581, -72.37966 4.85448, -72.39796 4.86636, -72.40229 4.88107, -72.40686 4.87785, -72.41335 4.89002, -72.44447 4.90894, -72.45692 4.95071, -72.49037 4.99091, -72.47475 5.01271, -72.46697 5.01228, -72.43727 4.97521, -72.40203 4.97949, -72.37954 5.00614, -72.35954 5.03485, -72.33741 5.09168, -72.35822 5.15157, -72.35436 5.17551, -72.36663 5.20115, -72.34156 5.21335, -72.34084 5.20844, -72.30675 5.19539, -72.29954 5.2067, -72.28858 5.20524, -72.28215 5.19185, -72.28683 5.26107, -72.26418 5.24851, -72.24387 5.25791, -72.24773 5.26615, -72.26092 5.26903, -72.26549 5.28123, -72.22829 5.28696, -72.22617 5.29193, -72.23772 5.30136, -72.22162 5.30622, -72.21035 5.32267, -72.21347 5.32922, -72.21791 5.32446, -72.22577 5.33003, -72.2253 5.37232, -72.20388 5.35916, -72.19913 5.36671, -72.19011 5.36335, -72.20056 5.38025, -72.21097 5.37569, -72.20524 5.38973, -72.22726 5.40906, -72.21827 5.45373, -72.23863 5.48775, -72.22545 5.49921, -72.2174 5.52207, -72.22257 5.53645, -72.24458 5.54958, -72.25446 5.5467, -72.24548 5.57563, -72.26401 5.61518))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND occurrence.occurrencestatus = 'PRESENT'
 AND (CAST(occurrence.taxonkey AS INTEGER) = 2476422 OR CAST(occurrence.acceptedtaxonkey AS INTEGER) = 2476422 OR CAST(occurrence.kingdomkey AS INTEGER) = 2476422 OR CAST(occurrence.phylumkey AS INTEGER) = 2476422 OR CAST(occurrence.classkey AS INTEGER) = 2476422 OR CAST(occurrence.orderkey AS INTEGER) = 2476422 OR CAST(occurrence.familykey AS INTEGER) = 2476422 OR CAST(occurrence.genuskey AS INTEGER) = 2476422 OR CAST(occurrence.specieskey AS INTEGER) = 2476422)
 AND (occurrence."year" &gt;= 2019 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 2 records were derived from 3 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0064334-251120083545085/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.