DOI: 10.15468/dl.83t8pn
title: Occurrence Download

description: A dataset containing 2 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.24843 AND occurrence.decimallatitude &lt;= 11.43459 AND (occurrence.decimallongitude &gt;= 125.26464 AND occurrence.decimallongitude &lt;= 125.47599) AND GBIF_WITHIN('MULTIPOLYGON (((125.26464 11.34247, 125.43694 11.31022, 125.43481 11.28248, 125.45263 11.29013, 125.46527 11.27228, 125.44906 11.25628, 125.45984 11.24843, 125.47599 11.25499, 125.47524 11.27391, 125.45834 11.30428, 125.44365 11.3066, 125.45507 11.31179, 125.44827 11.33238, 125.45428 11.35872, 125.431 11.36443, 125.43021 11.37055, 125.43603 11.36884, 125.44028 11.38158, 125.4202 11.36811, 125.43204 11.39524, 125.39504 11.3841, 125.39036 11.38913, 125.40185 11.40404, 125.41353 11.40674, 125.41089 11.42564, 125.40124 11.43459, 125.39482 11.43019, 125.39082 11.41356, 125.38749 11.41386, 125.3895 11.42329, 125.38088 11.42223, 125.37692 11.41143, 125.36203 11.42542, 125.26464 11.34247)))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE OR occurrence.decimallatitude &gt;= 11.13735 AND occurrence.decimallatitude &lt;= 11.34247 AND (occurrence.decimallongitude &gt;= 125.23549 AND occurrence.decimallongitude &lt;= 125.47182) AND GBIF_WITHIN('MULTIPOLYGON (((125.43694 11.31022, 125.26464 11.34247, 125.27813 11.32627, 125.26989 11.29801, 125.25511 11.28811, 125.27104 11.26274, 125.25382 11.26313, 125.24899 11.24595, 125.23549 11.2191, 125.24888 11.18874, 125.27972 11.19075, 125.28869 11.20347, 125.30574 11.20839, 125.30873 11.20031, 125.32515 11.20632, 125.31159 11.21196, 125.3175 11.22358, 125.33251 11.22681, 125.35549 11.21666, 125.39245 11.18171, 125.40964 11.17715, 125.4205 11.13735, 125.43808 11.15559, 125.43404 11.17338, 125.4388 11.17918, 125.44855 11.18439, 125.47138 11.19424, 125.47182 11.21875, 125.45936 11.2232, 125.4426 11.20776, 125.44412 11.22773, 125.40145 11.19886, 125.39801 11.22331, 125.38068 11.2051, 125.37387 11.22375, 125.38512 11.2445, 125.39837 11.2333, 125.41727 11.23623, 125.40925 11.24045, 125.42211 11.29283, 125.43694 11.31022)))', 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 2 records were derived from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0071297-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.