Occurrence Download

A dataset containing 649 records in GBIF matching the query:SELECT PRINTF('%04d-%02d', "year", "month") AS yearMonth, GBIF_EEARGCode(10000, decimalLatitude, decimalLongitude, COALESCE(coordinateUncertaintyInMeters, 10000)) AS eeaCellCode, basisOfRecord, datasetKey, countryCode, speciesKey, species, family, COUNT(*) AS occurrences FROM occurrence WHERE occurrenceStatus = 'PRESENT' AND "year" >= 2020 AND continent = 'EUROPE' AND speciesKey IN (2440934, 2340977) 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, eeaCellCode, basisOfRecord, datasetKey, countryCode, speciesKey, species, family ORDER BY yearMonth DESC, eeaCellCode ASC, countryCode ASC The dataset's 649 records were derived from 83 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0012921-240506114902167/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.