Occurrence Download

A dataset containing 1428438 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 (2498155, 2498264)
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 1428438 records were derived from 314 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0017838-260507073636908/datasets/export for details.

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

本数据集囊括1428438条符合下述结构化查询语言（Structured Query Language, SQL）查询的全球生物多样性信息设施（Global Biodiversity Information Facility, GBIF）记录：

其中，COALESCE为取首个非空值的SQL函数，GBIF_MGRSCODE为GBIF提供的军事格网参考系（Military Grid Reference System, MGRS）编码函数，GBIF_WITHIN为空间范围判断函数，GBIF_STRINGARRAYCONTAINS为字符串数组包含判断函数。

SELECT
species AS 物种,
specieskey AS 物种键,
kingdom AS 界,
class AS 纲,
phylum AS 门,
countrycode AS 国家代码,
decimallatitude AS 十进制纬度,
decimallongitude AS 十进制经度,
GBIF_MGRSCODE(1000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)) AS mgrscellcode,
COUNT(*) AS 出现记录数,
MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) AS 最小坐标不确定性
FROM
occurrence AS 生物出现记录表
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 (2498155, 2498264)
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))

本数据集的1428438条记录源自314个组成数据集，详细信息请参见：https://api.gbif.org/v1/occurrence/download/0017838-260507073636908/datasets/export。

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