DOI: 10.15468/dl.pc3rs4
title: Occurrence Download

description: A dataset containing 1681995 records in GBIF matching the query:
 SELECT "year", GBIF_EEARGCode( 1000, decimalLatitude, decimalLongitude, COALESCE(coordinateUncertaintyInMeters, 1000) ) AS eeaCellCode, classKey, class, taxonKey, scientificName, COUNT(*) AS occurrences, MIN(COALESCE(coordinateUncertaintyInMeters, 1000)) AS minCoordinateUncertaintyInMeters, MIN(GBIF_TemporalUncertainty(eventDate)) AS minTemporalUncertainty, IF(ISNULL(classKey), NULL, SUM(COUNT(*)) OVER (PARTITION BY classKey)) AS classCount FROM occurrence WHERE occurrenceStatus = 'PRESENT' AND taxonKey IN (5740285, 3202936, 5250069, 5250090, 2557730, 7239373, 6159273, 3376286, 4344674, 2515351, 2515236, 2514972, 2513609, 7670473, 2627503, 5930559, 5533814, 2441122, 5786666, 3190551, 8077391, 9518324, 2433536, 2435451, 3189939, 3189935, 2436886, 5216933, 3989886, 7161168, 7814921, 4285694, 5544928, 7322393, 7322373, 2394563, 3667406, 3667721, 3667628, 3188838, 3188867, 5202793, 5202520, 3665966, 5204034, 2351064, 2351211, 2351136, 2351413, 2367033, 2360504, 5408775, 4562566, 5386028, 7505045, 7587923, 4564944, 2296805, 7066596, 9479629, 9442679, 4410150, 5392270, 4410056, 4812260, 5391882, 4307880, 5391810, 2308605, 2308541, 5199161, 7009279, 5388967, 2321012, 5391292, 5709400, 2286079, 5387817, 2288859, 5403743, 5403742, 5401239, 5401508, 5704991, 5401877, 5402627, 5402874, 5393689, 2287249, 4556286, 2284443, 5399550, 5401007, 7569785, 4243464, 3148548, 3148560, 3147913, 3138953, 3141046, 3140910, 2202786, 2205951, 3141571, 3142974, 4314683, 4314702, 8018277, 5177825, 4250826, 3128437, 3128007, 3127837, 3127691, 4416920, 3137629, 3133702, 6128436, 3122190, 8195160, 5166489, 7222196, 3120391, 3120066, 3119285, 3126046, 3125944, 3125901, 2162464, 3125765, 9321334, 2161710, 2161911, 2161467, 3123300, 7652364, 3123249, 2158821, 2176168, 2172282, 2171214, 3115131, 4550810, 2157984, 2155807, 2157278, 3119191, 2157335, 2157949, 3112994, 2157928, 2157944, 2157942, 4255472, 2153712, 2153759, 2153791, 3114343, 2155557, 4210773, 2149847, 3114679, 2149761, 2150043, 2149992, 2150089, 5170395, 2152822, 3110293, 2140406, 5168461, 3112123, 2138649, 3112098, 2141241, 2148040, 2145078, 7481364, 4487282, 3107896, 3107177, 3110041, 3104078, 1652150, 1650106, 3098176, 3098183, 3098186, 3093891, 1722140, 3092782, 3092604, 4206362, 3094899, 6931186, 3151666, 3088652, 7497356, 1422818, 3092125, 1420197, 8351995, 1420769, 1420791, 1420795, 1420828, 1420829, 1420612, 1420765, 1419894, 3037015, 3036958, 7664179, 8364220, 1325561, 8455382, 1320777, 1322674, 1321805, 1323402, 1316805, 1314773, 1319260, 7987143, 4453195, 1043978, 6027313, 4989894, 6026954, 6308164, 3637507, 3637112, 4271356, 4987920, 1032377, 1032262, 1031743, 1031564, 1031685, 5831906, 1031677, 6026972, 3639326, 1031680, 3638793, 3034552, 1031512, 1031520, 1031524, 1013526, 1010644, 5567657, 3754353, 3753098, 3032646, 7334263, 7334576, 4048052, 4048240, 5372457, 3875113, 7602322, 5670646, 7300922, 5669632, 7272312, 5370043, 3025989, 3026040, 3028431, 3028586, 3027332, 3027355, 3026431, 7501634, 3002263, 3002372, 3001270, 2989222, 5646410, 3645346, 5341768, 3798835, 2928779, 2928766, 2929892, 2931914, 2932501, 2932905, 2928624, 2928589, 2928583, 2927484, 2927522, 5356429, 5356407, 5356441, 5356361, 5356614, 5356680, 5356931, 5356971, 7600608, 5358906, 5359118, 5359067, 5359499, 5359447, 5359526, 5358301, 5352372, 5632334, 5360451, 5360465, 5360508, 5360523, 5360415, 5360417, 5345430, 5345210, 5344663, 5344424, 5356481, 5342618, 2982380, 2977222, 2971068, 2975384, 2975393, 2975262, 2974946, 2975097, 2974887, 2974876, 2974826, 2956441, 2951998, 2957966, 2965459, 2965461, 2965209, 2965232, 2965233, 2965226, 2949235, 2949250, 6366597, 7270381, 5414545, 5414550, 5336632, 2916767, 2916975, 2892272, 2914501, 4934102, 3828217, 2891628, 2891617, 7372514, 5374998, 5374933, 5375105, 5373365, 5377678, 5376481, 5376874, 5376530, 5376494, 5376785, 5375555, 5375285, 5377196, 3042439, 3042889, 3041109, 3040923, 3046850, 3046839, 3046778, 3046092, 3045193, 3045042, 3045006, 3044201, 3053950, 3050357, 3048288, 3048532, 3047633, 7853188, 2928153, 7536406, 7806790, 8227753, 5662089, 5341198, 4067281, 7294722, 7294644, 2926041, 4064572, 8386733, 2925879, 2925877, 2925754, 7294771, 2925790, 7564934, 7519710, 3172127, 3685073, 4926977, 5415100, 3725805, 4055853, 8186932, 3170878, 7353862, 3740974, 3741432, 8114833, 7683374, 7963687, 5415013, 5415014, 7727786, 7303024, 3189723, 3189760, 7784175, 3732995, 3172066, 7333212, 6410563, 5605751, 5608183, 7350989, 5341498, 5607452, 4930999, 7096205, 8118326, 3895710, 7308043, 3905970, 2927075, 3885185, 2927296, 2927030, 2926686, 7455425, 2925492, 2925515, 2925518, 7270761, 4007682, 3169329, 7223680, 5659657, 2927783, 5333408, 2888298, 2888310, 5621983, 3190845, 7407436, 7846821, 7933495, 8243150, 6447806, 7323632, 7707087, 7877091, 5568361, 5568424, 5568188, 5383909, 5383926, 5568899, 7576335, 7323834, 7323810, 7323341, 5548011, 5547989, 5384370, 5384383, 5384332, 5384342, 5384341, 6447496, 3083657, 3083667, 3083763, 3083746, 3083771, 3083773, 7644304, 6035549, 3757189, 3756650, 3083921, 3083934, 3083905, 7606014, 3084922, 3084939, 3084949, 3084958, 3084616, 8185812, 3084842, 3084883, 5384459, 5384465, 5585762, 7523432, 7746901, 8150863, 7267492, 5585975, 7314281, 8012084, 7267631, 3085435, 2874701, 8773480, 8720751, 7510471, 5652131, 5334386, 5334439, 8242651, 4036957, 2889038, 2889024, 2889030, 2888948, 2888993, 4097656, 2876571, 5331404, 2874019, 3937506, 7278926, 8402586, 3152723, 2888588, 5598839, 7504215, 4102909, 8201823, 4095186, 7298858, 4095244, 7826351, 3927790, 3033434, 3033289, 6374790, 3033584, 4938153, 3981817, 3033898, 5334188, 2888485, 2888559, 7901652, 5646136, 3711846, 3056259, 3060710, 3065883, 3066482, 3068528, 3070346, 5381097, 3079631, 5372854, 2653321, 5285053, 2865501, 5295375, 2742119, 8418777, 2771094, 5305162, 5314814, 2784401, 2856504, 2855374, 5298908, 2747939, 7881150, 2769073, 2764202, 2764337, 5289490, 2714796, 2714453, 2714301, 2713662, 2713519, 2716420, 2715206, 2708808, 7795128, 7549853, 7810452, 7998563, 8369366, 5679692, 7361239, 5676003, 5674888, 5677636, 5674620, 5289814, 5289819, 5289791, 5289793, 5289781, 5289762, 5289763, 5289731, 8420312, 5289751, 5674218, 5289709, 5290170, 5674919, 5290130, 5290129, 5679952, 5289911, 5674047, 5674110, 5289836, 5289831, 5678495, 5289620, 5289623, 5289631, 5289629, 4142153, 4146512, 4152037, 4932431, 9484350, 4135892, 4136060, 4136390, 4138669, 4127352, 4125930, 4127831, 4130246, 5289995, 5289957, 4131963, 7517279, 4136338, 4121201, 4125110, 4125808, 6710856, 4104718, 4104890, 4105208, 4128347, 4122609, 2703765, 2703696, 2703704, 2703682, 2703686, 2703731, 2703733, 2703720, 4110879, 2704234, 4152153, 2703892, 4136695, 2704112, 4118773, 4118753, 2702798, 4134633, 4134508, 2702519, 2702527, 2702529, 2703231, 2703240, 2702862, 2705737, 2705957, 2705932, 2705587, 8322034, 4154800, 8018483, 8192063, 4143386, 4142741, 4142399, 4145354, 4143912, 4143852, 4143702, 4150636, 4117648, 4111606, 4113766, 2705341, 2705350, 2705362, 2705452, 2705431, 2705373, 2705422, 9393876, 8047362, 4152259, 4151306, 2704778, 2704664, 4116709, 4113402, 2705066, 2705092, 2705141, 4123970, 2704966, 2706195, 6431764, 4126800, 4128792, 2706277, 7883427, 2706301, 2706526, 2706457, 4139625, 4139894, 2706003, 4148661, 4148721, 4149167, 2706070, 2706067, 2706190, 4108297, 4107552, 4105652, 2687948, 2650180, 5274964, 5275398, 5274858, 5211250, 9491873, 2292567, 4467502, 2294131, 2295309, 5421557, 5188774, 7425750, 2495342, 2497798, 2498109, 2498104, 2498283, 8050384, 2498054, 5788513, 2481092, 7340811, 6101013, 2494536, 2494787, 2484628, 2486147, 2484608, 2489362, 5845390, 2489071, 2489073, 2488960, 2490789, 2747750, 2493697, 2493447, 2717402, 2482499, 2481875, 5959227, 6559940, 5229045, 5229072, 2480102, 2479550, 2479851, 2475679, 2474937, 4134265, 2473421, 4154259, 5200414, 4124350, 2320998, 2320810, 2228667, 4805565, 2115724, 2110811, 2114326, 8244019, 2114446, 10329298, 4985433, 8428595, 7668385, 1007534, 1008610, 1008612, 1002621, 2940408, 3111758, 8078031, 5402340, 3137686, 3145375, 10411852, 7331548, 3084693, 3757457, 2888870, 2725229, 7563173, 4416161, 2502805, 5241445, 2527401, 5270720, 7581174, 5185859, 6101215, 2432063, 2703776, 2374521, 8953936, 5221810, 5223725, 5225137, 5225433, 8782549, 4287413, 7582319, 5221988, 9022569, 9195230, 5222820, 9187223, 2453826, 2458386, 2458438, 2455676, 2458916, 2457378, 2453882, 5225659, 2465369, 2465003, 5226308, 2465641, 2465649, 2465402, 2470656, 8566446, 2470376, 2444141, 2464899, 2444356, 2444339, 2444221, 2443876, 2447418, 2447367, 5220394, 2441533, 2442665, 2443173, 2443074, 9601519, 9803191, 2442257, 4194699, 2308549, 2321001, 3266899, 2223840, 3036157, 2219149, 2220417, 5166487, 2114769, 7484581, 5632022, 4528099, 3967193, 7426824, 2972703, 1548900, 2938473, 1195013, 1194989, 1194885, 2890995, 3596131, 7327719, 8210972, 6076957, 4211590, 3089140, 3190715, 5384889, 7975549, 3085196, 7655198, 4038524, 8012649, 7261816, 8699607, 2515982, 2515591, 7239389, 2515673, 3377362, 2514552, 8427910, 7805464, 2514415, 10797854, 2514345, 2514574, 2514484, 7954545, 2513597, 2513637, 5240299, 6164210, 2473221, 2739769, 9340142, 2458374, 9342283, 2457577, 5224480, 5224543, 7576179, 2457224, 9099408, 11205618, 6159238, 7444957, 2445496, 10755213, 2459603, 8228334, 8219807, 8991514, 8082581, 10236166, 7826520, 2701120, 2498061, 4104665, 4135683, 4105744, 9382716, 9267300, 9632508, 9462721, 9405036, 9379326, 2498325, 11335341, 4154206, 4845821, 10920460, 12246414, 4123394, 6431611, 4121365, 4128881, 4113111, 5674825, 4138275, 2705287, 2703867, 4132902, 4132112, 4142335, 8112114, 5289726, 4114858, 8338571, 2479694, 2702543, 2480317, 7528816, 8389446, 6313049, 12205713, 2705828, 2705848, 2705875, 4155246, 2497828, 8918909, 5739284, 7226794, 9473367, 10986555, 4132188, 4121049, 4121360, 7948459, 9231612, 10800064, 7738621, 4146851, 9317568, 2367913, 2443339, 5289670, 4149175, 2705391, 2723909, 7540482, 2714166, 2426658, 3746867, 10857535, 9662775, 2431993, 7536754, 5285385, 6476579, 2653389, 2653392, 3697259, 4561827, 3188847, 8045384, 3666059, 4567449, 6427623, 8305409, 5190912, 5795017, 3799170, 8791507, 6402873, 5581279, 9060332, 7324507, 7225712, 8864505, 4194303, 3152839, 4202184, 11162940, 7863397, 5688347, 10730110, 4346612, 3790832, 10773250, 2971024, 7769230, 7225456, 7302355, 5041423, 9551728, 5360221, 8261015, 5349991, 1349836, 5354675, 5928735, 2965250, 7373959, 2965405, 7926816, 3826854, 8391331, 3826756, 2891621, 1835422, 9711656, 6420901, 9405645, 4273336, 2088481, 7600329, 7769968, 4487660, 4485839, 7318199, 2012520, 3837891, 7300414, 3982013, 3033868, 3982284, 7277946, 1623077, 9673106, 2211487, 5928306, 4417132, 3693336, 3053399, 2225770, 3045082, 3048073, 3047147, 7711892, 2152793, 9067615, 2141622, 11528335, 8264893, 3066321, 8427207, 2173887, 8345607, 7104074, 7266656, 5583195, 7266329, 7427741, 3189474, 8332078, 6913500, 4544661, 4544759, 3707394, 4549071, 9554442, 3084748, 7288892, 7624620, 2888990, 4036350, 2888945, 4985069, 2888955, 8909872, 2889198, 7298085, 8129694, 7136602, 3755928, 3757050, 3757660, 9454901, 7323251, 3083888, 7685459, 3083659, 8160803, 7282357, 5588185, 5586656, 5384782, 8419625, 7757300, 4211074, 5392271, 3108121, 3107362, 3107661, 7223177, 7222255, 10629881, 10108775, 3121547, 3121593, 4233822, 11136683, 3123262, 9541940, 5387537, 10948891, 4248063, 3089549, 8708866, 6076279, 6302047, 6300531, 10676000, 3132567, 3110905, 3089142, 11794300, 3170260, 7480365, 7224069, 6550056, 6027290, 5371869, 5539680, 12132283, 8326061, 2879411, 4205304, 4103685, 2888805, 5598788, 5599249, 2888799, 9771172, 2888796, 5549698, 7332517, 7359335, 7757431, 7308335, 3893979, 10646747, 3890974, 3898065, 2927029, 3896203, 5341447, 3736228, 9629891, 8602699, 2925616, 8983123, 5414989, 5415006, 8006893, 3189696, 7332416, 5559825, 7327959, 6400569, 8076173, 2874718, 5671095, 2984537, 3025764, 11844792, 5363613, 3000384, 2988224, 7219988, 2988040, 7925720, 7882872, 7499940, 7272185, 3026906, 3026426, 3012426, 5365494) AND (continent = 'EUROPE' OR countrycode = 'BE') AND "year" &gt;= 1900 AND hasCoordinate = TRUE 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 coordinateUncertaintyInMeters &lt;= 10000 GROUP BY "year", eeaCellCode, classKey, class, taxonKey, scientificName ORDER BY "year" DESC, eeaCellCode ASC, taxonKey ASC;

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