DOI: 10.15468/dl.fhmp63
title: Occurrence Download

description: A dataset containing 97386 records in GBIF matching the query:
SELECT
 kingdom,
 kingdomkey,
 phylum,
 phylumkey,
 class,
 classkey,
 "order",
 orderkey,
 family,
 familykey,
 genus,
 genuskey,
 species,
 specieskey,
 GBIF_ISEA3HCODE(10, decimallatitude, decimallongitude, 0.0) isea3hcellcode,
 COUNT(*) occurrences
FROM
 occurrence
WHERE
 occurrence.basisofrecord = 'HUMAN_OBSERVATION'
 AND occurrence.occurrencestatus = 'PRESENT'
 AND (occurrence.taxonkey IN ('1934693', '1926385', '1930110', '1926324', '1922197', '5882965', '1932411', '1932393', '7417698', '1929697', '8356768', '1929270', '5882898', '1929659', '1932976', '1924713', '1932752', '7508312', '7552387', '5882969', '5882980', '7391741', '9750977', '7985111', '4535140', '1926260', '8030835', '1925918', '8016522', '1922343', '1922406', '1922311', '1922584', '1928248', '1923019', '1924097', '1924082', '5138561', '5714680', '5714690', '7977706', '1933138', '1933126', '1933095', '1933163', '10854079', '1933793', '5139156', '7601222', '8020665', '9816676', '1926054', '1925221', '7354189', '1925233', '7484070', '7664111', '5772730', '5140436', '7597891', '5140311', '7445680', '7634721', '5140244', '5140214') OR occurrence.acceptedtaxonkey IN ('1934693', '1926385', '1930110', '1926324', '1922197', '5882965', '1932411', '1932393', '7417698', '1929697', '8356768', '1929270', '5882898', '1929659', '1932976', '1924713', '1932752', '7508312', '7552387', '5882969', '5882980', '7391741', '9750977', '7985111', '4535140', '1926260', '8030835', '1925918', '8016522', '1922343', '1922406', '1922311', '1922584', '1928248', '1923019', '1924097', '1924082', '5138561', '5714680', '5714690', '7977706', '1933138', '1933126', '1933095', '1933163', '10854079', '1933793', '5139156', '7601222', '8020665', '9816676', '1926054', '1925221', '7354189', '1925233', '7484070', '7664111', '5772730', '5140436', '7597891', '5140311', '7445680', '7634721', '5140244', '5140214') OR occurrence.kingdomkey IN ('1934693', '1926385', '1930110', '1926324', '1922197', '5882965', '1932411', '1932393', '7417698', '1929697', '8356768', '1929270', '5882898', '1929659', '1932976', '1924713', '1932752', '7508312', '7552387', '5882969', '5882980', '7391741', '9750977', '7985111', '4535140', '1926260', '8030835', '1925918', '8016522', '1922343', '1922406', '1922311', '1922584', '1928248', '1923019', '1924097', '1924082', '5138561', '5714680', '5714690', '7977706', '1933138', '1933126', '1933095', '1933163', '10854079', '1933793', '5139156', '7601222', '8020665', '9816676', '1926054', '1925221', '7354189', '1925233', '7484070', '7664111', '5772730', '5140436', '7597891', '5140311', '7445680', '7634721', '5140244', '5140214') OR occurrence.phylumkey IN ('1934693', '1926385', '1930110', '1926324', '1922197', '5882965', '1932411', '1932393', '7417698', '1929697', '8356768', '1929270', '5882898', '1929659', '1932976', '1924713', '1932752', '7508312', '7552387', '5882969', '5882980', '7391741', '9750977', '7985111', '4535140', '1926260', '8030835', '1925918', '8016522', '1922343', '1922406', '1922311', '1922584', '1928248', '1923019', '1924097', '1924082', '5138561', '5714680', '5714690', '7977706', '1933138', '1933126', '1933095', '1933163', '10854079', '1933793', '5139156', '7601222', '8020665', '9816676', '1926054', '1925221', '7354189', '1925233', '7484070', '7664111', '5772730', '5140436', '7597891', '5140311', '7445680', '7634721', '5140244', '5140214') OR occurrence.classkey IN ('1934693', '1926385', '1930110', '1926324', '1922197', '5882965', '1932411', '1932393', '7417698', '1929697', '8356768', '1929270', '5882898', '1929659', '1932976', '1924713', '1932752', '7508312', '7552387', '5882969', '5882980', '7391741', '9750977', '7985111', '4535140', '1926260', '8030835', '1925918', '8016522', '1922343', '1922406', '1922311', '1922584', '1928248', '1923019', '1924097', '1924082', '5138561', '5714680', '5714690', '7977706', '1933138', '1933126', '1933095', '1933163', '10854079', '1933793', '5139156', '7601222', '8020665', '9816676', '1926054', '1925221', '7354189', '1925233', '7484070', '7664111', '5772730', '5140436', '7597891', '5140311', '7445680', '7634721', '5140244', '5140214') OR occurrence.orderkey IN ('1934693', '1926385', '1930110', '1926324', '1922197', '5882965', '1932411', '1932393', '7417698', '1929697', '8356768', '1929270', '5882898', '1929659', '1932976', '1924713', '1932752', '7508312', '7552387', '5882969', '5882980', '7391741', '9750977', '7985111', '4535140', '1926260', '8030835', '1925918', '8016522', '1922343', '1922406', '1922311', '1922584', '1928248', '1923019', '1924097', '1924082', '5138561', '5714680', '5714690', '7977706', '1933138', '1933126', '1933095', '1933163', '10854079', '1933793', '5139156', '7601222', '8020665', '9816676', '1926054', '1925221', '7354189', '1925233', '7484070', '7664111', '5772730', '5140436', '7597891', '5140311', '7445680', '7634721', '5140244', '5140214') OR occurrence.familykey IN ('1934693', '1926385', '1930110', '1926324', '1922197', '5882965', '1932411', '1932393', '7417698', '1929697', '8356768', '1929270', '5882898', '1929659', '1932976', '1924713', '1932752', '7508312', '7552387', '5882969', '5882980', '7391741', '9750977', '7985111', '4535140', '1926260', '8030835', '1925918', '8016522', '1922343', '1922406', '1922311', '1922584', '1928248', '1923019', '1924097', '1924082', '5138561', '5714680', '5714690', '7977706', '1933138', '1933126', '1933095', '1933163', '10854079', '1933793', '5139156', '7601222', '8020665', '9816676', '1926054', '1925221', '7354189', '1925233', '7484070', '7664111', '5772730', '5140436', '7597891', '5140311', '7445680', '7634721', '5140244', '5140214') OR occurrence.genuskey IN ('1934693', '1926385', '1930110', '1926324', '1922197', '5882965', '1932411', '1932393', '7417698', '1929697', '8356768', '1929270', '5882898', '1929659', '1932976', '1924713', '1932752', '7508312', '7552387', '5882969', '5882980', '7391741', '9750977', '7985111', '4535140', '1926260', '8030835', '1925918', '8016522', '1922343', '1922406', '1922311', '1922584', '1928248', '1923019', '1924097', '1924082', '5138561', '5714680', '5714690', '7977706', '1933138', '1933126', '1933095', '1933163', '10854079', '1933793', '5139156', '7601222', '8020665', '9816676', '1926054', '1925221', '7354189', '1925233', '7484070', '7664111', '5772730', '5140436', '7597891', '5140311', '7445680', '7634721', '5140244', '5140214') OR occurrence.specieskey IN ('1934693', '1926385', '1930110', '1926324', '1922197', '5882965', '1932411', '1932393', '7417698', '1929697', '8356768', '1929270', '5882898', '1929659', '1932976', '1924713', '1932752', '7508312', '7552387', '5882969', '5882980', '7391741', '9750977', '7985111', '4535140', '1926260', '8030835', '1925918', '8016522', '1922343', '1922406', '1922311', '1922584', '1928248', '1923019', '1924097', '1924082', '5138561', '5714680', '5714690', '7977706', '1933138', '1933126', '1933095', '1933163', '10854079', '1933793', '5139156', '7601222', '8020665', '9816676', '1926054', '1925221', '7354189', '1925233', '7484070', '7664111', '5772730', '5140436', '7597891', '5140311', '7445680', '7634721', '5140244', '5140214'))
 AND (occurrence."year" &gt;= 2010 AND occurrence."year" &lt;= 2025)
 AND occurrence.hasgeospatialissues = FALSE
 AND NOT GBIF_STRINGARRAYCONTAINS(occurrence.issue, 'TAXON_MATCH_FUZZY', TRUE)
 AND (occurrence.distancefromcentroidinmeters &gt;= 2000.0 OR occurrence.distancefromcentroidinmeters IS NULL)
 AND (occurrence.specieskey 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,
 GBIF_ISEA3HCODE(10, decimallatitude, decimallongitude, 0.0)

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