Occurrence Download

A dataset containing 259767 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 ('CL')

AND CAST(occurrence.phylumkey AS INTEGER) = 7707728

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

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

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