DOI: 10.15468/dl.f67yan
title: Occurrence Download

description: A dataset containing 73812 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,COUNT(*), decimalLatitude AS decimalLatitude, decimalLongitude AS decimalLongitude,MIN(COALESCE(coordinateUncertaintyInMeters, 1000)) AS minCoordinateUncertaintyInMeters, IF(ISNULL(family), NULL, SUM(COUNT(*)) OVER (PARTITION BY family)) AS familyCount
FROM 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, 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
AND decimalLatitude IS NOT NULL AND decimalLongitude IS NOT NULL
GROUP BY
eqdg_code,
speciesKey,
"year",
species,
decimalLatitude,
decimalLongitude,
family ORDER BY 
eqdg_code ASC,
"year" ASC,
speciesKey ASC,
family ASC


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