DOI: 10.15468/dl.ypkbua
title: Occurrence Download

description: A dataset containing 266 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;= 11.30088
 AND occurrence.decimallatitude &lt;= 11.99785
 AND (occurrence.decimallongitude &gt;= 125.04026 AND occurrence.decimallongitude &lt;= 125.42134)
 AND GBIF_WITHIN('MULTIPOLYGON (((125.25619 11.90621, 125.20641 11.99504, 125.18485 11.99785, 125.15412 11.99565, 125.13519 11.99126, 125.12586 11.99483, 125.12586 11.99483, 125.09267 11.99456, 125.06798 11.98529, 125.09809 11.96396, 125.11367 11.96857, 125.11045 11.94638, 125.13503 11.96453, 125.12767 11.9457, 125.13714 11.94952, 125.14094 11.93784, 125.13196 11.9254, 125.12308 11.92602, 125.11404 11.94136, 125.10438 11.94948, 125.09299 11.94901, 125.09599 11.94177, 125.10404 11.94227, 125.11583 11.92108, 125.0993 11.90148, 125.09863 11.88538, 125.08931 11.901, 125.07956 11.8969, 125.0864 11.88352, 125.08908 11.87129, 125.09439 11.87514, 125.13239 11.83375, 125.15599 11.83331, 125.16569 11.8089, 125.15897 11.78525, 125.1095 11.74145, 125.1138 11.72225, 125.13809 11.70126, 125.13182 11.67881, 125.12911 11.64884, 125.05059 11.65828, 125.04026 11.65224, 125.0416 11.64474, 125.05901 11.63239, 125.07482 11.63006, 125.08729 11.62581, 125.09647 11.62908, 125.11004 11.62315, 125.12761 11.63359, 125.16645 11.62943, 125.17244 11.61272, 125.14603 11.56792, 125.16084 11.54227, 125.15458 11.52093, 125.15453 11.47484, 125.16054 11.4226, 125.17844 11.40275, 125.18827 11.37825, 125.16884 11.37949, 125.16498 11.34732, 125.16935 11.33368, 125.19222 11.3488, 125.19425 11.36128, 125.2059 11.35925, 125.19764 11.32932, 125.20948 11.31508, 125.20135 11.3043, 125.21327 11.30088, 125.23365 11.31741, 125.2472 11.31065, 125.2595 11.32307, 125.25186 11.34061, 125.26464 11.34247, 125.36203 11.42542, 125.36326 11.44318, 125.35092 11.46547, 125.33133 11.44284, 125.31523 11.48043, 125.30906 11.47242, 125.3132 11.46934, 125.3126 11.46157, 125.28474 11.48869, 125.28895 11.49588, 125.29139 11.48781, 125.29784 11.49074, 125.31554 11.4809, 125.33535 11.49493, 125.32599 11.5061, 125.31615 11.52644, 125.32129 11.54861, 125.32901 11.53995, 125.32366 11.52944, 125.33632 11.51519, 125.35471 11.52395, 125.35469 11.52168, 125.354 11.5015, 125.40305 11.48839, 125.40586 11.49198, 125.39763 11.50592, 125.39906 11.51257, 125.41049 11.51971, 125.42134 11.5227, 125.42062 11.53881, 125.40757 11.53862, 125.40724 11.52974, 125.37723 11.52745, 125.36984 11.54221, 125.35775 11.56007, 125.34198 11.56796, 125.34221 11.59461, 125.34821 11.61789, 125.37495 11.62992, 125.36206 11.65139, 125.37802 11.67155, 125.37957 11.69319, 125.4084 11.68799, 125.40828 11.70826, 125.38894 11.72144, 125.37155 11.73462, 125.39246 11.78528, 125.36639 11.7888, 125.36823 11.81433, 125.39094 11.8461, 125.36527 11.866, 125.34635 11.82087, 125.32339 11.84713, 125.31738 11.88217, 125.34423 11.90919, 125.28938 11.88931, 125.26717 11.89002, 125.25619 11.90621)))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND occurrence.occurrencestatus = 'PRESENT'
 AND (CAST(occurrence.taxonkey AS INTEGER) = 7707728 OR CAST(occurrence.acceptedtaxonkey AS INTEGER) = 7707728 OR CAST(occurrence.kingdomkey AS INTEGER) = 7707728 OR CAST(occurrence.phylumkey AS INTEGER) = 7707728 OR CAST(occurrence.classkey AS INTEGER) = 7707728 OR CAST(occurrence.orderkey AS INTEGER) = 7707728 OR CAST(occurrence.familykey AS INTEGER) = 7707728 OR CAST(occurrence.genuskey AS INTEGER) = 7707728 OR CAST(occurrence.specieskey AS INTEGER) = 7707728)
 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 266 records were derived from 14 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0066277-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.