DOI: 10.15468/dl.9ddrtm
title: Occurrence Download

description: A dataset containing 5773 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.datasetkey = '4fa7b334-ce0d-4e88-aaae-2e0c138d049e'
 AND (occurrence.decimallatitude &gt;= 36.30016 AND occurrence.decimallatitude &lt;= 36.8963 AND (occurrence.decimallongitude &gt;= -87.6123 AND occurrence.decimallongitude &lt;= -86.87206) AND GBIF_WITHIN('POLYGON ((-87.23862 36.8963, -87.25506 36.896, -87.27146 36.8951, -87.28779 36.89359, -87.30402 36.89149, -87.32012 36.88879, -87.33604 36.88551, -87.35176 36.88164, -87.36724 36.87721, -87.38245 36.87221, -87.39736 36.86665, -87.41193 36.86056, -87.42615 36.85393, -87.43903 36.84731, -87.44737 36.84281, -87.44737 36.84281, -87.45133 36.84068, -87.4515 36.84058, -87.4515 36.84058, -87.45307 36.83974, -87.45397 36.83925, -87.46737 36.83161, -87.48032 36.82349, -87.49279 36.8149, -87.50476 36.80586, -87.51621 36.7964, -87.52711 36.78652, -87.53743 36.77625, -87.54716 36.76562, -87.55627 36.75463, -87.56475 36.74333, -87.57258 36.73173, -87.57975 36.71985, -87.58623 36.70772, -87.59202 36.69536, -87.5971 36.68281, -87.60146 36.67008, -87.6051 36.65721, -87.60801 36.64421, -87.61018 36.63112, -87.61161 36.61797, -87.6123 36.60478, -87.61224 36.59157, -87.61143 36.57838, -87.61079 36.57292, -87.61067 36.57108, -87.60912 36.55793, -87.60684 36.54486, -87.60381 36.53188, -87.60006 36.51903, -87.59559 36.50633, -87.59041 36.4938, -87.58453 36.48148, -87.57797 36.46938, -87.57073 36.45754, -87.56283 36.44598, -87.5543 36.43472, -87.54514 36.42378, -87.53538 36.4132, -87.52503 36.40298, -87.51412 36.39315, -87.50267 36.38373, -87.49071 36.37474, -87.47826 36.3662, -87.46534 36.35812, -87.45198 36.35053, -87.43821 36.34344, -87.42406 36.33686, -87.40956 36.3308, -87.39473 36.32528, -87.37961 36.32032, -87.36422 36.31591, -87.34861 36.31207, -87.3328 36.30881, -87.31682 36.30614, -87.30506 36.30455, -87.29799 36.30371, -87.29463 36.30334, -87.29316 36.30317, -87.29043 36.30285, -87.27422 36.30136, -87.25795 36.30046, -87.24164 36.30016, -87.22533 36.30046, -87.20905 36.30136, -87.19284 36.30285, -87.17673 36.30494, -87.16075 36.30762, -87.14494 36.31088, -87.12933 36.31472, -87.11395 36.31912, -87.09883 36.32409, -87.084 36.32961, -87.0695 36.33566, -87.05535 36.34224, -87.04158 36.34934, -87.02822 36.35693, -87.0153 36.36501, -87.00285 36.37355, -86.99089 36.38253, -86.97944 36.39195, -86.96853 36.40178, -86.96675 36.40354, -86.95969 36.4099, -86.94935 36.42012, -86.93958 36.43071, -86.93042 36.44164, -86.92189 36.4529, -86.91399 36.46447, -86.90675 36.47631, -86.90018 36.4884, -86.89431 36.50072, -86.88912 36.51325, -86.88465 36.52595, -86.8809 36.5388, -86.87886 36.5472, -86.87781 36.55194, -86.87666 36.55762, -86.87607 36.5608, -86.87433 36.57161, -86.87417 36.57274, -86.87417 36.57279, -86.87293 36.58376, -86.87212 36.59695, -86.87206 36.61016, -86.87274 36.62335, -86.87417 36.6365, -86.87634 36.64959, -86.87925 36.66259, -86.88289 36.67546, -86.88726 36.68819, -86.89234 36.70074, -86.89813 36.7131, -86.90461 36.72523, -86.91178 36.73711, -86.91961 36.74871, -86.92809 36.76002, -86.9372 36.771, -86.94693 36.78163, -86.95725 36.7919, -86.96815 36.80178, -86.9796 36.81124, -86.99157 36.82028, -87.00405 36.82887, -87.017 36.83699, -87.0304 36.84463, -87.04422 36.85177, -87.04424 36.85178, -87.04668 36.85304, -87.0609 36.85966, -87.07548 36.86576, -87.09039 36.87131, -87.1056 36.87631, -87.12108 36.88075, -87.13679 36.88461, -87.15272 36.8879, -87.15326 36.888, -87.15713 36.88879, -87.17323 36.89149, -87.18945 36.89359, -87.20579 36.8951, -87.22219 36.896, -87.23862 36.8963))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE)
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND occurrence.occurrencestatus = 'PRESENT'
 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 5773 records were derived from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0007117-260108223611665/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.