Occurrence Download

A dataset containing 374671 records in GBIF matching the query:SELECT "year", GBIF_MGRSCode(10000, 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 level1gid = 'BEL.2_1' 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 374671 records were derived from 39 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0003849-250325103851331/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.