DOI: 10.15468/dl.6em5pn
title: Occurrence Download

description: A dataset containing 29665226 records in GBIF matching the query:
SELECT PRINTF('%04d-%02d', "year", "month") AS yearMonth, GBIF_EEARGCode(10000, decimalLatitude, decimalLongitude, COALESCE(coordinateUncertaintyInMeters, 10000)) AS eeaCellCode, basisOfRecord, datasetKey, countryCode, speciesKey, species, family, class, COUNT(*) AS occurrences FROM occurrence WHERE occurrenceStatus = 'PRESENT' AND continent = 'EUROPE' AND speciesKey IN (8894817, 2442225, 9789983, 2481800, 8277073, 2498112, 8332393, 8214667, 8000602, 9761484, 2498017, 2498036, 2481776, 2498255, 2498261, 2498265, 5232446, 5232437, 5232464, 2498326, 2481606, 2481748, 2481759, 2481765, 2481741, 2481743, 6178228, 2481521, 2481521, 2481521, 2481312, 2480311, 9566659, 2481119, 2498273, 6178421, 2498338, 2498347, 2498343, 2480876, 2481353, 2474377, 2481433, 2481433, 2481959, 2481958, 2481263, 7788295, 2480449, 2482001, 10884686, 4408455, 6065841, 2481236, 2481139, 7406504, 7982160, 2481174, 2481174, 2481174, 6065810, 2481172, 8151548, 9413670, 6065824, 2481681, 2481685, 2498238, 2498247, 2498285, 9537647, 2498375, 2480964, 2480964, 2481792, 2481784, 2482001, 2482012, 2481991, 2481861, 2481890, 8250742, 2480801, 2480332, 2480327, 2482059, 2482054, 2482051, 2482065, 5232431, 5788464, 2481463, 5229343, 5739277, 5229361, 5229360, 5229380, 5229377, 2480259, 2481205, 2498352, 2481621, 2481609, 2481618, 7192406, 5229249, 9367409, 5229230, 2481240, 5789279, 2498009, 2481725, 2481713, 2481726, 2481714, 2481342, 2480242, 2289348, 2289359, 2290522, 2290374, 2289671, 9385151, 2290849, 12232247, 2290489, 2290469, 9809222, 4287132, 2402203, 5214401, 2420813, 2420797, 2412685, 2412623, 2420446, 2392210, 8006460, 5212973, 2417115, 2389391, 5214450, 5214448, 2408575, 2408554, 2408516, 2408543, 2369178, 2395359, 5210955, 2415505, 2409909, 2386906, 2386887, 2389708, 2346315, 5216423, 5216437, 5216430, 2421020, 2421147, 2421203, 2379498, 2420726, 2336745, 2336534, 2336774, 2336786, 2400863, 2417343, 5213909, 8351946, 8351946, 2416296, 2403490, 2351027, 2351211, 2351174, 5209780, 5215150, 5962255, 2420911, 2419543, 2421127, 2376296, 2392679, 2394622, 5210983, 5210969, 9777888, 5210968, 5210979, 2420234, 2420247, 2420174, 2386469, 5214892, 2414031, 2395031, 2388507, 2346633, 2421071, 2421031, 2421064, 2336597, 4284220, 8084280, 2415603, 2415581, 2418259, 5215626, 5215611, 2411201, 5213996, 2403289, 2375526, 4286361, 2420586, 2420569, 5201064, 5201134, 2409218, 2357093, 5215455, 5215127, 5216248, 2383648, 5216239, 2421365, 5210267, 2409395, 2409391, 2336734, 2336719, 2378673, 2378690, 5851603, 2419863, 2419849, 2419852, 2419875, 5213960, 2415070, 2415075, 5211321, 5215092, 2415822, 2415788, 2415643, 2410133, 2410130, 2410119, 2410108, 2415777, 5214022, 2419188, 5214883, 5214875, 5214880, 5215435, 2396862, 9530947, 2418315, 2418313, 2418361, 2419310, 2379089, 2416878, 2405532, 2392603, 5216313, 2392566, 2392562, 2392557, 2392554, 8140485, 2334967, 8236498, 5214919, 2409330, 7700106, 2415872, 2415861, 5211265, 2409418, 5216016, 5216024, 5216033, 5216014, 5216053, 5216046, 2420418, 2417443, 2420268, 7595433, 8215487, 2382155, 5208593, 2413224, 2392628, 2399670, 2374161, 2374149, 2409418, 2409418, 2409403, 2334658, 2334619, 2334600, 2334574, 2418684, 2418670, 2421174, 2388710, 2388724, 5214139, 5214139, 2418794, 2393205, 2393205, 2392356, 2413452, 5216368, 5216342, 2417781, 2384043, 2383970, 2409453, 9694948, 2373980, 5203999, 5215518, 2386475, 5210496, 5210490, 5210473, 2415973, 4286391, 2336771, 2415923, 2415916, 2415906, 2360504, 2397850, 7744449, 2381013, 2440728, 2440709, 2440714, 2440735, 2440718, 8324617, 2440605, 2440596, 5220027, 2434806, 2434806, 5220013, 2440694, 5220086, 2440412, 2440397, 2440417, 2434779, 2440483, 5219369, 2434793, 2440669, 2440669, 8123917, 8123917, 2440440, 5219369, 5220055, 5220045, 2440433, 2440447, 2440369) AND occurrence.hasgeospatialissues = FALSE AND 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 (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%')) AND "month" IS NOT NULL 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 AND occurrence.hascoordinate = TRUE) GROUP BY yearMonth, eeaCellCode, basisOfRecord, datasetKey, countryCode, speciesKey, species, family, class ORDER BY yearMonth DESC, eeaCellCode ASC, countryCode ASC

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