Occurrence Download

A dataset containing 141400 records in GBIF matching the query:

SELECT
gbifid,
institutionid,
basisofrecord,
catalognumber,
recordnumber,
recordnumber RLIKE '[0-9]' AS recordnumber_contains_numerals,
(POSITION ("year" IN recordnumber) > 0) AS recordnumber_contains_year,
recordedby,
CASE
WHEN recordedby IS NULL OR SIZE(recordedby) = 0 THEN FALSE
WHEN ARRAY_CONTAINS(ARRAY('s.coll.', 'Unknown', '[data not captured]', 'Anonymous', 'Collector unknown', 'Anon.', 'Collector(s): unknown', 'not recorded', '[no data available]', 'unknown', 'no consta', 'Collector unspecified', 's.col.', 'provisional entry', 's.n.', 'provisional entry s.n. [s.d.]', 'Anonymous collector s.n. [s.d.]', '?', 'sin. coll.', 's.c.', 'NO DISPONIBLE', '(n/a)', 'REFLORA provisional entry', 'unclear', 'leg. ign.', '', 'et al.', 'Mike Hopkins'), recordedby[0]) THEN FALSE
ELSE TRUE
END AS recordedby_has_personal_name,
recordedbyid,
georeferenceverificationstatus,
othercatalognumbers,
fieldnumber,
fieldnumber RLIKE '[0-9]' AS fieldnumber_contains_numerals,
eventdate,
CASE WHEN eventdate LIKE '____-__-__%' THEN DATEDIFF(SUBSTR(eventdate, 1, 10), '1970-01-01') ELSE NULL END AS eventdate_day_offset,
"year",
"month",
"day",
verbatimeventdate,
habitat,
fieldnotes,
eventremarks,
countrycode,
locality,
verbatimlocality,
decimallatitude,
decimallongitude,
scientificname,
datasetkey,
elevation,
elevationaccuracy,
nontaxonomicissue,
mediatype,
v_associatedmedia,
hascoordinate,
hasgeospatialissues,
issequenced,
institutionkey,
collectionkey,
isincluster
FROM
occurrence
WHERE

occurrence.countrycode IN ('NG')

AND CAST(occurrence.phylumkey AS INTEGER) = 7707728

AND occurrence.basisofrecord IN ('PRESERVED_SPECIMEN', 'MATERIAL_CITATION')

The dataset's 141400 records were derived from 175 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0023673-260507073636908/datasets/export for details.

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

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

SELECT
gbifid,
institutionid,
basisofrecord,
catalognumber,
recordnumber,
recordnumber RLIKE '[0-9]' AS 记录号包含数字,
(POSITION ("year" IN recordnumber) > 0) AS 记录号包含年份,
recordedby,
CASE
WHEN recordedby IS NULL OR SIZE(recordedby) = 0 THEN FALSE
WHEN ARRAY_CONTAINS(ARRAY('s.coll.', 'Unknown', '[data not captured]', 'Anonymous', 'Collector unknown', 'Anon.', 'Collector(s): unknown', 'not recorded', '[no data available]', 'unknown', 'no consta', 'Collector unspecified', 's.col.', 'provisional entry', 's.n.', 'provisional entry s.n. [s.d.]', 'Anonymous collector s.n. [s.d.]', '?', 'sin. coll.', 's.c.', 'NO DISPONIBLE', '(n/a)', 'REFLORA provisional entry', 'unclear', 'leg. ign.', '', 'et al.', 'Mike Hopkins'), recordedby[0]) THEN FALSE
ELSE TRUE
END AS 采集者字段含个人姓名,
recordedbyid,
georeferenceverificationstatus,
othercatalognumbers,
fieldnumber,
fieldnumber RLIKE '[0-9]' AS 野外编号包含数字,
eventdate,
CASE WHEN eventdate LIKE '____-__-__%' THEN DATEDIFF(SUBSTR(eventdate, 1, 10), '1970-01-01') ELSE NULL END AS 事件日期日偏移量,
"year",
"month",
"day",
verbatimeventdate,
habitat,
fieldnotes,
eventremarks,
countrycode,
locality,
verbatimlocality,
decimallatitude,
decimallongitude,
scientificname,
datasetkey,
elevation,
elevationaccuracy,
nontaxonomicissue,
mediatype,
v_associatedmedia,
hascoordinate,
hasgeospatialissues,
issequenced,
institutionkey,
collectionkey,
isincluster
FROM occurrence
WHERE
occurrence.countrycode IN ('NG')
AND CAST(occurrence.phylumkey AS INTEGER) = 7707728
AND occurrence.basisofrecord IN ('PRESERVED_SPECIMEN', 'MATERIAL_CITATION')

本数据集的141400条记录源自175个组成数据集；详细信息请参阅：https://api.gbif.org/v1/occurrence/download/0023673-260507073636908/datasets/export。此外，本下载包中部分单个数据集的授权条款可能更为宽松。