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

description: A dataset containing 78 records in GBIF matching the query:
SELECT
 kingdom,
 kingdomkey,
 phylum,
 phylumkey,
 class,
 classkey,
 "order",
 orderkey,
 family,
 familykey,
 genus,
 genuskey,
 species,
 specieskey,
 "year",
 countrycode countrycode,
 IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY genuskey, countrycode, "year")) genuscount,
 COUNT(*) occurrences,
 MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty,
 MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters
FROM
 occurrence
WHERE
 occurrence.decimallatitude &gt;= 56.91065
 AND occurrence.decimallatitude &lt;= 83.27109
 AND (occurrence.decimallongitude &gt;= -140.66144 AND occurrence.decimallongitude &lt;= -59.18683)
 AND GBIF_WITHIN('POLYGON ((-140.66144 69.63744, -138.99152 68.859, -136.88214 68.7637, -135.56378 68.31351, -133.63019 68.24847, -131.16925 68.89067, -127.74152 68.95389, -126.0716 68.63599, -124.84113 68.39456, -123.43488 68.01933, -123.08331 66.83888, -122.02863 66.63058, -121.01789 66.08428, -120.18292 65.08537, -118.513 65.23306, -117.54621 64.71253, -117.53762 63.45964, -115.50756 62.79925, -113.5568 62.13912, -112.64356 62.11857, -112.487 61.7464, -112.43756 61.7464, -112.2508 61.78798, -112.14093 61.78798, -111.95416 61.78798, -111.86078 61.89167, -111.94318 61.7464, -111.56964 61.7464, -107.52667 61.7464, -105.4173 62.36418, -103.5716 62.24163, -101.81378 62.24163, -100.362 61.70207, -98.20709 61.4063, -96.79767 61.27438, -96.17608 60.18913, -95.10869 58.64589, -92.62234 56.91065, -92.33326 58.91589, -93.77075 59.74442, -92.6438 61.26898, -90.98949 62.23565, -89.83317 62.79756, -88.92678 63.34319, -87.28978 63.24111, -86.47672 62.95604, -85.02637 62.37748, -83.53192 61.69029, -81.42194 61.80065, -80.54182 61.18426, -78.95735 60.17772, -79.47982 59.34658, -79.55796 58.36669, -77.69276 57.66292, -77.58538 56.94522, -76.42331 56.98751, -75.46642 57.2514, -74.78313 57.77354, -73.24075 57.59132, -71.73803 57.41395, -69.61149 57.90701, -68.17091 58.59949, -65.85142 59.05329, -64.69168 59.05272, -63.58446 58.09009, -62.50351 57.64586, -61.69936 58.40208, -62.79143 60.02676, -63.60113 60.89601, -65.99287 61.65887, -64.4493 61.98669, -63.38226 62.91545, -63.72146 63.62109, -63.96042 64.418, -62.5734 64.44454, -62.59263 65.2182, -60.83208 66.19259, -60.65356 67.16495, -62.40589 67.8342, -64.68008 68.35223, -66.04247 68.51999, -65.77896 68.85179, -65.7793 69.3153, -66.65887 69.73175, -67.9779 70.55398, -67.53912 70.77356, -69.21039 70.97773, -70.70587 71.40533, -71.59014 71.85849, -73.1829 72.04163, -74.43482 72.82277, -75.70821 72.76818, -76.49716 73.7502, -78.38475 73.91662, -80.27234 73.83854, -78.59418 74.9083, -77.34723 76.10438, -75.38068 77.67379, -73.0296 78.9142, -72.37042 79.36539, -67.36066 80.59486, -59.18683 82.36582, -62.263 82.73606, -68.23956 83.27109, -80.80792 83.09373, -92.67316 81.98907, -100.23175 80.55168, -101.46222 80.07863, -106.80158 79.51838, -109.85578 79.02769, -114.55792 78.47928, -118.33722 77.90384, -121.67706 77.30011, -123.7394 76.30251, -124.04393 75.5825, -124.12564 74.78553, -125.34375 74.62469, -126.19794 74.15467, -126.50006 73.01893, -127.45587 71.59045, -130.2464 70.65218, -135.30011 70.00128, -140.66144 69.63744))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND occurrence.occurrencestatus = 'PRESENT'
 AND (occurrence.taxonkey = 1035920 OR occurrence.acceptedtaxonkey = 1035920 OR occurrence.kingdomkey = 1035920 OR occurrence.phylumkey = 1035920 OR occurrence.classkey = 1035920 OR occurrence.orderkey = 1035920 OR occurrence.familykey = 1035920 OR occurrence.genuskey = 1035920 OR occurrence.specieskey = 1035920)
 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.specieskey IS NOT NULL AND occurrence."year" IS NOT NULL AND occurrence.hascoordinate = TRUE)
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",
 occurrence.countrycode

 The dataset's 78 records were derived from 8 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0000208-250515123054153/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.