DOI: 10.15468/dl.wvku3q
title: Occurrence Download

description: A dataset containing 8316 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.basisofrecord = 'HUMAN_OBSERVATION'
 AND occurrence.datasetkey = '50c9509d-22c7-4a22-a47d-8c48425ef4a7'
 AND (occurrence.decimallatitude &gt;= 30.07776 AND occurrence.decimallatitude &lt;= 30.48304 AND (occurrence.decimallongitude &gt;= -81.76226 AND occurrence.decimallongitude &lt;= -81.46111) AND (occurrence.decimallatitude &gt;= 30.07776 AND occurrence.decimallatitude &lt;= 30.48304 AND (occurrence.decimallongitude &gt;= -81.76226 AND occurrence.decimallongitude &lt;= -81.46111) OR occurrence.decimallatitude &gt;= 30.32164 AND occurrence.decimallatitude &lt;= 30.33878 AND (occurrence.decimallongitude &gt;= -81.5196 AND occurrence.decimallongitude &lt;= -81.49021) OR occurrence.decimallatitude &gt;= 30.34569 AND occurrence.decimallatitude &lt;= 30.36034 AND (occurrence.decimallongitude &gt;= -81.52659 AND occurrence.decimallongitude &lt;= -81.51195) OR occurrence.decimallatitude &gt;= 30.37163 AND occurrence.decimallatitude &lt;= 30.39274 AND (occurrence.decimallongitude &gt;= -81.5597 AND occurrence.decimallongitude &lt;= -81.53594) OR occurrence.decimallatitude &gt;= 30.41355 AND occurrence.decimallatitude &lt;= 30.43962 AND (occurrence.decimallongitude &gt;= -81.60559 AND occurrence.decimallongitude &lt;= -81.58561) OR occurrence.decimallatitude &gt;= 30.46409 AND occurrence.decimallatitude &lt;= 30.47955 AND (occurrence.decimallongitude &gt;= -81.63993 AND occurrence.decimallongitude &lt;= -81.62859)) AND GBIF_WITHIN('MULTIPOLYGON (((-81.74789 30.22882, -81.7411 30.22552, -81.76226 30.14679, -81.73187 30.1526, -81.72381 30.14411, -81.71879 30.14818, -81.72286 30.15432, -81.71587 30.15566, -81.71807 30.13088, -81.71075 30.13421, -81.6925 30.12569, -81.69585 30.14057, -81.68922 30.15999, -81.6963 30.15906, -81.69536 30.18077, -81.68836 30.18701, -81.65283 30.18466, -81.68079 30.14525, -81.67239 30.14234, -81.66764 30.13169, -81.64266 30.12833, -81.64108 30.12196, -81.6505 30.11124, -81.61763 30.10727, -81.62231 30.1035, -81.60817 30.09639, -81.59892 30.0994, -81.60378 30.10623, -81.57108 30.10376, -81.59525 30.09788, -81.5837 30.0884, -81.53983 30.07776, -81.52529 30.11046, -81.52008 30.10765, -81.51783 30.13928, -81.49702 30.15634, -81.49781 30.16854, -81.51549 30.16875, -81.5114 30.22994, -81.50319 30.22883, -81.50821 30.22641, -81.50182 30.21553, -81.50873 30.20029, -81.50221 30.19493, -81.50792 30.19061, -81.50456 30.18407, -81.49876 30.1861, -81.50675 30.17948, -81.50332 30.17296, -81.48944 30.18171, -81.49487 30.20515, -81.49153 30.20983, -81.48302 30.20683, -81.47695 30.21488, -81.48082 30.22055, -81.47899 30.23255, -81.47211 30.235, -81.47419 30.25605, -81.46111 30.26198, -81.47029 30.27975, -81.47526 30.27696, -81.54975 30.35568, -81.54309 30.35823, -81.54976 30.36996, -81.55698 30.36656, -81.55389 30.36005, -81.67069 30.48304, -81.68056 30.47865, -81.67952 30.46659, -81.67554 30.46842, -81.68689 30.45439, -81.68115 30.44769, -81.68345 30.43919, -81.69271 30.43777, -81.69319 30.43071, -81.686 30.42976, -81.69434 30.41674, -81.69109 30.41095, -81.73827 30.23604, -81.74798 30.2365, -81.74789 30.22882)), ((-81.5196 30.33119, -81.51201 30.32164, -81.49021 30.32524, -81.49645 30.33641, -81.50402 30.33279, -81.51008 30.33878, -81.5196 30.33119)), ((-81.52659 30.35567, -81.52229 30.34569, -81.51195 30.34933, -81.5183 30.36034, -81.52659 30.35567)), ((-81.54541 30.37549, -81.53594 30.37849, -81.55051 30.39274, -81.55771 30.38929, -81.5597 30.37804, -81.55312 30.37163, -81.54541 30.37549)), ((-81.60529 30.43652, -81.60559 30.41778, -81.59829 30.41355, -81.58561 30.42095, -81.59572 30.43962, -81.60529 30.43652)), ((-81.62859 30.46755, -81.63278 30.47955, -81.63993 30.47593, -81.6366 30.46409, -81.62859 30.46755)))', 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 (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 8316 records were derived from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0006972-251025141854904/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.