DOI: 10.15468/dl.q3j6qu
title: Occurrence Download

description: A dataset containing 3223149 records in GBIF matching the query:
SELECT speciesKey, decimalLongitude, decimalLatitude, "year" FROM occurrence WHERE hasCoordinate = TRUE AND hasGeospatialIssues = FALSE AND CoordinateUncertaintyInMeters &gt;= 0 AND CoordinateUncertaintyInMeters &lt;= 1000 AND basisOfRecord IN ('LIVING_SPECIMEN', 'HUMAN_OBSERVATION', 'MACHINE_OBSERVATION', 'OCCURRENCE') AND ( (level0Gid IN ('ALA', 'ALB', 'AND', 'AUT', 'BLR', 'BEL', 'BIH', 'BGR', 'HRV', 'CZE', 'DNK', 'EST', 'FRO', 'FIN', 'FRA', 'DEU', 'GIB', 'GRC', 'GGY', 'HUN', 'ISL', 'IRL', 'IMN', 'ITA', 'JEY', 'XKO', 'LVA', 'LIE', 'LTU', 'LUX', 'MKD', 'MLT', 'MDA', 'MCO', 'MNE', 'NLD', 'NOR', 'POL', 'PRT', 'ROU', 'SMR', 'SRB', 'SVK', 'SVN', 'ESP', 'SJM', 'SWE', 'CHE', 'UKR', 'GBR', 'VAT') AND ((speciesKey = 1651430 AND "year" IN (2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 1652212 AND "year" IN (2018, 2019)) OR (speciesKey = 1817797 AND "year" IN (2021, 2022, 2023, 2024)) OR (speciesKey = 2427091 AND "year" IN (2011, 2012, 2013, 2014, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 2439261 AND "year" IN (2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 2439270 AND "year" IN (2011, 2012, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023)) OR (speciesKey = 2440954 AND "year" IN (2015, 2016, 2017, 2018, 2021, 2022, 2023, 2024)) OR (speciesKey = 2443002 AND "year" IN (2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 2479226 AND "year" IN (2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 2479407 AND "year" IN (2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 2489005 AND "year" IN (2016, 2017, 2018, 2019, 2022, 2023, 2024)) OR (speciesKey = 2493660 AND "year" IN (2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 2498305 AND "year" IN (2003, 2004, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013)) OR (speciesKey = 2566393 AND "year" IN (2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018)) OR (speciesKey = 2704523 AND "year" IN (2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 2706026 AND "year" IN (2020, 2021, 2022)) OR (speciesKey = 2765156 AND "year" IN (2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 2889173 AND "year" IN (2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 2891661 AND "year" IN (2010, 2011, 2012, 2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 2891755 AND "year" IN (2019, 2020, 2021, 2022)) OR (speciesKey = 2891770 AND "year" IN (2012, 2013, 2014, 2015, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 2931469 AND "year" IN (2021, 2022)) OR (speciesKey = 2970418 AND "year" IN (2021, 2022)) OR (speciesKey = 2972983 AND "year" IN (2019, 2020, 2021, 2022)) OR (speciesKey = 2978552 AND "year" IN (2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 2978730 AND "year" IN (2021, 2022, 2023, 2024)) OR (speciesKey = 2979000 AND "year" IN (2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 2984306 AND "year" IN (2018, 2019, 2020, 2021, 2022)) OR (speciesKey = 2986239 AND "year" IN (2020, 2021, 2022, 2023)) OR (speciesKey = 3033896 AND "year" IN (2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 3034825 AND "year" IN (2014, 2015, 2016, 2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 3039267 AND "year" IN (2023, 2024)) OR (speciesKey = 3109086 AND "year" IN (2014, 2015, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 3170823 AND "year" IN (2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 3172294 AND "year" IN (2019, 2020, 2021, 2022)) OR (speciesKey = 3173338 AND "year" IN (2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 3190653 AND "year" IN (2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 4264680 AND "year" IN (2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 4989904 AND "year" IN (2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 5218987 AND "year" IN (2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 5219173 AND "year" IN (2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 5219362 AND "year" IN (2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023)) OR (speciesKey = 5219681 AND "year" IN (2011, 2012, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 5232437 AND "year" IN (2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 5334240 AND "year" IN (2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 5341784 AND "year" IN (2002, 2003, 2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 5352251 AND "year" IN (2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 5361889 AND "year" IN (2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 5384075 AND "year" IN (2022, 2023, 2024)) OR (speciesKey = 5384931 AND "year" IN (2020, 2021, 2022)) OR (speciesKey = 5914287 AND "year" IN (2018, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 8002952 AND "year" IN (2006, 2007, 2019, 2020, 2021, 2022, 2023, 2024)) OR (speciesKey = 8424006 AND "year" IN (2013, 2014)) OR (speciesKey = 9326020 AND "year" IN (2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024)))) OR ("year" &gt;= 1992 AND "year" &lt;= 2024 AND ((speciesKey = 1651430 AND level0Gid IN ('JPN')) OR (speciesKey = 1652212 AND level0Gid IN ('CHN', 'JPN', 'KOR', 'PRK', 'RUS', 'TWN')) OR (speciesKey = 1817797 AND level0Gid IN ('CAN', 'MEX', 'USA')) OR (speciesKey = 2427091 AND level0Gid IN ('CAN', 'USA')) OR (speciesKey = 2439261 AND level0Gid IN ('CHN')) OR (speciesKey = 2439270 AND level0Gid IN ('IND')) OR (speciesKey = 2440954 AND level0Gid IN ('CHN', 'JPN', 'KOR', 'PRK', 'RUS', 'TWN', 'VNM')) OR (speciesKey = 2443002 AND level0Gid IN ('USA')) OR (speciesKey = 2479226 AND level0Gid IN ('AFG', 'BEN', 'BFA', 'BGD', 'BTN', 'CAF', 'CHN', 'CIV', 'CMR', 'DJI', 'EGY', 'ERI', 'ETH', 'GHA', 'GIN', 'GMB', 'GNB', 'IND', 'LBR', 'LKA', 'MLI', 'MMR', 'MRT', 'NER', 'NGA', 'NPL', 'PAK', 'SDN', 'SEN', 'SLE', 'TCD', 'TGO', 'UGA', 'VNM')) OR (speciesKey = 2479407 AND level0Gid IN ('ARG', 'BOL', 'BRA', 'PRY', 'URY')) OR (speciesKey = 2489005 AND level0Gid IN ('AFG', 'BGD', 'BTN', 'CHN', 'EGY', 'IND', 'IRN', 'KAZ', 'KHM', 'LAO', 'LBN', 'LKA', 'MMR', 'MYS', 'NPL', 'PAK', 'THA', 'TJK', 'TKM', 'UZB', 'VNM')) OR (speciesKey = 2493660 AND level0Gid IN ('AGO', 'BDI', 'BWA', 'CAF', 'CIV', 'CMR', 'COD', 'COG', 'ETH', 'GAB', 'GHA', 'GIN', 'GNQ', 'KEN', 'LBR', 'LSO', 'MOZ', 'MWI', 'NAM', 'NGA', 'RWA', 'SDN', 'SLE', 'SOM', 'STP', 'SWZ', 'TZA', 'UGA', 'ZAF', 'ZMB', 'ZWE')) OR (speciesKey = 2498305 AND level0Gid IN ('MEX')) OR (speciesKey = 2566393 AND level0Gid IN ('CHN', 'JPN', 'KOR', 'PRK', 'TWN')) OR (speciesKey = 2704523 AND level0Gid IN ('ARG', 'BRA', 'CHL', 'PRY', 'URY')) OR (speciesKey = 2706026 AND level0Gid IN ('CHN', 'IDN', 'JPN', 'KOR', 'PHL', 'RUS', 'TWN')) OR (speciesKey = 2765156 AND level0Gid IN ('BRA')) OR (speciesKey = 2889173 AND level0Gid IN ('CHN', 'JPN', 'KOR', 'TWN')) OR (speciesKey = 2891661 AND level0Gid IN ('NAM', 'ZAF')) OR (speciesKey = 2891755 AND level0Gid IN ('BLZ', 'BOL', 'CAN', 'COL', 'CRI', 'CUB', 'ECU', 'GLP', 'GTM', 'HND', 'MEX', 'MTQ', 'NIC', 'PAN', 'PER', 'PRI', 'SLV', 'USA', 'VEN')) OR (speciesKey = 2891770 AND level0Gid IN ('IND', 'NPL', 'PAK')) OR (speciesKey = 2931469 AND level0Gid IN ('BRA', 'URY')) OR (speciesKey = 2970418 AND level0Gid IN ('BLZ', 'MEX')) OR (speciesKey = 2972983 AND level0Gid IN ('AFG', 'BTN', 'CHN', 'IND', 'IRN', 'JPN', 'MMR', 'NPL', 'PAK', 'PRK', 'TWN')) OR (speciesKey = 2978552 AND level0Gid IN ('AUS')) OR (speciesKey = 2978730 AND level0Gid IN ('AUS')) OR (speciesKey = 2979000 AND level0Gid IN ('AUS')) OR (speciesKey = 2984306 AND level0Gid IN ('ARG', 'BOL', 'BRA', 'CHL', 'COL', 'ECU', 'PER')) OR (speciesKey = 2986239 AND level0Gid IN ('AUS')) OR (speciesKey = 3033896 AND level0Gid IN ('JPN')) OR (speciesKey = 3034825 AND level0Gid IN ('AZE', 'GEO', 'RUS')) OR (speciesKey = 3039267 AND level0Gid IN ('CHN', 'JPN', 'KOR', 'PRK', 'TWN', 'USA')) OR (speciesKey = 3109086 AND level0Gid IN ('BWA', 'LSO', 'MOZ', 'NAM', 'SWZ', 'ZAF')) OR (speciesKey = 3170823 AND level0Gid IN ('CHN')) OR (speciesKey = 3172294 AND level0Gid IN ('CHN', 'HKG', 'LAO', 'TWN', 'VNM')) OR (speciesKey = 3173338 AND level0Gid IN ('CHN')) OR (speciesKey = 3190653 AND level0Gid IN ('AUS', 'CHN')) OR (speciesKey = 4264680 AND level0Gid IN ('ARG', 'BOL', 'BRA', 'CHL', 'PRY', 'URY')) OR (speciesKey = 4989904 AND level0Gid IN ('CHN', 'JPN', 'KOR', 'PRK', 'RUS')) OR (speciesKey = 5218987 AND level0Gid IN ('CAN', 'TUR', 'USA')) OR (speciesKey = 5219173 AND level0Gid IN ('AUS')) OR (speciesKey = 5219362 AND level0Gid IN ('AGO', 'BEN', 'BFA', 'BWA', 'CAF', 'CIV', 'CMR', 'DJI', 'DZA', 'EGY', 'ERI', 'ETH', 'GHA', 'GIN', 'GMB', 'KEN', 'LBY', 'LSO', 'MAR', 'MLI', 'NAM', 'NER', 'NGA', 'OMN', 'SAU', 'SDN', 'SEN', 'TCD', 'TUN', 'UGA', 'YEM', 'ZAF', 'ZMB', 'ZWE')) OR (speciesKey = 5219681 AND level0Gid IN ('CAN', 'USA')) OR (speciesKey = 5232437 AND level0Gid IN ('BHS', 'CAN', 'CUB', 'CYM', 'GRL', 'HTI', 'MEX', 'PRI', 'SPM', 'TCA', 'USA')) OR (speciesKey = 5334240 AND level0Gid IN ('JPN')) OR (speciesKey = 5341784 AND level0Gid IN ('BOL', 'COL', 'ECU', 'PER', 'VEN')) OR (speciesKey = 5352251 AND level0Gid IN ('USA')) OR (speciesKey = 5361889 AND level0Gid IN ('CHN')) OR (speciesKey = 5384075 AND level0Gid IN ('BMU', 'CUB', 'MEX', 'USA')) OR (speciesKey = 5384931 AND level0Gid IN ('BTN', 'CHN', 'IND', 'JPN', 'KOR', 'NPL', 'PRK', 'TWN')) OR (speciesKey = 5914287 AND level0Gid IN ('AUS', 'CHN', 'IDN', 'IND', 'JPN', 'LKA', 'SLB')) OR (speciesKey = 8002952 AND level0Gid IN ('CAN', 'MEX', 'USA')) OR (speciesKey = 8424006 AND level0Gid IN ('JPN', 'PHL', 'THA')) OR (speciesKey = 9326020 AND level0Gid IN ('BGD', 'BTN', 'CHN', 'IDN', 'IND', 'KHM', 'LAO', 'MMR', 'MYS', 'NPL', 'PAK', 'PHL', 'PRI', 'SGP', 'THA', 'TLS', 'VNM')))) )

 The dataset's 3223149 records were derived from 1425 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0006753-250325103851331/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.