Occurrence Download

A dataset containing 20630 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 = 'BT'
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 20630 records were derived from 78 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0021418-250402121839773/datasets/export for details.

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

数据集包含全球生物多样性信息机构（GBIF）中与以下查询匹配的20630条记录：
SELECT
界（kingdom）、
界键（kingdomkey）、
门（phylum）、
门键（phylumkey）、
纲（class）、
纲键（classkey）、
目（order）、
目键（orderkey）、
科（family）、
科键（familykey）、
属（genus）、
属键（genuskey）、
种（species）、
种键（specieskey）、
年份（year）、
若界键（kingdomkey）为空则返回空，否则返回按界键和年份分区的记录数总和 kingdomcount、
若门键（phylumkey）为空则返回空，否则返回按门键和年份分区的记录数总和 phylumcount、
若纲键（classkey）为空则返回空，否则返回按纲键和年份分区的记录数总和 classcount、
若目键（orderkey）为空则返回空，否则返回按目键和年份分区的记录数总和 ordercount、
若科键（familykey）为空则返回空，否则返回按科键和年份分区的记录数总和 familycount、
若属键（genuskey）为空则返回空，否则返回按属键和年份分区的记录数总和 genuscount、
记录数（occurrences）、
发生日期和时间的最小时间不确定性（mintemporaluncertainty）、
最小坐标不确定性（米）（若coordinateuncertaintyinmeters为空则取1000，否则取最小值）（mincoordinateuncertaintyinmeters）
FROM 发生记录（occurrence）
WHERE
发生记录的国家代码为'BT'
AND 发生状态为'存在'
AND 年份在2000到2024之间
AND 无地理空间问题
AND 发生记录的问题列表中不包含'TAXON_MATCH_FUZZY'（模糊分类匹配）
AND 距质心距离（米）大于等于2000.0或为空
AND 记录依据不在'化石标本'或'活体标本'中
AND 种键和年份均不为空
GROUP BY
发生记录的界、界键、门、门键、纲、纲键、目、目键、科、科键、属、属键、种、种键、年份

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

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