Occurrence Download

A dataset containing 2 records in GBIF matching the query:SELECT "year", GBIF_EEARGCode( 1000, decimalLatitude, decimalLongitude, COALESCE(coordinateUncertaintyInMeters, 1000) ) AS eeaCellCode, classKey, class, familyKey, family, 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 familyKey IS NOT NULL 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 familyKey IN (5666)AND COALESCE(coordinateUncertaintyInMeters, 1000) <= 10000GROUP BY "year", eeaCellCode, classKey, class, familyKey, family ORDER BY "year" DESC, eeaCellCode ASC, familyKey ASC; The dataset's 2 records were derived from 2 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0000028-250710112747441/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.