DOI: 10.15468/dl.5g8gx9
title: Occurrence Download

description: A dataset containing 5365 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.decimallatitude &gt;= 46.93682
 AND occurrence.decimallatitude &lt;= 47.03831
 AND (occurrence.decimallongitude &gt;= -1.87928 AND occurrence.decimallongitude &lt;= -1.73172)
 AND GBIF_WITHIN('POLYGON ((-1.86747 47.01399, -1.8687 47.01283, -1.86925 47.0122, -1.87402 47.00563, -1.87441 47.00495, -1.87756 46.99794, -1.87779 46.99723, -1.87922 46.98996, -1.87928 46.98923, -1.87897 46.9819, -1.87886 46.98117, -1.87681 46.97397, -1.87652 46.97326, -1.8728 46.96639, -1.87235 46.96572, -1.86705 46.95935, -1.86645 46.95874, -1.85971 46.95304, -1.85897 46.95251, -1.8552 46.95022, -1.85527 46.95017, -1.85473 46.94983, -1.85311 46.94895, -1.85096 46.94764, -1.85011 46.9472, -1.84838 46.94638, -1.84657 46.94539, -1.8457 46.945, -1.83662 46.9415, -1.83567 46.9412, -1.8259 46.93874, -1.82489 46.93854, -1.81467 46.93716, -1.81364 46.93708, -1.80323 46.93682, -1.80219 46.93686, -1.79185 46.93773, -1.79083 46.93787, -1.78082 46.93985, -1.77985 46.9401, -1.77042 46.94313, -1.76952 46.94349, -1.76509 46.94538, -1.76475 46.94554, -1.76048 46.94771, -1.75965 46.94816, -1.75195 46.95317, -1.75125 46.95371, -1.74584 46.95857, -1.7458 46.95855, -1.7452 46.95913, -1.74516 46.95918, -1.74494 46.95938, -1.74402 46.96035, -1.7441 46.96039, -1.73983 46.96525, -1.73936 46.96589, -1.73661 46.97023, -1.73625 46.9709, -1.73482 46.97382, -1.73451 46.97453, -1.73228 46.98186, -1.73215 46.9826, -1.73172 46.99008, -1.73177 46.99082, -1.73316 46.99825, -1.73339 46.99898, -1.73656 47.00614, -1.73696 47.00683, -1.74182 47.01354, -1.74239 47.01418, -1.74541 47.0173, -1.74552 47.0174, -1.74852 47.02002, -1.74915 47.02053, -1.75596 47.02529, -1.75669 47.02573, -1.75849 47.02668, -1.75844 47.02672, -1.75926 47.02718, -1.76091 47.02797, -1.76299 47.02908, -1.7633 47.02922, -1.76337 47.02915, -1.76791 47.03133, -1.76882 47.0317, -1.77834 47.03486, -1.77932 47.03512, -1.78946 47.03719, -1.79049 47.03734, -1.80098 47.03828, -1.80203 47.03831, -1.81261 47.03809, -1.81366 47.03801, -1.82404 47.03663, -1.82506 47.03643, -1.83498 47.03393, -1.83594 47.03363, -1.84515 47.03007, -1.84603 47.02967, -1.85428 47.02515, -1.85505 47.02465, -1.86214 47.01929, -1.86278 47.01871, -1.86583 47.01576, -1.8666 47.01494, -1.86747 47.01399))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND occurrence.publishingorgkey = '1928bdf0-f5d2-11dc-8c12-b8a03c50a862'
 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 5365 records were derived from 68 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0018434-250914085247600/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.