DOI: 10.15468/dl.qve98j
title: Occurrence Download

description: A dataset containing 83473 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 ('CO') AND speciesKey IN (2431315, 9338198, 2431289, 2431296, 9577531, 2431259, 9268523, 2431290, 9545519, 11539236, 8531823, 2426319, 11433514, 2426290, 5216705, 7785931, 5216689, 5216638, 5216697, 5216644, 5216632, 5216618, 5216685, 5216673, 8304240, 5216611, 5216664, 5216655, 5216631, 10746797, 5216668, 5216690, 5216654, 5216688, 5216674, 5216660, 8298659, 7712378, 5216694, 5216609, 5216693, 5216633, 5216700, 5216683, 5216671, 5216635, 5216703, 2422192, 2422196, 10722300, 8608994, 2423153, 8464900, 5216977, 5216885, 5216926, 5216896, 5216987, 5216841, 5216904, 5216927, 2429465, 2429499, 2429462, 2429464, 2429490, 2429495, 2429500, 2429503, 2429481, 10814932, 10724610, 10787159, 2429394, 2429441, 2429328, 10760915, 2429377, 10890337, 2429365, 2429368, 2429352, 2429389, 2429371, 2429342, 2429379, 2429359, 10721467, 10842940, 10739522, 2426021, 2424985, 2425875, 10758785, 10841663, 10884670, 2425873, 2425097, 2425044, 2425014, 2424996, 2425859, 2425842, 2425671, 2425628, 2425571, 2425418, 2425311, 2425231, 2425160, 2425142, 2425126, 2425735, 2425601, 2425560, 2425544, 2425526, 2425508, 2425428, 2425265, 2425172, 2425153, 2425066, 2425798, 2425642, 2425553, 2425533, 2425519, 2425398, 2425384, 10855389, 2425349, 2425297, 2425280, 2425233, 2425197, 2425180, 2424990, 2425545, 2425496, 2425476, 2425390, 2425376, 2425363, 2425305, 2425016, 2425863, 2425846, 2425830, 10857707, 2425596, 2425575, 2425521, 9309439, 2425455, 2425400, 2425282, 2425217, 2425117, 2425040, 2425714, 2425623, 2425581, 2425443, 2425290, 2425832, 2425490, 2425402, 2425331, 2425252, 2425219, 2425095, 2425076, 2424992, 2425840, 2425825, 5785438, 2425774, 2425716, 9299318, 2425498, 2425416, 2425340, 2425192, 2425086, 2425069, 2425850, 2425834, 2425769, 2425733, 2425637, 2425459, 2425441, 2425426, 2425388, 2425317, 2425042, 2425012, 2425758, 2425655, 2425382, 2425367, 2425261, 2425244, 2425194, 2425071, 2425942, 2425982, 2425945, 2425984, 2425947, 2425955, 2425958, 2425976, 2425940, 10795634, 10862510, 7393394, 8213814, 7536992, 7651757, 7773159, 8240569, 9331187, 8290723, 7725061, 2428977, 2428978, 2428982, 2428984, 2428975, 2428985, 10845498, 10886856, 2429175, 2429169, 2429251, 2429223, 2429188, 2429215, 2429195, 2429227, 10704401, 10002746, 10041465, 2429137, 2429146, 2429140, 10643110, 10813843, 5218019, 5218020, 10755604, 2429062, 2429060, 10718275, 2424016, 2430112, 2430105, 2430111, 5218147, 5218196, 5218182, 5218174, 5218162, 5218150, 5218184, 5218168, 5218171, 5218192, 2429984, 9677467, 8855870, 2428311, 2428333, 2428299, 2428303, 2428289, 2428305, 2428291, 2428329, 2428313, 2428297, 2428339, 2428321, 2430888, 2430884, 2467165, 2467088, 2467207, 5223977, 5223858, 5223914, 2455429, 2452606, 2456921, 2453810, 5226970, 5227052, 11162988, 9452814, 2450943, 2450915, 11117482, 2450757, 7890528, 9437485, 2468068, 2468068, 2448206, 2446445, 2446456, 2444957, 2442071, 8894817, 2442225, 8841716, 2442153, 9789983, 2443652, 2442399, 2442785, 2442795, 2442789, 2442782, 9533689, 2441409, 2441329, 2441344, 2477557, 2477618, 2498127, 2498177, 7373023, 2498305, 2498003, 9345027, 5959223, 2482178, 2482172, 2482171, 2482168, 2482271, 2482216, 2482224, 5228040, 5228049, 5228041, 2482063, 9691034, 2480971, 2480975, 2480888, 2481907, 2480374, 5229170, 5788512, 5228216, 2474837, 2481225, 2496093, 2496098, 8184592, 5232019, 5232136, 7516718, 5228486, 2476132, 10983511, 2477035, 5228535, 5788552, 5228536, 11110017, 7858664, 7548091, 11077667, 5228247, 2479046, 2479030, 2478357, 2478579, 2478858, 2478861, 2481086, 5959233, 5959230, 5229120, 2479473, 2479477, 2480179, 2480100, 2479912, 2479816, 2479854, 2480129, 9415596, 2490404, 2482546, 2486417, 5959195, 2486397, 2486504, 2486243, 2491123, 2491624, 5788834, 2491438, 2491464, 9697915, 2488745, 5845578, 6088359, 7604570, 2485846, 2490520, 2490522, 2490517, 2490530, 2490519, 2490543, 8032918, 2484281, 5229915, 5229931, 2484179, 2484244, 2489759, 2489795, 8330576, 6093350, 2487705, 2491005, 2490978, 8986607, 5789077, 5789075, 5789072, 2490227, 2490030, 2490037, 2488331, 2488330, 5230597, 2488782, 2488368, 2488350, 5230666, 5230940, 2488162, 10728818, 2493862, 5789241, 6089798, 7652738, 5231458, 2490835, 2483628, 2483709, 2483334, 2483200, 5229775, 2482649, 6100766, 2487431, 2487433, 2439956, 2433360, 5706807, 2433216, 2435292, 2435296, 2434340, 2434930, 5219426, 2433738, 2433681, 2433401, 2440899, 2440709, 2440735, 2440718, 5220086, 2440537, 2440314, 8123917, 5219593, 5786069, 5219591, 5786070, 4267251, 2436464, 2436476, 2436469, 7361386, 7832196, 9407885, 8594043, 9438354, 9234391, 9250812, 2439161, 2439166, 2439802, 2437612, 2437607, 2436649, 2438903, 11215067, 2436642, 2436641, 8365779, 2440807, 4827382, 2436637, 7261725, 2440787, 2439849, 5786667, 5786085, 2433316, 2433214, 2439874, 5220122, 2433922, 2436346, 5220096, 2440912, 2440542, 8395500, 2440898, 2440993, 2439173, 7456473, 5787406, 9527247, 11219159, 6156842, 6179762, 6175177, 4262310, 2436348, 4267366, 5786089, 4267247) 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 83473 records were derived from 786 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0032805-240906103802322/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.