DOI: 10.15468/dl.w9rq7m
title: Occurrence Download

description: A dataset containing 756 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;= 51.75961
 AND occurrence.decimallatitude &lt;= 51.8315
 AND (occurrence.decimallongitude &gt;= 10.59061 AND occurrence.decimallongitude &lt;= 10.70687)
 AND GBIF_WITHIN('POLYGON ((10.64874 51.8315, 10.64304 51.83133, 10.63739 51.83081, 10.63185 51.82995, 10.62648 51.82877, 10.62132 51.82726, 10.61643 51.82544, 10.61184 51.82334, 10.60762 51.82097, 10.60379 51.81835, 10.60039 51.81552, 10.59746 51.81249, 10.59502 51.8093, 10.5931 51.80598, 10.59172 51.80255, 10.59089 51.79906, 10.59061 51.79554, 10.5909 51.79202, 10.59174 51.78853, 10.59313 51.78511, 10.59506 51.78179, 10.5975 51.7786, 10.60043 51.77557, 10.60383 51.77274, 10.60766 51.77013, 10.61189 51.76776, 10.61647 51.76566, 10.62136 51.76385, 10.62651 51.76234, 10.63188 51.76115, 10.63741 51.7603, 10.64305 51.75978, 10.64874 51.75961, 10.65443 51.75978, 10.66007 51.7603, 10.6656 51.76115, 10.67097 51.76234, 10.67612 51.76385, 10.68101 51.76566, 10.68559 51.76776, 10.68982 51.77013, 10.69365 51.77274, 10.69705 51.77557, 10.69998 51.7786, 10.70242 51.78179, 10.70435 51.78511, 10.70574 51.78853, 10.70658 51.79202, 10.70687 51.79554, 10.70659 51.79906, 10.70576 51.80255, 10.70438 51.80598, 10.70246 51.8093, 10.70002 51.81249, 10.69709 51.81552, 10.69369 51.81835, 10.68986 51.82097, 10.68564 51.82334, 10.68105 51.82544, 10.67616 51.82726, 10.671 51.82877, 10.66563 51.82995, 10.66009 51.83081, 10.65444 51.83133, 10.64874 51.8315))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND occurrence.occurrencestatus = 'PRESENT'
 AND (CAST(occurrence.taxonkey AS INTEGER) = 797 OR CAST(occurrence.acceptedtaxonkey AS INTEGER) = 797 OR CAST(occurrence.kingdomkey AS INTEGER) = 797 OR CAST(occurrence.phylumkey AS INTEGER) = 797 OR CAST(occurrence.classkey AS INTEGER) = 797 OR CAST(occurrence.orderkey AS INTEGER) = 797 OR CAST(occurrence.familykey AS INTEGER) = 797 OR CAST(occurrence.genuskey AS INTEGER) = 797 OR CAST(occurrence.specieskey AS INTEGER) = 797)
 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 756 records were derived from 7 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0000078-250811113504898/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.