DOI: 10.15468/dl.fdvvap
title: Occurrence Download

description: A dataset containing 89 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;= 11.10651
 AND occurrence.decimallatitude &lt;= 11.23608
 AND (occurrence.decimallongitude &gt;= 99.35343 AND occurrence.decimallongitude &lt;= 99.46244)
 AND GBIF_WITHIN('MULTIPOLYGON (((99.46211 11.18726, 99.46154 11.19009, 99.46034 11.19418, 99.45966 11.19873, 99.45837 11.20305, 99.45681 11.20654, 99.45457 11.21022, 99.45102 11.21476, 99.44908 11.21689, 99.4465 11.2192, 99.44486 11.2216, 99.44297 11.22394, 99.44122 11.22578, 99.43834 11.2283, 99.43637 11.22972, 99.43214 11.23212, 99.42894 11.23346, 99.42447 11.23486, 99.42116 11.23551, 99.41542 11.23608, 99.41254 11.23604, 99.40838 11.23553, 99.40464 11.23459, 99.40178 11.23353, 99.39735 11.23124, 99.39534 11.22987, 99.39308 11.22806, 99.39114 11.2262, 99.38954 11.22439, 99.38757 11.22172, 99.38641 11.21984, 99.38511 11.21727, 99.38397 11.21442, 99.38301 11.211, 99.38254 11.20837, 99.38228 11.20424, 99.38237 11.202, 99.38271 11.19914, 99.38325 11.19652, 99.38571 11.18876, 99.38633 11.18724, 99.3855 11.18626, 99.38292 11.18616, 99.38025 11.18584, 99.3759 11.18481, 99.37114 11.1829, 99.36891 11.18168, 99.36509 11.17901, 99.36145 11.17553, 99.3586 11.17181, 99.35705 11.1692, 99.35586 11.16668, 99.35504 11.1645, 99.35414 11.16123, 99.35348 11.15657, 99.35343 11.15352, 99.35378 11.14975, 99.35449 11.14638, 99.35501 11.14465, 99.35654 11.14088, 99.35789 11.13838, 99.35939 11.1361, 99.36163 11.13333, 99.36446 11.13023, 99.36566 11.12779, 99.36775 11.12448, 99.36971 11.12201, 99.37179 11.11985, 99.37489 11.11723, 99.37833 11.11397, 99.38064 11.11224, 99.38306 11.11075, 99.3869 11.1089, 99.39153 11.10742, 99.39515 11.10675, 99.39786 11.10651, 99.40174 11.10656, 99.40636 11.10722, 99.41016 11.10827, 99.4129 11.10934, 99.41677 11.11043, 99.41937 11.11145, 99.42315 11.11319, 99.42705 11.11536, 99.4297 11.11645, 99.434 11.11888, 99.4368 11.12096, 99.4384 11.12239, 99.44051 11.12458, 99.44333 11.1283, 99.4469 11.13204, 99.44957 11.13583, 99.45189 11.14042, 99.45288 11.14327, 99.45411 11.14789, 99.45451 11.1504, 99.45474 11.15455, 99.45462 11.15708, 99.45411 11.16068, 99.45677 11.16405, 99.45837 11.16662, 99.46037 11.17089, 99.46149 11.17444, 99.46232 11.17909, 99.46244 11.18406, 99.46211 11.18726)))', 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.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 89 records were derived from 2 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0001952-260119153935675/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.