DOI: 10.15468/dl.2xh4qy
title: Occurrence Download

description: A dataset containing 91562075 records in GBIF matching the query:
SELECT "year", GBIF_EEARGCODE(1000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)) 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 (5231630, 2480610, 2480578, 2480589, 2480637, 2493137, 2493128, 2493145, 2493124, 2493114, 2493136, 2493129, 2493118, 2481800, 2495000, 5739298, 5229165, 8077224, 2490611, 2490682, 8277073, 2475532, 2474045, 2474029, 2474055, 2474051, 2481299, 2490641, 2473732, 2498112, 8214667, 9761484, 2482080, 2498017, 2498036, 2498024, 2498167, 2498026, 2498027, 2474936, 2490270, 2490274, 2490283, 2490281, 2490244, 2490275, 2490266, 2490255, 2490246, 5228662, 5228676, 5228644, 5228695, 5228694, 2480510, 2480506, 5844449, 2480500, 2480513, 9752617, 9797180, 2480934, 2480906, 2481776, 2493316, 2497295, 2497306, 2497266, 2498255, 2498261, 2498265, 2498259, 2484605, 2473663, 2480910, 5232446, 5232437, 5232464, 5232451, 5959092, 5959143, 2480830, 2494394, 4408954, 2498326, 2498325, 2481606, 2482100, 2480537, 2480524, 2480564, 2490681, 2491678, 2481748, 2481759, 2481770, 2481765, 7537888, 2481741, 2481743, 2481749, 8250742, 2481740, 2492537, 6178228, 2481521, 8109681, 9411857, 2494686, 2494632, 4408961, 2494459, 2494517, 2492364, 2481618, 9717283, 2481312, 5788860, 7806848, 2487603, 2475679, 2493012, 2480311, 2480308, 7937336, 9566659, 2480297, 2490674, 2474863, 2474864, 2481121, 2481120, 2481119, 2481912, 2481909, 2495093, 2480666, 2480482, 2480487, 2480491, 2480495, 2492822, 2496464, 2480509, 2480505, 2498273, 2494329, 2495427, 2495434, 2495414, 2495471, 2495455, 2495406, 2475365, 2482492, 9409796, 2482513, 6100954, 2474156, 4408498, 5231918, 5231898, 10789323, 9317615, 2492943, 2492959, 7342065, 2492960, 2492944, 9990095, 2492953, 2492954, 2492963, 2492955, 6100917, 2492965, 9478399, 2492949, 2480740, 4408732, 2487879, 2487877, 7341849, 5844936, 2498338, 2498347, 2498343, 2489214, 2477927, 2477968, 2478031, 9015784, 2477872, 2480876, 2480372, 2491518, 2491521, 9566476, 2491490, 7634625, 2491498, 2491469, 7626513, 2491534, 2491482, 2491472, 9613112, 2491591, 2491544, 2491582, 2491557, 9415596, 2492462, 2480281, 8014966, 2481034, 9813242, 2481037, 9584698, 2481047, 8069880, 2481035, 9616058, 2481062, 2492601, 2492606, 2492605, 2492608, 5227919, 2481353, 2494422, 2494441, 7894593, 2494442, 2474377, 2474381, 2481433, 2490669, 9330514, 2481819, 2481831, 2481815, 2481828, 5228199, 5229493, 2481957, 2481959, 2481962, 2481958, 2481263, 2480770, 2480758, 2480757, 5232162, 2474950, 2481861, 6100968, 2480649, 2480389, 7788295, 5228328, 2480449, 2480685, 5229126, 2493220, 2493217, 2493219, 2493214, 9515886, 2498224, 2482001, 2482012, 10884686, 4408455, 6065841, 2481236, 5739359, 5739355, 5739361, 5739357, 2492700, 2480850, 8012314, 5232229, 2473421, 5227679, 7745240, 9444556, 7341500, 2492854, 2492855, 2492867, 2481139, 2481171, 7406504, 2481181, 7982160, 2481174, 6065810, 2481156, 2481127, 8028588, 2481172, 8151548, 9413670, 6065824, 8773033, 2481681, 2481685, 8104397, 7668711, 2493549, 2493550, 2493551, 2493548, 2487883, 9629160, 8144830, 2494154, 2494177, 2490604, 2492542, 7660710, 2481835, 2473680, 2473682, 8000602, 9362027, 2498390, 2498238, 2498247, 2490609, 2490613, 2490614, 2498285, 9537647, 2498375, 2475443, 2475419, 10095118, 5229167, 5229168, 2490956, 2490955, 2492371, 2480964, 9687165, 2490310, 2490307, 9701857, 2492576, 2480696, 2498180, 2482613, 2481792, 2481784, 2481789, 2480863, 5788868, 5231234, 5231244, 5231251, 5231235, 5231245, 5231236, 5231240, 5231233, 5231239, 5789284, 2488949, 2474921, 2497755, 9103006, 2497701, 2498302, 2481202, 2480726, 2493367, 9705453, 5231190, 5231209, 8426551, 5231203, 5231198, 5845386, 2481991, 2480353, 2480350, 2473958, 2487871, 2482449, 2480420, 2492350, 2481890, 5229390, 5739290, 9752149, 4352332, 7340976, 5739315, 5739317, 2493070, 2493071, 7341593, 2493091, 7341585, 2493095, 9584952, 4408827, 8128385, 7341578, 2493084, 2493052, 5229490, 2477804, 2478548, 9029556, 2478523, 2494771, 2480801, 2491719, 2480773, 2480332, 2480327, 2482059, 2482054, 2482051, 2482065, 2487862, 7342129, 2487857, 2487866, 2487843, 5232431, 2474416, 2474621, 2492748, 5231766, 5231770, 5231763, 5231759, 5231773, 2480204, 2480193, 5788464, 2481463, 4408796, 5229361, 5229360, 5229380, 5229377, 2486116, 2482553, 2482552, 4408970, 2494543, 2474831, 2480259, 6093527, 4408806, 2484596, 2487385, 2494570, 2494787, 2481218, 2489160, 2481205, 2492522, 2492521, 2492526, 2481700, 2494303, 2494194, 2494200, 2484916, 2484880, 2484890, 2484885, 2484886, 2498352, 2498350, 8332393, 9274012, 6101223, 6092830, 2481613, 2481621, 2481609, 5229249, 9367409, 5229230, 5789279, 2495696, 2495708, 9282206, 2497522, 2497509, 2489104, 9809229, 2497894, 2492956, 2492942, 2480208, 2482048, 2477411, 2498015, 2498009, 2492509, 2473577, 2473442, 2473446, 5228228, 2481240, 2484918, 2481725, 2481713, 2481726, 2481728, 2481719, 2481714, 5231438, 4408790, 2490781, 2490719, 7901064, 2490737, 7865305, 2490774, 2475001, 2497921, 2498415, 2481342, 2481339, 5229138, 5229131, 5229147, 5229142, 2480242, 2481221, 2481703, 2474627, 2474628, 4408785) AND occurrence.hasgeospatialissues = FALSE AND occurrence.hascoordinate = TRUE AND (coordinateUncertaintyInMeters &lt;= 1000 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 "year", basisOfRecord, datasetKey, countryCode, speciesKey, species, family, class, sex, GBIF_EEARGCODE(1000, occurrence.decimallatitude, occurrence.decimallongitude, COALESCE(occurrence.coordinateuncertaintyinmeters, 1000)) ORDER BY "year" DESC, countryCode ASC

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