Occurrence Download
收藏DataCite Commons2025-04-10 更新2025-04-15 收录
下载链接：
https://www.gbif.org/occurrence/download/0015060-250402121839773
下载链接
链接失效反馈官方服务：
资源简介：
A dataset containing 2050669 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 occurrence.basisofrecord IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN')
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 2050669 records were derived from 39 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0015060-250402121839773/datasets/export for details.
Data from some individual datasets included in this download may be licensed under less restrictive terms.
提供机构：
The Global Biodiversity Information Facility
创建时间：
2025-04-10
