Occurrence Download

A dataset containing 1991974 records in GBIF matching the query: SELECT "year", GBIF_EEARGCode( 1000, decimalLatitude, decimalLongitude, COALESCE(coordinateUncertaintyInMeters, 1000) ) AS eeaCellCode, classKey, class, speciesKey, species, COUNT(*) AS occurrences, MIN(COALESCE(coordinateUncertaintyInMeters, 1000)) AS minCoordinateUncertaintyInMeters, MIN(GBIF_TemporalUncertainty(eventDate, null)) AS minTemporalUncertainty FROM occurrence WHERE occurrenceStatus = 'PRESENT' AND speciesKey IN (5217334, 2394604, 5218823, 2437282, 2427091, 2286388, 5219683, 9225458, 9711540, 1311477, 2367919, 1319870, 5871429, 1651430, 2226990, 2439838, 5232437, 2440946, 5220435, 2225776, 9738098, 2434271, 8721209, 9565801, 5892137, 2502792, 5187508, 2367911, 2437394, 2227231, 2437450, 2437399, 8946295, 2390064, 2440934, 4264680, 2362868, 8930656, 5220136, 1315391, 8971201, 2227289, 7965247, 8909595, 9799308, 4417558, 5855350, 5219681, 5229055, 8790531, 8701771, 2479226, 2502938, 2480764, 2482499, 2489010, 2443002, 2292586, 9442269, 2479407, 5712056, 5219858, 2498252, 4284921, 2350570, 8889878, 2227300, 2433536, 5035230, 8979506, 2486131, 2486151, 2498305, 2440954, 2489005, 5035187, 5218786, 2434552, 2350580, 2394486, 2340977, 5035017, 2979775, 8848208, 2706080, 3169169, 5389029, 8114276, 3134183, 5304294, 11055820, 3088310, 5289808, 2863943, 2889173, 2650436, 4038485, 5328593, 5384932, 10919373, 3628745, 2889088, 3642949, 5304257, 2865524, 3084923, 3189935, 2928835, 5329263, 5828232, 7346102, 4033648, 2984306, 5274863, 7978544, 7287606, 3190653, 2704521, 3084842, 5420991, 2977647, 5389017, 5358460, 5384931, 2869311, 2766030, 5361762, 2984537, 5361944, 5361785, 2891770, 3034825, 3003979, 2702865, 3086784, 6063677, 5329212, 5824863, 3129663, 3054399, 2865565, 5362054, 2765942, 2870583, 5421039, 2882443, 2978552, 3170247) AND "year" >= 2000 AND "year"