Occurrence Download

A dataset containing 2209771 records in GBIF matching the query:
SELECT
species,
specieskey,
kingdom,
class,
phylum,
countrycode,
decimallatitude,
decimallongitude,
GBIF_MGRSCODE(1000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)) mgrscellcode,
COUNT(*) occurrences,
MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters
FROM
occurrence
WHERE
occurrence.basisofrecord IN ('OBSERVATION', 'MACHINE_OBSERVATION', 'HUMAN_OBSERVATION', 'MATERIAL_SAMPLE', 'PRESERVED_SPECIMEN', 'LIVING_SPECIMEN', 'OCCURRENCE')
AND GBIF_WITHIN('POLYGON((-180 -90,180 -90,180 90,-180 90,-180 -90))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
AND occurrence.hascoordinate = TRUE
AND occurrence.hasgeospatialissues = FALSE
AND occurrence.occurrencestatus = 'PRESENT'
AND CAST(occurrence.specieskey AS INTEGER) IN (2480907, 2481853, 2498011, 3053168, 6065820, 2703459, 2351027, 2429583, 2410854, 9691034, 2498411, 2498035, 8930531, 2427091, 2427573, 6109637, 2422872, 2498064, 2882398, 2722046, 5166639, 2351174, 5232435, 2498027, 5330661, 2480800, 7569571, 2480350, 2382002, 2352186, 2372285, 2480857, 5233597, 2498090, 7682342, 2481918, 5205740)
AND NOT GBIF_STRINGARRAYCONTAINS(occurrence.issue, 'TAXON_MATCH_FUZZY', TRUE)
AND (occurrence.distancefromcentroidinmeters >= 2000.0 OR occurrence.distancefromcentroidinmeters IS NULL)
AND occurrence.specieskey IS NOT NULL
GROUP BY
occurrence.kingdom,
occurrence.phylum,
occurrence.class,
occurrence.species,
occurrence.specieskey,
occurrence.countrycode,
occurrence.decimallatitude,
occurrence.decimallongitude,
GBIF_MGRSCODE(1000, occurrence.decimallatitude, occurrence.decimallongitude, COALESCE(occurrence.coordinateuncertaintyinmeters, 1000))

The dataset's 2209771 records were derived from 5420 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0019963-260507073636908/datasets/export for details.

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

本数据集包含2209771条符合下述查询条件的全球生物多样性信息机构（GBIF，Global Biodiversity Information Facility）记录：从`occurrence`数据表中选取物种（species）、物种键（specieskey）、界（kingdom）、纲（class）、门（phylum）、国家代码（countrycode）、十进制纬度（decimallatitude）、十进制经度（decimallongitude），通过`GBIF_MGRSCODE`函数（参数为1000、十进制纬度、十进制经度，以及经`COALESCE`函数处理后的坐标不确定性米数，默认值为1000）生成的MGRS（军事网格参考系统，Military Grid Reference System）单元格编码，记录出现次数（occurrences），以及坐标不确定性米数的最小值（mincoordinateuncertaintyinmeters）。筛选条件如下：记录基础类型（basisofrecord）属于{'OBSERVATION', 'MACHINE_OBSERVATION', 'HUMAN_OBSERVATION', 'MATERIAL_SAMPLE', 'PRESERVED_SPECIMEN', 'LIVING_SPECIMEN', 'OCCURRENCE'}集合；经`GBIF_WITHIN`空间函数判定坐标落在全球范围多边形`((-180 -90,180 -90,180 90,-180 90,-180 -90))`内，结果为真；存在有效坐标；无地理空间异常；物种存在状态为“PRESENT”（存在）；转换为整数后的物种键属于指定的物种键集合；不包含`TAXON_MATCH_FUZZY`（分类单元模糊匹配）异常标记；距物种分布质心的距离大于等于2000.0米，或该距离值为空；物种键非空。最终按界、门、纲、物种、物种键、国家代码、十进制纬度、十进制经度以及上述MGRS单元格编码进行分组。

本数据集的2209771条记录源自5420个组成数据集；详细信息请参见：https://api.gbif.org/v1/occurrence/download/0019963-260507073636908/datasets/export。
本下载包中包含的部分独立数据集可能采用了更为宽松的授权条款。