DOI: 10.15468/dl.djpd2t
title: Occurrence Download

description: A dataset containing 36 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.decimallatitude &gt;= 41.58132
 AND occurrence.decimallatitude &lt;= 42.02
 AND (occurrence.decimallongitude &gt;= 13.47601 AND occurrence.decimallongitude &lt;= 14.0536)
 AND GBIF_WITHIN('MULTIPOLYGON (((13.47601 41.87324, 13.47852 41.86286, 13.4855 41.8573, 13.50377 41.85105, 13.51177 41.8458, 13.52894 41.84127, 13.54106 41.83394, 13.5439 41.82777, 13.56794 41.81007, 13.57712 41.80124, 13.59185 41.79429, 13.61372 41.77255, 13.62217 41.77051, 13.63162 41.77237, 13.63967 41.77628, 13.65599 41.77044, 13.66387 41.7663, 13.68048 41.75342, 13.68282 41.74654, 13.68772 41.74272, 13.70164 41.74156, 13.71959 41.74795, 13.72446 41.74597, 13.73668 41.74594, 13.74166 41.74238, 13.75173 41.7392, 13.76783 41.73966, 13.79093 41.73408, 13.80746 41.73936, 13.81111 41.73794, 13.82223 41.73055, 13.82143 41.71398, 13.82379 41.70652, 13.83146 41.69667, 13.85633 41.67481, 13.85293 41.66602, 13.85569 41.6513, 13.86611 41.64208, 13.87055 41.63275, 13.87974 41.62668, 13.91551 41.61742, 13.93558 41.60789, 13.95119 41.60497, 13.95896 41.606, 13.97335 41.60206, 13.98227 41.60164, 13.99121 41.60426, 13.99735 41.60188, 13.99734 41.59441, 14.00147 41.58564, 14.00682 41.58229, 14.01569 41.58132, 14.0315 41.58724, 14.03826 41.59609, 14.04612 41.60011, 14.05074 41.60871, 14.0536 41.63319, 14.03976 41.66273, 14.04617 41.67149, 14.04599 41.68078, 14.04281 41.68903, 14.04 41.70505, 14.03332 41.71296, 14.03055 41.71973, 14.01796 41.72703, 14.00332 41.72907, 14.00235 41.73633, 14.00714 41.73787, 14.01561 41.73718, 14.03992 41.74732, 14.04493 41.75213, 14.04606 41.76107, 14.04329 41.76915, 14.03995 41.77285, 14.0261 41.77801, 14.02385 41.78024, 14.02965 41.79309, 14.03003 41.80109, 14.02786 41.80922, 14.02075 41.81718, 14.01628 41.81892, 14.01178 41.82404, 13.99871 41.83319, 13.99988 41.8387, 14.00556 41.84847, 13.99442 41.8889, 13.98416 41.89609, 13.95997 41.89633, 13.94406 41.90652, 13.929 41.91236, 13.91232 41.91133, 13.89137 41.90496, 13.88194 41.91366, 13.86553 41.92121, 13.84024 41.9414, 13.83197 41.94379, 13.82408 41.94406, 13.81602 41.94187, 13.80799 41.93501, 13.80049 41.93284, 13.7923 41.93718, 13.78933 41.94445, 13.79093 41.95021, 13.79963 41.9608, 13.79563 41.96786, 13.79205 41.97011, 13.79028 41.97634, 13.78193 41.99032, 13.77844 42.00106, 13.77657 42.00357, 13.77022 42.00669, 13.76185 42.00613, 13.75253 42.003, 13.73696 42.00587, 13.72427 42.01722, 13.72108 42.01907, 13.7132 42.02, 13.69649 42.0141, 13.6902 42.0014, 13.69382 41.99356, 13.70378 41.98801, 13.71128 41.97497, 13.72167 41.96304, 13.72143 41.94612, 13.72377 41.9379, 13.72388 41.92929, 13.72058 41.92669, 13.70538 41.93457, 13.69903 41.93519, 13.67418 41.92721, 13.66721 41.92819, 13.65757 41.92579, 13.64808 41.92585, 13.62926 41.9211, 13.62444 41.92419, 13.61601 41.92615, 13.61335 41.93657, 13.60302 41.94417, 13.603 41.95218, 13.60026 41.95508, 13.59206 41.95791, 13.56004 41.9624, 13.55242 41.9612, 13.53768 41.95484, 13.5299 41.9553, 13.52025 41.95316, 13.51155 41.94745, 13.50916 41.93793, 13.51111 41.93478, 13.52289 41.92992, 13.53306 41.9138, 13.51205 41.90151, 13.48805 41.89233, 13.48462 41.88927, 13.47601 41.87324)))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND (occurrence.taxonkey IN ('131', '10910236', '12314925', '11418114') OR occurrence.acceptedtaxonkey IN ('131', '10910236', '12314925', '11418114') OR occurrence.kingdomkey IN ('131', '10910236', '12314925', '11418114') OR occurrence.phylumkey IN ('131', '10910236', '12314925', '11418114') OR occurrence.classkey IN ('131', '10910236', '12314925', '11418114') OR occurrence.orderkey IN ('131', '10910236', '12314925', '11418114') OR occurrence.familykey IN ('131', '10910236', '12314925', '11418114') OR occurrence.genuskey IN ('131', '10910236', '12314925', '11418114') OR occurrence.specieskey IN ('131', '10910236', '12314925', '11418114'))
 AND NOT GBIF_STRINGARRAYCONTAINS(occurrence.issue, 'TAXON_MATCH_FUZZY', TRUE)
 AND (occurrence.distancefromcentroidinmeters &gt;= 2000.0 OR occurrence.distancefromcentroidinmeters IS NULL)
 AND NOT occurrence.basisofrecord IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN')
 AND occurrence.occurrencestatus = 'PRESENT'
 AND (occurrence.specieskey IS NOT NULL 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 36 records were derived from 4 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0040119-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.