DOI: 10.15468/dl.89ekpv
title: Occurrence Download

description: A dataset containing 6334 records in GBIF matching the query:
SELECT PRINTF('%04d-%02d', "year", "month") AS yearMonth, GBIF_EQDGCCode(3, decimalLatitude, decimalLongitude, COALESCE(coordinateUncertaintyInMeters, 10000)) AS eqdgcCellCode, basisOfRecord, datasetKey, countryCode, speciesKey, species, family, class, order_, COUNT(*) AS occurrences FROM occurrence WHERE occurrenceStatus = 'PRESENT' AND "year" &lt;= 2024 AND countryCode IN ('BO') AND speciesKey IN (10865918, 5216990, 2424499, 2424523, 2424487, 2428315, 2428337, 2424979, 5218152, 5216621, 5216831, 5216897, 2429375, 2424480, 2424477, 2424518, 2424484, 2424460, 2424516, 2424473, 10794016, 10819426, 10804175, 10819929, 10886986, 10670110, 10743075, 10685744, 2426327, 5216881, 2429357, 2424486, 2424507, 2424467, 2424503, 2428331, 2423458, 5217477, 2424971, 2424968, 2424977, 10860887, 10680231, 10788212, 10689503, 10676129, 10810155, 10721083, 10855183, 2424904, 10871229, 10727081, 10679866, 5223963, 5223963, 5846511, 2442795, 2460298, 5223963, 5223964, 9306352, 2441409, 2472937, 5222303, 2460260, 2460522, 7936394, 7488809, 5225709, 2458345, 5223963, 5223225, 5223415, 2453475, 5223557, 5712490, 5220817, 2441396, 2441394, 2441991, 2441980, 9533689, 5220283, 5220281, 2442037, 2468213, 5227372, 2460613, 5224846, 5224872, 5224860, 5224883, 2464991, 2465228, 2458342, 5789833, 2458323, 5223437, 9582469, 5226945, 2444960, 9379695, 5220763, 5220861, 8433859, 2482171, 2482267, 5959235, 5959224, 2485048, 5788707, 9101785, 2495160, 5229425, 2480375, 5788452, 2485287, 5230115, 2490015, 2482685, 2483780, 2491153, 2477596, 2482219, 2482183, 2481106, 2481108, 2481907, 2480516, 5788512, 2474391, 2474389, 2479359, 2479272, 6170795, 2479629, 2497399, 5230076, 7341001, 5789128, 6174639, 2486499, 5788911, 9594691, 2491830, 2491160, 2434979, 5706328, 4264738, 2439414, 2440815, 2433215, 9509736, 9613557, 9213198, 2433681, 2440998, 2440980, 2438941, 5219955, 2439854, 5786553, 5220096, 2440792, 4265381, 4265371, 2433341, 5963042, 5787387, 7810095, 2436471, 2436464, 2436372, 2436646, 2434444, 2434919, 5219426, 2433401, 6165034, 2440898, 2440963, 5220125, 2440978, 8755526, 2437902, 2437612, 2439986, 2439972, 2439966, 2439961, 2440821, 2440817, 2440816, 2440788, 2436346, 5706811, 5218752, 2433173, 8843902, 2432434, 4827382, 9178968, 2436652, 2436651, 2434454, 2434450, 2434942, 2434950, 2433738, 2440995, 2440993, 2439165, 2438945, 2438933, 4263406, 2439634) AND hasCoordinate = TRUE 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 "month" IS NOT NULL GROUP BY yearMonth, eqdgcCellCode, basisOfRecord, datasetKey, countryCode, speciesKey, species, family, class, order_ ORDER BY yearMonth DESC, eqdgcCellCode ASC, countryCode ASC

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