Occurrence Download

A dataset containing 74263 records in GBIF matching the query:SELECTGBIF_EQDGCode(2,decimalLatitude,decimalLongitude,COALESCE(coordinateUncertaintyInMeters, 1000)) AS eqdg_code,speciesKey,"year",species,class,kingdom,phylum,datasetKey,publishingOrgKey,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 (2153923, 2153921, 2153919, 5829525, 2909512, 2909527, 5328103, 6894611, 6894637, 5327293, 2340714, 7676418, 5327557, 7298716, 4107059, 2705141, 2705868, 2705090, 2129330, 2129352, 7453543, 2455615, 2455676, 7576179, 4129602, 2705108, 2189283, 6894329, 6894340, 2206602, 9695387, 1884479, 2705081, 2157402, 8147463, 2279614, 4555363, 4538516, 5777120, 1806872, 1806871, 2888443, 2120418, 9657641, 2943719, 5162255, 5361801, 2492081, 5357217, 5359949, 5415088, 3086784, 3039194, 2705565, 2705622, 2705621, 8194801, 5231190, 5231209, 5231210, 5231198, 4154990, 2705650, 2705620, 2874214, 2874199, 2874190, 2874173, 1265423, 1710385, 2874219, 9451184, 5240002, 5121979, 7152132, 3587022, 8000389, 5220435, 3170823, 10855386, 2069955, 2223719, 8406925, 5185730, 2952798, 2952775, 2074692, 6276981, 8140485, 2473958, 9265904, 9664943, 9802456, 9658981, 9135535, 1393793, 2000152, 2486342, 5156506, 5729682, 12251984, 5384215, 4144406, 3034046, 2889304, 7349477, 2574135, 2440043, 7820611, 4033648, 8236498, 6391908, 3084012, 2514153, 2514154, 2925536, 5289746, 9752149, 2447419, 2096180, 2096139, 2096152, 4410223, 1871058, 5289756, 5289751, 2953161, 2986045, 2209507, 3976082, 2871003, 9348298, 2650479, 9014945, 2437845, 2927744, 6109529, 6109699, 5293119, 1995086, 2149937, 5293121, 1114246, 1114140, 2153759, 2153764, 5293153, 5293177, 2778511, 5363930, 10757028, 7540201, 2421592, 2194577, 4528100, 1852118, 2570817, 5364025, 5364029, 7455425, 5381589, 5381231, 1749580, 5156017, 5381956, 5284474, 5284474, 5290167, 5341792, 5189806, 2465402, 5341818, 6277354, 5341772, 5341784, 5341766, 3203682, 3203617, 3203643, 3203610, 2988354, 3084015, 7309625, 3084021, 5284884, 1920506, 3146150, 3190672, 3093276, 5333350, 2947990, 3122924, 9458333, 2049568, 2049572, 2494771, 4230951, 3186096, 2739494, 5285094, 5285497, 5285836, 5285533, 5285243, 5285740, 5285768, 5285750, 5285113, 5285380, 5285104, 5285019, 5285196, 5285324, 5285796, 5285777, 5285551, 5285180, 5285140, 5285216, 5285604, 5285141, 5285247, 8892957, 5285824, 5284979, 5284989, 5285173, 5285511, 5285182, 5285228, 5285082, 5285215, 5285543, 5285119, 5285501, 5285261, 5285621, 5285538, 5285385, 5285595, 5285118, 5284809, 5285286, 5285220, 5285816, 5285090, 5285565, 5285165, 5285053, 5285170, 5285219, 5285139, 5285727, 5285067, 5285635, 5285084, 5285602, 5285004, 5284982, 5285637, 5285241, 5285810, 5285629, 5285233, 5285799, 2479441, 2479437, 2479901, 2479912, 2479902, 2479906, 1522458, 5285764, 5285772, 5285091, 2525455, 2525474, 1223050, 1222991, 5285074, 3086355, 3086357, 2956069, 3190581, 3190586, 3190583, 3190580, 3190585, 2870583, 2962831, 2986285, 2453826, 9208361, 9187223, 4161770, 2096047, 5164206, 7984698, 5164238, 8319203, 5189745, 1738080, 2986293, 8677924, 2986239, 10713283, 2651790, 8208358, 3189767, 3189751, 3152815, 7400250, 2218560, 2479329, 3152820, 3152816, 3152812, 5892137, 3152817, 7126767, 1741820, 10244518, 2684855, 8668049, 2944725, 3905950, 7916408, 5601511, 5601452, 5601379, 10863132, 2171214, 3673630, 2494017, 2494063, 1873079, 3673614, 5415571, 3082282, 1831136, 3169673, 3169677, 3614691, 3169674, 2704179, 2704265, 2704178, 8300875, 5286128, 5285930, 2350050, 2154241, 2154252, 2154253, 2154249, 2154245, 2154240, 2154248, 2154244, 2154239, 2154250, 2154242, 2154243, 5791511, 5285940, 5231425, 5231424, 5231423, 2465641, 5286074, 4538730, 2479975, 2479951, 2479947, 2479948, 2479964, 5285976, 5871389, 5286079, 2291759, 5197741, 5197736, 1623380, 2131854, 1032595, 3156325, 2292582, 8110535, 8946295, 7821030, 5289917, 3035593, 2965911, 7494501, 2766030, 2765942, 4307912, 2308741, 2765991, 2766055, 8238520, 8345607, 8190077, 3040185, 3040245, 3040233, 3040196, 3040184, 3040232, 6362975, 3040237, 6457426, 6284535, 6284337, 3040227, 3040231, 3040249, 2928472, 2288926, 3084719, 3084699, 3084777, 2893899, 5301233, 2433573, 5301200, 5365717, 8356787, 1830823, 2479268, 2479270)AND "year" <=2022AND decimalLatitude IS NOT NULL AND decimalLongitude IS NOT NULLGROUP BYeqdg_code,"year",species,speciesKey,class,phylum,kingdom,decimalLatitude,decimalLongitude,publishingOrgKey,datasetKey,family ORDER BY eqdg_code ASC,"year" ASC,speciesKey ASC,family ASC The dataset's 74263 records were derived from 94 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0053310-250827131500795/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.