DOI10.15468/dl.gr68sa

Please cite as

GBIF.org (26 June 2024) GBIF Occurrence Download https://doi.org/10.15468/dl.gr68sa
Copy BibTex RIS

 

授权条款
文件
1 GB SQL TSV zip
涉及的数据集
{{ 12407 | localNumber}}
在文本字段中查找具有相似匹配文本的记录。对于特定字段中的匹配文本，请使用相应的过滤器，例如“科学名称”的过滤器。
{{ 1258 | localNumber}}
在文本字段中查找具有相似匹配文本的记录。对于特定字段中的匹配文本，请使用相应的过滤器，例如“科学名称”的过滤器。
{{ 115 | localNumber}}
SELECT "year", GBIF_ISEA3HCode( 6, decimalLatitude, decimalLongitude, COALESCE(coordinateUncertaintyInMeters, 1000) ) AS isea3hCellCode, familyKey, family, speciesKey, species, basisOfRecord, COUNT(*) AS occurrences, MIN(COALESCE(coordinateUncertaintyInMeters, 1000)) AS minCoordinateUncertaintyInMeters, MIN(GBIF_TemporalUncertainty(eventDate)) AS minTemporalUncertainty, IF(ISNULL(familyKey), NULL, SUM(COUNT(*)) OVER (PARTITION BY familyKey, "year", basisOfRecord)) AS familyCount FROM occurrence WHERE occurrenceStatus = 'PRESENT' AND continent IS NOT NULL AND (coordinateUncertaintyInMeters <= 50000 OR coordinateUncertaintyInMeters IS NULL) AND kingdomKey = 6 AND hasCoordinate = TRUE AND speciesKey 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 "year" IS NOT NULL GROUP BY "year", isea3hCellCode, familyKey, family, speciesKey, species, basisOfRecord ORDER BY "year" DESC, familyKey ASC, speciesKey ASC, basisOfRecord ASC;

Download as TSV