DOI: 10.15468/dl.psu2d7
title: Occurrence Download

description: A dataset containing 17 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 IN ('HUMAN_OBSERVATION', 'LIVING_SPECIMEN', 'MACHINE_OBSERVATION', 'OBSERVATION')
 AND occurrence.datasetkey IN ('50c9509d-22c7-4a22-a47d-8c48425ef4a7', 'a96ab213-6a98-46eb-b016-bbff44153785', '56c48715-9f8b-445a-98b7-cada12902027', '8a863029-f435-446a-821e-275f4f641165', '8e4e5830-2f87-47d7-a265-3411f172a640', 'fbd321be-0dd6-466b-8bb3-701ea697dfcf', 'd002c155-3025-4a2e-8843-fcefa96e2802', '2bd4874a-949b-45ca-afcb-87285eb15038', '3fd08e44-6c9a-43e7-98d0-d3fc0e41d478')
 AND (occurrence.decimallatitude &gt;= -0.01235 AND occurrence.decimallatitude &lt;= 22.02147 AND (occurrence.decimallongitude &gt;= -111.48673 AND occurrence.decimallongitude &lt;= -76.94096) AND GBIF_WITHIN('POLYGON ((-111.48673 21.00035, -105.26498 15.95001, -90.22434 8.64736, -83.90307 1.97263, -82.29142 0.07504, -80.17771 -0.01235, -76.94096 4.01516, -77.2275 4.59037, -77.33119 6.5443, -77.78263 6.87851, -78.49985 8.69983, -79.30637 8.92253, -79.80695 8.6276, -81.07391 7.82447, -86.98186 12.96861, -94.35711 16.26777, -105.30103 20.8522, -109.59644 22.02147, -111.48673 21.00035))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE OR occurrence.decimallatitude &gt;= 8.57849 AND occurrence.decimallatitude &lt;= 26.97347 AND (occurrence.decimallongitude &gt;= -97.83982 AND occurrence.decimallongitude &lt;= -63.0958) AND GBIF_WITHIN('POLYGON ((-97.83982 24.00431, -97.80682 21.22204, -96.091 19.05364, -94.44116 18.24077, -91.66132 18.85273, -90.13676 21.26444, -86.68643 21.4886, -88.53195 16.32886, -87.97382 15.52567, -83.90759 15.60589, -83.81624 11.67794, -82.99538 10.16182, -81.90244 9.1468, -77.13784 8.57849, -75.83105 9.40732, -75.13184 11.26559, -73.52129 11.54865, -71.34351 12.64561, -71.4755 10.77171, -69.56169 11.80716, -65.82397 10.39868, -63.29233 10.51228, -63.22633 11.03092, -63.0958 12.9132, -65.40411 15.52567, -68.70378 16.41391, -71.93745 16.28726, -73.05933 16.22391, -81.57247 18.11538, -83.88224 15.97029, -81.50648 18.17809, -83.07562 20.28916, -86.06002 22.26409, -86.84691 21.56324, -83.6373 24.58937, -84.8409 26.97347, -92.46137 26.47077, -94.83712 24.50509, -97.83982 24.00431))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE OR occurrence.decimallatitude &gt;= 46.28111 AND occurrence.decimallatitude &lt;= 51.77651 AND (occurrence.decimallongitude &gt;= -59.57551 AND occurrence.decimallongitude &lt;= -52.34748) AND GBIF_WITHIN('POLYGON ((-55.3752 51.77651, -56.12776 51.68901, -56.7753 51.37398, -57.24784 51.02396, -57.75538 50.48142, -58.17541 49.88637, -58.49043 49.48384, -58.78795 49.08132, -59.27799 48.80129, -59.57551 48.25876, -59.523 47.61121, -58.89296 47.26118, -57.94789 47.08617, -57.10783 47.17368, -56.35527 47.01616, -56.30277 46.57863, -55.62022 46.49113, -54.55264 46.59613, -53.73008 46.29861, -53.08253 46.28111, -52.6275 46.56113, -52.34748 47.08617, -52.41749 48.32876, -52.6625 48.9063, -53.32755 49.71136, -53.76508 50.3064, -54.46514 50.58642, -54.85016 50.90145, -54.92017 51.46149, -55.3752 51.77651))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE OR occurrence.decimallatitude &gt;= 33.86448 AND occurrence.decimallatitude &lt;= 51.19216 AND (occurrence.decimallongitude &gt;= -78.6175 AND occurrence.decimallongitude &lt;= -58.34218) AND GBIF_WITHIN('POLYGON ((-78.6175 33.86448, -65.76487 37.02977, -58.53479 42.91169, -58.34218 45.78059, -60.35105 47.49249, -58.66705 51.19216, -62.93534 50.4803, -67.64903 49.6049, -73.94761 44.99817, -66.36254 48.29846, -65.79427 47.06851, -63.35734 45.32911, -71.24915 43.39367, -70.58179 42.13207, -76.1094 39.52892, -78.6175 33.86448))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE OR occurrence.decimallatitude &gt;= 34.83816 AND occurrence.decimallatitude &lt;= 61.06944 AND (occurrence.decimallongitude &gt;= -165.32569 AND occurrence.decimallongitude &lt;= -119.5838) AND GBIF_WITHIN('POLYGON ((-165.32569 54.67849, -161.42522 52.79117, -148.66004 57.25715, -139.44075 56.08835, -119.5838 34.83816, -122.42051 49.22369, -134.12192 58.01634, -139.44075 60.55065, -150.43298 61.06944, -165.32569 54.67849))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE)
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND GBIF_STRINGARRAYCONTAINS(occurrence.issue, 'COORDINATE_ROUNDED', TRUE)
 AND occurrence.occurrencestatus = 'PRESENT'
 AND (CAST(occurrence.taxonkey AS INTEGER) = 2418059 OR CAST(occurrence.acceptedtaxonkey AS INTEGER) = 2418059 OR CAST(occurrence.kingdomkey AS INTEGER) = 2418059 OR CAST(occurrence.phylumkey AS INTEGER) = 2418059 OR CAST(occurrence.classkey AS INTEGER) = 2418059 OR CAST(occurrence.orderkey AS INTEGER) = 2418059 OR CAST(occurrence.familykey AS INTEGER) = 2418059 OR CAST(occurrence.genuskey AS INTEGER) = 2418059 OR CAST(occurrence.specieskey AS INTEGER) = 2418059)
 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 17 records were derived from 3 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0021299-250914085247600/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.