DOI: 10.15468/dl.brnbya
title: Occurrence Download

description: A dataset containing 33047 records in GBIF matching the query:
SELECT
GBIF_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
FROM occurrence
WHERE countrycode = 'ZA'
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, 5777120, 1806872, 1806871, 2888443, 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, 12372868, 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)
AND "year" &lt;= 2022
GROUP BY
eqdg_code,
speciesKey,
"year",
species,
family ORDER BY 
eqdg_code ASC,
"year",
speciesKey ASC


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