DOI: 10.15468/dl.u6dxyd
title: Occurrence Download

description: A dataset containing 564474 records in GBIF matching the query:

SELECT 
 -- Dimensions
 PRINTF('%04d-%02d', "year", "month") AS yearMonth,
 GBIF_EEARGCode(
 250,
 decimalLatitude,
 decimalLongitude,
 COALESCE(coordinateUncertaintyInMeters, 1000)
 ) AS eeaCellCode,
 datasetkey,
 taxonKey,
 acceptedTaxonKey,
 familyKey,
 family,
 speciesKey,
 species,
 scientificName,

 -- Measurements
 COUNT(*) AS occurrences, 
 MIN(COALESCE(coordinateUncertaintyInMeters, 1000)) AS minCoordinateUncertaintyInMeters,
 MIN(GBIF_TemporalUncertainty(eventDate, NULL)) AS minTemporalUncertainty

FROM occurrence

WHERE occurrenceStatus = 'PRESENT'
 AND basisOfRecord NOT IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN')
 AND datasetkey NOT IN ('8a863029-f435-446a-821e-275f4f641165')
 AND countryCode = 'NL'
 AND "year" &gt;= 2020
 AND "year" &lt; 2025
 AND hasCoordinate = TRUE
 AND speciesKey IN (133142097, 104109161, 304189867, 100145582, 165902491, 116902418, 222466917, 155309291, 180177343, 143705799, 304185247, 302565820, 176605732, 100481856, 102089338, 273121764, 176605738, 164696338, 299348704, 159935932, 2481912, 299348685, 2481916, 100510281, 100509370, 133144857, 304185545, 202601409, 176652855, 102096937, 159936440, 143705524, 165912027, 100148051, 160795980, 304185384, 155308918, 180173783, 2494686, 273193859, 299384074, 165902045, 181869563, 202602190, 100184464, 159937579, 160796399, 180172635, 102111547, 2497921, 273163251, 299396274, 100142980, 222463059, 155307572, 176613352, 180176709, 100482429, 2480495, 273149606, 102085731, 185023118, 133143465, 164696471, 165901118, 288470265, 168241351, 202601924, 159938733, 299355909, 160796294, 10687398, 2480487, 2480491, 185022515, 165900128, 104148941, 133137699, 100184572, 180172625, 100484324, 164696298, 159935993, 2498415, 273154524, 102112205, 299396361, 273199666, 304185377, 100174403, 165917716, 222457820, 104135740, 176633068, 180174878, 159937050, 264619828, 2492943, 155308427, 299386420, 304185321, 165919488, 304189805, 116900717, 133153088, 304185485, 100148870, 104128292, 143705569, 302565958, 273187271, 102098771, 222458165, 100483288, 159937287, 10042909, 159937319, 288439939, 9515886, 202601299, 160795932, 180173413, 176639208, 181870117, 155308616, 299380246, 133156786, 302565983, 302565978, 304185491, 165917884, 100174417, 304185379, 104135750, 180174857, 104135783, 222457844, 180174834, 6094046, 100484007, 10731929, 2492960, 264619899, 299386541, 273199902, 159937054, 164696496, 176633109, 9694782, 9612559, 165910870, 116897567, 304185338, 133145869, 100147705, 176643378, 143705606, 104120669, 222460390, 2491534, 100483028, 164696604, 159936301, 180174084, 102095785, 273187735, 159936266, 288444149, 10496117, 299370844, 100523475, 100153417, 302565904, 176635189, 165911579, 143705648, 133148537, 304185310, 102100309, 273183562, 180174214, 159937197, 9701857, 155308654, 299377677, 165907573, 100160095, 302565824, 222467018, 140698905, 133168422, 104150646, 116895440, 100482580, 273208080, 164696309, 159938571, 180175869, 176614434, 2474156, 102092495, 299359329, 116898548, 302565901, 2490266, 100483422, 133148896, 102100269, 222458943, 159937263, 100153290, 143705654, 273183210, 165911037, 304185308, 176635061, 180174288, 299377441, 155308666, 116896838, 116896878, 222461878, 273189436, 102094766, 180174005, 116896953, 176650601, 159936520, 9409796, 140698857, 100147048, 133155101, 165921416, 104114949, 100482914, 288446806, 159936522, 299381204, 155308974, 104108753, 160796163, 121513394, 165904076, 202600648, 222463967, 176607298, 100171527, 133140391, 2481819, 116901139, 100481524, 273134485, 102089057, 159937810, 180177776, 160796164, 202600651, 181869781, 299350879, 155306364, 2481817, 299350862, 133155020, 302565923, 121498444, 304185282, 176650645, 104115592, 165921569, 102094941, 5229490, 180173970, 273189283, 100147203, 299380944, 159936546, 104135409, 100143233, 133150075, 273192320, 165918819, 102103070, 176640965, 222458384, 180175457, 100483856, 2493220, 159936178, 299381493, 2493214, 304185387, 222459173, 180173585, 8104397, 176653431, 159936328, 100148209, 273194664, 134111940, 165911917, 155308921, 299385090, 304185286, 102094773, 176650590, 100147079, 304189828, 185018224, 304185498, 165921434, 104115013, 133154826, 273189403, 116896922, 222461874, 2482513, 100482926, 180174001, 159936530, 155308968, 299381145, 304187327, 304185311, 100153399, 133148650, 304185553, 165911510, 304189801, 302565905, 143705646, 116898569, 116898574, 104122193, 222458905, 273183613, 102100299, 176635168, 100483447, 9687165, 159937213, 159937216, 180174253, 299377808, 155308643, 100171867, 185022640, 165903945, 116901109, 176607173, 222464147, 2481714, 180177678, 159937726, 100481685, 133140352, 102089191, 273133880, 299350403, 155306300, 100172401, 165901664, 140698860, 133135440, 116894347, 304185589, 104146907, 222455648, 302565842, 2497266, 273163984, 176617928, 100484250, 159937545, 180172708, 176617915, 102111322, 299392204, 299392455, 165193309, 165193310, 176633811, 304185514, 102105106, 165914086, 100182075, 273174033, 133155905, 143705574, 116899402, 304185351, 104139875, 222460565, 2490774, 100484116, 159937098, 180174983, 155308714, 299360717, 304185314, 116896334, 100174305, 160795687, 181869956, 116896315, 273180074, 165914900, 159936499, 180174787, 222460736, 202601204, 104134889, 102102825, 164696538, 9809229, 176631440, 155308003, 299374387, 165526076, 304185219, 176613710, 104151575, 180176168, 100482600, 100160388, 165930789, 116895672, 159938549, 9752149, 202602032, 160796051, 102092902, 273207394, 299359122, 205105248, 143705558, 302565897, 102093977, 100143305, 273191671, 133153885, 165920071, 304185290, 104118147, 159937357, 176652316, 8077224, 155308820, 180173883, 299388094, 133140765, 304185235, 100145526, 143705938, 202600994, 159938349, 2480242, 116901926, 104107974, 165905019, 222464927, 180178614, 100481074, 273136932, 102088435, 176607718, 164696409, 155305984, 299350008, 133141675, 165904087, 104113502, 155309058, 143705795, 100168865, 116906995, 100482697, 222455060, 102093456, 176619071, 4408498, 273157338, 180175653, 299396523, 165930012, 116903738, 116903809, 304187286, 140698870, 304185188, 102091893, 104112807, 222462028, 100147980, 176605050, 100482545, 159938617, 9616058, 273202754, 180176418, 155307629, 165475835, 299357431, 304189888, 104108835, 304185232, 143618336, 133140519, 202600686, 100171668, 165904477, 100481587, 222464083, 180177724, 176607331, 2481792, 164696397, 159937754, 102089122, 273134137, 160796156, 202600679, 155306235, 2481784, 299350625, 2481791, 121513174, 133140262, 100148818, 222464906, 273138658, 102088518, 100481114, 164696345, 159938314, 165905049, 104108031, 7788295, 180178689, 176608008, 155306120, 299351335, 133140502, 143705978, 116900944, 222464016, 160796202, 165904452, 100171647, 2481685, 159937767, 104108823, 164696402, 180177751, 176607377, 100481565, 102089109, 273134228, 155306320, 299350690, 205111561, 116898838, 100159097, 222458810, 273199012, 133145199, 304185300, 102101653, 165912704, 176635329, 288426747, 104122923, 5231198, 202601280, 160795840, 159936470, 10094195, 159936474, 180174669, 299385766, 155308025, 5231190, 304189792, 165930745, 222467101, 176614594, 140698903, 304185221, 116895490, 104151162, 164696306, 102092741, 104151319, 100482593, 159938474, 2473958, 160796049, 273206518, 180176189, 299358724, 100515889, 165910784, 302565934, 116897570, 133145730, 222460386, 304189843, 100147710, 273187704, 176643335, 2491482, 180174082, 100483032, 102095806, 164696600, 159936303, 299370904, 9566476, 303470831, 273119451, 102089968, 304187254, 100146696, 143705754, 180177164, 246549174, 165905316, 133138977, 222463681, 176621228, 2495708, 100482226, 299346825, 159937631, 100171727, 144032017, 165904369, 104108706, 160796200, 116901076, 202600727, 133140486, 8250742, 181869794, 100481632, 176607120, 204868630, 222463821, 273134935, 180177812, 164696391, 116899367, 100181977, 165913760, 140698846, 176633803, 133155884, 304185348, 222460599, 273174222, 102105089, 2490737, 100484096, 164696521, 159937114, 180174996, 155308721, 299360923, 304189846, 304185337, 100147698, 143705605, 133145607, 165910878, 222460402, 7634625, 116897538, 302565933, 176643304, 104120627, 159936304, 180174030, 100483015, 273187754, 102095751, 164696605, 299370801)
 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 (
 LOWER(identificationVerificationStatus) NOT IN (
 'unverified',
 'unvalidated',
 'not validated',
 'under validation',
 'not able to validate',
 'control could not be conclusive due to insufficient knowledge',
 'uncertain',
 'unconfirmed',
 'unconfirmed - not reviewed',
 'validation requested'
 )
 OR identificationVerificationStatus IS NULL
 )

GROUP BY
 yearMonth,
 eeaCellCode,
 datasetkey,
 taxonKey,
 acceptedTaxonKey,
 familyKey,
 family,
 speciesKey,
 species,
 scientificName

ORDER BY 
 yearMonth DESC,
 eeaCellCode ASC,
 speciesKey ASC;


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