Occurrence Download

A dataset containing 29646441 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(1000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)) eeacellcode, IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY orderkey, GBIF_EEARGCODE(1000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), PRINTF('%04d-%02d-%02d', "year", "month", "day"))) ordercount, IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY familykey, GBIF_EEARGCODE(1000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), PRINTF('%04d-%02d-%02d', "year", "month", "day"))) familycount, IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY genuskey, GBIF_EEARGCODE(1000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), PRINTF('%04d-%02d-%02d', "year", "month", "day"))) genuscount, COUNT(*) occurrences, MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty, MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters FROM occurrence WHERE (occurrence.level0gid IN ('BEL.2_1', 'BEL.1.1.1_1') OR occurrence.level1gid IN ('BEL.2_1', 'BEL.1.1.1_1') OR occurrence.level2gid IN ('BEL.2_1', 'BEL.1.1.1_1') OR occurrence.level3gid IN ('BEL.2_1', 'BEL.1.1.1_1')) AND occurrence.occurrencestatus = 'PRESENT' AND (occurrence.taxonkey IN ('1', '5', '6') OR occurrence.acceptedtaxonkey IN ('1', '5', '6') OR occurrence.kingdomkey IN ('1', '5', '6') OR occurrence.phylumkey IN ('1', '5', '6') OR occurrence.classkey IN ('1', '5', '6') OR occurrence.orderkey IN ('1', '5', '6') OR occurrence.familykey IN ('1', '5', '6') OR occurrence.genuskey IN ('1', '5', '6') OR occurrence.specieskey IN ('1', '5', '6')) AND (occurrence."year" >= 1975 AND occurrence."year"