Occurrence Download

A dataset containing 6613 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.decimallatitude >= 4.64763
AND occurrence.decimallatitude <= 4.87313
AND (occurrence.decimallongitude >= -74.42102 AND occurrence.decimallongitude <= -74.11996)
AND GBIF_WITHIN('POLYGON ((-74.36236 4.8415, -74.42102 4.81603, -74.21999 4.64763, -74.11996 4.727, -74.31225 4.87313, -74.36236 4.8415))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
AND occurrence.hasgeospatialissues = FALSE
AND occurrence.occurrencestatus = 'PRESENT'
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 6613 records were derived from 104 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0002400-250515123054153/datasets/export for details.

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

一个来自全球生物多样性信息网络（GBIF）的数据集，包含6613条记录，匹配以下查询：
SELECT
界（kingdom）,
界键（kingdomkey）,
门（phylum）,
门键（phylumkey）,
纲（class）,
纲键（classkey）,
"目"（"order"）,
目键（orderkey）,
科（family）,
科键（familykey）,
属（genus）,
属键（genuskey）,
种（species）,
种键（specieskey）,
年份（"year"）,
若界键为空则为NULL，否则返回按界键与年份分区的计数总和（界计数）,
若门键为空则为NULL，否则返回按门键与年份分区的计数总和（门计数）,
若纲键为空则为NULL，否则返回按纲键与年份分区的计数总和（纲计数）,
若目键为空则为NULL，否则返回按目键与年份分区的计数总和（目计数）,
若科键为空则为NULL，否则返回按科键与年份分区的计数总和（科计数）,
若属键为空则为NULL，否则返回按属键与年份分区的计数总和（属计数）,
记录数（occurrences）,
事件日期与时间的最小时间不确定性（mintemporaluncertainty）,
最小坐标不确定性（单位：米，若coordinateuncertaintyinmeters为空则取1000）（mincoordinateuncertaintyinmeters）
FROM
occurrence表
WHERE
occurrence.decimallatitude >=4.64763
AND occurrence.decimallatitude <=4.87313
AND (occurrence.decimallongitude >=-74.42102 AND occurrence.decimallongitude <=-74.11996)
AND GBIF_WITHIN('POLYGON ((-74.36236 4.8415, -74.42102 4.81603, -74.21999 4.64763, -74.11996 4.727, -74.31225 4.87313, -74.36236 4.8415))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
AND occurrence.hasgeospatialissues = FALSE
AND occurrence.occurrencestatus = 'PRESENT'
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"

该数据集的6613条记录源自104个组成数据集；详情请见https://api.gbif.org/v1/occurrence/download/0002400-250515123054153/datasets/export。

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