Occurrence Download

A dataset containing 190 records in GBIF matching the query:
SELECT
kingdom,
kingdomkey,
phylum,
phylumkey,
class,
classkey,
"order",
orderkey,
family,
familykey,
genus,
genuskey,
species,
specieskey,
COUNT(*) occurrences
FROM
occurrence
WHERE
occurrence.decimallatitude >= 36.87114
AND occurrence.decimallatitude <= 36.93595
AND (occurrence.decimallongitude >= -4.90909 AND occurrence.decimallongitude <= -4.79128)
AND GBIF_WITHIN('POLYGON ((-4.90909 36.88735, -4.88015 36.87159, -4.83857 36.87114, -4.79128 36.91576, -4.80858 36.93595, -4.83757 36.93595, -4.86375 36.93146, -4.90909 36.88735))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
AND occurrence.hascoordinate = TRUE
AND occurrence.hasgeospatialissues = FALSE
AND occurrence.occurrencestatus = 'PRESENT'
AND (occurrence.taxonkey = 212 OR occurrence.acceptedtaxonkey = 212 OR occurrence.kingdomkey = 212 OR occurrence.phylumkey = 212 OR occurrence.classkey = 212 OR occurrence.orderkey = 212 OR occurrence.familykey = 212 OR occurrence.genuskey = 212 OR occurrence.specieskey = 212)
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
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

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

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

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

SELECT
界（kingdom）,
界键（kingdomkey）,
门（phylum）,
门键（phylumkey）,
纲（class）,
纲键（classkey）,
目（order）,
目键（orderkey）,
科（family）,
科键（familykey）,
属（genus）,
属键（genuskey）,
种（species）,
种键（specieskey）,
COUNT(*) occurrences
FROM
发生记录表（occurrence）
WHERE
occurrence.decimallatitude >= 36.87114
AND occurrence.decimallatitude <= 36.93595
AND (occurrence.decimallongitude >= -4.90909 AND occurrence.decimallongitude <= -4.79128)
AND GBIF空间包含函数（GBIF_WITHIN）('POLYGON ((-4.90909 36.88735, -4.88015 36.87159, -4.83857 36.87114, -4.79128 36.91576, -4.80858 36.93595, -4.83757 36.93595, -4.86375 36.93146, -4.90909 36.88735))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
AND occurrence.hascoordinate = TRUE
AND occurrence.hasgeospatialissues = FALSE
AND occurrence.occurrencestatus = 'PRESENT'
AND (occurrence.taxonkey = 212 OR occurrence.acceptedtaxonkey = 212 OR occurrence.kingdomkey = 212 OR occurrence.phylumkey = 212 OR occurrence.classkey = 212 OR occurrence.orderkey = 212 OR occurrence.familykey = 212 OR occurrence.genuskey = 212 OR occurrence.specieskey = 212)
AND NOT GBIF字符串数组包含函数（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
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

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

本次下载所包含的部分单个数据集，可能采用更为宽松的许可条款。