Occurrence Download

A dataset containing 15714 records in GBIF matching the query: SELECT occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['kingdom'] kingdom, occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['kingdomkey'] kingdomkey, occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['phylum'] phylum, occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['phylumkey'] phylumkey, occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['class'] class, occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['classkey'] classkey, occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['order'] "order", occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['orderkey'] orderkey, occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['family'] family, occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['familykey'] familykey, occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['genus'] genus, occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['genuskey'] genuskey, occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['species'] species, occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['specieskey'] specieskey, "year", GBIF_EQDGCODE(2, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)) eqdcellcode, SUM(COUNT(*)) OVER ( PARTITION BY occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['kingdomkey'], GBIF_EQDGCODE(2, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year") kingdomcount, SUM(COUNT(*)) OVER ( PARTITION BY occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['phylumkey'], GBIF_EQDGCODE(2, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year") phylumcount, SUM(COUNT(*)) OVER ( PARTITION BY occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['classkey'], GBIF_EQDGCODE(2, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year") classcount, SUM(COUNT(*)) OVER ( PARTITION BY occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['orderkey'], GBIF_EQDGCODE(2, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year") ordercount, SUM(COUNT(*)) OVER ( PARTITION BY occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['familykey'], GBIF_EQDGCODE(2, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year") familycount, SUM(COUNT(*)) OVER ( PARTITION BY occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['genuskey'], GBIF_EQDGCODE(2, 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 IN ('PRESENT') AND occurrence.countrycode IN ('ZA', 'ES', 'US', 'PT') AND ARRAYS_OVERLAP(occurrence.classifications['7ddf754f-d193-4cc9-b351-99906754a03b'], ARRAY('LV7')) AND (occurrence."year" >= 1980 AND occurrence."year" = 2000.0 OR occurrence.distancefromcentroidinmeters IS NULL) AND NOT occurrence.basisofrecord IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN') AND (occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['specieskey'] '' AND occurrence."year" IS NOT NULL AND occurrence.hascoordinate = TRUE) GROUP BY occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['kingdom'], occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['kingdomkey'], occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['phylum'], occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['phylumkey'], occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['class'], occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['classkey'], occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['order'], occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['orderkey'], occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['family'], occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['familykey'], occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['genus'], occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['genuskey'], occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['species'], occurrence.classificationdetails['7ddf754f-d193-4cc9-b351-99906754a03b']['specieskey'], occurrence."year", GBIF_EQDGCODE(2, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)) The dataset's 15714 records were derived from 164 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0073924-260519110011954/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.