DOI: 10.15468/dl.cn832q
title: Occurrence Download

description: A dataset containing 24 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(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty,
 MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters
FROM
 occurrence
WHERE
 occurrence.basisofrecord = 'HUMAN_OBSERVATION'
 AND (occurrence.decimallatitude &gt;= 3.00994 AND occurrence.decimallatitude &lt;= 3.79574 AND (occurrence.decimallongitude &gt;= -76.69 AND occurrence.decimallongitude &lt;= -76.18271) AND GBIF_WITHIN('POLYGON ((-76.43216 3.7814, -76.44227 3.79574, -76.44924 3.78304, -76.43605 3.75668, -76.43123 3.74009, -76.43915 3.72793, -76.45041 3.71995, -76.45101 3.70922, -76.4597 3.69519, -76.49738 3.67439, -76.49767 3.65691, -76.50622 3.65437, -76.51356 3.64272, -76.48698 3.64254, -76.47955 3.63644, -76.48064 3.61858, -76.50387 3.61011, -76.48292 3.60512, -76.48318 3.59487, -76.4749 3.56315, -76.48537 3.56126, -76.48596 3.54788, -76.50184 3.51001, -76.49185 3.5061, -76.4845 3.49526, -76.47615 3.47385, -76.47556 3.44446, -76.46221 3.43477, -76.46141 3.41546, -76.46847 3.40001, -76.48232 3.41473, -76.49976 3.40201, -76.51382 3.38805, -76.51353 3.35742, -76.52569 3.33435, -76.53553 3.32494, -76.55565 3.3389, -76.54913 3.3518, -76.5507 3.36274, -76.56405 3.36296, -76.57408 3.37963, -76.5955 3.37295, -76.5931 3.36302, -76.60473 3.34194, -76.59034 3.31563, -76.59502 3.29344, -76.60365 3.28101, -76.60419 3.26801, -76.61596 3.26653, -76.61611 3.28201, -76.62651 3.27853, -76.63994 3.24307, -76.64604 3.23544, -76.63802 3.22429, -76.62659 3.2206, -76.63611 3.2101, -76.63482 3.20163, -76.66231 3.19724, -76.67024 3.19142, -76.67346 3.17749, -76.68213 3.17369, -76.69 3.1557, -76.68095 3.15463, -76.68272 3.13731, -76.68999 3.12135, -76.67539 3.10054, -76.64869 3.09248, -76.64421 3.07976, -76.63168 3.08983, -76.61979 3.0847, -76.60173 3.08958, -76.58826 3.08032, -76.57693 3.05832, -76.57806 3.04612, -76.54687 3.03208, -76.54178 3.03821, -76.53023 3.03691, -76.5166 3.0576, -76.50425 3.05798, -76.49964 3.04637, -76.50393 3.03375, -76.49373 3.02043, -76.48052 3.02247, -76.47021 3.01095, -76.45734 3.02104, -76.44138 3.00994, -76.42919 3.02372, -76.4305 3.03458, -76.44421 3.04698, -76.43253 3.06667, -76.4054 3.06043, -76.39915 3.03954, -76.38657 3.04574, -76.37971 3.03032, -76.3715 3.0454, -76.38001 3.06905, -76.36896 3.06996, -76.34922 3.06251, -76.34823 3.0554, -76.33149 3.04823, -76.33842 3.06521, -76.32374 3.07661, -76.31191 3.09637, -76.29616 3.10447, -76.29288 3.11463, -76.28433 3.11914, -76.26466 3.15153, -76.231 3.14188, -76.22914 3.16375, -76.22148 3.18107, -76.20974 3.1815, -76.20067 3.20142, -76.21021 3.20923, -76.20707 3.2408, -76.19549 3.25002, -76.20237 3.25861, -76.20051 3.27066, -76.18761 3.28448, -76.18271 3.30113, -76.19226 3.30933, -76.18757 3.3323, -76.1941 3.3493, -76.19396 3.36632, -76.18888 3.38279, -76.19144 3.42083, -76.20217 3.41268, -76.21011 3.41892, -76.21044 3.42968, -76.21891 3.44797, -76.22768 3.45586, -76.22236 3.47502, -76.22668 3.48959, -76.19962 3.50687, -76.19027 3.52729, -76.19001 3.55689, -76.18615 3.58683, -76.18823 3.6036, -76.18367 3.62016, -76.19089 3.64237, -76.19111 3.67077, -76.20692 3.67546, -76.21236 3.69995, -76.2091 3.70474, -76.22228 3.72861, -76.21819 3.74835, -76.23384 3.75558, -76.25087 3.74377, -76.25716 3.73162, -76.27758 3.72044, -76.29283 3.72168, -76.32076 3.72825, -76.3323 3.75584, -76.35263 3.75576, -76.36872 3.76821, -76.38391 3.7738, -76.39914 3.78589, -76.41165 3.7753, -76.43216 3.7814))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE)
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND occurrence.occurrencestatus = 'PRESENT'
 AND GBIF_STRINGARRAYCONTAINS(occurrence.classifications['d7dddbf4-2cf0-4f39-9b2a-bb099caae36c'], '5228793', TRUE)
 AND occurrence.hasgeospatialissues = FALSE
 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 24 records were derived from 9 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0015875-260208012135463/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.