A dataset containing 141869114 records in GBIF matching the query: SELECT catalognumber, scientificname, publishingorgkey, institutioncode, datasetkey, gbifid, decimallatitude, decimallongitude, recordedby, identifiedby, eventdate, kingdomkey, phylumkey, classkey, orderkey, familykey, genuskey, subgenuskey, specieskey FROM occurrence WHERE classkey = 212 AND orderkey IN (1492, 7191407, 7190953, 7192755, 7192754, 7191588, 7192775) AND taxonomicstatus = 'ACCEPTED' //newly added 12Feb2025 AND hascoordinate = 1 AND hasgeospatialissues = 0 AND specieskey IS NOT NULL AND occurrencestatus = 'PRESENT' -- AND ( -- basisofrecord = 'HUMAN_OBSERVATION' -- OR basisofrecord = 'MACHINE_OBSERVATION' -- OR basisofrecord = 'OCCURRENCE' -- OR basisofrecord = 'LIVING_SPECIMEN' -- OR basisofrecord = 'MATERIAL_SAMPLE' -- ) AND NOT ARRAY_CONTAINS(issue, 'ZERO_COORDINATE') AND NOT ARRAY_CONTAINS(issue, 'COORDINATE_OUT_OF_RANGE') AND datasetkey NOT IN ('040c5662-da76-4782-a48e-cdea1892d14c') The dataset's 141869114 records were derived from 9930 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0005992-250325103851331/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.