DOI: 10.15468/dl.sq72fv
title: Occurrence Download

description: A dataset containing 641 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,
 IF(ISNULL(kingdomkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY kingdomkey, PRINTF('%04d-%02d', "year", "month"))) kingdomcount,
 IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY phylumkey, PRINTF('%04d-%02d', "year", "month"))) phylumcount,
 IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY classkey, PRINTF('%04d-%02d', "year", "month"))) classcount,
 IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY orderkey, PRINTF('%04d-%02d', "year", "month"))) ordercount,
 IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY familykey, PRINTF('%04d-%02d', "year", "month"))) familycount,
 IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY genuskey, 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;= 16.28903
 AND occurrence.decimallatitude &lt;= 16.38348
 AND (occurrence.decimallongitude &gt;= 104.54886 AND occurrence.decimallongitude &lt;= 104.6535)
 AND GBIF_WITHIN('MULTIPOLYGON (((104.6308 16.37984, 104.62908 16.38062, 104.62738 16.38128, 104.62567 16.38186, 104.62352 16.38245, 104.62151 16.38288, 104.61964 16.38318, 104.61771 16.38338, 104.61573 16.38348, 104.61364 16.38347, 104.61128 16.38332, 104.60903 16.38304, 104.6068 16.38261, 104.60478 16.3821, 104.60265 16.38143, 104.60055 16.38062, 104.59855 16.3797, 104.5956 16.38062, 104.59351 16.38109, 104.59139 16.38142, 104.58926 16.38162, 104.58712 16.38168, 104.58497 16.38161, 104.58284 16.3814, 104.58072 16.38106, 104.57864 16.38059, 104.57658 16.37998, 104.5733 16.3787, 104.5711 16.37806, 104.5691 16.37733, 104.56715 16.37647, 104.56526 16.37549, 104.56344 16.37439, 104.5617 16.37318, 104.55997 16.37181, 104.55841 16.37039, 104.55694 16.36887, 104.55559 16.36727, 104.55434 16.36558, 104.55321 16.36382, 104.55221 16.362, 104.55132 16.36011, 104.55057 16.35817, 104.54996 16.35619, 104.54947 16.35417, 104.54913 16.35212, 104.54892 16.35006, 104.54886 16.34799, 104.54893 16.34593, 104.54915 16.34387, 104.5495 16.34182, 104.54999 16.33981, 104.55062 16.33783, 104.55138 16.33589, 104.55227 16.33401, 104.55328 16.33218, 104.55426 16.33068, 104.55438 16.32888, 104.55463 16.32691, 104.55534 16.32355, 104.55588 16.32171, 104.5565 16.31998, 104.55726 16.31818, 104.55801 16.31666, 104.55892 16.31501, 104.56114 16.31136, 104.56221 16.30979, 104.56343 16.30821, 104.56497 16.30644, 104.56654 16.30486, 104.56809 16.30349, 104.5699 16.30206, 104.57169 16.30084, 104.5733 16.29987, 104.57551 16.2987, 104.57771 16.29773, 104.57937 16.29659, 104.58119 16.2955, 104.58309 16.29453, 104.58612 16.29327, 104.58934 16.29227, 104.59231 16.29155, 104.5956 16.29044, 104.59802 16.28984, 104.59993 16.28948, 104.60187 16.28923, 104.6035 16.28909, 104.60588 16.28903, 104.60807 16.2891, 104.61 16.28928, 104.61202 16.28957, 104.61395 16.28996, 104.61583 16.29045, 104.61767 16.29103, 104.61951 16.29171, 104.62138 16.29253, 104.62305 16.29338, 104.62494 16.29447, 104.62682 16.29572, 104.6283 16.29682, 104.62988 16.29816, 104.63133 16.29952, 104.63262 16.30089, 104.63404 16.30257, 104.63546 16.3045, 104.6366 16.30629, 104.63767 16.30823, 104.63868 16.31038, 104.63961 16.31135, 104.64097 16.31295, 104.64221 16.31463, 104.64361 16.31689, 104.64536 16.31879, 104.64707 16.32095, 104.64851 16.32311, 104.65001 16.32582, 104.65087 16.32769, 104.65162 16.32965, 104.65229 16.33178, 104.6528 16.33388, 104.65316 16.33588, 104.6534 16.33803, 104.6535 16.3402, 104.65347 16.3422, 104.6533 16.34435, 104.65298 16.34654, 104.65248 16.34885, 104.65184 16.35108, 104.65022 16.35565, 104.64926 16.35797, 104.64866 16.35989, 104.64795 16.36179, 104.64688 16.36412, 104.64556 16.3665, 104.64447 16.36818, 104.64254 16.37072, 104.641 16.37244, 104.63918 16.3742, 104.63707 16.37597, 104.63487 16.37753, 104.63288 16.37875, 104.6308 16.37984)))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND (occurrence."year" &gt;= 2022 AND occurrence."year" &lt;= 2024)
 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.classificationdetails['d7dddbf4-2cf0-4f39-9b2a-bb099caae36c']['specieskey'] &lt;&gt; '' AND occurrence."year" IS NOT NULL AND occurrence."month" 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', "year", "month")

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