Abstract
A dataset containing 4641 records in GBIF matching the query: SELECT PRINTF('%d-%02d', "year", "month") AS yearMonth, GBIF_EQDGCode(4, decimalLatitude, decimalLongitude, COALESCE(coordinateUncertaintyInMeters, 1000)) AS eqdgcCellCode, familyKey, family, speciesKey, species, COUNT(*) AS occurrences, MIN(coordinateUncertaintyInMeters) AS minCoordinateUncertaintyInMeters, SUM(COUNT(*)) OVER ( PARTITION BY GBIF_EQDGCode(4, decimalLatitude, decimalLongitude, COALESCE(coordinateUncertaintyInMeters, 1000)), PRINTF('%d-%02d', "year", "month"), familyKey ) AS familyCount FROM occurrence WHERE occurrenceStatus = 'PRESENT' AND speciesKey IN (2441176, 2481916, 2474942, 5232483, 2481681, 2480805, 2480353, 2481765, 2498026, 2474960, 2498035, 7595433, 2433399, 2433451, 5219426, 5219436, 2435238, 5219416, 2435349, 2435350, 5219461, 2440880, 5220111, 5220113, 5220112, 2440878, 5219534, 7262070, 2436441, 5219533, 5219532, 5707420, 9789983, 8841716, 8894817, 2442225, 2442153, 5220086, 2440669, 5220001, 2440339, 2440665, 2440704, 2440330, 2402105, 5220008, 8123917, 8324617, 2440505, 2440656, 2440495, 2440459, 5220033, 2440718, 2440332, 2440735, 5220042, 4352040, 2440314, 2440460, 2440537, 2440764, 4287132, 2402120, 2402119, 2402090, 2402084, 2402118, 2402088, 2402192, 2402122, 9779149, 2402193, 2402168, 2402159, 2402129, 2402149, 2402100, 4287131, 2402096, 2402092, 2402151, 2402117, 2402154, 2402124, 2402203) AND decimalLatitude >= -18.0081798 AND decimalLatitude = -79.4362778 AND decimalLongitude