DOI: 10.15468/dl.57rsur
title: Occurrence Download

description: A dataset containing 5213640 records in GBIF matching the query:
SELECT "year" , GBIF_EEARGCode(1000, decimalLatitude, decimalLongitude, COALESCE(coordinateUncertaintyInMeters, 1000)) AS eeaCellCode, speciesKey, species, establishmentMeans, degreeOfEstablishment, pathway, COUNT(*) AS occurrences, COUNT(DISTINCT recordedBy) AS distinctObservers FROM occurrence WHERE countrycode='BE' AND occurrenceStatus = 'PRESENT' 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 "year" IS NOT NULL AND taxonKey in ( 8190643,2688345,2688393,2688369,2688434,6385542,2688381,2688410,2688270,4926451,7452468,2687927,2687940,2687920,2687937,2687932,2687929,7924597,2650133,8148679,2650165,9225633,8049341,2651315,5274858,5274861,2650107,3913526,2650818,2650832,2650841,2650669,2650720,2650625,8108066,8108066,8108066,2650632,2650716,2650702,8150126,7310610,2650999,2650903,7296752,2651495,5275316,2651113,7319269,4044517,8915858,8915858,8915858,8915858,5275149,5275102,5274951,5649577,2687885,2653321,5285637,5284809,5284809,5284809,5285565,5285385,5285635,5285053,5284982,5284884,5284794,5284827,5284950,5284871,2685796,2686212,2686157,2687210,2687182,2685484,2684984,2684120,5284237,2684191,2684171,2683866,5284517,2882437,2882437,2882437,2882437,7551339,6435002,7313595,2873991,2869101,5330661,5330661,5330661,5330092,5330085,2867589,2867631,2867614,2867569,4097481,5328882,5328909,5328689,2865152,2865125,2864546,2864552,2864467,5329266,7707728,5329212,2865565,5329192,2865526,5329338,5329434,2865260,2865280,2863938,4009380,7689610,7361877,5301204,5301231,5642073,8351789,6389089,5301162,5301175,5301213,5301141,5301183,5301140,5301147,7289632,5301226,7871428,2864004,5602614,2755063,5295911,2739622,5299536,5300535,5299797,5299816,2753146,2753079,2820517,2795845,2795952,2795869,5319226,5318948,8998684,5318906,5318980,2849252,2805343,2805322,2816176,2816213,2840931,2817361,7919491,2797913,7845022,2840425,2840474,2792588,3655061,2792998,5324951,5324959,2812375,2849624,8794742,2809968,2808461,2808565,2808426,8248593,8248593,8248593,2810532,7631065,7631065,7631065,7861697,2810677,8179794,8179794,8179794,2747489,2747564,5298675,5298231,5298069,5298765,5296178,2747939,2781103,2857616,7792960,2857071,2855968,9177060,2855963,2855717,2857017,2858244,2858581,2855356,2855356,2860425,2769766,2768885,2768885,2768885,7459480,2770004,2770228,2769317,2773448,2773453,2773290,2773057,7989830,2767506,2769204,2772020,2772094,8152187,2773902,2773942,7679536,7679536,7679536,7679536,2702266,2702384,5289423,5289503,2700736,2700706,2700874,2700828,2700934,2700896,2702084,2702084,2702084,2701599,6413621,6413649,2701578,2701736,2701665,2701841,2701799,2702048,2701869,2701957,2701900,2701571,2701261,10027741,2701930,2701339,2701339,2701612,2730127,2730210,2730137,2717570,2717493,2717641,2717467,2716838,2717898,2717002,2717002,2717002,2717400,2710650,2713142,2713316,2710592,2710592,2710592,2718302,2718377,2720080,2720120,2720269,2718201,2711190,2710941,2711157,2730906,2716226,8243603,2715482,2731327,2709923,2728870,2728143,2726956,2723410,2721897,2724439,2723073,2721983,2724120,2724120,2724120,2728514,2722210,2722926,2727765,2723371,2723156,2727917,2722380,2726894,2723188,10960168,2722602,2722760,2723508,2726010,2723521,2728963,2725754,2726545,2729050,2726880,2725388,2725414,2721893,2721893,2724661,2728531,2726725,2722046,2718117,2724729,2710421,2724925,2727655,2729177,2729081,2724108,8346717,2726614,2725766,2727038,2722950,2724284,2722051,2722051,2722051,2727195,2727938,2723055,2726592,2725881,2724609,2705090,2705090,2705090,2705167,2705098,4125308,2705144,2705144,2705144,2702808,2702816,2702816,2702816,2702816,5289686,5289686,5289686,5289684,5289698,5289666,5289972,5290003,5676646,2704102,7738766,2705449,2705369,2705378,2705401,2705339,4139037,5290126,2702905,5290149,2703250,5289877,5289877,5289877,2702717,2706196,5289756,2705972,2703336,2705921,2705914,8311670,5289906,2706164,2706163,5290194,2703592,2704505,2703793,6559940,2705297,2705286,2705300,2705295,2705290,2705290,2705290,8059811,4149465,4130991,5289582,7747216,5290068,5290069,2706368,5290319,2704160,7325083,4154442,2706242,7883427,7795888,7886346,7886346,7886346,2706053,2706068,2706052,8332019,2706056,2706056,2706056,5290097,5672393,5290090,5290083,5289917,5289913,5289919,5290177,2706011,4139238,9014945,5290186,4151143,4108861,6431455,4108217,2706444,2706465,2706458,2706490,4122968,2706435,2706541,5289642,5289643,4116392,4118973,5290142,5290146,2704395,2704841,2705308,2705308,2702789,2702793,8086756,2704179,2704194,2704261,2704300,2704178,2704178,2704178,2704211,2704265,2703705,2703764,2703778,2703778,2703659,4932846,6084960,4112836,4112404,2703648,2703751,2703761,2703664,2703722,2703727,2705315,2705228,4105452,2705484,2705495,2705512,2704687,2704688,4149119,4145057,5289598,2704913,2704913,4122081,2704922,2704922,3073,8213826,2705011,2704951,2704951,2704951,4121486,2704913,2704913,2704913,2704966,4118209,4120709,4115695,4117276,4120440,3073,3073,4125878,4126597,4126612,7587545,2882398,2882404,5334186,2888439,2888445,2888427,2888464,2888464,3601414,5530881,7315229,7315063,5334215,5334216,5530883,5334217,5334217,7695021,6375040,3033108,3033108,3033227,7278276,5371702,5371473,3033191,3033833,3033665,3033665,3033665,3033266,3927746,6375391,3033518,3033605,8246651,5371707,5371709,8310009,3033312,3931003,3033374,3033348,3033483,11011124,9100915,3033363,3033363,3033363,3033329,3033339,3928735,3922323,7278260,3923698,8365713,3033464,3033377,3926532,3033382,7278019,7278019,7278019,9094061,7509607,3033129,3033129,2984671,2986185,2986192,2986184,2986097,2986129,2986130,3032833,3032758,8028512,7526486,7339315,3032698,5362055,5362054,2985949,4200522,5690287,7172720,5362008,5361982,5361991,5362007,2406,5362004,2985865,2985865,2985865,4201607,5361779,5361760,5361773,5361762,5361785,5372392,5372392,3039209,3039203,5356345,5354676,7681436,5354707,5354656,5386,5386,5347612,5347571,5347824,5347702,5355395,2963817,2964355,5352251,2975667,2956441,5343253,5350466,2975152,2974988,2975188,2975188,2975188,2974946,2974922,2974786,2974811,2974811,2974751,2975053,2975014,2974753,2975309,2975087,2974751,5359721,5350010,5356704,5356662,5356631,5356393,5356393,5356393,5356701,5356412,5356522,5356623,5356488,5356649,5347845,5347845,5347845,2977234,2977214,2977149,2977149,9616723,8026358,7520471,7592856,2965201,9151957,9151957,9151957,2965531,8347243,5359047,5358748,6109535,6109535,6109535,5359169,5359060,5359477,5359429,5358683,5359246,5358977,5359378,8324121,5358812,5359249,5359209,5358907,5359330,5357013,5356973,5352367,5352367,5352367,5352367,5358266,5358256,5348647,5350005,5353705,5353750,2972595,3191414,3191374,3191374,3191374,3191374,7293616,7293605,3012089,2988354,3026585,3026819,7889822,3026431,3026406,8170635,2994912,2992808,2993761,2993094,2995149,2995209,2994822,2991652,2993012,2990412,2994551,2991260,2990369,7657760,2997591,2997376,2997778,2990618,2989551,2992543,2997827,8127026,2994157,2997421,2991019,2994562,2996929,2995779,2994335,2990967,2995253,9293593,2995030,2990923,7786853,8181078,10783897,2993073,2990014,2996763,2994419,2997264,2992165,8289268,2989301,2997343,8674642,2995861,4923926,2990625,8348564,2995870,2990818,7621087,12256997,8207950,2999493,2990855,2989529,8248614,2995864,7444839,2991290,7880586,2990614,7449823,2990622,7805238,8358255,2990748,2988903,2998969,2988867,7391303,2994052,2990359,11220454,10766846,2989420,2997310,2998745,2999696,2988912,8209375,2999825,2993649,3854984,4938434,2995958,8846677,2988765,2999817,9422770,2999360,5369701,5366327,5366090,8011540,5365888,5367294,5365305,5365305,5365705,5367273,8182596,10903138,7436088,5365717,5367246,3001836,5370380,3020532,8400458,3029817,8350369,2988069,2987999,2987999,3001956,3002121,3029627,5364245,5364245,5364245,3027640,3028198,3027437,3027437,3027437,3027485,3027485,3027485,3028763,5365013,3007054,3011150,8313600,8467212,3002461,8250315,10761796,3008017,7578787,8269038,3002245,3003248,3002154,3004635,3003244,8174785,3007315,3004370,3002496,3003979,3002300,3002333,7699588,3003708,3005325,7934161,12205752,3021850,3021037,7818643,8149923,3023221,3021730,7931731,7931731,7931731,3022789,3021922,3020791,5362215,3025576,3025617,3026049,3026040,3026074,3026004,3026162,3025896,3025932,3026092,3025564,3026160,3001509,3001509,5362573,5362573,3023878,3024109,8252683,8252683,8252683,10973763,10973763,10973763,9220780,3015106,5363613,3012167,7707106,3013206,3012567,9755562,3854116,5015,3039269,3039267,3039491,3039454,5361866,5361865,7141604,2984535,5361880,5361909,5361889,5361888,7960979,5361815,5361803,5361801,2984366,2882316,2881283,2878688,5333294,3054357,8288647,2875979,2875818,2876213,9148577,2876607,5331916,6422396,2874508,2874570,7433196,2891707,9823072,8427624,2891677,3189525,3713039,3189543,6437017,6437017,7921919,3714477,4933119,3712747,5646136,5646074,5331268,5664290,7296398,5663962,5331258,5331258,7946708,5664390,7499288,5331355,8388117,5331347,3040185,3040249,3040227,3040227,3040227,8190077,3040184,6362904,7645931,5582691,5372829,5373037,5372876,5372866,5583179,5583533,8367413,5583323,5372639,5372638,5372952,5583586,5372818,5372605,5372605,5372605,9153437,5372614,5927965,8183217,5372827,5372647,5372800,5372800,5582714,5372926,9148812,9148812,9148812,5582973,7103891,8696073,5582033,5372933,3062975,3063016,3066965,3065239,3069761,3070106,8203538,8203538,8203538,3066386,3069593,3066179,3066367,3064056,3069475,3069475,3070024,3067119,2873865,2873896,2873861,2891304,2890502,2890536,2890287,2891390,2890920,2891079,2890603,2891031,2891488,2890212,2890560,2890668,9485490,9485490,6366011,3188743,3188736,3988701,5421039,5420991,3188924,3188894,7322773,3189172,3189157,3664083,3666788,3666800,3189080,3189152,7322563,7322563,7322563,8406741,12041591,3188794,3188797,8186928,3189846,3189863,3189866,7263145,3189815,3189809,3190382,3190411,3190653,3152048,3152047,3152046,3152520,5406789,3152560,3152365,3152379,3152374,3152373,3152372,3152378,3940638,3152614,5420853,5420852,7331288,8890062,8890062,2889930,3040253,3040251,3040254,3040252,3046890,3046736,3046812,3046875,3044318,5376075,5374118,3050357,3050364,3048266,3048203,3040913,3042291,5708780,5374635,5374614,5374672,3053201,3053118,3693336,3053168,3053406,7701037,9184619,3045931,3045634,3046044,7972010,7972010,3045858,3046187,3046076,3046258,3690997,3046015,3052509,3052509,3052450,3052436,5374998,9202524,5374838,5374922,5376000,5376286,3042086,5373322,3044855,7292989,5377778,5373358,3112,7473187,7473187,7473187,5373254,5373276,3042416,9040863,5376179,3045282,3045463,3045463,5377163,5377236,5377236,5377303,3041800,7703116,5376846,5376994,5376692,5376616,5376648,5377064,5376961,5376627,5377060,5373421,5376337,3042845,3042636,7903057,3047621,3047598,5375547,3040600,3050595,3048831,5373368,5373368,5373368,5373533,3048782,3040983,3040983,2889828,5334510,3082322,4088825,11310169,2888995,2888951,2888992,4033306,7291247,2889019,2888960,2888963,2888978,2889011,2889011,2889011,2889035,2888980,4037603,7821030,7821030,7821030,8323622,6391648,6391194,2889262,2889262,2889262,2889262,7925535,4037343,5334351,6391461,6391461,6391461,6391446,4038485,3191157,8089871,5384470,3085370,6364297,3085776,6363434,6363434,6363434,5384604,6363436,5584066,5384676,5384606,8127028,5384616,3085313,3085349,3085475,3085433,3085458,3085458,3085458,3085458,3085439,3085439,3085440,3085469,3085469,3085469,3085464,7841283,3085388,3085402,8941837,8941837,8941837,3085407,3085894,3085894,3085895,5384680,3085798,3085797,5384589,3085381,3085810,3085810,3085810,3085811,3085814,7570897,7736551,8153621,3085368,5384805,5384834,9172281,9172281,9172281,8406661,5384774,7746901,5384781,5384818,5384848,5384738,10953644,5384741,7268098,5384457,3085360,3085320,3085320,3085619,6363496,6364219,3085424,8400876,3085413,6109611,7323711,6109534,5384364,5384364,5384364,5384364,5384364,5384364,5384364,7905507,5384395,5548401,5384373,8911082,12239479,12239479,6035873,6035873,6447704,3083541,6035538,3064,7547827,3083975,3083838,3083903,3083920,3083862,8127633,5568446,5568428,5568339,8044896,8273130,7551162,8149099,8290282,7418706,7725469,7725469,7725469,8117283,8971274,8971274,3083647,3083718,3083761,3083680,3083783,3083696,3083728,3757720,3083786,3083786,3083786,3083786,3083786,3083660,3756031,3756036,3084022,3084015,3086240,7736011,3084742,7357900,9004024,5384287,5384287,3084719,3082234,3082244,2891770,2891783,2891782,2927850,4006551,5414335,8377689,5414326,3169329,3169379,7702019,3169358,3169386,3169340,4007442,7939955,8272844,4005183,8184903,8368021,3169313,7127810,2882482,5333412,5333411,7327990,2883007,5333413,2882841,2882835,2882833,8925249,2888298,2888292,2888269,2888276,8249145,8249145,8249145,5339050,5339050,2916662,2917026,2914642,2914338,9063248,2913288,2913130,2913130,2913130,2913727,9039392,9039392,9121716,2913515,2913515,2913515,2913556,2913169,2913214,2914590,5338920,3841406,3841586,5414469,7439391,5414457,6366886,3841866,3170040,3170115,7270598,7270427,7539382,8196434,7270648,3169707,3169708,3170247,2925767,2926110,2926048,2925892,4058401,4062037,2925901,5341204,5439925,7294681,5341203,7958783,7294673,2925756,7295106,2925815,7558421,7558421,2926066,2926068,4067302,4067281,5341175,5341177,5661343,5341190,5341170,7589756,5341184,7730039,12186874,12186874,5662089,5341199,5341202,5341197,2926130,2928226,2928390,2389,3610757,2927518,3678256,2932737,9150405,9150405,9150405,2931237,2932144,2930805,2930262,2930137,2928835,2928751,5341754,7717,7717,7717,3172347,3172358,7325877,3172348,3172348,3172348,3172300,3172291,3172266,3684450,5421111,3189739,3189755,8208358,3189747,3189767,3189767,3189762,5372503,8306779,5372487,7647358,5372484,3172070,3725447,3172068,3172077,3172100,3172071,3172082,3172074,3172048,3172119,3172116,7331926,3172104,3172057,3172049,3172072,3172062,3172086,3172092,7332572,7874883,8328247,8046918,3725062,3172118,8200663,5415020,5415019,5562956,5415009,8287616,3170819,3171145,3171915,5414995,5414990,5414992,5578472,3173338,3171943,3171949,3171939,3171948,3171947,3171941,3171945,3172211,3170866,3170866,7810918,3170873,8602699,3171888,3172427,7297904,3172414,7658928,3172413,3172429,5415065,2925529,2925514,2927189,2927190,7510173,2927175,2927175,2927175,2927192,2927192,2927192,2927192,8004895,8004895,8004895,7858518,8707933,8707933,8172952,2927185,2927185,7923052,7923052,3902478,2927004,2926995,2927028,6409706,5341387,2926612,5341449,5341449,5341449,6409622,5341443,5341442,2926885,2926884,8916040,8916040,8916040,5341501,5341499,2926557,2927324,2927324,2926683,2926684,2926682,8941778,2926681,5341310,5341303,5341300,5341308,5341309,2927298,2927235,2927229,7306931,2927282,2927245,2927297,2927280,2927069,2926894,5341389,7666664,5341296,5341297,2926759,5341345,5609719,2927080,8429926,2927079,7308294,2926901,6411747,6411747,6411747,7945074,7346090,7346102,3730664,3173271,7519710,3733128,7332642,7943745,7718653,3731346,3728894,7331741,7331741,7331741,3725765,8106874,8106874,3171980,3171979,3171964,7855120,7564934,8971475,8971475,8971475,3171818,3172045,3172045,3172045,3172042,3172042,3172042,3172043,5414239,5410857,5409933,5410907,5411475,5411920,5411408,5410480,5410411,5410151,8022456,3166917,3166655,3166655,3166655,8366345,5408512,5408353,5341511,8810827,5402943,6446462,5389017,5389029,3098616,3091677,3151618,8421156,9202318,3147080,3117449,3117449,3117449,3146791,3146717,3115755,7533148,11665063,5385604,7995437,5390848,3147760,3131809,3065,4933624,7502456,8229935,3101193,6443643,5391074,5389173,3110686,8002952,3110588,3089150,3089154,3089146,5402620,3114229,3119175,3119181,5391710,5392083,5392174,5392145,5391862,8298495,5387817,3102781,3120333,3120024,3103791,3104173,5401008,3118274,3118430,3118216,3112110,8542672,3092691,3120946,3120790,3121461,3121650,3121088,8373355,3121226,3149879,3088282,9490132,7749287,3088310,5405976,7363445,3130936,7903764,3107361,3107060,3108983,3107855,3107987,3109117,3109086,10380222,5388595,5388602,8340600,8340600,8340600,3142951,3143034,4230874,3142974,5391480,9182765,5392683,5392883,3105380,5393080,5393111,5393103,5393103,5393103,3114627,8185959,3114643,3114649,3114649,3113650,3112801,3112620,3112620,3112620,3113458,3113745,3112651,3113637,3113414,3113414,3113414,3113414,3094900,3128888,3128483,3127727,8087525,3128166,3128547,3128547,3128547,3128228,3128225,3128156,5386027,5386012,3138327,3138230,5392252,3134857,3134857,3134857,3087403,3093693,3093702,3093702,3093702,3065,3137498,3137498,3137498,3137498,3137498,3137498,3137498,3137498,3093337,3141855,6443709,5386897,5386897,5386897,5386938,3111049,5397911,5699450,6064015,5698445,5697988,7923693,5393876,5698520,7537576,8053079,5694900,5698968,5698171,5698060,7882948,5696416,5696484,5696921,5394278,5698122,5699449,6082564,5698760,5694743,5696921,5699306,5394200,5696819,5697799,5695779,8228544,3105650,3140574,3140467,3140490,3140346,3140320,3140436,3140436,5403470,4245384,5403709,5403302,5403296,5403272,5403508,5403304,5403531,9458333,3123262,3123717,3122924,8288930,3123021,3123663,6300805,3135601,9689880,8605056,7647400,7485421,3135329,3136606,2888794,2888728,2888723,2888605,5334227,5334259,5599249,5598915,5334240,8012439,8435025,2888814,4102733,7443846,2888808,2888811,2888802,2888802,2888740,7298931,7298987,2888762,2888763,2888763,2888769,2888789,2888773,8351737,8168344,3034606,7978544,3034426,3034391,3034915,6027128,3034681,3034650,3034653,3642531,5371742,5371746,5371743,3034233,3034819,3034820,3034823,3638282,3034523,3034778,3034871,5371870,6027105,3635987,3034554,5371879,3631418,3631293,3631293,3631293,7828157,3641433,3634745,5371864,3034182,5371753,3034714,3034501,6026760,3034620,5371874,7622278,3034530,3034699,3034922,3034646,3632234,6026420,3632301,5371825,5371825,5371825,5371888,5540419,5371890,6027222,5371889,5540332,5540247,6027319,6026490,5371818,5371808,5371781,6027388,3634395,3639144,3638577,5540777,8262702,8262702,8262702,3034830,3034830,3034830,3034825,3633319,6026401,3630948,3034742,3034742,3034742,6027089 ) GROUP BY "year", eeaCellCode, speciesKey, species, establishmentMeans, degreeOfEstablishment, pathway ORDER BY "year" DESC, eeaCellCode ASC, speciesKey ASC

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