DOI: 10.15468/dl.mcuxv4
title: Occurrence Download

description: A dataset containing 1324 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.82825 AND occurrence.decimallatitude &lt;= 20.99628 AND (occurrence.decimallongitude &gt;= -100.68586 AND occurrence.decimallongitude &lt;= -100.50557) AND GBIF_WITHIN('POLYGON ((-100.59576 20.99246, -100.60005 20.99628, -100.60405 20.99346, -100.6054 20.98885, -100.61106 20.98728, -100.62063 20.99225, -100.62394 20.98901, -100.62147 20.98458, -100.63155 20.97912, -100.65043 20.97271, -100.66187 20.96514, -100.67167 20.97045, -100.68155 20.97306, -100.68179 20.9708, -100.67841 20.96703, -100.67949 20.96281, -100.67664 20.96196, -100.67478 20.95829, -100.67606 20.95405, -100.68031 20.95003, -100.67906 20.93156, -100.68362 20.92003, -100.68184 20.91741, -100.68427 20.90696, -100.68402 20.89884, -100.68586 20.8968, -100.68314 20.89416, -100.68495 20.88872, -100.68341 20.88809, -100.67733 20.89155, -100.66985 20.88914, -100.66926 20.88585, -100.67147 20.88423, -100.67424 20.87729, -100.6722 20.86143, -100.66355 20.86317, -100.65717 20.86096, -100.65757 20.85614, -100.65424 20.85617, -100.65186 20.84859, -100.6502 20.84741, -100.64259 20.86334, -100.63795 20.86212, -100.63191 20.85666, -100.62823 20.85637, -100.63039 20.84914, -100.63014 20.84053, -100.62465 20.83944, -100.62361 20.83282, -100.62159 20.83035, -100.61911 20.8307, -100.61902 20.8337, -100.61499 20.83682, -100.61183 20.83691, -100.60537 20.83273, -100.59651 20.83091, -100.59188 20.83872, -100.58768 20.83624, -100.58002 20.83525, -100.57642 20.83566, -100.57486 20.83857, -100.57111 20.83587, -100.57058 20.8296, -100.56735 20.82825, -100.55876 20.83104, -100.5586 20.83433, -100.55454 20.83768, -100.55142 20.83609, -100.54751 20.83742, -100.54155 20.84371, -100.53713 20.84079, -100.52889 20.84453, -100.52787 20.84814, -100.52257 20.84998, -100.52459 20.85446, -100.52069 20.86027, -100.52035 20.86983, -100.51859 20.87545, -100.51274 20.87601, -100.51536 20.88557, -100.5111 20.89154, -100.51185 20.89557, -100.50688 20.90006, -100.50557 20.90879, -100.50997 20.9134, -100.50935 20.91875, -100.51355 20.91857, -100.51349 20.92256, -100.51629 20.92164, -100.51773 20.92293, -100.51483 20.92315, -100.51498 20.92553, -100.51326 20.92578, -100.51577 20.92872, -100.51807 20.93825, -100.52161 20.94029, -100.52175 20.94338, -100.52789 20.9431, -100.53012 20.94471, -100.52787 20.95068, -100.53021 20.95546, -100.52919 20.96118, -100.53214 20.96353, -100.533 20.9684, -100.53993 20.97093, -100.54042 20.97298, -100.54369 20.97421, -100.54541 20.97243, -100.54937 20.97474, -100.55132 20.9704, -100.55658 20.97186, -100.55918 20.97421, -100.55895 20.97741, -100.557 20.98064, -100.55534 20.97969, -100.55188 20.98354, -100.55714 20.98274, -100.56609 20.98648, -100.56777 20.98855, -100.57166 20.985, -100.57162 20.98796, -100.58757 20.9886, -100.58966 20.99108, -100.59197 20.99068, -100.59379 20.99356, -100.59576 20.99246))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE OR GBIF_WITHIN('POLYGON((-100.70127 20.82069,-100.48861 20.82069,-100.48861 21.01289,-100.70127 21.01289,-100.70127 20.82069))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE)
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND occurrence.hasgeospatialissues = FALSE
 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 1324 records were derived from 62 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0006494-250920141307145/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.