Occurrence Download

A dataset containing 2423617 records in GBIF matching the query:
SELECT "year", GBIF_EEARGCode( 1000, decimalLatitude, decimalLongitude, COALESCE(coordinateUncertaintyInMeters, 1000) ) AS eeaCellCode, classKey, class, COUNT(*) AS occurrences, MIN(COALESCE(coordinateUncertaintyInMeters, 1000)) AS minCoordinateUncertaintyInMeters, MIN(GBIF_TemporalUncertainty(eventDate, null)) AS minTemporalUncertainty FROM occurrence WHERE occurrenceStatus = 'PRESENT' AND countrycode = 'BE' AND "year" >= 1900 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 (LOWER(identificationVerificationStatus) NOT IN ( 'unverified', 'unvalidated', 'not validated', 'under validation', 'not able to validate', 'control could not be conclusive due to insufficient knowledge', 'uncertain', 'unconfirmed', 'unconfirmed - not reviewed', 'validation requested' ) OR identificationVerificationStatus IS NULL)AND classKey IN (126, 131, 137, 139, 148, 151, 179, 183, 186, 194, 196, 199, 203, 205, 206, 212, 216, 220, 225, 229, 232, 244, 245, 252, 255, 256, 270, 281, 282, 307, 327, 328, 354, 356, 359, 360, 361, 365, 367, 7073593, 7228684, 7742773, 7774442, 7947184, 8179345, 9273948, 10689325, 11133537, 11418114, 11493978, 11545536, 11592253)AND COALESCE(coordinateUncertaintyInMeters, 1000) <= 10000GROUP BY "year", eeaCellCode, classKey, class ORDER BY "year" DESC, eeaCellCode ASC, classKey ASC;

The dataset's 2423617 records were derived from 664 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0022611-250402121839773/datasets/export for details.

Data from some individual datasets included in this download may be licensed under less restrictive terms.