Occurrence Download
收藏资源简介：
A dataset containing 29465 records in GBIF matching the query: SELECT kingdom, kingdomkey, phylum, phylumkey, class, classkey, "order", orderkey, family, familykey, genus, genuskey, species, specieskey, PRINTF('%04d-%02d-%02d', "year", "month", "day") yearmonthday, GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)) eeacellcode, IF(ISNULL(kingdomkey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY kingdomkey, GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), PRINTF('%04d-%02d-%02d', "year", "month", "day"))) kingdomcount, IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY phylumkey, GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), PRINTF('%04d-%02d-%02d', "year", "month", "day"))) phylumcount, IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY classkey, GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), PRINTF('%04d-%02d-%02d', "year", "month", "day"))) classcount, IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY orderkey, GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), PRINTF('%04d-%02d-%02d', "year", "month", "day"))) ordercount, IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY familykey, GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), PRINTF('%04d-%02d-%02d', "year", "month", "day"))) familycount, IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY genuskey, GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), PRINTF('%04d-%02d-%02d', "year", "month", "day"))) genuscount, COUNT(*) occurrences, MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty, MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters FROM occurrence WHERE occurrence.continent = 'EUROPE' AND occurrence.hascoordinate = TRUE AND occurrence.hasgeospatialissues = FALSE AND occurrence."month" IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) AND (occurrence.taxonkey = 5218786 OR occurrence.acceptedtaxonkey = 5218786 OR occurrence.kingdomkey = 5218786 OR occurrence.phylumkey = 5218786 OR occurrence.classkey = 5218786 OR occurrence.orderkey = 5218786 OR occurrence.familykey = 5218786 OR occurrence.genuskey = 5218786 OR occurrence.specieskey = 5218786) AND (occurrence."year" >= 2000 AND occurrence."year" <= 2025) AND NOT GBIF_STRINGARRAYCONTAINS(occurrence.issue, 'TAXON_MATCH_FUZZY', TRUE) AND (occurrence.distancefromcentroidinmeters >= 2000.0 OR occurrence.distancefromcentroidinmeters IS NULL) AND NOT occurrence.basisofrecord IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN') AND occurrence.occurrencestatus = 'PRESENT' AND (occurrence.specieskey IS NOT NULL AND occurrence."year" IS NOT NULL AND occurrence."month" IS NOT NULL AND occurrence."day" IS NOT NULL AND occurrence.hascoordinate = TRUE) GROUP BY occurrence.kingdom, occurrence.kingdomkey, occurrence.phylum, occurrence.phylumkey, occurrence.class, occurrence.classkey, occurrence."order", occurrence.orderkey, occurrence.family, occurrence.familykey, occurrence.genus, occurrence.genuskey, occurrence.species, occurrence.specieskey, PRINTF('%04d-%02d-%02d', "year", "month", "day"), GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)) The dataset's 29465 records were derived from 169 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0028148-250426092105405/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.
本数据集包含29465条符合以下查询语句的全球生物多样性信息设施（GBIF，Global Biodiversity Information Facility）记录： SELECT kingdom, kingdomkey, phylum, phylumkey, class, classkey, "order", orderkey, family, familykey, genus, genuskey, species, specieskey, PRINTF('%04d-%02d-%02d', "year", "month", "day") yearmonthday, GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)) eeacellcode, IF(ISNULL(kingdomkey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY kingdomkey, GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), PRINTF('%04d-%02d-%02d', "year", "month", "day"))) kingdomcount, IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY phylumkey, GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), PRINTF('%04d-%02d-%02d', "year", "month", "day"))) phylumcount, IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY classkey, GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), PRINTF('%04d-%02d-%02d', "year", "month", "day"))) classcount, IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY orderkey, GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), PRINTF('%04d-%02d-%02d', "year", "month", "day"))) ordercount, IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY familykey, GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), PRINTF('%04d-%02d-%02d', "year", "month", "day"))) familycount, IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY genuskey, GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), PRINTF('%04d-%02d-%02d', "year", "month", "day"))) genuscount, COUNT(*) occurrences, MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty, MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters FROM occurrence WHERE occurrence.continent = 'EUROPE' AND occurrence.hascoordinate = TRUE AND occurrence.hasgeospatialissues = FALSE AND occurrence."month" IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) AND (occurrence.taxonkey = 5218786 OR occurrence.acceptedtaxonkey = 5218786 OR occurrence.kingdomkey = 5218786 OR occurrence.phylumkey = 5218786 OR occurrence.classkey = 5218786 OR occurrence.orderkey = 5218786 OR occurrence.familykey = 5218786 OR occurrence.genuskey = 5218786 OR occurrence.specieskey = 5218786) AND (occurrence."year" >= 2000 AND occurrence."year" <= 2025) AND NOT GBIF_STRINGARRAYCONTAINS(occurrence.issue, 'TAXON_MATCH_FUZZY', TRUE) AND (occurrence.distancefromcentroidinmeters >= 2000.0 OR occurrence.distancefromcentroidinmeters IS NULL) AND NOT occurrence.basisofrecord IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN') AND occurrence.occurrencestatus = 'PRESENT' AND (occurrence.specieskey IS NOT NULL AND occurrence."year" IS NOT NULL AND occurrence."month" IS NOT NULL AND occurrence."day" IS NOT NULL AND occurrence.hascoordinate = TRUE) GROUP BY occurrence.kingdom, occurrence.kingdomkey, occurrence.phylum, occurrence.phylumkey, occurrence.class, occurrence.classkey, occurrence."order", occurrence.orderkey, occurrence.family, occurrence.familykey, occurrence.genus, occurrence.genuskey, occurrence.species, occurrence.specieskey, PRINTF('%04d-%02d-%02d', "year", "month", "day"), GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)) 本数据集的29465条记录源自169个组成数据集，详细信息请访问以下链接查询：https://api.gbif.org/v1/occurrence/download/0028148-250426092105405/datasets/export 本次下载包中部分独立数据集的授权协议可能采用更为宽松的条款。
