DOI: 10.15468/dl.9794tm
title: Occurrence Download

description: A dataset containing 20443080 records in GBIF matching the query:
SELECT
 "year",
 GBIF_EEARGCode(
 10000,
 decimalLatitude,
 decimalLongitude,
 COALESCE(coordinateUncertaintyInMeters, 1000)
 ) AS eeaCellCode,
 classKey,
 class,
 speciesKey,
 species,
 COUNT(*) AS occurrences,
 MIN(COALESCE(coordinateUncertaintyInMeters, 1000)) AS minCoordinateUncertaintyInMeters,
 MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) AS minTemporalUncertainty,
 IF(ISNULL(classKey), NULL, SUM(COUNT(*)) OVER (PARTITION BY classKey)) AS classCount
FROM
 occurrence
WHERE 
 occurrenceStatus = 'PRESENT'
 AND NOT occurrence.basisofrecord IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN')
 AND speciesKey IN (5754817, 4567113, 2685484, 2685383, 2685326, 2685580, 2685318, 2685361, 2685552, 2685464, 2685308, 2685654, 2685400, 2369165, 1364478, 1364517, 1364531, 9809222, 5384889, 2398623, 2398675, 2398623, 2398669, 2398682, 2398664, 2398634, 3152633, 3935859, 3152614, 2981303, 2979559, 2979474, 2981177, 2978730, 2979775, 2979000, 2980432, 2978604, 2979408, 2978548, 2978552, 2978771, 2979292, 5370687, 5370688, 5370755, 3056835, 3056259, 8159460, 3056384, 3057221, 4527322, 2064632, 4309455, 2271208, 10595482, 4459446, 1102084, 4449493, 1248774, 4492363, 2392311, 5277297, 1047525, 2153823, 3100375, 3100377, 2408186, 3142611, 1412626, 1412616, 5209181, 5209174, 5209188, 5209173, 5209184, 5209252, 5574054, 5415455, 5415453, 4543508, 4373187, 4543512, 4333247, 4333235, 9240761, 2480637, 7100404, 3189863, 7262908, 3189884, 7262958, 3189866, 3189882, 3189836, 3189846, 3189870, 3189883, 7263145, 3189837, 3189859, 3189848, 7263128, 1384680, 4544313, 4544295, 4544292, 4544719, 4651567, 2128502, 6135493, 4544342, 4544502, 4544669, 4544391, 4544331, 4544585, 2128510, 4544321, 4544690, 4544517, 9776414, 8305409, 10486625, 2118435, 1718308, 1718287, 3120391, 3120275, 7491603, 3120264, 3120284, 3120032, 3120356, 3120060, 3120129, 3120333, 2670002, 9036299, 3085168, 7489536, 1697617, 4287131, 2402129, 2402168, 2402159, 2402122, 2013998, 2014048, 2014023, 2014031, 1188302, 1188308, 1739837, 1739833, 4448454, 3033665, 3033671, 8090449, 7967494, 9038042, 5109387, 2873769, 2873807, 2562367, 2489007, 2489010, 2489004, 2489005, 4433528, 1044952, 2114252, 2663953, 2663971, 8280204, 1118064, 4462506, 9238897, 5209531, 1067377, 1421117, 2658484, 3199341, 6097688, 8047391, 4435781, 4435758, 4435859, 4435760, 4435724, 6376106, 5371704, 5969672, 5730578, 4359671, 4359672, 3189693, 3189694, 2505225, 4412423, 9103686, 4435662, 4377664, 4543905, 6914433, 4543940, 4543942, 4543895, 4544126, 4543960, 4484454, 2077518, 2077443, 2077518, 2077491, 2077443, 4499838, 2049739, 3092973, 3133702, 2651816, 7335341, 2651839, 2651826, 5371709, 8246651, 5616463, 1040288, 1740482, 1652150, 1651891, 1651430, 1651430, 1651718, 1652212, 1652150, 1652274, 5678027, 5678024, 5289783, 5289781, 5677944, 4138080, 5289790, 5289779, 5289793, 5289791, 4562566, 4562554, 4562571, 3034620, 4136390, 1378816, 1160956, 1420995, 1420978, 1420984, 1421001, 4424276, 2985682, 4198315, 7334101, 7414630, 4198135, 2985683, 4197955, 4197630, 2267503, 2267504, 2267500, 2949235, 2949250, 3189824, 3189815, 8566446, 3189828, 3189807, 1004581, 1004589, 1004580, 3143051, 8254044, 1010422, 10416813, 4372407, 7681512, 2211255, 4497745, 2854755, 2479555, 2479544, 2479559, 2479553, 2479546, 9770031, 5279568, 1888554, 2926406, 2926403, 1264554, 5284401, 5055183, 2767031, 2766552, 2766613, 2766601, 2767123, 2766660, 2766636, 2766811, 7582756, 9409198, 1377762, 1377774, 5400613, 5400552, 5400768, 5400324, 5400790, 5401760, 5718569, 5718570, 8249226, 7470812, 2656879, 2656914, 2656908, 1045944, 1877988, 1877941, 2337248, 4432673, 6003913, 5878491, 5878492, 4432736, 3002121, 4308843, 6100940, 2705196, 4133312, 2705200, 2705195, 2706490, 2706501, 2706526, 2706541, 2706548, 2706457, 4118280, 2706444, 2706435, 5942450, 8369050, 1043858, 6992701, 2667162, 7334818, 3190653, 7747216, 4450313, 2498388, 2498387, 8124412, 2927080, 3887580, 2927079, 8429926, 2927078, 8187634, 1005501, 3033965, 3033964, 8077224, 4569852, 4570272, 4569938, 4569970, 4570291, 2972983, 2973215, 2772339, 2360305, 2362920, 2362925, 2363005, 2362899, 5406789, 5617456, 3027648, 3027531, 3028431, 3027997, 3028175, 3028469, 3028123, 3028921, 3028596, 3027791, 3028528, 3027653, 3027751, 3028392, 3028052, 3028148, 3028176, 7350401, 3028586, 2474045, 2474029, 2474055, 2474051, 5578044, 4595294, 1040779, 8335840, 7624596, 5874866, 2390581, 7661391, 2012158, 7638482, 7730290, 6130411, 4771607, 2012122, 4484277, 4484273, 8389610, 4484230, 2109122, 2012137, 7498361, 8407378, 4484285, 7719368, 7646080, 7974238, 8202590, 8110888, 7910173, 7632200, 8234615, 2469363, 2945092, 4599728, 4568664, 2865125, 2315382, 2315395, 3797084, 2325846, 1013263, 2856834, 2856037, 2855717, 2856009, 2855968, 2857697, 2856780, 2856340, 2856504, 2856261, 2855999, 2857111, 2856920, 2855705, 2855825, 2856348, 2855823, 2857071, 2856288, 2856456, 2855893, 2855963, 2856681, 9177060, 2856204, 2857616, 2856593, 2855683, 2857317, 2856457, 2856297, 2857829, 2857601, 2857132, 7792960, 2857341, 2891902, 2332269, 8053133, 8941475, 2294131, 2294133, 8956987, 2876213, 9148577, 2876595, 2876176, 2876571, 5329904, 4463833, 4463833, 2777855, 2777537, 2778092, 2777639, 2777789, 2777339, 2777430, 2777626, 2777280, 2778035, 2777724, 3696771, 2077000, 9527904, 7869713, 5290083, 5672406, 5290090, 5290097, 5290073, 2498252, 2412712, 5341164, 4309906, 2226103, 4309912, 8416593, 4309900, 2226174, 1045875, 1045874, 5301979, 2753786, 3084958, 3084922, 3084923, 3084949, 3084939, 2616137, 12206489, 2616157, 2616116, 3933860, 3152519, 3152521, 3152520, 4462336, 4462339, 2406708, 2406721, 6526124, 3044855, 8215381, 3044972, 3045006, 3044823, 3044966, 3045042, 3045193, 3045137, 2426612, 2493707, 2493698, 2493696, 2493697, 5240299, 1035185, 1035204, 1035194, 4473101, 4472906, 7905507, 5384395, 8911082, 9294952, 7323340, 5547989, 5384404, 5384390, 5384396, 5384373, 5384364, 9080185, 7323810, 5384332, 5384393, 5384342, 5384359, 6109534, 5384401, 5548401, 5384383, 5384397, 8577467, 5384334, 7720079, 9577059, 7762704, 7923128, 5325855, 1228073, 7552441, 7910118, 7818107, 7446481, 4359135, 2370027, 2141617, 4465793, 2479662, 2479666, 2479606, 2479652, 2479655, 2479612, 2479646, 2498411, 2387309, 3122190, 2394514, 2184174, 2183998, 2183968, 2184359, 2184069, 2183943, 2184018, 6098559, 8002952, 3110654, 3110686, 3110580, 3110588, 2340972, 2340977, 2340969, 2340989, 3024109, 3023901, 4106335, 10150189, 1249663, 4930999, 4481193, 1042204, 1400742, 1400750, 3188714, 3188716, 3188711, 3188708, 7122782, 3034182, 2473733, 5166760, 2441005, 5357407, 2219451, 2219490, 4925448, 7293727, 3110041, 2020835, 4487243, 5862470, 6128436, 4805565, 1095712, 7727539, 2328853, 7916836, 5197001, 5856036, 2277692, 2277536, 7441080, 7909442, 7818074, 1014565, 7804271, 7629910, 2078399, 8038632, 5177561, 4060237, 2925887, 2925879, 2925874, 2925870, 2925877, 3169689, 9225458, 2307610, 2307609, 4410206, 4422796, 1702101, 3148589, 3148560, 3148548, 5855397, 6529629, 5729462, 5188945, 1027048, 6189484, 1379917, 1379990, 1380005, 1379970, 3096972, 4926336, 1366671, 4423678, 1420576, 1420592, 8114833, 1847640, 2498112, 2498090, 2498094, 2498097, 2498064, 2498065, 2498127, 9761484, 9450106, 2498156, 3041976, 1390610, 1390553, 4529738, 4529740, 2210079, 5341198, 7582887, 8353055, 5662089, 5341201, 7295349, 5661914, 7295330, 4899435, 3079631, 4497120, 1309606, 1309600, 4497054, 4497124, 2208095, 4150293, 2706080, 3169325, 3169328, 4006267, 3169329, 4412789, 3927746, 3033242, 3033261, 3033263, 3924146, 3033266, 3922888, 3034646, 5537578, 5890402, 5213022, 2284451, 4346612, 2284450, 2468095, 1375843, 8193234, 2210206, 4346647, 1036917, 1419902, 1420719, 9085904, 9149759, 1030510, 5407147, 5407099, 3152493, 2479359, 5166357, 5188926, 4450610, 1044343, 5233631, 2117379, 9490730, 4491852, 7987143, 7572133, 2656854, 1039462, 4440524, 3083508, 2498017, 2498024, 2498034, 2498026, 2498027, 2498035, 2497981, 1683928, 8183323, 5710214, 8035698, 3122639, 3122765, 7389428, 3102823, 1377333, 1866556, 1866568, 2773902, 2773942, 1046911, 4458039, 4544165, 4544158, 4487205, 4487208, 5013699, 2705972, 2705975, 4133491, 4427283, 4427286, 1095893, 4427320, 4427293, 1095904, 1095892, 5371743, 5371746, 5540254, 5371742, 5352335, 5352367, 5729397, 2889355, 4360191, 4559502, 7333212, 7740323, 8927100, 2657504, 2657449, 2657472, 2657657, 2657664, 2657641, 5163968, 8082584, 4554009, 8415576, 9198247, 8194699, 2082977, 2083015, 2082988, 8318877, 6460811, 6460808, 6460818, 2442680, 7438067, 2212718, 2212761, 6005830, 4427567, 6005825, 3195275, 5676903, 5289643, 5289642, 1316075, 1232252, 1232260, 1232255, 1232238, 1232261, 5365013, 9062455, 2348104, 1309465, 3202936, 4559429, 1364062, 1364024, 2323931, 1269247, 1269194, 1598968, 2072331, 9083295, 2072761, 2072087, 2072384, 2072673, 2072061, 2072677, 2072331, 9083295, 2072474, 2072384, 2072788, 2072648, 2072761, 2072087, 2072320, 2072687, 1364756, 1364778, 1364694, 1364750, 1364769, 1364625, 1364679, 1364710, 1364706, 1364719, 1364656, 1364732, 8549410, 1248553, 2510205, 2510183, 2966796, 2371265, 5371879, 4355609, 2330843, 2330928, 2330832, 2489042, 8876519, 9025372, 2116805, 3169816, 3169790, 2437760, 5853511, 1869858, 5328593, 2130053, 4345796, 2307759, 2307760, 4361146, 3094355, 2069916, 10202109, 1848219, 8599762, 1386896, 1387369, 1387093, 1386934, 1387805, 4498881, 2481660, 4424793, 4424792, 4424002, 1420772, 2480506, 2480513, 3921447, 3033188, 3033208, 7527324, 2272084, 5959231, 5959227, 5959230, 5959224, 5959228, 3052509, 3052450, 3052544, 3052436, 5375020, 5374922, 5374982, 5374998, 5374841, 5374933, 5375012, 5353770, 4985448, 1010410, 1166198, 7942674, 1779258, 3037060, 3036940, 3036892, 3036958, 3036972, 2479121, 2479101, 2479105, 2479146, 2479127, 2479159, 2684984, 2684918, 2684969, 3170442, 8472121, 2034536, 4170901, 2882803, 5968806, 7422457, 7774029, 1014453, 2732621, 1073568, 4314748, 2269489, 5393111, 5393080, 5393100, 8418228, 5393120, 8206548, 9378826, 3114986, 3114978, 5406226, 5406166, 6531334, 6531311, 2988624, 5587267, 7267924, 6363863, 7664515, 1871969, 2184918, 6096907, 2888485, 2888490, 4559504, 2285862, 2114151, 3104491, 1830221, 1830209, 1830284, 1830271, 5211031, 4292492, 7536175, 2508973, 5778937, 2318573, 1117891, 2114793, 2294090, 2294096, 2294102, 11049437, 2294097, 2294103, 7540164, 2867531, 2744906, 2706277, 4128792, 4126800, 2706259, 2873991, 3589517, 2874019, 3589175, 2203834, 2203676, 2203765, 2203739, 2203611, 2202347, 8930531, 7481857, 7901954, 4360202, 7806790, 5405938, 9558299, 3087403, 4486297, 5001658, 5001643, 2407378, 2704505, 2150089, 8042568, 3121319, 3121088, 3120677, 3120648, 3121668, 3121226, 3121461, 3120837, 10667450, 3120950, 3121258, 3121389, 3121562, 3121391, 3121623, 3121228, 3120790, 3121656, 6130575, 2502792, 7579869, 7463403, 8088608, 9979550, 1757853, 5330580, 5362136, 4110556, 3729273, 7313595, 1843058, 4558661, 6486731, 2330592, 2330587, 5200467, 3170241, 3170260, 3170247, 3170305, 2318324, 2615061, 2615156, 3196524, 4911642, 4382606, 4559169, 3158040, 5279840, 5279834, 2768763, 2768367, 2768503, 2768780, 2768885, 2768686, 9289944, 2926055, 2916662, 2916822, 2917001, 2916975, 2777134, 2778437, 1592766, 1592770, 4463824, 4463823, 8125974, 6097763, 5161761, 5161787, 2769937, 2510275, 2510310, 8150126, 2650669, 7566891, 2226998, 5387639, 5387396, 8133114, 5187508, 7765831, 5393689, 2332123, 5163002, 4484323, 3193854, 1383131, 3032696, 7596861, 7339513, 12176639, 3754647, 5344663, 5343253, 5344424, 5347276, 7945845, 5347136, 5347051, 5346998, 5342681, 5346614, 5342618, 5345430, 5345013, 5345603, 5345210, 3034915, 3634768, 3634505, 2370243, 2619683, 1188650, 3173254, 4371524, 1065819, 2437140, 2437136, 2227756, 4490913, 3633322, 3114343, 2554082, 2497266, 1530777, 1530823, 7999925, 1040990, 5874770, 6097431, 6097420, 1041063, 6097469, 9351338, 6097441, 6097466, 6097459, 6097429, 7402894, 5122232, 2437470, 5749277, 5749227, 5749134, 5749182, 5716420, 6943324, 5749277, 6943243, 5749265, 6943225, 6943215, 5749280, 6943368, 5749203, 5749196, 4413919, 2682955, 8175705, 6285627, 3756350, 6035529, 6035855, 3083659, 6035816, 3083718, 3083746, 3083783, 6447496, 3083793, 3083696, 3083680, 3083773, 3083657, 3083786, 3083745, 3760099, 3760001, 3083667, 7340014, 3083763, 3759716, 3083771, 3083702, 3802655, 4427480, 1095954, 6965560, 4427472, 1095953, 4427437, 4427468, 3193079, 6075968, 6075969, 1300033, 3054110, 3054117, 3033077, 1074277, 5188832, 2620333, 4456939, 1025098, 4450235, 1420769, 5185431, 5185429, 5377774, 5377778, 5377794, 6476889, 2502865, 3951322, 7282233, 3951058, 7282153, 7282135, 7282098, 2115769, 1792418, 4154800, 4154485, 4154168, 2705297, 8174035, 8322034, 12211725, 1374530, 5170476, 10317531, 2643471, 4449412, 2440934, 2705932, 6447806, 2498263, 2498262, 4379029, 2650105, 4196474, 2650107, 11073901, 5788062, 3129663, 8205774, 1415862, 3171189, 3171174, 3192919, 7930834, 7587619, 8021093, 4400961, 2142995, 4435710, 8172198, 1420323, 1244539, 2094580, 7678423, 8970635, 2115719, 2115706, 2115724, 2864546, 5228232, 5228229, 2407121, 2407129, 2367033, 2926894, 8310958, 4435554, 2705752, 2705757, 4484322, 5227939, 5189518, 7124338, 5374635, 5374672, 5551358, 4373229, 5204862, 2366101, 2307447, 5739539, 5206720, 5739556, 5739559, 5206714, 5207310, 11172891, 5206782, 5188774, 4554041, 2161370, 2161364, 1198608, 1386306, 1386308, 4329456, 3083504, 2166782, 5568249, 5383909, 5568213, 5568188, 5568099, 5383936, 2377057, 2134068, 4446484, 2300712, 1133716, 2627503, 7670473, 2953747, 2953251, 4558769, 2502946, 10196361, 6487091, 2768035, 8026581, 5290059, 10039339, 2874717, 2874711, 8414451, 4157965, 1031543, 2771938, 2771972, 2771988, 3117441, 3117424, 2007665, 4454848, 4484239, 2012126, 4314645, 2209893, 2378864, 2118930, 3981040, 3033905, 4938160, 3981472, 3981543, 7300375, 3033896, 3033894, 3981814, 5567694, 5646095, 4458779, 2198141, 5233152, 3053522, 3053517, 2302627, 5567951, 5383926, 8971274, 5331779, 5332004, 5331916, 3193674, 5391901, 5391802, 5389402, 5392065, 5392083, 5392174, 5391845, 5392145, 5391882, 5391928, 5391810, 8856674, 1842198, 1007721, 5371870, 7412216, 3172516, 5680555, 2291021, 9068475, 2502938, 6476069, 4453317, 3041800, 3041758, 4437343, 4437293, 4437317, 4437326, 2441176, 2329515, 7577557, 2299854, 8189065, 9746127, 5725688, 5150245, 5150248, 8692916, 6366886, 4454570, 4454606, 4454595, 4454582, 4454603, 1995681, 4492147, 1852831, 1852841, 1852787, 1852871, 1852751, 4529658, 2013328, 5151589, 1997215, 4557709, 4078397, 1464288, 2808791, 2359471, 5799849, 9867629, 9918244, 10224791, 10638041, 5646410, 2581196, 2865980, 2320813, 2320810, 2320817, 2320998, 5209660, 2114738, 2984359, 3086287, 3086288, 2457884, 2718387, 2718377, 2501237, 4366020, 7876352, 5393593, 2423435, 1340542, 1340513, 1340298, 7734137, 8050384, 5721772, 2668884, 2926110, 4063741, 7577086, 1014399, 1838811, 8187261, 4963768, 5856482, 5229203, 4427588, 6005596, 1575603, 2704120, 2704093, 2704112, 2704099, 2704102, 2704111, 4136695, 2704103, 1376850, 2650180, 2332104, 4354937, 6486710, 4354950, 2332084, 10739063, 2663181, 10889612, 2583473, 3198843, 4532146, 5384862, 7167078, 2266597, 2266586, 2266593, 4422493, 1032751, 1032750, 3034738, 2285737, 4374596, 4984081, 2078547, 2078547, 1246684, 1246366, 8119595, 7426033, 8053313, 7323035, 2077522, 1020944, 3138434, 3138474, 4441504, 1317317, 1317348, 1317293, 1317320, 2225797, 7793521, 9181882, 5290143, 5290144, 5290142, 4451384, 1044325, 4451390, 4458863, 4465713, 1262108, 4423648, 2297154, 1488968, 1488850, 4520719, 1488908, 1488856, 1488673, 1488558, 1488827, 2736794, 4812260, 5854272, 5200325, 9817665, 5200315, 5200302, 2309685, 2308574, 5232437, 5232452, 5232464, 5232451, 5232445, 3042799, 3042925, 3042507, 3042888, 3042809, 3042751, 3042636, 3042835, 7903057, 3042624, 4452928, 9442679, 1489081, 2417299, 5424258, 4566277, 4566273, 2130874, 2131090, 2131024, 2131035, 5383031, 2767920, 2702792, 2702789, 2702793, 2703696, 2703705, 4111181, 2703682, 2703712, 2703723, 4110768, 2703778, 2703704, 2703659, 2703777, 2703670, 4128338, 2703644, 2703733, 2703711, 2703721, 2703686, 4122974, 4122609, 2703776, 4111775, 2703706, 4154191, 2703764, 2703663, 4109815, 2703740, 2703720, 2703717, 2703698, 2703700, 2703647, 2703746, 2479580, 2479562, 5361944, 2932934, 1167007, 1047568, 4461643, 4461664, 4461751, 6951145, 6950919, 4461677, 1370756, 1370716, 5752150, 5752153, 5752155, 5752143, 5009537, 5752157, 5752137, 5581099, 5341760, 2926045, 2874497, 2874496, 5959092, 2480830, 2494394, 4535888, 2498329, 2498325, 5233411, 2020779, 2212099, 4055853, 3173337, 3173338, 6387494, 4055769, 3173340, 5217160, 7267943, 8218420, 4062055, 5304851, 5292341, 7695428, 6520353, 3050357, 3050364, 3034501, 5188632, 1973414, 3639903, 3639326, 6027105, 5831906, 3034557, 7960717, 3034552, 6026972, 3034554, 1049530, 6003731, 8401448, 2209765, 2209748, 4631108, 7021952, 8848401, 9680062, 2480542, 2864467, 2480824, 2984672, 2984671, 4309816, 2234644, 5143677, 2882443, 2479888, 2479881, 2479893, 8094357, 4484176, 2012934, 1932752, 1873919, 1873903, 2205843, 5192917, 10742771, 2502810, 10742771, 6476679, 5305000, 2374775, 4308862, 9751099, 3048882, 3048831, 2128578, 6431455, 4107931, 1068879, 3084693, 4331916, 4334330, 2114201, 4334328, 4334322, 5178365, 5730505, 3172127, 3726586, 7622753, 3172126, 2224434, 5329163, 5391454, 5391476, 3048782, 1365139, 2928905, 4330560, 1420526, 2869101, 7683823, 9538779, 2225650, 2225643, 4307357, 2225646, 2386919, 2293333, 5228080, 1502577, 1502691, 5406702, 5729391, 3173413, 3173407, 3173353, 3092946, 6097854, 8402883, 5372477, 2498384, 5108671, 1417422, 2437394, 2437399, 2437397, 1047341, 1047343, 1047342, 2882482, 4360210, 2114223, 2114225, 2114230, 2114236, 2683936, 2512991, 4937111, 2670188, 2014649, 5104903, 5104862, 5104781, 4360289, 3098186, 3098176, 3098183, 7242545, 3034113, 4427081, 4427083, 2266546, 2301629, 2669838, 2928446, 3679288, 2769084, 8168527, 7389097, 8256670, 8168527, 3042398, 3042396, 3042416, 3042439, 9073641, 3189636, 3189635, 9055455, 1749449, 5410181, 5410826, 5410194, 5409852, 5410210, 5411353, 5409933, 5409907, 5410628, 5411392, 5411408, 5411453, 5410564, 5411475, 5410411, 5410151, 5410661, 5410550, 5410436, 5411920, 5410480, 5410717, 5410161, 2119537, 2119500, 4536759, 2119536, 1313740, 5281901, 5281948, 5856069, 2222075, 4564687, 4807641, 5303151, 5303128, 8034409, 7529533, 2406961, 2407087, 2888522, 6370689, 2441050, 2441056, 2441055, 5178057, 5178082, 5220126, 5375387, 2932944, 4470961, 1036779, 4470480, 4471042, 8056040, 10613863, 1764981, 2943190, 2943316, 2390762, 4286942, 2366645, 2366634, 4837765, 1411953, 2564485, 4433161, 5178595, 3045931, 3045783, 3046015, 3045875, 3045634, 3046258, 3690997, 3046092, 3045840, 3046032, 3045797, 2490384, 1317116, 1317123, 8384845, 4429127, 3189935, 3189939, 2494686, 3114643, 3114528, 3114689, 3114667, 3114693, 3114627, 3114536, 2725766, 2725002, 2728048, 2722942, 2727655, 2722380, 2724046, 2728143, 2724457, 2724661, 2727755, 8285827, 2723340, 2724790, 2722515, 2726538, 2724925, 2726082, 2726539, 2724367, 2727891, 2726483, 2728060, 2874484, 4283812, 5414420, 3105419, 3105433, 3105410, 4440144, 3094841, 1205812, 1205821, 2875818, 3703606, 3703579, 3084844, 3084842, 3703453, 3703360, 5086461, 9547586, 1044114, 4453192, 1044111, 4453187, 1044108, 1044109, 1044106, 4453189, 4453195, 4453205, 4453190, 6130918, 4453191, 5375285, 11652031, 1947335, 3138274, 3138230, 3138332, 3138327, 4451122, 4451122, 4451134, 4451126, 4451136, 8535986, 2083838, 3034714, 2225568, 3054299, 3054289, 3054296, 4571331, 2291066, 2291063, 4461593, 1047737, 3169652, 2264603, 5333249, 5333294, 2439838, 2891932, 2891930, 3172615, 3172613, 3172612, 3134871, 4463346, 4105452, 1008558, 3169830, 1477289, 2481930, 1043847, 1043843, 1043837, 1229687, 1043964, 3688630, 4445084, 1919346, 4286868, 2359014, 5227753, 3034523, 2666539, 2666536, 2643120, 2643131, 2643072, 2643011, 2643172, 2642947, 1006197, 9559796, 4543499, 4543430, 4543438, 2297229, 4568166, 4568170, 2926887, 5284702, 5284698, 5284682, 8688929, 3169169, 3169171, 4369982, 1004629, 1004642, 1004649, 1004623, 1004634, 1004698, 1004650, 1005938, 7940754, 3085191, 2984492, 2984481, 5963673, 5828197, 5289734, 5828201, 5289739, 5290192, 5289731, 5828232, 5289726, 2131294, 3127822, 7841783, 7723839, 3127691, 3128156, 3127979, 3128962, 3129010, 3127830, 3128437, 3127988, 3127837, 3128547, 3129064, 3128269, 3128091, 3128601, 3128007, 8018277, 3127841, 3127587, 3128910, 8087525, 3128640, 3128725, 5414457, 7853619, 7439391, 5391292, 7298966, 2888740, 6528791, 1365193, 2383720, 3141046, 2114733, 6894283, 2294279, 2294280, 2888799, 2888797, 4104035, 8355821, 4492374, 4492381, 4492365, 4492369, 4492379, 1358491, 2388914, 2388954, 2388910, 2685265, 6360715, 1587323, 4484283, 8806844, 5820507, 5998035, 5276982, 5276936, 10708694, 5277182, 1388028, 1388013, 3085433, 3085437, 3085439, 3812695, 3085435, 3085458, 3085440, 7267365, 3085474, 3085438, 7925372, 2074364, 2074369, 2074362, 5039868, 2138356, 1626096, 6035781, 5252354, 5252313, 5252364, 5281381, 2315832, 5356354, 1417170, 2651586, 7559942, 4420304, 3082279, 5353590, 2234642, 5219566, 5264768, 7254733, 4434267, 1034447, 1034478, 1034437, 4434267, 1034447, 9379028, 4434272, 1034424, 5384000, 5184341, 2926108, 7294722, 2299122, 4362829, 4363108, 4363120, 9487869, 4362898, 2299100, 4362872, 4362895, 4565140, 4565061, 9805907, 1031680, 1552561, 1552561, 7953279, 2092472, 2092435, 8188295, 2092339, 10547069, 9206047, 2440958, 2440954, 2928789, 6403186, 2928791, 2928792, 2493012, 9801477, 3000610, 3000679, 3000632, 3171669, 5561475, 1383849, 3642608, 3642531, 3034653, 3642339, 6027328, 3034650, 1420765, 4275372, 4275413, 4376592, 9501293, 4275413, 3193042, 8054640, 3193040, 4275399, 5752377, 8020115, 2394320, 2385390, 2385336, 2385342, 2385353, 2385345, 2396591, 4315713, 4315708, 2209413, 2306710, 2076486, 2074499, 2927071, 5225137, 2495840, 7878882, 1347287, 4372055, 4372070, 3944596, 2950302, 2683866, 2683880, 2683871, 5333436, 2734637, 2734661, 2448980, 2449051, 5391595, 2736625, 1537581, 2732008, 2387155, 2387143, 2387157, 4284921, 2391455, 2391520, 2406374, 5270682, 7937336, 8357882, 8156367, 7780454, 7969748, 1366036, 4647366, 2225629, 4307421, 4307415, 2225631, 2225632, 2744161, 2744155, 2703077, 5959222, 2397527, 2164198, 3097075, 4314683, 6460946, 8439213, 2336774, 5334186, 5167813, 2400863, 5414935, 5414946, 5414932, 1032220, 5280189, 2498046, 3760713, 3083838, 3757189, 3083920, 3756402, 6447554, 3083915, 3083862, 3756077, 3083934, 3759215, 3758873, 3758151, 3083903, 3083935, 3083932, 3083866, 4417558, 4648604, 10598952, 1883226, 1043501, 1043491, 2406485, 4563246, 2888304, 7275851, 4154003, 8306510, 2086740, 5789302, 2226639, 4996760, 1420729, 1420748, 2306165, 1029056, 5232428, 5289631, 5289618, 5289623, 5678495, 5289619, 5289620, 5289629, 5289624, 1111797, 5243168, 2774846, 5211121, 2506053, 3833284, 5279755, 5279751, 5279753, 5279795, 8537667, 5403820, 4419245, 2360551, 2360575, 4566199, 1014409, 1545138, 1545172, 3195749, 3044349, 5771482, 9510763, 1006372, 5855356, 1382104, 7160028, 6065820, 2076260, 4360023, 2375934, 3087725, 3054465, 3150767, 7694984, 5185418, 10894642, 2443133, 2399295, 2399258, 9205012, 10724225, 5744378, 1384723, 1384909, 8389589, 1785181, 1785185, 1785145, 1851337, 9534100, 4460066, 4460057, 4459831, 4460185, 5228033, 5228034, 8026254, 2083463, 5064140, 5064187, 5064167, 3195298, 1374148, 1606124, 2115620, 5167566, 1557713, 1557728, 1557720, 1557705, 8383011, 2583057, 2583088, 2582976, 7490259, 2947311, 5208140, 5392271, 5392243, 5392252, 5392270, 2481915, 2481912, 2481909, 2144543, 8022397, 1171838, 2021062, 2073347, 2073431, 2073667, 2073320, 2073431, 2073214, 2073362, 2073287, 2073464, 2073690, 2073520, 2073347, 2073560, 2073469, 2073206, 2073401, 2073366, 11067653, 2073440, 2073494, 2073345, 5724275, 3033991, 3033987, 2329622, 9738098, 6524257, 10185207, 9941550, 2213484, 2213524, 2564494, 2375097, 2267186, 1381383, 1381262, 1381201, 1381168, 3113784, 7987728, 3113027, 3113777, 8029008, 3113650, 3113239, 3112651, 8188714, 7332229, 7331435, 6437976, 2874030, 2874027, 1202692, 1381011, 2874622, 2874621, 7647136, 3190157, 3190172, 3190129, 9958973, 8077391, 7647136, 10530603, 5272690, 1453172, 1453151, 4428304, 4428312, 5202782, 5202683, 5202793, 5420978, 5420982, 5420957, 10058837, 5239483, 5239476, 1377230, 2330170, 2330172, 4329474, 1748202, 8081031, 7734180, 7734180, 3084742, 9293058, 3033599, 6375061, 3921611, 6374790, 3033584, 6376216, 3033532, 3033543, 7277777, 3033535, 3033546, 3033558, 3033518, 4372695, 3872424, 3871995, 4530608, 2925351, 2925366, 2888323, 7866157, 2941713, 7437438, 2926945, 4414705, 1412393, 5326276, 1415826, 5717425, 6465506, 4499302, 4487598, 9855566, 2143921, 5214533, 5197206, 5375313, 4609086, 11553363, 5186036, 5186058, 1475022, 7994366, 6132425, 2368222, 1375647, 1376477, 1364249, 2888831, 1364376, 1364389, 1365059, 1365055, 1365013, 1365086, 1364834, 1364976, 1364911, 1364857, 1364838, 1365087, 1364938, 1364962, 1230353, 1230310, 3829341, 5712981, 8202676, 5163301, 5163248, 5163369, 5373276, 4562917, 2296807, 2295977, 2615946, 7348337, 4561750, 4561827, 7812596, 5272096, 5839323, 5272185, 8111748, 8142643, 9701509, 1528043, 2895345, 3040600, 2706301, 5278525, 5278375, 2739622, 1177026, 5120915, 5120767, 5121010, 5121029, 2155867, 2513916, 3092083, 1851409, 4480771, 4382675, 5228112, 9791464, 6371450, 8884140, 2568773, 2568828, 5414959, 7294226, 2927556, 2927552, 2090075, 5330776, 10458860, 2353152, 3197970, 5231817, 2495414, 2495471, 2495455, 2495891, 2495869, 7844167, 2956442, 2764202, 2764389, 2764435, 2763962, 1375555, 1377352, 1377362, 5414197, 8332178, 7393181, 1217275, 1546012, 4465226, 3034807, 2529986, 2529960, 6489949, 1007739, 6026760, 10055245, 3040923, 3040913, 3040928, 3959487, 5082263, 5082256, 5082244, 5082160, 5082199, 5082110, 5082091, 5082067, 2479449, 8045637, 5728241, 5728171, 7459480, 2928390, 3679569, 1378485, 1378607, 4799716, 1588315, 1589683, 4438493, 1861237, 1861251, 2370703, 4543457, 2007383, 2475360, 2479297, 2291865, 5189032, 8190231, 7405043, 8140432, 5794018, 8129124, 3152084, 1876941, 4989746, 5341290, 2203165, 2766411, 3041109, 4738460, 2266009, 2351027, 2351128, 2351119, 2351219, 2351211, 2351222, 2351174, 2350989, 2351196, 2351064, 2351155, 2351136, 2350976, 5200463, 8053367, 3133936, 3133927, 3133938, 3133950, 3133887, 3034871, 3701787, 3701777, 10826904, 3760051, 7340011, 3759655, 3759530, 3083975, 3759205, 4309237, 4152614, 3082270, 3082263, 3082244, 7893775, 1784349, 3215307, 5348644, 5348633, 6433998, 5384680, 2704523, 4450862, 4450792, 4450809, 2482519, 2482479, 2482499, 2110709, 5531529, 5334210, 5531213, 5334213, 5530881, 5530829, 5531997, 5531941, 2875979, 2875968, 2876049, 3201736, 5418434, 5185697, 5290194, 4147899, 3169083, 5279459, 3198873, 3198882, 6539249, 1488075, 1488092, 1488057, 1487995, 1488101, 1487853, 5962076, 6518477, 2395367, 8001222, 2020671, 2020655, 5421557, 2498288, 2128550, 1169988, 3098912, 6524775, 5390611, 5390637, 5390618, 5390630, 1257656, 1257921, 1257783, 8039268, 3190522, 3025770, 3025764, 3025857, 3026024, 3026294, 3025899, 3025894, 3026049, 3025896, 3026334, 3026162, 7671195, 3026092, 3025617, 3025793, 3025645, 3026022, 3026064, 3025948, 3025572, 3026239, 3025927, 3026074, 3025980, 3026107, 3026219, 3026040, 3026004, 3025605, 8542672, 3112110, 3112098, 2474163, 2474156, 2474162, 5361969, 2264581, 3101808, 7844959, 5373502, 5373475, 5373497, 5373533, 5373466, 2217983, 2217982, 4408321, 3115443, 2286073, 2286079, 7565449, 7334487, 7334263, 5362054, 5362058, 7396425, 7642067, 8289768, 7172747, 5362055, 5689573, 3013739, 3015853, 3014860, 3014211, 8252683, 3015120, 3014233, 3014430, 3015457, 3015560, 3013800, 3015045, 1638284, 2264633, 4520883, 1487488, 2482168, 1324603, 1325120, 2392500, 7366493, 1039254, 5192789, 5192786, 4360387, 5403573, 7455538, 5403531, 5403541, 5403304, 5403547, 5403470, 5403290, 5403323, 5403562, 5403605, 4245384, 5403284, 4288621, 7680807, 2475211, 9280231, 2853668, 4928395, 4990500, 2094171, 2228958, 7811641, 8373396, 6100979, 6100984, 6100990, 6100996, 6498827, 1736623, 5787823, 2435654, 2435687, 2747948, 2747939, 2747946, 2747927, 2747959, 2747842, 2747704, 2747589, 2747340, 2747489, 2747813, 2747737, 8844020, 2747313, 2747814, 2747464, 2747815, 2747430, 2747530, 2747718, 2747564, 2747567, 2747907, 2747750, 2517486, 2517512, 2225637, 2150043, 2474099, 2942877, 5336632, 5336587, 5336640, 5338929, 5338920, 1212322, 1212105, 1212134, 2566393, 6718178, 4550810, 1043889, 2091256, 1873051, 5209043, 7960987, 5160450, 2869246, 2869214, 1043717, 4989828, 5749732, 6992753, 4989843, 5284237, 2656674, 5748888, 5749059, 5749047, 5749027, 5749008, 8151310, 1034244, 5179146, 5179130, 7563173, 5730513, 3170473, 2592401, 3034433, 2007322, 4424759, 2069750, 1231274, 9202355, 1304909, 2376212, 2013904, 2013907, 2013910, 1284239, 2114911, 6931582, 1421095, 2362030, 1785329, 2209874, 1487130, 6456766, 1032131, 10640992, 2874570, 7885624, 2874569, 7849018, 2874512, 2874521, 2874515, 2874508, 5793674, 2356556, 1652909, 1652991, 1653175, 1653127, 1653260, 4520506, 1649571, 2948921, 3034775, 2516075, 2589233, 3188698, 3188684, 7773195, 3188690, 9341614, 2683969, 2684012, 2684046, 2684030, 5010466, 6064795, 2927520, 7154776, 3610757, 2927530, 2927518, 2927493, 2927492, 8406906, 3678256, 7361176, 7324013, 2927490, 2927484, 6537484, 2706169, 2292317, 2498380, 2482575, 2479529, 7341881, 4470300, 6962435, 2683264, 2683217, 7127354, 7127347, 7127810, 3169317, 3169315, 7127713, 3625789, 2874529, 2406520, 4458140, 8308248, 2116818, 2116814, 5962255, 1724191, 5899940, 4362606, 8350395, 4532122, 1737808, 1737761, 1737816, 1737847, 1737775, 4530002, 5362215, 2498344, 2498345, 2498347, 2498335, 2498343, 7814219, 2562837, 1017156, 1013526, 1013578, 1013547, 1013610, 1013597, 7282673, 6381277, 3952654, 3952282, 7282418, 3219362, 2216329, 5559871, 5559837, 5559825, 8052076, 5305627, 5727801, 5176737, 2210279, 8220829, 7387431, 3571089, 3112364, 3112361, 6109637, 5674825, 5289803, 2925816, 4064572, 4064507, 4064467, 2925815, 2409598, 7131800, 2399985, 2704395, 2704394, 4133858, 2713662, 2715443, 2714272, 2714094, 2713479, 2714301, 2714453, 2716778, 2714796, 2716294, 2715482, 6417217, 2716226, 2715206, 2716489, 2716110, 2714233, 2715729, 2716209, 2714056, 2715429, 2716311, 2714722, 2713519, 2714818, 2715260, 2715620, 2716719, 2716420, 6097492, 1029062, 5207666, 4286975, 2820340, 1029157, 4423350, 2650829, 2650827, 4038992, 4558978, 2650799, 1669053, 2940408, 5354676, 7681436, 5354646, 5354707, 8400045, 1042624, 1251536, 2706188, 4149975, 2706190, 4412372, 4412352, 4412366, 4412354, 4412304, 4412351, 4412387, 2505275, 4412376, 2090105, 1034043, 1223760, 1625561, 5387098, 8190990, 5387142, 2227465, 2049512, 1041686, 5220136, 5303891, 7642610, 5133088, 2703250, 2703267, 5420853, 5420852, 2234836, 4309227, 2234848, 2234831, 2468847, 2468735, 3032611, 1595588, 1595142, 1595212, 1595380, 9805719, 1595199, 1594819, 8135438, 2659108, 2659095, 6481820, 2704854, 7682935, 2928755, 2928738, 2928741, 3642740, 6027382, 7704950, 3641853, 6027313, 3640822, 2391050, 1690687, 3145383, 3134183, 4320356, 4320346, 5077529, 1279129, 2956176, 3707475, 9376410, 8006447, 1043663, 3033757, 3033699, 8429167, 5757310, 1201654, 4595289, 8290434, 7725323, 8751940, 7772922, 5739805, 2127270, 4344674, 1228061, 2498406, 2498398, 2498393, 2498402, 2498404, 2498396, 4359824, 9715336, 1733484, 9515376, 2392664, 7125872, 4488821, 2643248, 2643247, 1189626, 2183450, 2183465, 8818917, 4427382, 1095847, 4427377, 1095847, 4427395, 4427381, 4427399, 1095856, 1095858, 6966099, 5781288, 8860193, 8838776, 8745918, 5781358, 9209733, 8734640, 5190777, 5781282, 9089581, 9218190, 1105851, 1138532, 8059811, 2703174, 3044285, 3044133, 3044318, 5200151, 2242928, 7484581, 5360097, 4142153, 1673407, 1673441, 1561398, 10656713, 2985963, 2985964, 2985965, 1263362, 1263322, 4453803, 5721108, 2257920, 4283395, 10609794, 4484288, 2220424, 2220434, 3085413, 3085421, 7592185, 8400876, 3085420, 3085418, 8179294, 3813136, 3085424, 7267630, 6364219, 3085412, 3809583, 8116809, 8012084, 6363496, 7620061, 5771877, 2234732, 2567769, 2568017, 2567947, 2567747, 5010133, 5010172, 5559593, 8329298, 2086988, 8324639, 2087308, 2087058, 2087457, 2087459, 8075301, 2087440, 2140326, 2888553, 5744552, 2702446, 2702451, 4410238, 2928668, 2928666, 2763632, 7993897, 3115588, 4469388, 1420855, 6096870, 3221967, 3221971, 7264147, 10814046, 4553323, 4553430, 1598057, 5421338, 2283441, 2020733, 5423588, 8018048, 5423480, 8052025, 1542026, 2329732, 2329725, 7707408, 2580627, 8030069, 4469619, 6989033, 6097717, 2888711, 10458686, 2742428, 5414991, 5414992, 5414989, 5414990, 5414995, 4131963, 5676646, 5289957, 5289998, 5289948, 5290003, 5289974, 5289954, 5289972, 5289995, 5046451, 5046454, 4315704, 4315703, 4315705, 10696614, 5402361, 8217929, 5402350, 2703240, 3194973, 4427616, 4427614, 4427610, 1095721, 6005724, 4427614, 4427612, 4427616, 1095721, 4427611, 7957037, 8099027, 3205241, 8208307, 7829478, 8175358, 4268107, 7708032, 1224843, 1169450, 4357872, 4357847, 2116689, 2323543, 2323552, 2479365, 4531246, 2755063, 3032984, 3032980, 3032986, 5186291, 2650858, 4536509, 2137834, 5252971, 5210979, 5209950, 1882905, 4433170, 5376351, 5376309, 5376337, 5376426, 5376435, 5376357, 2657801, 2156506, 5349965, 2321463, 2321466, 4810589, 5868180, 8435025, 2888814, 2888816, 2374804, 1362963, 2296666, 8018241, 5252870, 2294144, 2235022, 3084850, 2321098, 2321098, 2321094, 2331256, 2331276, 2331267, 3101193, 3101184, 4372949, 8462585, 1380657, 3742239, 2324127, 5421144, 1548900, 1548955, 1029160, 5830619, 5034845, 2484417, 1507934, 4416161, 1729292, 2437619, 1311831, 1203924, 1204035, 1204047, 1203918, 1203910, 9296147, 9629323, 9553901, 7296839, 5730193, 3143034, 8292300, 3142951, 3142974, 5198034, 1031742, 1031743, 4372861, 3166285, 6489837, 3049799, 3049685, 3049513, 5304469, 5304583, 2927222, 7309179, 2927220, 3901967, 2927224, 5330001, 2284433, 4429363, 2287073, 2287072, 4371623, 2070390, 2580870, 4984515, 2078315, 2776471, 4563479, 3084872, 3084869, 3191008, 5073713, 5073820, 5074849, 5075111, 5074589, 5074215, 5075039, 5074662, 5073820, 5073574, 5073510, 1856893, 3001836, 1242914, 1242934, 1309652, 5656424, 7319302, 2082867, 1879452, 2925655, 2412966, 1401771, 2422538, 5186319, 2075229, 2139421, 7672713, 8293804, 2092891, 2092833, 2227670, 2227665, 5568446, 5568442, 11715681, 5568428, 5568415, 7707087, 7422037, 5568361, 5568339, 5568322, 7720286, 1803060, 1803108, 1803012, 1803078, 2513560, 2874680, 1871826, 1419322, 1419325, 3150935, 5674620, 6431411, 2702808, 2702827, 2702822, 4118773, 2702816, 2702820, 2702806, 2702795, 4469718, 5817851, 7725417, 5331404, 4315760, 5233633, 5392859, 5392672, 7281375, 4413950, 4413955, 1420846, 4059853, 7551118, 2925889, 4068166, 2925895, 4067965, 4067922, 1031791, 2480075, 5384950, 2330739, 2330731, 4527258, 2265658, 1031391, 4397116, 1031397, 8026099, 9559829, 1031402, 4397216, 1031403, 1031399, 1031404, 8298912, 1386680, 5711881, 2480876, 2480898, 2702865, 2702863, 2702862, 3221418, 5116698, 1006399, 5815559, 8955108, 5815560, 8906702, 2307762, 1384088, 5423038, 3039269, 3039274, 7293094, 3039272, 3039270, 3039267, 4048240, 3792084, 3634845, 5973976, 2480461, 2458438, 2216045, 4488979, 2335806, 5646136, 5421094, 7289729, 5421095, 4984866, 4374760, 2717771, 2717329, 2717948, 2716838, 2717421, 2717467, 7766369, 2716818, 2717522, 1618227, 4124350, 2705957, 4115735, 2705953, 4115439, 2705955, 3119915, 3035369, 2424091, 2424089, 2439683, 4114523, 2928303, 5329198, 5329212, 6133140, 9025973, 9181627, 7701320, 7705954, 2927075, 7308883, 2613163, 5176082, 8766300, 5290282, 5290313, 4110465, 5290299, 5290323, 5290148, 5290318, 5724665, 6520752, 5192089, 5724656, 2491521, 2491490, 2491538, 2491475, 2491491, 1030870, 4401162, 7376217, 1859046, 8937497, 2008616, 8909809, 3053961, 3053950, 1365278, 1365671, 1365611, 1365463, 1365699, 1365686, 1365555, 1365627, 1365473, 1365418, 1365676, 1365511, 1365496, 1365386, 1365477, 1365557, 1365723, 1365658, 1365637, 1365587, 1365462, 1365395, 2683786, 2683776, 6447669, 9150366, 1379402, 1379355, 6476961, 5166723, 4396308, 1032234, 1032253, 4483422, 1837172, 5727962, 2112133, 10761071, 2703892, 4152153, 4308830, 2763050, 4589737, 8485639, 3210505, 2085445, 5679692, 2576553, 2120784, 2513609, 2513597, 2513665, 2513596, 2294275, 2215190, 4312751, 2215201, 2494146, 2494143, 4485285, 2479486, 2129852, 2129866, 4476059, 1869450, 2653284, 2653321, 1878490, 1878513, 1878469, 2481904, 4451853, 1744658, 4547594, 4547594, 1597077, 3189073, 7322764, 9188840, 3189172, 3664889, 3189174, 3663811, 7737682, 3189157, 3667399, 3667121, 7322563, 3665061)
 AND speciesKey IS NOT NULL
 AND GBIF_Within('POLYGON ((-14.31175 30.26388, 68.13666 30.26388, 68.13666 82.96604, -14.31175 82.96604, -14.31175 30.26388))
', decimalLatitude, decimalLongitude) = TRUE
 AND "year" &gt;= 1950
 AND "year" IS NOT NULL
 AND hasCoordinate = TRUE
 AND NOT GBIF_STRINGARRAYCONTAINS(issue, 'ZERO_COORDINATE', TRUE)
 AND NOT GBIF_STRINGARRAYCONTAINS(issue, 'COORDINATE_OUT_OF_RANGE', TRUE)
 AND NOT GBIF_STRINGARRAYCONTAINS(issue, 'COORDINATE_INVALID', TRUE)
 AND NOT GBIF_STRINGARRAYCONTAINS(issue, 'COUNTRY_COORDINATE_MISMATCH', TRUE)
 AND NOT GBIF_STRINGARRAYCONTAINS(issue, 'TAXON_MATCH_FUZZY', TRUE)
 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,
 speciesKey,
 species,
 classKey,
 class
ORDER BY
 "year" DESC,
 eeaCellCode ASC,
 speciesKey ASC;

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