DOI: 10.15468/dl.67jx5p
title: Occurrence Download

description: A dataset containing 2 records in GBIF matching the query:
SELECT
 kingdom,
 kingdomkey,
 COUNT(*) occurrences,
 MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty,
 MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters
FROM
 occurrence
WHERE
 occurrence.decimallatitude &gt;= -10.67974
 AND occurrence.decimallatitude &lt;= -10.5849
 AND (occurrence.decimallongitude &gt;= -37.29809 AND occurrence.decimallongitude &lt;= -37.17743)
 AND GBIF_WITHIN('POLYGON ((-37.29406 -10.61258, -37.29224 -10.61291, -37.29034 -10.61554, -37.28745 -10.61637, -37.28611 -10.61807, -37.28286 -10.61883, -37.28225 -10.62381, -37.28061 -10.62672, -37.28191 -10.62891, -37.28187 -10.63051, -37.28023 -10.63383, -37.2751 -10.63621, -37.27046 -10.63528, -37.26642 -10.63934, -37.26612 -10.64313, -37.26493 -10.6443, -37.26285 -10.64449, -37.26202 -10.64774, -37.26047 -10.65014, -37.25886 -10.65106, -37.25271 -10.65142, -37.25072 -10.65042, -37.24819 -10.65044, -37.2466 -10.65149, -37.24576 -10.6532, -37.24757 -10.65662, -37.24834 -10.65908, -37.24786 -10.66204, -37.24506 -10.66263, -37.24214 -10.66384, -37.24072 -10.66559, -37.23916 -10.66577, -37.23764 -10.66762, -37.23718 -10.66976, -37.235 -10.67291, -37.23122 -10.67582, -37.22917 -10.67634, -37.19917 -10.67892, -37.19768 -10.67829, -37.19555 -10.67934, -37.19255 -10.67974, -37.19056 -10.67698, -37.19071 -10.67563, -37.18876 -10.67246, -37.1885 -10.66956, -37.18987 -10.66632, -37.18849 -10.66448, -37.18567 -10.66224, -37.18509 -10.66098, -37.18601 -10.65876, -37.18102 -10.65682, -37.18013 -10.65538, -37.17743 -10.65307, -37.17769 -10.65146, -37.1813 -10.64766, -37.17941 -10.64636, -37.17865 -10.64482, -37.17846 -10.64066, -37.18018 -10.63886, -37.18367 -10.63834, -37.18532 -10.63365, -37.19161 -10.62567, -37.193 -10.62445, -37.19557 -10.62375, -37.19831 -10.62514, -37.20251 -10.62586, -37.20243 -10.62413, -37.20382 -10.62235, -37.20578 -10.62221, -37.20725 -10.61832, -37.2113 -10.61511, -37.21287 -10.61509, -37.21512 -10.61357, -37.21541 -10.61144, -37.21662 -10.60985, -37.21968 -10.60876, -37.22313 -10.60679, -37.2272 -10.60626, -37.22799 -10.60374, -37.22984 -10.6021, -37.23462 -10.60206, -37.23536 -10.60102, -37.23526 -10.59838, -37.23647 -10.59749, -37.23821 -10.59786, -37.24017 -10.59668, -37.24333 -10.59628, -37.24332 -10.59328, -37.24587 -10.59173, -37.25065 -10.59372, -37.25291 -10.59378, -37.25401 -10.59143, -37.25779 -10.58827, -37.25993 -10.5886, -37.26109 -10.58691, -37.26419 -10.58511, -37.2669 -10.58511, -37.27035 -10.58599, -37.27865 -10.5849, -37.28207 -10.58575, -37.28502 -10.58802, -37.28713 -10.59178, -37.28867 -10.59254, -37.29335 -10.59284, -37.29477 -10.59379, -37.29793 -10.60028, -37.29809 -10.60119, -37.29715 -10.61102, -37.29673 -10.61199, -37.29406 -10.61258))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND occurrence.occurrencestatus = 'PRESENT'
 AND NOT GBIF_STRINGARRAYCONTAINS(occurrence.issue, 'TAXON_MATCH_FUZZY', TRUE)
 AND (occurrence.distancefromcentroidinmeters &gt;= 2000.0 OR occurrence.distancefromcentroidinmeters IS NULL)
 AND occurrence.classificationdetails['d7dddbf4-2cf0-4f39-9b2a-bb099caae36c']['kingdomkey'] &lt;&gt; ''
GROUP BY
 occurrence.kingdom,
 occurrence.kingdomkey

 The dataset's 2 records were derived from 17 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0003831-260126135527185/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.