Occurrence Download
收藏DataCite Commons2025-04-14 更新2025-04-15 收录
下载链接：
https://www.gbif.org/occurrence/download/0012420-250402121839773
下载链接
链接失效反馈官方服务：
资源简介：
A dataset containing 575420 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 countryCode = 'BE'
AND "year" >= 2000
AND "year" <= 2024
AND speciesKey IS NOT NULL
AND decimalLatitude IS NOT NULL
AND decimalLongitude IS NOT NULL
AND class = 'Aves'
GROUP BY
"year",
mgrsCode,
speciesKey,
family,
species
ORDER BY
"year" ASC,
mgrsCode ASC,
speciesKey ASC
The dataset's 575420 records were derived from 88 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0012420-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-09
