Occurrence Download

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

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

本数据集包含1695条符合以下查询规则的全球生物多样性信息设施（GBIF，Global Biodiversity Information Facility）记录：
从occurrence发生记录表中选取以下字段：界（kingdom）、界键（kingdomkey）、门（phylum）、门键（phylumkey）、纲（class）、纲键（classkey）、目（`order`）、目键（orderkey）、科（family）、科键（familykey）、属（genus）、属键（genuskey）、种（species）、种键（specieskey）、年份（`year`），以及：
1. 若界键为空则返回NULL，否则返回按界键与年份分区的累计计数（字段名为kingdomcount）；
2. 若门键为空则返回NULL，否则返回按门键与年份分区的累计计数（字段名为phylumcount）；
3. 若纲键为空则返回NULL，否则返回按纲键与年份分区的累计计数（字段名为classcount）；
4. 若目键为空则返回NULL，否则返回按目键与年份分区的累计计数（字段名为ordercount）；
5. 若科键为空则返回NULL，否则返回按科键与年份分区的累计计数（字段名为familycount）；
6. 若属键为空则返回NULL，否则返回按属键与年份分区的累计计数（字段名为genuscount）；
7. 发生记录总数（occurrences）；
8. 时间不确定性最小值（通过GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)函数计算，字段名为mintemporaluncertainty）；
9. 坐标不确定性最小值（通过COALESCE函数将空坐标不确定性替换为1000后计算，字段名为mincoordinateuncertaintyinmeters）。

筛选条件如下：
- 发生记录的国家代码为'KP'（朝鲜民主主义人民共和国）；
- 发生状态为'PRESENT'（存在）；
- 记录年份介于2000至2024年之间；
- 无空间数据异常（hasgeospatialissues = FALSE）；
- 不包含GBIF_STRINGARRAYCONTAINS函数检测到的'TAXON_MATCH_FUZZY'（分类单元模糊匹配）类问题；
- 距质心距离不小于2000.0米，或该距离值为空；
- 排除'FOSSIL_SPECIMEN'（化石标本）与'LIVING_SPECIMEN'（活标本）两类记录；
- 物种键与年份字段均非空。

结果将按界、界键、门、门键、纲、纲键、目、目键、科、科键、属、属键、种、种键以及年份进行分组。

本数据集的1695条记录源自41个组成数据集；详细信息请参阅：https://api.gbif.org/v1/occurrence/download/0021358-250402121839773/datasets/export。

此外，本次下载所包含的部分独立数据集的授权条款可能较为宽松。