Occurrence Download

A dataset containing 4845 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.countrycode = 'BN'
AND occurrence.occurrencestatus = 'PRESENT'
AND (occurrence."year" >= 2000 AND occurrence."year" <= 2024)
AND occurrence.hasgeospatialissues = FALSE
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.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 4845 records were derived from 94 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0020447-250402121839773/datasets/export for details.

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

GBIF中包含4845条记录的数据集，匹配以下查询：
SELECT
界,
界键,
门,
门键,
纲,
纲键,
目,
目键,
科,
科键,
属,
属键,
种,
种键,
年份,
若界键为空则返回空值，否则按界键与年份分组的记录数累计和 AS 界级年度计数,
若门键为空则返回空值，否则按门键与年份分组的记录数累计和 AS 门级年度计数,
若纲键为空则返回空值，否则按纲键与年份分组的记录数累计和 AS 纲级年度计数,
若目键为空则返回空值，否则按目键与年份分组的记录数累计和 AS 目级年度计数,
若科键为空则返回空值，否则按科键与年份分组的记录数累计和 AS 科级年度计数,
若属键为空则返回空值，否则按属键与年份分组的记录数累计和 AS 属级年度计数,
记录数,
事件日期与时间的最小时间不确定性,
最小坐标不确定性（米）
FROM
occurrence表
WHERE
国家代码 = 'BN'
且记录状态 = '存在'
且年份介于2000年至2024年之间
且无地理空间问题
且问题列表中不包含'TAXON_MATCH_FUZZY'（精确匹配）
且距质心距离（米）≥2000.0或为空
且记录基础不在['化石标本','活体标本']中
且种键与年份均非空
GROUP BY
界,界键,门,门键,纲,纲键,目,目键,科,科键,属,属键,种,种键,年份

该数据集的4845条记录来源于94个子数据集；详情参见：https://api.gbif.org/v1/occurrence/download/0020447-250402121839773/datasets/export。

本下载中包含的部分独立数据集的数据可能采用限制更少的许可条款。