DOI: 10.15468/dl.jqczrk
title: Occurrence Download

description: A dataset containing 725252 records in GBIF matching the query:
SELECT PRINTF('%04d-%02d', "year", "month") AS yearMonth, GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 10000)) AS eeacellcode, countryCode AS countryCode, datasetKey, basisOfRecord, speciesKey, species, family, class, sex, COUNT(*) AS occurrences FROM occurrence WHERE occurrence.occurrencestatus = 'PRESENT' AND continent = 'EUROPE' AND "year" &gt;= 2000 AND speciesKey IN (1343457, 1343432, 1343390, 1343312, 1343297, 1343255, 1343241, 1343973, 1343944, 1343865, 1343847, 1343801, 1343789, 1343776, 1343731, 1343713, 1343680, 1343642, 1343608, 1343593, 1343578, 1343546, 1343515, 1343451, 1343397, 1343381, 1343367, 1343277, 1343261, 1343234, 1343986, 1343922, 1343905, 1343885, 7442089, 1343826, 1343796, 1343785, 1343724, 1343689, 6096983, 1343614, 1343602, 1343570, 1343527, 1343508, 1343495, 1343342, 11135200, 1343298, 1339368, 1339370, 5039596, 1340232, 5039715, 5039714, 1343048, 1343075, 1343068, 1343132, 10751428, 1343115, 1343108, 9569843, 1343074, 1343026, 1343130, 1343121, 9761295, 1343072, 9274802, 1343070, 1343062, 1343051, 1343040, 10835653, 1344875, 5040561, 1344888, 1344862, 1344849, 1344838, 1344902, 1344865, 1344841, 1344907, 1344878, 1341624, 1342477, 1342427, 1342279, 1342082, 1342363, 1342075, 1342196, 1342108, 1342324, 1348776, 1348747, 1348737, 1348665, 1348571, 1348560, 1348674, 1348543, 1348996, 1348989, 1348575, 1348979, 1348947, 1348796, 1348768, 1348710, 1348691, 1348655, 1348620, 1349010, 1349001, 1348928, 1348863, 1348844, 1348742, 1348658, 1348725, 1348616, 1349006, 1348923, 1348914, 1348904, 1348850, 1348624, 1348797, 10712150, 1348585, 1348944, 1348836, 1348792, 1348753, 1348716, 1348558, 1349007, 1348940, 1348905, 1348841, 10828240, 1348634, 1348921, 1348901, 1348569, 1348973, 1348965, 1348957, 1348950, 1348805, 1348780, 1348713, 1348704, 1348635, 1348528, 1348988, 1348884, 1348794, 1349836, 1350078, 1349617, 1349822, 1349884, 1350053, 10862726, 1349470, 1349965, 1349878, 1349653, 1349560, 1349414, 1349558, 1349838, 1349795, 1349768, 1349755, 1349646, 1349632, 1349619, 1349527, 1349909, 10896001, 1349802, 8457894, 1349576, 1349415, 1349673, 1349554, 1349515, 1349447, 1349419, 1350073, 1350025, 1349788, 1349640, 1349638, 1349520, 1349480, 1349466, 1349389, 8083501, 10462569, 1349757, 1349648, 1349573, 1349997, 9546600, 10787602, 1350084, 10686531, 1349433, 1349367, 1350075, 1349736, 1349564, 1349550, 1349482, 1349948, 1349889, 1349842, 1349829, 1350002, 1349475, 1349461, 1349842, 1349434, 1349955, 1349865, 1349751, 1349443, 1349428, 1349918, 1349904, 1349744, 1349703, 1349544, 1349384, 1350077, 1349942, 1349792, 1349737, 1349658, 1349484, 1352694, 1351991, 1351854, 1351885, 1351938, 1351891, 1351877, 1351980, 1351966, 1351953, 1351927, 1351940, 1351912, 1351839, 1351974, 1351869, 5042717, 1351820, 1351944, 1351832, 1353401, 1353412, 1353345, 1353269, 1353204, 1353192, 1353408, 1353390, 1353352, 1353343, 1353320, 1353416, 1353361, 1353348, 1353328, 1353229, 1353212, 1353196, 1353413, 1353312, 1353227, 1353394, 1353381, 1353364, 1353344, 1353321, 1353379, 1353220, 1353198, 1353359, 1353303, 1353273, 1353236, 1353228, 1353207, 1353183, 1353453, 1353432, 1353420, 1353395, 1353332, 1353322, 1353310, 1353191, 1353418, 1353407, 9398537, 1353342, 1355373, 1355170, 1355135, 1355065, 1354990, 1354941, 1354896, 9876257, 1354826, 1354808, 1354743, 1355050, 1354590, 1354521, 1354512, 1354418, 1354317, 1354192, 1354088, 1354066, 1354029, 1353719, 1353710, 1355263, 1355137, 1355058, 1355041, 1354959, 1354953, 1354819, 1354798, 1354640, 1354476, 1354420, 1354278, 1354138, 1353948, 1353509, 1355366, 1355234, 1355083, 1355003, 1354994, 1354961, 1354552, 1354881, 1354781, 1354677, 1354627, 1354547, 1354446, 1354150, 1354085, 1354033, 1353951, 1353865, 1353841, 1353713, 1353632, 1353590, 1353580, 1353502, 1355368, 1355141, 1354773, 1354651, 1354414, 1354397, 1354377, 1354282, 1354132, 1353733, 1353676, 1355157, 1355131, 1355052, 1354874, 1354864, 1354527, 1354468, 1354340, 1354307, 1354284, 1354272, 1354133, 1354102, 1354007, 1353851, 1353834, 1353805, 1353725, 1353715, 1353697, 1353626, 1353569, 1353557, 1353511, 1355330, 1355095, 1355085, 1355045, 1355018, 1355007, 1354884, 9902334, 1354833, 1354615, 1354422, 1354398, 1354254, 1354226, 1354206, 1354079, 1353756, 1353610, 1353593, 1353558, 1355159, 1354766, 1354551, 1354528, 1354342, 1354274, 1354263, 1354037, 1353985, 1353651, 1355301, 1355250, 1355230, 1355107, 1355097, 1354989, 1354964, 1354934, 1354867, 1354742, 1354699, 1354645, 1354623, 1354607, 1354598, 1354560, 10339747, 1354058, 1353749, 1353718, 1355126, 1355001, 1354991, 1354982, 1354973, 1354966, 1354952, 1354656, 1354498, 1354400, 1354196, 1354118, 1354039, 1354000, 1353981, 1355216, 1355179, 1354799, 1354693, 1354676, 1354555, 1354506, 1354465, 1354169, 1354041, 1354032, 1353989, 1353761, 1353731, 1355337, 1353103, 1353125, 1353130, 1353098, 4495970, 12280372, 12354407, 1353144, 1352101, 1352078, 1352051, 1352072, 1352096, 1352050, 1353155, 1352023, 10846962, 1352007, 1352017, 1352012, 1352026, 1352013, 1352014, 1352006, 1353450, 1353363, 8505781, 1353295, 1353285, 8614362, 1353283, 1353181, 8698664, 8487821, 1353376, 1353374, 1353300, 1353234, 8583657, 1353298, 1353289, 11130531, 1351582, 1351548, 5042554, 5042351, 5042529, 5042392, 1351435, 1351387, 10805562, 1351338, 1351326, 7645045, 1351495, 1351470, 1351360, 5042560, 1351491, 10709829, 1351292, 1351574, 1351463, 10885449, 1351361, 1351335, 1351577, 1351467, 1351330, 1351304, 1351513, 5042435, 1351287, 1351446, 10738357, 1351310, 1351531, 1351518, 1351481, 1351332, 1351576, 10257991, 1351540, 1351503, 1351392, 5042448, 1351462, 1351334, 1351642, 8916884, 1351648, 1355411, 1338308, 1338304, 1335008, 1338911, 1338883, 11802552, 1334822, 1334932, 1334816, 1334943, 1334802, 1334967, 1334821, 1334892, 1334902, 1334817, 1334945, 1334975, 1334829, 1334922, 1334949, 1334937, 1334837, 8644630, 1334499, 8580995, 1334512, 1334501, 1334482, 1334536, 1334527, 1334528, 1334517, 1334507, 1334497, 1334485, 8617099, 1334542, 8490287, 1334495, 1334487, 1334478, 1334493, 1334515, 1334490, 1334538, 1338566, 1338498, 1338466, 1338740, 1338721, 1338640, 1338797, 1338586, 1338425, 1338722, 1338630, 1338442, 1338379, 11821475, 1338361, 1338340, 1338840, 1338357, 1338677, 1338432, 1338626, 1338489, 1338704, 1338713, 1338603, 1338800, 1338348, 5038509, 5038531, 5038501, 5038502, 5038524, 5038513, 1338203, 1337405, 1337414, 1337408, 1334591, 1336871, 1336835, 1336795, 1336823, 1336802, 1334372, 1337115, 1337092, 1336998, 8013042, 10856132, 1337086, 1337304, 5038891, 1337324, 1337160, 5038724, 1337025, 1337009, 1336977, 9753086, 1337075, 1337329, 1337101, 1337059, 1337021, 1337376, 1337361, 1337210, 1337159, 1337139, 1337123, 1337096, 9652556, 9233394, 1337226, 1337135, 5038620, 8445227, 1336994, 5038641, 1336931, 1337371, 8537289, 1337185, 5038826, 1337023, 1336911, 5038975, 1337290, 1337182, 1336937, 1336921, 1337359, 8668708, 1337229, 1337190, 1337091, 8532444, 1337051, 5038686, 1337386, 1337354, 1337334, 8507966, 5038875, 8462308, 1337008, 8485665, 1336989, 5038629, 1337328, 1337297, 1337261, 8585968, 5038938, 1337144, 1337100, 5038703, 1336957, 1336923, 1337375, 5038831, 1337179, 1337391, 1336934, 5038625, 8611964, 10981601, 5038670, 1337050, 5038657, 9671292, 5039047, 1337383, 5038943, 1337281, 5038889, 1337241, 1337165, 5038627, 1336926, 1337319, 5038910, 1337257, 1336648, 1336635, 1336627, 1336640, 1336601, 1336592, 1336615, 1335113, 1335037, 1336536, 1336476, 1336307, 1336029, 1336013, 1335684, 1335657, 1335229, 1335975, 1335307, 1336575, 1336050, 1335945, 1335822, 1335505, 1336564, 1335525, 1336006, 1336553, 1336296, 1336005, 8461422, 1335321, 8522167, 1336284, 1336139, 1336024, 1335930, 1335632, 1335504, 1335050, 1336390, 1335395, 1335194, 1336249, 1336452, 1336343, 1336138, 1336107, 1335981, 1335802, 1335519, 1336535, 1336457, 1336431, 1336112, 7548157, 1335588, 1335222, 1335829, 1335260, 1335197, 1336451, 1335942, 1335866, 1335245, 11612869, 1335824, 1335792, 1335777, 1336407, 1335648, 1336031, 1335351, 1335213, 9655305, 1336092, 11892608, 1336096, 11412772, 11768718, 1335338, 1336116, 1335556, 5039136, 5039072, 5039043, 5039478, 8880388, 5039442, 5039421, 5039409, 5039395, 5039340, 5039261, 5039228, 5039315, 5039018, 5039207, 5039191, 5039166, 5039096, 5039341, 5039035, 5039358, 5039333, 5039186, 5039293, 5039006, 5039237, 5039065, 5039047, 5039470, 11321409, 5039150, 9794322, 11858882, 5039384, 5039353, 5039020, 9760604, 5039454, 5039176, 9762019, 5039444, 9661030, 5039209, 5039248, 7926280, 5039147, 9125017, 5039183, 8343705, 5039087, 5039039, 5039461, 5039008, 5039419, 5039392, 5039338, 5039239, 5039204, 5039219, 9691646, 5039025, 5039453, 5039432, 5039160, 5039103, 5039404, 5039370, 5039317, 5039287, 5039401, 11621020, 11677676, 5039199, 5039158, 11094673, 5039061, 5039016, 5039347, 5039194, 5039153, 5039106, 5039009, 5039475, 5039015, 6096937, 5039339, 5039322, 5039303, 5039155, 5039243, 5039225, 9710827, 5039085, 5039058, 5039053, 5039031, 5039455, 5039435, 1334370, 1334776, 1334787, 1334771, 1334789, 1334773, 11193635, 1334785, 1334774, 8663370, 1334775, 1334769, 1334788, 1334781, 1334647, 1334668, 1334658, 11836037, 1334646, 9309752, 1334653, 1334638, 10860468, 1334642, 1334626, 1334632, 1334629, 11698779, 1334622, 1334630, 1334635, 5038443, 1334209, 1334298, 1334278, 5038479, 1334262, 10682524, 1334246, 1334237, 9159830, 1334267, 1334251, 1334225, 1334214, 10843230, 1334198, 1334185, 1334291, 1334282, 1334264, 1334241, 1334203, 1334196, 8318680, 1338214, 9698831, 5038591, 5038594, 10718656, 5038598, 5038570, 5038562, 5038568, 10751960, 1345883, 1345885, 1345860, 1345877, 1345879, 1345866, 1345892, 1345858, 1345870, 9400324, 9182351, 1345874, 1345858, 1345861, 1345876, 1345865, 1345875, 1345867, 1345893, 1345909, 1345907, 1345902, 5040874, 8689465, 5040847, 5040885, 9796233, 5040892, 5040862, 5040894, 5040875, 5040859, 5040855, 5040861, 5040881, 5040886, 5040887, 5040849, 5040893, 5040872) AND occurrence.hasgeospatialissues = FALSE AND occurrence.hascoordinate = TRUE AND (coordinateUncertaintyInMeters &lt;= 10000 OR coordinateUncertaintyInMeters IS NULL) AND NOT ARRAY_CONTAINS(issue, 'ZERO_COORDINATE') AND NOT ARRAY_CONTAINS(issue, 'COORDINATE_OUT_OF_RANGE') AND NOT ARRAY_CONTAINS(issue, 'COORDINATE_INVALID') AND NOT ARRAY_CONTAINS(issue, 'COUNTRY_COORDINATE_MISMATCH') AND "month" IS NOT NULL AND (occurrence."year" IS NOT NULL AND occurrence.hascoordinate = TRUE) 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 (identificationVerificationStatus IS NULL OR NOT (LOWER(identificationVerificationStatus) LIKE '%unverified%' OR LOWER(identificationVerificationStatus) LIKE '%unvalidated%' OR LOWER(identificationVerificationStatus) LIKE '%not able to validate%' OR LOWER(identificationVerificationStatus) LIKE '%control could not be conclusive due to Insufficient knowledge%' OR LOWER(identificationVerificationStatus) LIKE '%unconfirmed%' OR LOWER(identificationVerificationStatus) LIKE '%unconfirmed - not reviewed%' OR LOWER(identificationVerificationStatus) LIKE '%validation requested%')) GROUP BY yearMonth, basisOfRecord, datasetKey, countryCode, speciesKey, species, family, class, sex, GBIF_EEARGCODE(10000, occurrence.decimallatitude, occurrence.decimallongitude, COALESCE(occurrence.coordinateuncertaintyinmeters, 10000)) ORDER BY yearMonth DESC, countryCode ASC

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