Occurrence Download

A dataset containing 472 records in GBIF matching the query: SELECT GBIF_ISEA3HCode( 8, decimalLatitude, decimalLongitude, COALESCE(coordinateUncertaintyInMeters, 1000) ) AS geogrid_id, CASE WHEN classKey IN ('359') THEN 'Mammals' WHEN classKey IN ('212') THEN 'Birds' WHEN familyKey IN ('1103', '1104', '494', '495', '1105', '496', '497', '1106', '498', '499', '1107', '537', '538', '1153', '547', '1162', '548', '549', '550', '1163', '1164', '1165', '1166', '1167', '1305', '1067', '1306', '1307', '1308', '1068', '1069', '587', '1310', '588', '589', '1311', '1312', '1313', '590', '708', '890', '774', '889', '773', '772', '888', '765', '879') THEN 'Bony Fish' WHEN classKey IN ('131') THEN 'Amphibians' WHEN classKey IN ('216') THEN 'Insects' WHEN classKey IN ('11418114', '11569602', '11592253', '11493978') THEN 'Reptiles' WHEN phylumKey IN ('52') THEN 'Molluscs' WHEN classKey IN ('367') THEN 'Arachnids' WHEN classKey IN ('220', '196') THEN 'Flowering Plants' WHEN classKey IN ('194', '244', '228', '282') THEN 'Gymnosperms' WHEN orderKey IN ('392') THEN 'Ferns' WHEN phylumKey IN ('35') THEN 'Mosses' WHEN phylumKey IN ('95') THEN 'Sac Fungi' WHEN phylumKey IN ('34') THEN 'Basidiomycota' END AS taxonomic_group, COUNT(DISTINCT speciesKey) AS species_count FROM occurrence WHERE countryCode = 'EG' AND hasCoordinate = TRUE AND hasGeospatialIssues = FALSE AND coordinateUncertaintyInMeters