Occurrence Download

A dataset containing 2582 records in GBIF matching the query: SELECT FLOOR(decimallatitude / 5) * 5 lat_band, FLOOR(decimallongitude / 5) * 5 lon_band, COUNT(DISTINCT specieskey) total_species_richness, COUNT(DISTINCT CASE WHEN kingdomkey = 1 THEN specieskey ELSE NULL END) animals_count, COUNT(DISTINCT CASE WHEN kingdomkey = 5 THEN specieskey ELSE NULL END) plants_count, COUNT(DISTINCT CASE WHEN kingdomkey = 6 THEN specieskey ELSE NULL END) fungi_count, COUNT(DISTINCT CASE WHEN classkey = 212 THEN specieskey ELSE NULL END) birds_count, COUNT(DISTINCT CASE WHEN classkey = 359 THEN specieskey ELSE NULL END) mammals_count, COUNT(DISTINCT CASE WHEN classkey = 186 THEN specieskey ELSE NULL END) amphibia_count FROM occurrence WHERE occurrence.occurrencestatus = 'PRESENT' AND occurrence.hascoordinate = TRUE AND occurrence.specieskey IS NOT NULL GROUP BY FLOOR(occurrence.decimallatitude / 5) * 5, FLOOR(occurrence.decimallongitude / 5) * 5 The dataset's 2582 records were derived from 67661 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0000781-260208012135463/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.