DOI: 10.15468/dl.z368xv
title: Occurrence Download

description: A dataset containing 312322 records in GBIF matching the query:
SELECT
 kingdom,
 kingdomkey,
 phylum,
 phylumkey,
 class,
 classkey,
 "order",
 orderkey,
 family,
 familykey,
 genus,
 genuskey,
 species,
 specieskey,
 "year",
 GBIF_MGRSCODE(100, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)) mgrscellcode,
 IF(ISNULL(kingdomkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY kingdomkey, GBIF_MGRSCODE(100, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year")) kingdomcount,
 IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY phylumkey, GBIF_MGRSCODE(100, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year")) phylumcount,
 IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY classkey, GBIF_MGRSCODE(100, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year")) classcount,
 IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY orderkey, GBIF_MGRSCODE(100, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year")) ordercount,
 IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY familykey, GBIF_MGRSCODE(100, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year")) familycount,
 IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY genuskey, GBIF_MGRSCODE(100, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year")) genuscount,
 COUNT(*) occurrences,
 MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty,
 MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters
FROM
 occurrence
WHERE
 occurrence.datasetkey = '4fa7b334-ce0d-4e88-aaae-2e0c138d049e'
 AND (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 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 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,
 occurrence."year",
 GBIF_MGRSCODE(100, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000))

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