Occurrence Download

A dataset containing 5149680 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 (7924597, 3188736, 5204862, 9751099, 7807208, 2346633, 5229156, 2495093, 5229203, 2426805, 5371685, 5217160, 5298231, 2480824, 2498080, 2402120, 2493367, 4352332, 2480766)
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 5149680 records were derived from 8132 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0019654-260507073636908/datasets/export for details.

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

本数据集包含5149680条符合以下查询条件的GBIF（全球生物多样性信息设施，Global Biodiversity Information Facility）记录：

查询语句如下：
SELECT
species,
specieskey,
kingdom,
class,
phylum,
countrycode,
decimallatitude,
decimallongitude,
GBIF_MGRSCODE(1000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)) AS mgrscellcode,
COUNT(*) AS occurrences,
MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) AS 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 (7924597, 3188736, 5204862, 9751099, 7807208, 2346633, 5229156, 2495093, 5229203, 2426805, 5371685, 5217160, 5298231, 2480824, 2498080, 2402120, 2493367, 4352332, 2480766)
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))

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

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