Occurrence Download

A dataset containing 4154 records in GBIF matching the query:
SELECT
kingdom,
kingdomkey,
phylum,
phylumkey,
class,
classkey,
"order",
orderkey,
family,
familykey,
genus,
genuskey,
species,
specieskey,
"year",
GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)) eeacellcode,
COUNT(*) occurrences,
MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty,
MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters
FROM
occurrence
WHERE
occurrence.continent = 'EUROPE'
AND occurrence.countrycode IN ('ES', 'FR', 'EE', 'CH', 'NO', 'UA', 'GB', 'SE', 'FI')
AND occurrence.occurrencestatus = 'PRESENT'
AND (occurrence.taxonkey = 2433433 OR occurrence.acceptedtaxonkey = 2433433 OR occurrence.kingdomkey = 2433433 OR occurrence.phylumkey = 2433433 OR occurrence.classkey = 2433433 OR occurrence.orderkey = 2433433 OR occurrence.familykey = 2433433 OR occurrence.genuskey = 2433433 OR occurrence.specieskey = 2433433)
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 AND occurrence.hascoordinate = TRUE)
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",
GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000))

The dataset's 4154 records were derived from 89 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0032584-250426092105405/datasets/export for details.

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

GBIF中包含4154条记录的数据集，匹配以下查询：
SELECT
界,
界键,
门,
门键,
纲,
纲键,
"目",
目键,
科,
科键,
属,
属键,
种,
种键,
"年份",
GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)) eeacellcode,
COUNT(*) 出现次数,
MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) 最小时间不确定性,
MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) 最小坐标不确定性（米）
FROM
occurrence
WHERE
occurrence.continent = 'EUROPE'
AND occurrence.countrycode IN ('ES', 'FR', 'EE', 'CH', 'NO', 'UA', 'GB', 'SE', 'FI')
AND occurrence.occurrencestatus = 'PRESENT'
AND (occurrence.taxonkey = 2433433 OR occurrence.acceptedtaxonkey = 2433433 OR occurrence.kingdomkey = 2433433 OR occurrence.phylumkey = 2433433 OR occurrence.classkey = 2433433 OR occurrence.orderkey = 2433433 OR occurrence.familykey = 2433433 OR occurrence.genuskey = 2433433 OR occurrence.specieskey = 2433433)
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."年份" IS NOT NULL AND occurrence.hascoordinate = TRUE)
GROUP BY
occurrence.kingdom,
occurrence.kingdomkey,
occurrence.phylum,
occurrence.phylumkey,
occurrence.class,
occurrence.classkey,
occurrence."目",
occurrence.orderkey,
occurrence.family,
occurrence.familykey,
occurrence.genus,
occurrence.genuskey,
occurrence.species,
occurrence.specieskey,
occurrence."年份",
GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000))

该数据集的4154条记录来源于89个子数据集；详情参见：https://api.gbif.org/v1/occurrence/download/0032584-250426092105405/datasets/export。

本下载中包含的部分独立数据集的数据可能采用限制性较低的许可条款。