Occurrence Download
收藏DataCite Commons2025-05-15 更新2025-05-17 收录
下载链接：
https://www.gbif.org/occurrence/download/0000199-250515123054153
下载链接
链接失效反馈官方服务：
资源简介：
A dataset containing 120 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.continent = 'EUROPE'
AND occurrence.occurrencestatus = 'PRESENT'
AND (occurrence.taxonkey = 4410657 OR occurrence.acceptedtaxonkey = 4410657 OR occurrence.kingdomkey = 4410657 OR occurrence.phylumkey = 4410657 OR occurrence.classkey = 4410657 OR occurrence.orderkey = 4410657 OR occurrence.familykey = 4410657 OR occurrence.genuskey = 4410657 OR occurrence.specieskey = 4410657)
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)
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 120 records were derived from 293 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0000199-250515123054153/datasets/export for details.
Data from some individual datasets included in this download may be licensed under less restrictive terms.
提供机构：
The Global Biodiversity Information Facility
创建时间：
2025-05-15
