Occurrence Download

A dataset containing 2364443 records in GBIF matching the query:SELECT "year", GBIF_MGRSCode( 1000, decimalLatitude, decimalLongitude, COALESCE(coordinateUncertaintyInMeters, 1000) ) AS mgrsCode, speciesKey, species, family, COUNT() AS n, MIN(COALESCE(coordinateUncertaintyInMeters, 1000)) AS minCoordinateUncertaintyInMeters, IF(ISNULL(family), NULL, SUM(COUNT()) OVER (PARTITION BY family)) AS familyCount FROM occurrence WHERE occurrenceStatus = 'PRESENT' 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 countryCode = 'BE' AND "year" >= 2007 AND "year" <= 2022 AND speciesKey IS NOT NULL AND decimalLatitude IS NOT NULL AND decimalLongitude IS NOT NULL AND class = 'Aves' AND collectionCode != 'ABV' GROUP BY "year", mgrsCode, speciesKey, family, species ORDER BY "year" ASC, mgrsCode ASC, speciesKey ASC The dataset's 2364443 records were derived from 45 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0010814-250127130748423/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.