Occurrence Download

A dataset containing 2844 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 = 'AF' 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 2844 records were derived from 64 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0022633-250402121839773/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.本数据集包含2844条符合如下查询的GBIF（Global Biodiversity Information Facility，全球生物多样性信息机构）物种发生记录，查询逻辑如下： 从物种发生记录表中筛选满足以下条件的记录： 1. 国家代码为AF（阿富汗）； 2. 记录存在状态为PRESENT（存在）； 3. 记录年份介于2000年至2024年（含两端）； 4. 无空间数据异常； 5. 不包含TAXON_MATCH_FUZZY（分类单元模糊匹配）类问题，该判定通过GBIF_STRINGARRAYCONTAINS函数实现； 6. 距分布质心的距离不小于2000.0米，或该距离值为空； 7. 记录类型不属于FOSSIL_SPECIMEN（化石标本）与LIVING_SPECIMEN（活体标本）； 8. 种主键与年份字段均非空。 随后按界、界主键、门、门主键、纲、纲主键、目、目主键、科、科主键、属、属主键、种、种主键及年份进行分组，并计算如下统计指标： 1. 界年度计数：若界主键为空则返回空值，否则按界主键与年份分区，对分区内的记录计数求和； 2. 门年度计数：若门主键为空则返回空值，否则按门主键与年份分区，对分区内的记录计数求和； 3. 纲年度计数：若纲主键为空则返回空值，否则按纲主键与年份分区，对分区内的记录计数求和； 4. 目年度计数：若目主键为空则返回空值，否则按目主键与年份分区，对分区内的记录计数求和； 5. 科年度计数：若科主键为空则返回空值，否则按科主键与年份分区，对分区内的记录计数求和； 6. 属年度计数：若属主键为空则返回空值，否则按属主键与年份分区，对分区内的记录计数求和； 7. 总发生记录数：分组内的记录总数； 8. 最小时间不确定性：调用GBIF_TEMPORALUNCERTAINTY函数，基于事件日期与事件时间计算得到的最小时间不确定性值； 9. 最小坐标不确定性：取以米为单位的坐标不确定性的最小值，若该值为空则默认替换为1000。 本数据集的2844条记录源自64个组成数据集，详细信息请访问以下链接获取：https://api.gbif.org/v1/occurrence/download/0022633-250402121839773/datasets/export 本下载包所包含的部分独立数据集，其授权条款可能更为宽松。