Occurrence Download

A dataset containing 464 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.datasetkey = '2dda31ff-f776-452f-9a4b-d5229f6e3494'
AND (occurrence.decimallatitude >= 44.45 AND occurrence.decimallatitude <= 53.84 AND (occurrence.decimallongitude >= 79.55 AND occurrence.decimallongitude <= 99.11) AND GBIF_WITHIN('POLYGON ((91.07 53.27, 90.71 53.32, 90.89 53.5, 90.76 53.6, 90.53 53.62, 90.2 53.84, 89.17 53.44, 88.91 53.62, 87.52 53.72, 87.3 53.61, 87.19 53.35, 86.54 53.22, 86.39 53.07, 86.48 52.91, 86.67 52.78, 86.25 52.6, 85.91 52.64, 85.7 52.39, 85.46 52.19, 84.52 52.04, 83.54 51.95, 82.53 51.88, 81.49 51.42, 80.9 50.74, 80.99 50.35, 80.88 49.87, 81.18 49.59, 82.03 49.28, 80.95 48.92, 80.41 48.33, 80.46 47.98, 79.58 47.7, 79.55 47.43, 80.28 47.25, 80.53 47.09, 81.44 46.78, 82.1 46.66, 82.37 46.3, 82.74 46.67, 83.82 46.41, 83.89 46.21, 84.33 46.24, 85.17 46.38, 85.88 46.53, 86.33 46.45, 86.93 46.49, 87.37 46.93, 86.87 47.28, 87.49 47.4, 87.31 47.53, 87.52 47.73, 88.41 47.37, 88.53 47.21, 89.55 46.33, 90.22 45.68, 90.17 45.39, 90.57 45.09, 91.25 44.83, 91.66 44.76, 91.96 44.88, 93.06 44.87, 93.77 44.79, 94.43 44.83, 95.03 44.53, 95.37 44.45, 95.86 44.53, 95.96 44.79, 96.11 44.77, 96.17 44.88, 96.25 45.17, 96.95 45.06, 97.97 44.69, 98.68 44.56, 99.1 44.6, 99.08 45, 99.11 45.2, 98.9 45.48, 98.65 45.63, 97.98 45.64, 97.94 45.9, 97.22 46.3, 96.28 46.87, 95.79 47.34, 95.45 47.41, 94.81 47.33, 94.85 46.69, 92 48.25, 92.42 48.42, 92.44 48.63, 92.03 49.77, 91.64 50.36, 92.07 50.7, 91.37 51.45, 92.25 51.75, 92.01 51.95, 92.33 52.11, 92.52 52.36, 92.34 52.6, 91.87 52.87, 91.07 53.27))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE)
AND occurrence.hascoordinate = TRUE
AND occurrence.hasgeospatialissues = FALSE
AND (occurrence.taxonkey = '9624496' OR occurrence.acceptedtaxonkey = '9624496' OR occurrence.kingdomkey = '9624496' OR occurrence.phylumkey = '9624496' OR occurrence.classkey = '9624496' OR occurrence.orderkey = '9624496' OR occurrence.familykey = '9624496' OR occurrence.genuskey = '9624496' OR occurrence.specieskey = '9624496')
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.occurrencestatus = 'PRESENT'
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 464 records were derived from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0019561-260507073636908/datasets/export for details.

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

本数据集包含符合下述查询条件的464条GBIF（Global Biodiversity Information Facility，全球生物多样性信息设施）记录：
查询语句如下：
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")) AS 界年度累计出现次数（kingdomcount）、
IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER (PARTITION BY phylumkey, "year")) AS 门年度累计出现次数（phylumcount）、
IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER (PARTITION BY classkey, "year")) AS 纲年度累计出现次数（classcount）、
IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER (PARTITION BY orderkey, "year")) AS 目年度累计出现次数（ordercount）、
IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER (PARTITION BY familykey, "year")) AS 科年度累计出现次数（familycount）、
IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER (PARTITION BY genuskey, "year")) AS 属年度累计出现次数（genuscount）、
COUNT(*) AS 总出现次数（occurrences）、
MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) AS 最小时间不确定性（mintemporaluncertainty）、
MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) AS 最小坐标不确定性（米，mincoordinateuncertaintyinmeters）
FROM 生物出现记录（occurrence）
WHERE
生物出现记录的数据集键（datasetkey） = '2dda31ff-f776-452f-9a4b-d5229f6e3494'
AND （生物出现记录的十进制纬度（decimallatitude） ≥ 44.45 且 ≤ 53.84，且十进制经度（decimallongitude） ≥ 79.55 且 ≤ 99.11，且通过GBIF_WITHIN空间函数验证位于多边形`POLYGON ((91.07 53.27, 90.71 53.32, 90.89 53.5, 90.76 53.6, 90.53 53.62, 90.2 53.84, 89.17 53.44, 88.91 53.62, 87.52 53.72, 87.3 53.61, 87.19 53.35, 86.54 53.22, 86.39 53.07, 86.48 52.91, 86.67 52.78, 86.25 52.6, 85.91 52.64, 85.7 52.39, 85.46 52.19, 84.52 52.04, 83.54 51.95, 82.53 51.88, 81.49 51.42, 80.9 50.74, 80.99 50.35, 80.88 49.87, 81.18 49.59, 82.03 49.28, 80.95 48.92, 80.41 48.33, 80.46 47.98, 79.58 47.7, 79.55 47.43, 80.28 47.25, 80.53 47.09, 81.44 46.78, 82.1 46.66, 82.37 46.3, 82.74 46.67, 83.82 46.41, 83.89 46.21, 84.33 46.24, 85.17 46.38, 85.88 46.53, 86.33 46.45, 86.93 46.49, 87.37 46.93, 86.87 47.28, 87.49 47.4, 87.31 47.53, 87.52 47.73, 88.41 47.37, 88.53 47.21, 89.55 46.33, 90.22 45.68, 90.17 45.39, 90.57 45.09, 91.25 44.83, 91.66 44.76, 91.96 44.88, 93.06 44.87, 93.77 44.79, 94.43 44.83, 95.03 44.53, 95.37 44.45, 95.86 44.53, 95.96 44.79, 96.11 44.77, 96.17 44.88, 96.25 45.17, 96.95 45.06, 97.97 44.69, 98.68 44.56, 99.1 44.6, 99.08 45, 99.11 45.2, 98.9 45.48, 98.65 45.63, 97.98 45.64, 97.94 45.9, 97.22 46.3, 96.28 46.87, 95.79 47.34, 95.45 47.41, 94.81 47.33, 94.85 46.69, 92 48.25, 92.42 48.42, 92.44 48.63, 92.03 49.77, 91.64 50.36, 92.07 50.7, 91.37 51.45, 92.25 51.75, 92.01 51.95, 92.33 52.11, 92.52 52.36, 92.34 52.6, 91.87 52.87, 91.07 53.27))`内）为真）
AND 生物出现记录具备有效空间坐标（hascoordinate = TRUE）
AND 无空间数据质量问题（hasgeospatialissues = FALSE）
AND （生物出现记录的分类单元键（taxonkey）为'9624496'，或接受分类单元键（acceptedtaxonkey）为'9624496'，或界键、门键、纲键、目键、科键、属键、种键任一为'9624496'）
AND 不包含经GBIF_STRINGARRAYCONTAINS函数标记为'TAXON_MATCH_FUZZY'的记录
AND （生物出现记录距质心的距离（distancefromcentroidinmeters）≥2000.0 或该字段为空值）
AND 不属于'FOSSIL_SPECIMEN'（化石标本）、'LIVING_SPECIMEN'（活体标本）类别
AND 出现状态（occurrencestatus）为'PRESENT'（存在）
AND （分类详情classificationdetails中'd7dddbf4-2cf0-4f39-9b2a-bb099caae36c'对应的种键非空，且年份字段非空）
GROUP BY
界、界键、门、门键、纲、纲键、目、目键、科、科键、属、属键、种、种键、年份

本数据集的464条记录源自1个组成数据集；详细信息请访问https://api.gbif.org/v1/occurrence/download/0019561-260507073636908/datasets/export查看。
本下载包中包含的部分独立数据集可能采用限制更为宽松的许可协议。