DOI: 10.15468/dl.mr5wh3
title: Occurrence Download

description: A dataset containing 100999 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 ('PE') AND speciesKey IN (2429027, 5216624, 5216634, 5216625, 5216616, 5216706, 5216629, 5216642, 5216628, 5216698, 5216617, 2429421, 5218180, 5218149, 10672255, 2424948, 2425887, 2425877, 2425896, 2425878, 2425893, 2425304, 2425372, 2425784, 5216952, 2424514, 2424470, 2424499, 2424502, 8819931, 2424490, 2424507, 2429050, 5216663, 5216666, 5216684, 5216621, 10879397, 2426030, 2426031, 8891896, 2429485, 10811223, 2429504, 2428992, 5218204, 2429202, 2424936, 10821079, 9014688, 10680606, 2424958, 10862119, 2425895, 2425883, 10844884, 2425046, 2425861, 2425658, 2425164, 2425625, 10717425, 2424910, 2429124, 5216825, 5216874, 8922443, 10673150, 2424483, 2424463, 2424478, 10886038, 2424497, 9160323, 2429486, 2429483, 2424453, 2428990, 2428331, 2428327, 5217547, 2427146, 2424941, 10719883, 2422949, 2429375, 2425882, 2425888, 2425900, 2425881, 2425821, 2425374, 2425225, 2425123, 2425082, 2425188, 2425438, 2425414, 2425748, 2425607, 2425139, 2425018, 2425542, 2425627, 2425530, 2425276, 10735531, 2429125, 5216838, 5217002, 5216843, 5216976, 2424493, 2424467, 2424472, 2424510, 2429005, 2429032, 8504143, 5216657, 2429056, 2429973, 5217481, 10864736, 2429345, 2425619, 2425635, 2429100, 9188056, 5217943, 10173033, 2429011, 2429030, 7785918, 5216656, 2430992, 5218269, 5218276, 2424520, 2424521, 2424492, 2424515, 2485048, 2485082, 2482171, 5788705, 6176696, 6101193, 2482192, 2481379, 2482057, 5789067, 2481460, 2495160, 2476642, 4352294, 5229231, 2482685, 2491440, 5229005, 2479580, 2490015, 2490508, 2490103, 2485155, 2486499, 5228461, 2498177, 5230347, 5229157, 2481869, 2486492, 9261925, 2491148, 2480405, 5229425, 5229386, 6065776, 2480971, 2480970, 2484975, 2484932, 2481410, 2486009, 2481907, 2497649, 2482313, 2480593, 2476307, 6174639, 5959230, 2483628, 2491467, 2480651, 7842368, 10728818, 2479029, 5230616, 2491076, 2477570, 2477534, 6093350, 5229299, 2486398, 2479067, 2474390, 5228247, 2479469, 2479472, 2480516, 2476709, 9235279, 2485775, 2491997, 2491996, 2481125, 2483801, 2480179, 2496097, 2480576, 2482276, 2490152, 2483583, 2498320, 5230515, 2477596, 2496814, 2482004, 2483181, 6174316, 5229435, 2495312, 2481427, 2482218, 5788628, 2485137, 2481106, 2481108, 5228771, 5788630, 2479272, 2481495, 2481499, 2481494, 2489128, 5229358, 2479839, 2485833, 5788512, 6092516, 2484976, 2484981, 2485371, 10967989, 2481408, 4847291, 2480786, 2477618, 2480129, 2488271, 2491716, 2486348, 2486234, 2483942, 2479652, 2478858, 5959225, 5959227, 2479104, 5230115, 2491448, 5229821, 2478579, 2476127, 2485944, 2488775, 2477287, 2477545, 5228583, 2479535, 2481021, 2481047, 2490549, 2474391, 2481814, 2490532, 2490544, 2490546, 2490512, 2483013, 2482973, 2483012, 2493956, 5788617, 2481953, 2485146, 2481515, 2481516, 2497399, 5789071, 2476859, 2482278, 2481937, 2490123, 2479405, 5229790, 9594691, 2476620, 6066498, 2480214, 2476245, 2476246, 2481110, 2479901, 2482310, 2486381, 2480803, 2482063, 2483912, 2481500, 2478833, 2478779, 2478765, 5230940, 2484990, 2485372, 5230760, 11070244, 2481415, 2477459, 2483285, 2485903, 9291744, 5219508, 2439637, 5706328, 5219851, 9633893, 2433049, 2436657, 5219826, 2440899, 2437915, 5786089, 2432771, 2433480, 9466252, 2436642, 2436646, 2439642, 4264785, 2440815, 4266508, 2438414, 5786086, 5786085, 2434979, 2433737, 2439880, 2439954, 2439889, 5220122, 5219933, 2439961, 4828974, 5219763, 2433257, 8883987, 5787384, 2433681, 10718810, 9178968, 2433326, 2439177, 2437888, 2437896, 2437883, 2437889, 2436648, 5219592, 2434454, 2440963, 2436410, 2433364, 9527247, 2436464, 5219501, 2439640, 2440777, 5786881, 2440980, 2432301, 5786087, 2433229, 11190449, 8846474, 5220125, 2436346, 8618720, 2437740, 5218774, 5220096, 2433024, 2440912, 4265149, 2438863, 5706774, 9512820, 4265171, 4265166, 2439172, 2439164, 4265173, 2439174, 4265170, 4265164, 4265174, 2439168, 2439910, 5218455, 2433401, 2435292, 2433190, 5787391, 5706515, 2432353, 2434326, 2432457, 5219426, 2435099, 2440898, 2440993, 2439163, 2439179, 2439180, 2439162, 5220192, 2439102, 4264738, 2437574, 2440314, 2434919, 2434930, 2434950, 2434333, 5220123, 4265441, 2437361, 9195979, 5219662, 5219675, 5219689, 2440537, 2433302, 2433330, 8841716, 2441329, 2441991, 5959872, 6162877, 5220759, 8894817, 2442225, 9789983, 2460323, 2441396, 8415260, 2442795, 5959832, 2450507, 2459737, 9379695, 5220821, 5220759, 2460641, 9533689, 2471918, 2442153, 2460479, 2460254, 2442051, 5224978, 9343566, 5959833, 2442792, 2442782, 2468051, 2472934, 5227373, 2471919, 2441409, 5224949, 2441394, 11086216, 5223895, 2473010, 5222343, 2471926, 9554179, 2460369, 10723759, 5959845, 2468052, 2459756, 2459849, 2459783, 11133930) 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 100999 records were derived from 106 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0032814-240906103802322/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.