Occurrence Download

A dataset containing 3470 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 >= 43.26814 AND occurrence.decimallatitude <= 43.48768 AND (occurrence.decimallongitude >= -89.28379 AND occurrence.decimallongitude <= -88.98516) AND GBIF_WITHIN('POLYGON ((-88.98602 43.44823, -88.9863 43.47035, -88.98779 43.47521, -88.99038 43.47848, -88.99338 43.48076, -88.99796 43.48286, -89.00233 43.48542, -89.00787 43.4872, -89.01215 43.48768, -89.02318 43.4875, -89.02722 43.4869, -89.03119 43.48563, -89.03591 43.48287, -89.03952 43.47878, -89.04256 43.47751, -89.04582 43.47543, -89.04944 43.47133, -89.05247 43.47006, -89.05572 43.46798, -89.05908 43.46432, -89.06064 43.46071, -89.06075 43.44584, -89.06445 43.44806, -89.06834 43.44946, -89.07254 43.4502, -89.07733 43.4503, -89.08018 43.45176, -89.08332 43.45283, -89.08946 43.45369, -89.09096 43.45523, -89.09136 43.46262, -89.09305 43.46683, -89.09666 43.47069, -89.09814 43.474, -89.10039 43.47669, -89.10338 43.47897, -89.10776 43.481, -89.11186 43.48202, -89.11617 43.48236, -89.16221 43.48197, -89.16876 43.48089, -89.17255 43.47937, -89.17581 43.47729, -89.17917 43.47363, -89.18082 43.46958, -89.18623 43.46593, -89.18921 43.46242, -89.19305 43.46074, -89.19672 43.45807, -89.19963 43.4542, -89.20075 43.45051, -89.20048 43.43306, -89.19965 43.43006, -89.19791 43.42717, -89.19412 43.42374, -89.18987 43.42157, -89.18677 43.42063, -89.176 43.41842, -89.18128 43.41807, -89.1867 43.41656, -89.19107 43.41594, -89.19503 43.41467, -89.19821 43.413, -89.20262 43.41288, -89.206 43.41233, -89.20996 43.41106, -89.21317 43.40938, -89.22076 43.40937, -89.2242 43.40904, -89.22829 43.40802, -89.23199 43.40639, -89.23641 43.40566, -89.26667 43.40524, -89.2716 43.40427, -89.27609 43.40238, -89.27865 43.40067, -89.2812 43.39813, -89.28294 43.39524, -89.28379 43.39215, -89.28325 43.36836, -89.28269 43.36553, -89.28294 43.36248, -89.28145 43.35757, -89.27774 43.35333, -89.27227 43.35026, -89.24003 43.34283, -89.22797 43.33938, -89.2151 43.33516, -89.20396 43.33103, -89.19139 43.32578, -89.16997 43.31527, -89.15943 43.30927, -89.14868 43.30247, -89.13349 43.29149, -89.13355 43.28199, -89.13265 43.27827, -89.13091 43.27538, -89.12892 43.27331, -89.12365 43.27008, -89.11887 43.26863, -89.11374 43.26814, -89.08149 43.26839, -89.07502 43.26947, -89.06986 43.27176, -89.05989 43.27875, -89.05716 43.28124, -89.05525 43.28407, -89.05413 43.28772, -89.05408 43.29525, -89.05067 43.29924, -89.04924 43.30352, -89.04963 43.30808, -89.05215 43.31258, -89.04477 43.31297, -89.04148 43.31373, -89.03841 43.31489, -89.03333 43.31829, -89.03109 43.32099, -89.0299 43.32336, -89.02923 43.32702, -89.02907 43.34169, -89.02969 43.34525, -89.02901 43.34899, -89.02902 43.35329, -89.02966 43.35636, -89.02906 43.35933, -89.02925 43.36553, -89.03093 43.36973, -89.03452 43.37357, -89.03601 43.37693, -89.03885 43.38017, -89.03631 43.38338, -89.03507 43.38659, -89.03315 43.38839, -89.02602 43.39317, -89.00388 43.3935, -88.99989 43.39397, -88.99663 43.39483, -88.99363 43.39609, -88.99038 43.39817, -88.98782 43.40071, -88.98636 43.403, -88.98516 43.40796, -88.98602 43.44823))', 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 >= 2000.0 OR occurrence.distancefromcentroidinmeters IS NULL)
AND NOT occurrence.basisofrecord IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN')
AND occurrence.occurrencestatus = 'PRESENT'
AND (occurrence.classificationdetails['d7dddbf4-2cf0-4f39-9b2a-bb099caae36c']['specieskey'] <> '' 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 3470 records were derived from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0017466-260423192947929/datasets/export for details.

Data from some individual datasets included in this download may be licensed under less restrictive terms.