DOI: 10.15468/dl.953pz7
title: Occurrence Download

description: A dataset containing 23 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.coordinateuncertaintyinmeters &gt;= 0.0
 AND occurrence.coordinateuncertaintyinmeters &lt;= 10000.0
 AND (occurrence.decimallatitude &gt;= 25.85445 AND occurrence.decimallatitude &lt;= 37.00505 AND (occurrence.decimallongitude &gt;= -106.63338 AND occurrence.decimallongitude &lt;= -89.70264) AND GBIF_WITHIN('POLYGON ((-90.18049 29.10291, -90.24697 29.20264, -90.20126 29.26081, -90.35085 29.5766, -90.49212 29.614, -90.62925 29.75943, -90.73728 29.75943, -90.82454 29.82591, -90.94088 29.83838, -91.0323 29.96303, -91.04476 30.07107, -91.01152 30.16664, -91.05307 30.22897, -91.14864 30.19988, -91.11956 30.28298, -91.22344 30.30376, -91.3564 30.76914, -91.57663 30.75252, -91.53923 30.92704, -91.65558 30.93119, -91.61818 31.25945, -91.50599 31.29269, -91.46859 31.39657, -91.51846 31.50876, -91.41042 31.56694, -91.34394 31.85364, -91.24421 31.87442, -91.18189 31.92428, -91.16111 31.98245, -91.07801 32.0157, -90.92011 32.33565, -91.1154 32.51016, -91.1528 33.00048, -91.21928 33.70768, -91.01983 33.92374, -91.11125 33.98192, -90.74144 34.36004, -90.56692 34.43899, -90.55861 34.74647, -90.23866 34.91268, -90.3093 35.04149, -90.18464 35.0498, -90.08907 35.16615, -90.10569 35.39468, -89.70264 36.00965, -90.37162 36.00134, -90.13478 36.25896, -90.0683 36.29636, -90.1514 36.49165, -94.62053 36.50227, -94.62318 37.00505, -103.01643 36.99921, -103.00812 36.49643, -103.05576 32.01012, -106.63338 32.00596, -106.61676 31.85222, -104.90066 30.55165, -104.48515 29.64582, -103.13056 28.97268, -102.97266 29.19705, -102.85631 29.21368, -102.89786 29.27185, -102.66933 29.74554, -102.37431 29.78294, -102.32029 29.89513, -101.57236 29.76632, -101.36045 29.67075, -101.2815 29.57518, -101.22748 29.51285, -101.05712 29.45468, -101.0031 29.37573, -100.82027 29.25938, -100.74963 29.18043, -100.72886 29.11811, -100.63329 28.9145, -100.20115 28.19981, -99.98508 28.02529, -99.85211 27.78845, -99.53632 27.54745, -99.49966 27.27137, -99.12154 26.45695, -98.17415 26.04974, -97.7337 26.03728, -97.64645 26.00403, -97.44284 25.85445, -97.34727 25.8586, -97.33896 25.9334, -97.1312 25.95833, -97.06057 26.0996, -97.34312 27.0553, -97.1312 27.7035, -96.36914 28.37, -95.31787 28.89771, -94.61149 29.34232, -94.62396 29.4088, -93.85109 29.67473, -93.38943 29.70039, -93.2074 29.7111, -92.26514 29.45947, -92.03492 29.52907, -91.84219 29.33633, -91.31216 29.26674, -90.99629 29.07935, -90.91598 28.97228, -90.34848 28.99905, -90.18049 29.10291))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE)
 AND (CAST(occurrence.taxonkey AS INTEGER) = 4264680 OR CAST(occurrence.acceptedtaxonkey AS INTEGER) = 4264680 OR CAST(occurrence.kingdomkey AS INTEGER) = 4264680 OR CAST(occurrence.phylumkey AS INTEGER) = 4264680 OR CAST(occurrence.classkey AS INTEGER) = 4264680 OR CAST(occurrence.orderkey AS INTEGER) = 4264680 OR CAST(occurrence.familykey AS INTEGER) = 4264680 OR CAST(occurrence.genuskey AS INTEGER) = 4264680 OR CAST(occurrence.specieskey AS INTEGER) = 4264680)
 AND (occurrence."year" &gt;= 1995 AND occurrence."year" &lt;= 2024)
 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)
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 23 records were derived from 4 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0039263-251009101135966/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.