Occurrence Download

A dataset containing 54922 records in GBIF matching the query:SELECTGBIF_EQDGCode(2,decimalLatitude,decimalLongitude,COALESCE(coordinateUncertaintyInMeters, 1000)) AS eqdg_code,speciesKey,"year",species,family,COUNT(DISTINCT specieskey) AS unique_species_count,COUNT() as occurrence_count,COUNT(), decimalLatitude AS Latitude,decimalLongitude AS Longitude, MIN(COALESCE(coordinateUncertaintyInMeters, 1000)) AS minCoordinateUncertaintyInMeters, IF(ISNULL(family), NULL, SUM(COUNT(*)) OVER (PARTITION BY family)) AS familyCountFROM occurrence WHERE countrycode = 'ZA'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 taxonkey IN (2956947, 2958049, 7679480, 2957751, 2958076, 2957431, 2957556, 2958100, 2957977, 2957656, 2957158, 2957408, 2957966, 2957187, 2957529, 2956905, 5504400, 5264312, 2957379, 2957438, 2957478, 8058144, 2154137, 2957728, 2683909, 2684120, 2735055, 2970728, 2970645, 5151541, 2491862, 5289666, 8058520, 2702958, 1586899, 5289679, 2337607, 2887138, 9250194, 2328161, 2886244, 2070969, 2070973, 2012130, 4492199, 9223124, 2444222, 3125901, 5384795, 3145214, 2073121, 1849209, 2150319, 1217592, 2122217, 5167064, 2077096, 3046890, 3046812, 5296015, 5296278, 10968642, 7279801, 10987750, 5581538, 2929394, 2930216, 2929362, 2932011, 2931374, 2929617, 2932686, 2930323, 2931088, 2929892, 2930439, 2929230, 2931714, 2930137, 7538163, 2931469, 2931104, 2931442, 2930922, 2932040, 5035230, 2932184, 2929938, 2932389, 2931914, 5389058, 5389017, 3105813, 3105782, 8228544, 8397826, 2958909, 3012167, 2704414, 2705188, 4108244, 2705185, 7679536, 5290035, 2154041, 5176584, 5176589, 5355395, 3172574, 2918871, 7116158, 5353525, 1169782, 6101224, 6101223, 5231640, 5274893, 5529738, 5529544, 8352161, 5109882, 3116842, 3026906, 2013759, 3026408, 3026402, 3190595, 2493733, 2157245, 1095652, 3661030, 2704757, 2925454, 2925462, 1247583, 1247584, 8361961, 5384604, 3995516, 2891789, 7580523, 10752687, 4292415, 5406675, 7804270, 2441757, 4092354, 7298473, 3677870, 2495667, 2495666, 2495688, 2495708, 4143591, 5329192, 12126545, 12056552, 12098504, 2495150, 2970821, 9809229, 2331954, 2970910, 2251188, 7552504, 7623986, 8146046, 7777157, 7909475, 1747023, 2435520, 7705930, 2970844, 2981499, 5645409, 2963569, 5351887, 3190485, 5293897, 5293907, 6122622, 5293816, 3151764, 9749839, 2926066, 3185932, 3185931, 2867866, 2886039, 2886103, 5549761, 7636833, 5415036, 5415039, 3183335, 3183002, 3182605, 3182425, 8652576, 3183934, 3183840, 3183940, 3183534, 3184509, 3183420, 3184108, 3183180, 3184410, 4091191, 3172526, 2498009, 3172527, 2493634, 2493633, 3172537, 3616406, 2705666, 3088481, 5284272, 3084672, 2975768, 2874704, 2874696, 2488189, 8380575, 2153895, 2153902, 2300928, 2874700, 2445034, 2131851, 2475250, 5220168, 3063696, 5354727, 3872463, 2684191, 7630288, 5284517, 3172492, 4094394, 2139961, 7470708, 2020580, 7615104, 4298151, 4093761, 4093643, 1045843, 2925649, 3899716, 5894575, 5894595, 2288847, 8155855, 3996729, 7283993, 5341998, 3699548, 3189390, 3698958, 3189394, 2443168, 5780591, 2441454, 2441502, 3189388, 2151827, 2151758, 2151986, 1368812, 1368812, 1368812, 2130168, 2130256, 2130316, 2130286, 2130185, 7810338, 5842764, 3699873, 3699858, 2684184, 9342283, 2012298, 3035275, 2294277, 2291814, 1930137, 1930275, 1930411, 2522928, 9188141, 2522935, 9689104, 5275277, 5275319, 5170450, 5170451, 8355178, 2155846, 2071624, 2703469, 1420951, 1420906, 1420961, 7584828, 2153780, 2153778, 1607932, 2703473, 3152205, 4125808, 5293659, 2684178, 2684171, 7474172, 5203999, 8309523, 1795068, 5415458, 5415456, 5573843, 2462515, 2462503, 3152046, 3152042, 2468542, 2362524, 1858163, 3152048, 4259350, 2695149, 11528335, 11597347, 11775509, 11785880, 11844032, 1921123, 2121891, 5352512, 5396557, 5396551, 5396560, 3190472, 7271504, 7928296, 3172203, 6157026, 3034823, 5284508, 3190624, 3169713, 2739071, 5787057, 5220180, 5220177, 5220179, 2765156, 2320407, 2765221, 2012132, 2765359, 1398002, 1398016, 6443709, 2049936, 8059650, 7903563, 2279608, 4555379, 4555381, 2479686, 1398814, 1398877, 1398374, 1398338, 1398347, 1398338, 5241725, 5450605, 3324249, 5241845, 9897298, 1476105, 1476105, 5059797, 2440254, 7895921, 3054399, 5421117, 4998217, 8219807, 2444101, 2444763, 8371864, 7858801, 11093098, 3149462, 5359395, 5358748, 4038608, 4037419, 7764920, 3188062, 2431887, 2431885, 1095979, 1095977, 1095971, 2735187, 7795888, 5258451, 8857722, 4652129, 8959303, 5051118, 2490719, 7901064, 3152072, 5231791, 2284218, 2889934, 4162399, 10324910, 2874852, 2951984, 5361872, 5361866, 7303616, 5361865, 2142456, 2142516, 10182426, 7911763, 7303591, 5361869, 5361877, 5422556, 2493723, 2493725, 3382275, 5361867, 2466109, 2515813, 2517820, 10770057, 10895358, 5808231, 4990860)AND "year" > 2022AND decimalLatitude IS NOT NULL AND decimalLongitude IS NOT NULLGROUP BYeqdg_code,speciesKey,"year",species,decimalLatitude,decimalLongitude,family ORDER BY eqdg_code ASC,"year" ASC,speciesKey ASC,family ASC The dataset's 54922 records were derived from 11 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0021343-250802193616735/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.