DOI: 10.15468/dl.63mdsh
title: Occurrence Download

description: A dataset containing 1752457 records in GBIF matching the query:
SELECT
"year",
 GBIF_EEARGCode(
 1000,
 decimalLatitude,
 decimalLongitude,
 COALESCE(coordinateUncertaintyInMeters, 1000)
 ) AS eeaCellCode,
 GBIF_Within('POLYGON ((2.613756 50.47394,
 2.625668 50.47367,
 2.624703 50.46334,
 2.648526 50.4628,
 2.671986 50.46227,
 2.671956 50.46194,
 2.672328 50.46194,
 2.670397 50.44161,
 2.694222 50.44106,
 2.695212 50.45139,
 2.707133 50.45111,
 2.719056 50.45083,
 2.718058 50.44051,
 2.741903 50.43995,
 2.789625 50.43882,
 2.837386 50.43767,
 2.885188 50.43649,
 2.93303 50.4353,
 2.980912 50.43408,
 3.004867 50.43347,
 3.007075 50.45411,
 3.031058 50.45349,
 3.055051 50.45286,
 3.079054 50.45223,
 3.081317 50.47287,
 3.153439 50.47094,
 3.151123 50.4503,
 3.175166 50.44965,
 3.199219 50.44899,
 3.223281 50.44833,
 3.247354 50.44766,
 3.259394 50.44733,
 3.258198 50.43701,
 3.270236 50.43667,
 3.269036 50.42636,
 3.317195 50.425,
 3.318412 50.43531,
 3.330463 50.43497,
 3.342515 50.43462,
 3.354571 50.43428,
 3.366628 50.43393,
 3.365393 50.42362,
 3.413631 50.42222,
 3.414883 50.43253,
 3.426953 50.43217,
 3.428211 50.44248,
 3.440288 50.44213,
 3.464449 50.44141,
 3.488619 50.44069,
 3.5128 50.43996,
 3.53699 50.43923,
 3.56119 50.4385,
 3.585399 50.43775,
 3.609619 50.43701,
 3.633848 50.43625,
 3.658087 50.43549,
 3.682335 50.43473,
 3.706593 50.43396,
 3.730861 50.43319,
 3.755138 50.43241,
 3.779425 50.43162,
 3.797647 50.43103,
 3.796951 50.42588,
 3.803025 50.42568,
 3.800933 50.41022,
 3.84952 50.40863,
 3.850932 50.41893,
 3.863089 50.41853,
 3.875248 50.41812,
 3.873828 50.40782,
 3.898145 50.40701,
 3.946809 50.40537,
 3.971155 50.40455,
 3.972611 50.41484,
 3.984792 50.41443,
 3.996976 50.41401,
 4.009161 50.41359,
 4.02135 50.41317,
 4.019876 50.40287,
 4.044251 50.40203,
 4.068635 50.40118,
 4.071619 50.42178,
 4.09603 50.42092,
 4.120451 50.42006,
 4.144882 50.41919,
 4.169322 50.41832,
 4.193771 50.41744,
 4.21823 50.41656,
 4.242699 50.41567,
 4.267176 50.41478,
 4.291664 50.41388,
 4.31616 50.41297,
 4.340666 50.41206,
 4.365182 50.41114,
 4.389706 50.41022,
 4.392926 50.43081,
 4.442039 50.42894,
 4.46661 50.428,
 4.469886 50.44859,
 4.494484 50.44765,
 4.519092 50.44669,
 4.543708 50.44574,
 4.568334 50.44477,
 4.57001 50.45507,
 4.582331 50.45458,
 4.594654 50.4541,
 4.592969 50.4438,
 4.617614 50.44283,
 4.621002 50.46342,
 4.645674 50.46244,
 4.695045 50.46046,
 4.719744 50.45946,
 4.721476 50.46975,
 4.733834 50.46925,
 4.735571 50.47954,
 4.747935 50.47904,
 4.772671 50.47803,
 4.797416 50.47701,
 4.822171 50.47599,
 4.846934 50.47496,
 4.84338 50.45438,
 4.892899 50.45231,
 4.936257 50.45048,
 4.935353 50.44533,
 4.941548 50.44507,
 4.938832 50.42964,
 4.963606 50.42859,
 4.988388 50.42753,
 5.01318 50.42647,
 5.03798 50.42539,
 5.06279 50.42432,
 5.087609 50.42324,
 5.112437 50.42215,
 5.137274 50.42105,
 5.162119 50.41995,
 5.186974 50.41885,
 5.211838 50.41774,
 5.236711 50.41662,
 5.261593 50.4155,
 5.263521 50.42577,
 5.275969 50.42521,
 5.277902 50.43549,
 5.290358 50.43492,
 5.340203 50.43264,
 5.390083 50.43034,
 5.44 50.42802,
 5.443488 50.446,
 5.446611 50.44585,
 5.44711 50.44842,
 5.468976 50.4474,
 5.493975 50.44622,
 5.518982 50.44503,
 5.543998 50.44384,
 5.569023 50.44265,
 5.594057 50.44145,
 5.598157 50.46199,
 5.648288 50.45957,
 5.685909 50.45774,
 5.683827 50.44747,
 5.696367 50.44685,
 5.694281 50.43658,
 5.719359 50.43535,
 5.744446 50.43412,
 5.769541 50.43288,
 5.794645 50.43163,
 5.819758 50.43037,
 5.84488 50.42911,
 5.87001 50.42785,
 5.895149 50.42658,
 5.920297 50.4253,
 5.945453 50.42401,
 5.94763 50.43427,
 5.960216 50.43363,
 5.962398 50.44389,
 6.050592 50.43933,
 6.055024 50.45986,
 6.08026 50.45854,
 6.105505 50.45722,
 6.109979 50.47774,
 6.13525 50.47641,
 6.138623 50.49181,
 6.144945 50.49147,
 6.146071 50.49661,
 6.165046 50.4956,
 6.167306 50.50587,
 6.179962 50.5052,
 6.182228 50.51546,
 6.194892 50.51479,
 6.197164 50.52506,
 6.209834 50.52438,
 6.212111 50.53465,
 6.224788 50.53398,
 6.228786 50.55195,
 6.231957 50.55178,
 6.232529 50.55435,
 6.254736 50.55316,
 6.259328 50.57371,
 6.284734 50.57234,
 6.28935 50.59289,
 6.293972 50.61345,
 6.319423 50.61207,
 6.324069 50.63264,
 6.32872 50.65321,
 6.333377 50.67379,
 6.338039 50.69437,
 6.342708 50.71496,
 6.347381 50.73556,
 6.352061 50.75616,
 6.356746 50.77678,
 6.334347 50.778,
 6.334931 50.78057,
 6.331731 50.78075,
 6.335819 50.79879,
 6.340497 50.81941,
 6.316471 50.82072,
 6.316763 50.82201,
 6.315161 50.8221,
 6.319535 50.84144,
 6.306715 50.84213,
 6.309045 50.85245,
 6.296222 50.85315,
 6.303206 50.88412,
 6.27754 50.8855,
 6.282185 50.90616,
 6.256508 50.90754,
 6.26114 50.9282,
 6.235454 50.92958,
 6.240072 50.95025,
 6.214375 50.95163,
 6.21898 50.97231,
 6.221285 50.98265,
 6.234146 50.98196,
 6.236457 50.99231,
 6.249325 50.99162,
 6.25396 51.01231,
 6.258601 51.03301,
 6.263247 51.05372,
 6.289046 51.05233,
 6.298393 51.09376,
 6.307763 51.13521,
 6.312456 51.15595,
 6.286563 51.15734,
 6.291243 51.17809,
 6.295929 51.19884,
 6.300621 51.21959,
 6.274679 51.22099,
 6.279358 51.24176,
 6.259893 51.2428,
 6.26106 51.24799,
 6.254571 51.24834,
 6.258071 51.26392,
 6.245088 51.26461,
 6.247418 51.275,
 6.234433 51.2757,
 6.23676 51.28609,
 6.223773 51.28678,
 6.226096 51.29717,
 6.213106 51.29787,
 6.215426 51.30826,
 6.202433 51.30895,
 6.204749 51.31935,
 6.191754 51.32004,
 6.194067 51.33044,
 6.168277 51.3318,
 6.168313 51.33196,
 6.16811 51.33197,
 6.172685 51.35262,
 6.146681 51.35399,
 6.151279 51.3748,
 6.125265 51.37616,
 6.09926 51.37752,
 6.103825 51.39835,
 6.051802 51.40105,
 6.056335 51.42188,
 6.030317 51.42323,
 6.004309 51.42456,
 5.97831 51.42589,
 5.953131 51.42717,
 5.95327 51.42783,
 5.952458 51.42787,
 5.95678 51.44806,
 5.878804 51.452,
 5.883213 51.47286,
 5.85722 51.47417,
 5.844226 51.47481,
 5.846419 51.48525,
 5.833423 51.4859,
 5.835611 51.49633,
 5.809617 51.49762,
 5.813979 51.5185,
 5.787974 51.51979,
 5.761978 51.52107,
 5.766307 51.54195,
 5.675325 51.54639,
 5.677458 51.55684,
 5.664465 51.55747,
 5.666594 51.56792,
 5.640605 51.56917,
 5.614625 51.57042,
 5.588654 51.57166,
 5.562692 51.5729,
 5.536739 51.57412,
 5.510796 51.57534,
 5.484861 51.57656,
 5.488989 51.59748,
 5.463044 51.59869,
 5.467157 51.61962,
 5.441203 51.62082,
 5.445302 51.64176,
 5.419337 51.64296,
 5.423422 51.6639,
 5.397447 51.6651,
 5.384463 51.66569,
 5.386493 51.67617,
 5.373506 51.67676,
 5.375533 51.68724,
 5.336573 51.68902,
 5.338585 51.6995,
 5.325599 51.70009,
 5.327608 51.71057,
 5.301631 51.71174,
 5.277287 51.71284,
 5.277536 51.71415,
 5.275913 51.71422,
 5.279648 51.73388,
 5.201744 51.73736,
 5.205674 51.75834,
 5.179706 51.75949,
 5.153747 51.76063,
 5.127797 51.76176,
 5.101856 51.76289,
 5.075925 51.76401,
 5.050004 51.76513,
 5.024092 51.76624,
 4.998189 51.76734,
 4.972296 51.76844,
 4.946412 51.76953,
 4.920538 51.77062,
 4.894673 51.7717,
 4.868818 51.77277,
 4.842972 51.77384,
 4.817136 51.7749,
 4.79131 51.77596,
 4.765493 51.77701,
 4.739685 51.77805,
 4.713887 51.77909,
 4.688099 51.78012,
 4.662321 51.78114,
 4.660558 51.77063,
 4.647677 51.77114,
 4.634799 51.77165,
 4.633047 51.76115,
 4.555856 51.76416,
 4.554134 51.75365,
 4.541282 51.75415,
 4.528433 51.75465,
 4.515586 51.75514,
 4.502741 51.75563,
 4.489899 51.75612,
 4.477059 51.75661,
 4.478752 51.76712,
 4.45307 51.7681,
 4.451387 51.75759,
 4.438555 51.75807,
 4.436877 51.74757,
 4.424052 51.74805,
 4.398409 51.74901,
 4.372776 51.74997,
 4.347152 51.75092,
 4.321538 51.75186,
 4.318273 51.73084,
 4.292688 51.73178,
 4.267113 51.73271,
 4.265501 51.7222,
 4.252722 51.72267,
 4.251116 51.71216,
 4.238344 51.71262,
 4.212808 51.71354,
 4.187282 51.71445,
 4.18412 51.69344,
 4.133135 51.69524,
 4.130016 51.67424,
 4.104557 51.67513,
 4.101848 51.65676,
 4.098668 51.65687,
 4.098282 51.65424,
 4.076031 51.65502,
 4.074494 51.64452,
 4.061788 51.64496,
 4.060256 51.63446,
 4.047557 51.6349,
 4.022166 51.63577,
 4.019135 51.61478,
 3.968421 51.6165,
 3.965431 51.59552,
 3.940107 51.59637,
 3.938623 51.58588,
 3.92597 51.5863,
 3.924492 51.57581,
 3.911846 51.57623,
 3.910373 51.56574,
 3.897734 51.56616,
 3.896267 51.55567,
 3.883636 51.55609,
 3.882174 51.54561,
 3.86955 51.54602,
 3.868094 51.53554,
 3.836556 51.53657,
 3.837278 51.54182,
 3.830971 51.54202,
 3.833135 51.55775,
 3.807899 51.55857,
 3.782673 51.55939,
 3.757457 51.5602,
 3.732252 51.561,
 3.735064 51.58198,
 3.709849 51.58278,
 3.65945 51.58436,
 3.634266 51.58514,
 3.637006 51.60614,
 3.611812 51.60691,
 3.586629 51.60769,
 3.589335 51.62869,
 3.564143 51.62945,
 3.513789 51.63097,
 3.488627 51.63172,
 3.491261 51.65273,
 3.46609 51.65348,
 3.44093 51.65422,
 3.41578 51.65495,
 3.39064 51.65568,
 3.36551 51.6564,
 3.34039 51.65711,
 3.315281 51.65782,
 3.290181 51.65853,
 3.28894 51.64802,
 3.276399 51.64837,
 3.275163 51.63786,
 3.112423 51.64228,
 3.062437 51.64359,
 3.060127 51.62257,
 3.035168 51.62321,
 3.01022 51.62385,
 2.985281 51.62449,
 2.98303 51.60347,
 2.958121 51.6041,
 2.933223 51.60472,
 2.931012 51.58371,
 2.906142 51.58433,
 2.905047 51.57382,
 2.892621 51.57413,
 2.891531 51.56363,
 2.854282 51.56454,
 2.852132 51.54353,
 2.827331 51.54413,
 2.825468 51.52576,
 2.822371 51.52583,
 2.822105 51.52321,
 2.80043 51.52373,
 2.775668 51.52432,
 2.77358 51.50332,
 2.748847 51.5039,
 2.724125 51.50448,
 2.722076 51.48349,
 2.697382 51.48406,
 2.672699 51.48463,
 2.67069 51.46364,
 2.646036 51.4642,
 2.621392 51.46476,
 2.619422 51.44378,
 2.594808 51.44432,
 2.59298 51.42466,
 2.591443 51.4247,
 2.591322 51.42339,
 2.568273 51.42389,
 2.543697 51.42443,
 2.541788 51.40346,
 2.492705 51.40452,
 2.491769 51.39403,
 2.47951 51.39429,
 2.478579 51.38381,
 2.466327 51.38407,
 2.44183 51.38458,
 2.417344 51.38509,
 2.415757 51.36675,
 2.412699 51.36682,
 2.412473 51.3642,
 2.391073 51.36464,
 2.366626 51.36513,
 2.365295 51.34942,
 2.359189 51.34954,
 2.358746 51.3443,
 2.340434 51.34467,
 2.316026 51.34515,
 2.31429 51.32421,
 2.289912 51.32469,
 2.265543 51.32516,
 2.263846 51.30422,
 2.239507 51.30469,
 2.238039 51.28637,
 2.234999 51.28643,
 2.23479 51.28381,
 2.213519 51.28422,
 2.212276 51.26852,
 2.206203 51.26863,
 2.205791 51.2634,
 2.18758 51.26374,
 2.186352 51.24805,
 2.180287 51.24816,
 2.179879 51.24293,
 2.16169 51.24327,
 2.160074 51.22236,
 2.135849 51.2228,
 2.134252 51.20189,
 2.132658 51.18099,
 2.120568 51.18121,
 2.119776 51.17076,
 2.118984 51.16031,
 2.106905 51.16053,
 2.105333 51.13964,
 2.103762 51.11876,
 2.102194 51.09788,
 2.100627 51.07701,
 2.099062 51.05615,
 2.097499 51.03529,
 2.121551 51.03486,
 2.118396 50.99317,
 2.142423 50.99273,
 2.14083 50.9719,
 2.139239 50.95107,
 2.13765 50.93025,
 2.161634 50.92981,
 2.160029 50.90899,
 2.15363 50.82581,
 2.152035 50.80503,
 2.175923 50.80459,
 2.174312 50.78381,
 2.172704 50.76305,
 2.1906 50.76272,
 2.190195 50.75752,
 2.196161 50.75741,
 2.194943 50.74185,
 2.19332 50.72109,
 2.217159 50.72064,
 2.215521 50.6999,
 2.239352 50.69945,
 2.237698 50.67871,
 2.261522 50.67825,
 2.259853 50.65752,
 2.28367 50.65706,
 2.281985 50.63634,
 2.305795 50.63587,
 2.304095 50.61516,
 2.327897 50.61468,
 2.345756 50.61433,
 2.345323 50.60915,
 2.351276 50.60903,
 2.349977 50.5935,
 2.373782 50.59302,
 2.385689 50.59278,
 2.38481 50.58243,
 2.396714 50.58218,
 2.395832 50.57183,
 2.41964 50.57134,
 2.440481 50.57091,
 2.440256 50.56832,
 2.443234 50.56826,
 2.44166 50.55016,
 2.465471 50.54966,
 2.463657 50.52897,
 2.499367 50.52821,
 2.498448 50.51788,
 2.510352 50.51762,
 2.509429 50.50729,
 2.533236 50.50677,
 2.531373 50.4861,
 2.555173 50.48559,
 2.590892 50.4848,
 2.58994 50.47447,
 2.601846 50.4742,
 2.613756 50.47394))',
 decimalLatitude,
 decimalLongitude
 ) AS withinPolygon,
 classKey,
 class,
 speciesKey,
 species,
 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 speciesKey IN (5232437, 2498252, 2480764, 2498305, 2489005, 2482499, 2486131, 2489010, 2479407, 2486151, 2350580, 2394486, 2394604, 2390064, 2362868, 2367919, 4284921, 2350570, 2340977, 5712056, 2367911, 2440946, 5218786, 2439838, 5219858, 4264680, 5218823, 2434552, 2440934, 2440954, 2437450, 5219683, 5219681, 2437394, 2437399, 2434271, 2433536, 9442269, 8909595, 2227300, 2225776, 2226990, 8971201, 8979506, 4648609, 8930656, 4417558, 1311477, 5871429, 1315391, 5035230, 5035187, 1651430, 5035017, 1319870, 9738098, 2292586, 5855350, 5217334, 2427091, 2443002, 9799308, 3169169, 2984306, 2869311, 3129663, 3170247, 3190653, 3054399, 2978552, 8848208, 4033648, 2889173, 2889088, 4038485, 8002952, 2706080, 3189935, 8114276, 3134183, 5828232, 5274863, 7287606, 2704521, 5289808, 2650436, 2977636, 5358460, 2984537, 2704523, 5361944, 3628745, 2891770, 3034825, 2702865, 3086784, 6063677, 3642949, 2765156, 2979775, 5420991, 5361762, 2865565, 2870583, 7978544, 5421039, 5361785, 5329212, 5362054, 2765942, 2882443, 3084923, 2502792, 2502938, 8701771, 5892137, 5187508, 2225646, 2863943, 5824863, 7965247, 2286388)
 AND continent = 'EUROPE'
 AND "year" &gt;= 2014
AND "year" &lt;= 2024
AND hasCoordinate = TRUE
 AND speciesKey IS NOT 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 (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
 "year",
 eeaCellCode,
 withinPolygon,
 classKey,
 class,
 speciesKey,
 species
 ORDER BY
 "year" DESC,
 eeaCellCode ASC,
 speciesKey ASC;
 

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