DOI: 10.15468/dl.cm8hwd
title: Occurrence Download

description: A dataset containing 207 records in GBIF matching the query:
SELECT
 kingdom,
 kingdomkey,
 phylum,
 phylumkey,
 class,
 classkey,
 "order",
 orderkey,
 family,
 familykey,
 genus,
 genuskey,
 species,
 specieskey,
 "year",
 IF(ISNULL(kingdomkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY kingdomkey, "year")) kingdomcount,
 IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY phylumkey, "year")) phylumcount,
 IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY classkey, "year")) classcount,
 IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY orderkey, "year")) ordercount,
 IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY familykey, "year")) familycount,
 IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY genuskey, "year")) genuscount,
 COUNT(*) occurrences,
 MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters
FROM
 occurrence
WHERE
 occurrence.basisofrecord IN ('HUMAN_OBSERVATION', 'MACHINE_OBSERVATION', 'MATERIAL_SAMPLE')
 AND (occurrence.decimallatitude &gt;= 40.43426 AND occurrence.decimallatitude &lt;= 40.4581 AND (occurrence.decimallongitude &gt;= -3.74345 AND occurrence.decimallongitude &lt;= -3.71411) AND GBIF_WITHIN('POLYGON ((-3.72981 40.45751, -3.7333 40.45671, -3.73858 40.45582, -3.73915 40.45507, -3.73986 40.4548, -3.74345 40.45283, -3.74287 40.45172, -3.74179 40.4502, -3.74117 40.4486, -3.74009 40.44635, -3.73938 40.44365, -3.73909 40.4427, -3.73902 40.44126, -3.73884 40.43998, -3.73789 40.43829, -3.73672 40.43712, -3.73543 40.43541, -3.73488 40.4344, -3.73432 40.43426, -3.73344 40.43426, -3.72997 40.43515, -3.727 40.43585, -3.72342 40.43729, -3.72181 40.43656, -3.72121 40.43613, -3.71983 40.43542, -3.71949 40.43525, -3.71943 40.43551, -3.71928 40.43566, -3.71899 40.43571, -3.71824 40.4356, -3.71775 40.43858, -3.71762 40.43961, -3.71767 40.44002, -3.71886 40.44221, -3.71953 40.44342, -3.71984 40.44375, -3.71996 40.44496, -3.71969 40.44539, -3.71949 40.44559, -3.71927 40.4457, -3.71821 40.44672, -3.71744 40.44743, -3.71653 40.44883, -3.71642 40.44906, -3.71646 40.44925, -3.71637 40.44934, -3.71621 40.44931, -3.71604 40.4495, -3.71571 40.44978, -3.71527 40.44997, -3.71481 40.45015, -3.71411 40.45047, -3.71443 40.45113, -3.71483 40.45191, -3.71467 40.45196, -3.71495 40.45261, -3.71767 40.45337, -3.7178 40.4534, -3.71824 40.45285, -3.71845 40.45288, -3.71887 40.45268, -3.71897 40.45279, -3.71974 40.4532, -3.71979 40.45336, -3.72034 40.45365, -3.71979 40.45451, -3.71971 40.45474, -3.71978 40.455, -3.71998 40.45516, -3.72029 40.45527, -3.72075 40.45524, -3.72102 40.45503, -3.72129 40.45484, -3.72167 40.45478, -3.72203 40.45468, -3.72236 40.45437, -3.72276 40.45427, -3.72314 40.45429, -3.72334 40.45431, -3.72361 40.45421, -3.72384 40.45396, -3.72401 40.45387, -3.72416 40.45387, -3.72435 40.45398, -3.7245 40.45417, -3.72446 40.45441, -3.72434 40.45461, -3.72416 40.45474, -3.72393 40.45492, -3.72354 40.45532, -3.72342 40.45553, -3.72335 40.45579, -3.72343 40.45598, -3.72367 40.45626, -3.7241 40.4565, -3.72424 40.45668, -3.72421 40.45687, -3.72401 40.45707, -3.72366 40.45721, -3.72346 40.45734, -3.72332 40.45744, -3.72442 40.45781, -3.72536 40.45789, -3.72551 40.4581, -3.72584 40.458, -3.72581 40.45779, -3.72729 40.45745, -3.72864 40.45769, -3.72981 40.45751))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE)
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND GBIF_STRINGARRAYCONTAINS(occurrence.issue, 'CONTINENT_DERIVED_FROM_COORDINATES', TRUE)
 AND occurrence.occurrencestatus = 'PRESENT'
 AND GBIF_STRINGARRAYCONTAINS(occurrence.classifications['d7dddbf4-2cf0-4f39-9b2a-bb099caae36c'], '6', TRUE)
 AND (occurrence."year" &gt;= 2024 AND occurrence."year" &lt;= 2024)
 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']['specieskey'] &lt;&gt; '' AND occurrence."year" 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,
 occurrence."year"

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