DOI: 10.15468/dl.g9y8vu
title: Occurrence Download

description: A dataset containing 67 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(genuskey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY genuskey, PRINTF('%04d-%02d', "year", "month"))) genuscount,
 IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY familykey, PRINTF('%04d-%02d', "year", "month"))) familycount,
 COUNT(*) occurrences,
 MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty,
 MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters
FROM
 occurrence
WHERE
 occurrence.decimallatitude &gt;= 14.74322
 AND occurrence.decimallatitude &lt;= 14.97321
 AND (occurrence.decimallongitude &gt;= -88.12824 AND occurrence.decimallongitude &lt;= -87.87506)
 AND GBIF_WITHIN('POLYGON ((-88.07693 14.97321, -88.07409 14.969, -88.07799 14.96593, -88.08224 14.96572, -88.08277 14.95726, -88.08652 14.94531, -88.09946 14.94423, -88.10496 14.93993, -88.11325 14.93736, -88.11331 14.93201, -88.11881 14.93062, -88.12455 14.92664, -88.12133 14.92186, -88.11937 14.92194, -88.11822 14.91587, -88.11487 14.91452, -88.11403 14.91117, -88.11678 14.90977, -88.11715 14.89114, -88.12236 14.88481, -88.12219 14.88105, -88.12824 14.87356, -88.10784 14.85836, -88.10346 14.85232, -88.09961 14.85064, -88.09999 14.84866, -88.09766 14.84577, -88.09145 14.84388, -88.0903 14.83814, -88.08597 14.84023, -88.08015 14.83354, -88.07528 14.83358, -88.07373 14.83036, -88.07104 14.82998, -88.07006 14.8285, -88.07172 14.82583, -88.07121 14.82117, -88.06588 14.8205, -88.06057 14.81699, -88.05649 14.81801, -88.05519 14.80769, -88.06498 14.79242, -88.06714 14.78561, -88.07059 14.78559, -88.07179 14.78197, -88.06914 14.78092, -88.06894 14.77023, -88.06327 14.7672, -88.0562 14.76858, -88.03581 14.75924, -88.03311 14.75326, -88.03002 14.75088, -88.02026 14.75486, -88.0165 14.75396, -88.00993 14.75662, -88.00512 14.75069, -88.00094 14.74931, -87.99573 14.75047, -87.99411 14.75385, -87.98512 14.75641, -87.97027 14.75438, -87.96772 14.75728, -87.96696 14.76126, -87.95805 14.7661, -87.95222 14.76633, -87.9481 14.76349, -87.94804 14.76025, -87.9457 14.7582, -87.9389 14.75882, -87.92987 14.7563, -87.91921 14.74762, -87.91023 14.74322, -87.89997 14.75512, -87.89645 14.75619, -87.89387 14.76056, -87.88402 14.76163, -87.88512 14.77006, -87.8993 14.78684, -87.8982 14.78996, -87.89933 14.79193, -87.88897 14.79829, -87.88472 14.80518, -87.87958 14.80666, -87.87964 14.80968, -87.88442 14.81295, -87.88594 14.81697, -87.8798 14.81864, -87.88149 14.82265, -87.87506 14.82969, -87.88243 14.83402, -87.87919 14.83878, -87.8774 14.84649, -87.8814 14.85074, -87.88376 14.85046, -87.88428 14.85576, -87.88144 14.86142, -87.88366 14.86361, -87.88634 14.86329, -87.8931 14.86931, -87.89795 14.86969, -87.90119 14.87235, -87.90229 14.87553, -87.91066 14.87865, -87.91412 14.87832, -87.91624 14.88187, -87.91511 14.88498, -87.9179 14.88986, -87.92158 14.89177, -87.92329 14.89727, -87.93665 14.9034, -87.94413 14.90862, -87.94929 14.92195, -87.95375 14.92779, -87.95651 14.93022, -87.95898 14.92591, -87.95925 14.94137, -87.96073 14.94255, -87.96464 14.94068, -87.96999 14.94399, -87.96964 14.9482, -87.974 14.94946, -87.97361 14.95259, -87.97919 14.9548, -87.97928 14.95931, -87.98157 14.96094, -87.98078 14.96405, -87.98281 14.96803, -87.98175 14.97112, -87.98613 14.9722, -87.98786 14.96866, -87.98621 14.96563, -87.99238 14.96105, -88.003 14.95883, -88.01183 14.95449, -88.02045 14.95413, -88.029 14.96402, -88.0315 14.96186, -88.04114 14.96215, -88.04305 14.96048, -88.04808 14.96409, -88.05544 14.96274, -88.05828 14.96474, -88.06446 14.96473, -88.06992 14.96867, -88.07138 14.97245, -88.07693 14.97321))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND occurrence.occurrencestatus = 'PRESENT'
 AND (CAST(occurrence.taxonkey AS INTEGER) = 2496714 OR CAST(occurrence.acceptedtaxonkey AS INTEGER) = 2496714 OR CAST(occurrence.kingdomkey AS INTEGER) = 2496714 OR CAST(occurrence.phylumkey AS INTEGER) = 2496714 OR CAST(occurrence.classkey AS INTEGER) = 2496714 OR CAST(occurrence.orderkey AS INTEGER) = 2496714 OR CAST(occurrence.familykey AS INTEGER) = 2496714 OR CAST(occurrence.genuskey AS INTEGER) = 2496714 OR CAST(occurrence.specieskey AS INTEGER) = 2496714)
 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)
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 67 records were derived from 4 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0027941-251025141854904/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.