Occurrence Download

A dataset containing 0 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.datasetkey = '0cdbc263-7514-477e-ae3d-c586aed1601c'
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.occurrencestatus = 'PRESENT'
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 0 records were derived from 0 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0032527-250426092105405/datasets/export for details.

本数据集包含0条匹配下述查询的全球生物多样性信息设施（GBIF，Global Biodiversity Information Facility）记录：
SELECT
kingdom AS 界（kingdom）,
kingdomkey AS 界主键（kingdomkey）,
phylum AS 门（phylum）,
phylumkey AS 门主键（phylumkey）,
class AS 纲（class）,
classkey AS 纲主键（classkey）,
"order" AS 目（order）,
orderkey AS 目主键（orderkey）,
family AS 科（family）,
familykey AS 科主键（familykey）,
genus AS 属（genus）,
genuskey AS 属主键（genuskey）,
species AS 种（species）,
specieskey AS 种主键（specieskey）,
"year" AS 年份（year）,
IF(ISNULL(kingdomkey), NULL, SUM(COUNT(*)) OVER (PARTITION BY kingdomkey, "year")) AS kingdomcount,
IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER (PARTITION BY phylumkey, "year")) AS phylumcount,
IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER (PARTITION BY classkey, "year")) AS classcount,
IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER (PARTITION BY orderkey, "year")) AS ordercount,
IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER (PARTITION BY familykey, "year")) AS familycount,
IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER (PARTITION BY genuskey, "year")) AS genuscount,
COUNT(*) AS 出现记录数,
MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) AS 最小时间不确定性,
MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) AS 最小坐标不确定性
FROM occurrence
WHERE occurrence.datasetkey = '0cdbc263-7514-477e-ae3d-c586aed1601c'
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.occurrencestatus = 'PRESENT'
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"

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