DOI: 10.15468/dl.7e2pga
title: Occurrence Download

description: A dataset containing 16 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;= 42.00014 AND occurrence.decimallatitude &lt;= 46.29989 AND (occurrence.decimallongitude &gt;= -124.70399 AND occurrence.decimallongitude &lt;= -116.45469) AND GBIF_WITHIN('POLYGON ((-124.3165 42.0022, -117.02506 42.00014, -117.02685 43.83346, -117.01697 43.85338, -117.01731 43.86025, -117.01094 43.86393, -116.99454 43.86427, -116.98248 43.86761, -116.98467 43.87831, -116.97613 43.89521, -116.9768 43.90275, -116.96927 43.90727, -116.96743 43.91748, -116.96308 43.92183, -116.96241 43.92853, -116.9686 43.93724, -116.96341 43.94544, -116.97652 43.96749, -116.963 43.9729, -116.94273 43.98506, -116.93664 43.99452, -116.93394 44.01412, -116.93597 44.02629, -116.96097 44.04521, -116.97449 44.05197, -116.9772 44.0905, -116.93462 44.09523, -116.92313 44.12024, -116.90826 44.14051, -116.89339 44.16214, -116.90758 44.18107, -116.9265 44.19391, -116.95016 44.19256, -116.97111 44.20067, -116.97449 44.225, -116.97314 44.24662, -116.99747 44.2473, -117.10913 44.28299, -117.14495 44.25933, -117.18347 44.26271, -117.20983 44.28569, -117.21727 44.30394, -117.19158 44.32827, -117.18956 44.3472, -117.21929 44.36409, -117.2612 44.35463, -117.29499 44.37423, -117.22538 44.4844, -117.18077 44.52157, -117.12467 44.58443, -117.0283 44.76558, -116.92735 44.77476, -116.83557 44.88031, -116.85393 45.03633, -116.71626 45.12811, -116.67955 45.31625, -116.54647 45.46769, -116.45469 45.61453, -116.54647 45.68337, -116.54647 45.77974, -116.67955 45.81186, -116.7805 45.83021, -116.88773 45.96015, -116.8931 45.97436, -116.91774 45.99701, -118.05104 46.00085, -118.42974 46.00107, -118.56672 46.00131, -118.98772 45.9995, -119.13921 45.92199, -119.60105 45.93011, -119.66538 45.83207, -120.0792 45.78771, -120.16939 45.76194, -120.20688 45.72445, -120.36267 45.7022, -120.48768 45.69434, -120.56179 45.73851, -120.6352 45.74832, -120.69181 45.71391, -120.85158 45.66274, -120.85158 45.66274, -120.90617 45.64012, -120.94525 45.65501, -121.01137 45.64679, -121.06707 45.65032, -121.14204 45.60815, -121.19103 45.60419, -121.21966 45.6721, -121.32386 45.70713, -121.41352 45.69717, -121.52551 45.72684, -121.7059 45.69404, -121.812 45.70049, -121.86721 45.69299, -121.93348 45.64537, -122.02133 45.61492, -122.18297 45.57626, -122.27434 45.54229, -122.38425 45.57668, -122.43962 45.55438, -122.49669 45.58371, -122.65951 45.61065, -122.76505 45.66396, -122.77547 45.68796, -122.75907 45.75941, -122.79493 45.80675, -122.8049 45.90969, -122.86467 46.00599, -122.89123 46.08569, -123.16021 46.18863, -123.42587 46.17203, -123.42998 46.23473, -123.47566 46.26987, -123.5008 46.27109, -123.53071 46.26167, -123.58567 46.25604, -123.63848 46.25933, -123.68967 46.25641, -123.74133 46.26833, -123.7799 46.25343, -123.81613 46.25042, -123.86998 46.23592, -123.93058 46.23891, -123.96211 46.26366, -124.00558 46.27805, -124.0143 46.29338, -124.0256 46.29989, -124.03571 46.29708, -124.03941 46.28519, -124.03491 46.26404, -124.15055 46.26136, -124.15394 46.24559, -124.14522 46.2258, -124.12476 46.20266, -124.06608 46.18355, -124.00495 46.01825, -124.09542 45.94501, -124.04157 45.8847, -124.06957 45.75762, -124.00926 45.70377, -124.06668 45.45737, -124.04005 45.41742, -124.08 45.33307, -124.05937 45.21033, -124.09932 45.0261, -124.14593 44.81302, -124.1782 44.32202, -124.27834 43.67441, -124.47589 43.32371, -124.50494 43.07008, -124.70399 42.76762, -124.47315 42.61669, -124.56638 42.47019, -124.49757 42.39472, -124.48647 42.23047, -124.4332 42.16388, -124.411 42.05956, -124.3165 42.0022))', 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;= 1990 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 16 records were derived from 2 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0048375-251009101135966/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.