Occurrence Download

A dataset containing 60476561 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(5000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 3000)) eeacellcode, IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY orderkey, GBIF_EEARGCODE(5000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 3000)), PRINTF('%04d-%02d-%02d', "year", "month", "day"))) ordercount, IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY familykey, GBIF_EEARGCODE(5000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 3000)), PRINTF('%04d-%02d-%02d', "year", "month", "day"))) familycount, IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY genuskey, GBIF_EEARGCODE(5000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 3000)), PRINTF('%04d-%02d-%02d', "year", "month", "day"))) genuscount, COUNT(*) occurrences, MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty, MIN(COALESCE(coordinateuncertaintyinmeters, 3000)) mincoordinateuncertaintyinmeters FROM occurrence WHERE occurrence.continent = 'EUROPE' AND occurrence.occurrencestatus = 'PRESENT' AND (occurrence.taxonkey IN ('1108', '3073') OR occurrence.acceptedtaxonkey IN ('1108', '3073') OR occurrence.kingdomkey IN ('1108', '3073') OR occurrence.phylumkey IN ('1108', '3073') OR occurrence.classkey IN ('1108', '3073') OR occurrence.orderkey IN ('1108', '3073') OR occurrence.familykey IN ('1108', '3073') OR occurrence.genuskey IN ('1108', '3073') OR occurrence.specieskey IN ('1108', '3073')) AND (occurrence."year" >= 1975 AND occurrence."year"