Occurrence Download

A dataset containing 250 records in GBIF matching the query: SELECT countryCode, COUNT(DISTINCT classKey) AS distinct_classes, COUNT(DISTINCT orderKey) AS distinct_orders, COUNT(DISTINCT familyKey) AS distinct_families, COUNT(DISTINCT genusKey) AS distinct_genera, COUNT(DISTINCT speciesKey) AS distinct_species, COUNT(*) AS total_occurrences, -- Count occurrences per taxonomic level COUNT(DISTINCT CASE WHEN classKey IS NOT NULL THEN gbifid END) AS occurrences_with_class, COUNT(DISTINCT CASE WHEN orderKey IS NOT NULL THEN gbifid END) AS occurrences_with_order, COUNT(DISTINCT CASE WHEN familyKey IS NOT NULL THEN gbifid END) AS occurrences_with_family, COUNT(DISTINCT CASE WHEN genusKey IS NOT NULL THEN gbifid END) AS occurrences_with_genus FROM occurrence WHERE hasCoordinate = TRUE AND hasgeospatialissues = FALSE AND basisOfRecord != 'FOSSIL_SPECIMEN' AND countryCode IS NOT NULL AND occurrencestatus = 'PRESENT' GROUP BY countryCode ORDER BY countryCode The dataset's 250 records were derived from 71417 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0010937-260226173443078/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.