Occurrence Download

A dataset containing 474835 records in GBIF matching the query:
SELECT
kingdom,
kingdomkey,
phylum,
phylumkey,
class,
classkey,
"order",
orderkey,
family,
familykey,
genus,
genuskey,
species,
specieskey,
"year",
GBIF_MGRSCODE(100000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)) mgrscellcode,
IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER (
PARTITION BY familykey, GBIF_MGRSCODE(100000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year")) familycount,
IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER (
PARTITION BY genuskey, GBIF_MGRSCODE(100000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year")) genuscount,
COUNT(*) occurrences,
MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty,
MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters
FROM
occurrence
WHERE
occurrence.occurrencestatus = 'PRESENT'
AND (occurrence.taxonkey IN ('7359', '5644') OR occurrence.acceptedtaxonkey IN ('7359', '5644') OR occurrence.kingdomkey IN ('7359', '5644') OR occurrence.phylumkey IN ('7359', '5644') OR occurrence.classkey IN ('7359', '5644') OR occurrence.orderkey IN ('7359', '5644') OR occurrence.familykey IN ('7359', '5644') OR occurrence.genuskey IN ('7359', '5644') OR occurrence.specieskey IN ('7359', '5644'))
AND occurrence.hasgeospatialissues = FALSE
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.classificationdetails['d7dddbf4-2cf0-4f39-9b2a-bb099caae36c']['specieskey'] <> '' AND occurrence."year" 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,
occurrence."year",
GBIF_MGRSCODE(100000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000))

The dataset's 474835 records were derived from 2600 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0000008-260430073515954/datasets/export for details.

Data from some individual datasets included in this download may be licensed under less restrictive terms.