Occurrence Download

A dataset containing 2403 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 >= 48.76736
AND occurrence.decimallatitude <= 48.78549
AND (occurrence.decimallongitude >= 2.44248 AND occurrence.decimallongitude <= 2.46482)
AND GBIF_WITHIN('POLYGON ((2.45395 48.76736, 2.45465 48.76793, 2.4562 48.76819, 2.45748 48.76834, 2.45896 48.76837, 2.46034 48.76889, 2.46129 48.7693, 2.46482 48.76844, 2.46274 48.77186, 2.46091 48.77424, 2.4599 48.77562, 2.45932 48.77761, 2.4589 48.78248, 2.45373 48.78238, 2.4524 48.78315, 2.4517 48.78395, 2.45087 48.78483, 2.44913 48.78549, 2.44248 48.77782, 2.44433 48.77497, 2.44587 48.77323, 2.44813 48.77068, 2.45068 48.76888, 2.45395 48.76736))', 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 >= 2000.0 OR occurrence.distancefromcentroidinmeters IS NULL)
AND NOT occurrence.basisofrecord IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN')
AND (occurrence.classificationdetails['d7dddbf4-2cf0-4f39-9b2a-bb099caae36c']['specieskey'] <> '' 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 2403 records were derived from 81 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0005047-260430073515954/datasets/export for details.

Data from some individual datasets included in this download may be licensed under less restrictive terms.