Occurrence Download

A dataset containing 2276629 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, 9448251, 1311477, 2367919, 10314173, 5871429, 1651430, 2226990, 2439838, 5232437, 2440946, 5220435, 2225776, 9738098, 2434271, 8721209, 8458912, 5892137, 2502792, 5187508, 2367913, 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, 2863941, 2889173, 2650436, 4038485, 5328593, 5384932, 10919373, 3628745, 2889088, 3642949, 5304257, 2865524, 3084923, 3189935, 2928835, 5329260, 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 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) AND COALESCE(coordinateUncertaintyInMeters, 1000)