DOI: 10.15468/dl.hrraqm
title: Occurrence Download

description: A dataset containing 529 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;= 20.42257
 AND occurrence.decimallatitude &lt;= 20.51542
 AND (occurrence.decimallongitude &gt;= -103.48566 AND occurrence.decimallongitude &lt;= -103.38982)
 AND GBIF_WITHIN('MULTIPOLYGON (((-103.44912 20.42763, -103.44944 20.42679, -103.4489 20.42661, -103.44842 20.42679, -103.44537 20.42312, -103.44533 20.42311, -103.43891 20.42257, -103.43887 20.42257, -103.42463 20.42617, -103.42438 20.4251, -103.42355 20.42527, -103.42381 20.42638, -103.42132 20.42701, -103.42088 20.42583, -103.41996 20.42613, -103.41992 20.42623, -103.41893 20.42656, -103.41928 20.42753, -103.41294 20.42913, -103.41287 20.42917, -103.41144 20.43007, -103.41143 20.43005, -103.41085 20.43041, -103.41083 20.43045, -103.40944 20.43133, -103.40911 20.43156, -103.41002 20.43274, -103.40662 20.44236, -103.38985 20.4486, -103.38982 20.44866, -103.39623 20.4717, -103.39188 20.48399, -103.39189 20.48403, -103.39512 20.48847, -103.39418 20.49084, -103.39422 20.49091, -103.39615 20.48989, -103.40448 20.50135, -103.40598 20.50673, -103.40659 20.50711, -103.40882 20.50843, -103.41009 20.50913, -103.41268 20.51027, -103.41264 20.51034, -103.41314 20.51059, -103.41634 20.51187, -103.41854 20.51283, -103.41866 20.51288, -103.41898 20.51293, -103.41993 20.51331, -103.42 20.51333, -103.42169 20.51383, -103.42176 20.51386, -103.42651 20.5142, -103.4338 20.51542, -103.43399 20.51542, -103.434 20.51473, -103.44193 20.5153, -103.44203 20.51528, -103.44994 20.51361, -103.45039 20.51347, -103.45063 20.5134, -103.45241 20.51286, -103.48547 20.47375, -103.48555 20.47285, -103.48566 20.47164, -103.44912 20.42763)))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND occurrence.occurrencestatus = 'PRESENT'
 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)
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 529 records were derived from 47 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0014662-260108223611665/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.