DOI: 10.15468/dl.4u6r7s
title: Occurrence Download

description: A dataset containing 15 records in GBIF matching the query:
SELECT
 kingdom,
 kingdomkey,
 phylum,
 phylumkey,
 class,
 classkey,
 "order",
 orderkey,
 family,
 familykey,
 genus,
 genuskey,
 species,
 specieskey,
 "year",
 IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY familykey, "year")) familycount,
 IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY genuskey, "year")) genuscount,
 COUNT(*) occurrences,
 MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty,
 MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters
FROM
 occurrence
WHERE
 occurrence.decimallatitude &gt;= 43.74905
 AND occurrence.decimallatitude &lt;= 45.16767
 AND (occurrence.decimallongitude &gt;= 38.69243 AND occurrence.decimallongitude &lt;= 40.73123)
 AND GBIF_WITHIN('POLYGON ((38.69243 45.06679, 38.69348 45.0416, 38.69483 44.98614, 38.78733 44.96423, 38.83734 44.92563, 39.09243 44.77203, 39.09932 44.76632, 39.5116 44.72593, 39.50622 44.75184, 39.50525 44.78361, 39.48081 44.85155, 39.47054 44.91117, 39.46663 44.94979, 39.50231 44.94685, 39.5292 44.91557, 39.53262 44.90189, 39.52577 44.87061, 39.52968 44.85546, 39.53995 44.83786, 39.56292 44.82173, 39.58736 44.8447, 39.60789 44.8188, 39.81767 44.884, 39.88983 44.83598, 39.94493 44.77675, 39.99403 44.7465, 39.95054 44.72567, 39.93901 44.66801, 39.9457 44.63593, 39.97559 44.60736, 39.94856 44.54575, 39.98149 44.53064, 40.05481 44.42818, 40.06114 44.27396, 40.08797 44.14715, 40.00641 44.0491, 39.96792 43.98463, 40.04148 43.89565, 40.04812 43.85444, 40.09396 43.77618, 40.21419 43.76648, 40.27416 43.76101, 40.34674 43.74905, 40.34326 43.9983, 40.36247 44.25713, 40.37389 44.31213, 40.3794 44.39173, 40.38407 44.43486, 40.37116 44.48953, 40.34504 44.5732, 40.34423 44.64577, 40.31438 44.67715, 40.19275 44.89728, 40.24268 44.91056, 40.3634 44.89223, 40.48159 44.82902, 40.66496 44.49828, 40.73123 44.50775, 40.70831 44.57751, 40.68101 44.63849, 40.64214 44.71074, 40.64788 44.8265, 40.60553 44.84793, 40.53966 44.90195, 40.48784 44.94131, 40.44648 44.99862, 40.31045 45.05891, 40.30049 45.07984, 40.25365 45.11023, 40.19286 45.11123, 40.07227 45.10226, 39.9487 45.0898, 39.74525 45.13987, 39.69243 45.15083, 39.5987 45.16767, 39.58174 45.14659, 39.56112 45.12276, 39.54667 45.10227, 39.51848 45.08402, 39.50014 45.06203, 39.47081 45.02765, 39.47265 45.01116, 39.44881 45.00274, 39.45827 44.98843, 39.45131 44.97494, 39.43416 44.97224, 39.42243 44.97544, 39.40115 44.99216, 39.38646 44.98507, 39.3057 44.94798, 39.26139 44.92878, 39.24357 44.92433, 39.2344 44.91974, 39.22695 44.91371, 39.21563 44.90826, 39.18972 44.90611, 39.17435 44.91255, 39.16129 44.90743, 39.15424 44.91284, 39.14308 44.93161, 39.13265 44.94003, 39.12418 44.95415, 39.11394 44.98645, 39.10159 44.98592, 39.09188 44.98539, 39.08059 44.98751, 39.07494 44.98609, 39.07035 44.98168, 39.07 44.9785, 39.07123 44.97586, 39.06099 44.97286, 39.05129 44.97992, 39.04228 44.98309, 39.0347 44.97762, 39.03064 44.9688, 39.01975 44.9644, 39.01704 44.97732, 39.015 44.98819, 39.01228 44.99838, 38.99937 45.0045, 38.98238 45.00858, 38.97626 44.99974, 38.9681 44.98751, 38.95315 44.99703, 38.94364 45.00722, 38.94908 45.02013, 38.94976 45.03169, 38.9382 45.0344, 38.92053 45.02421, 38.9083 45.01673, 38.89946 45.02421, 38.90082 45.03576, 38.89743 45.05003, 38.88247 45.03916, 38.8608 45.03033, 38.85972 45.02016, 38.86803 45.01185, 38.86803 45.00292, 38.85787 44.99923, 38.84241 45.00585, 38.81871 45.01079, 38.8031 44.99929, 38.78339 45.00586, 38.77435 45.01818, 38.76942 45.0264, 38.75299 45.03379, 38.7571 45.04447, 38.76367 45.05515, 38.74888 45.0568, 38.73245 45.03708, 38.71766 45.04201, 38.69243 45.06679))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND occurrence.occurrencestatus = 'PRESENT'
 AND (occurrence.taxonkey = 1492 OR occurrence.acceptedtaxonkey = 1492 OR occurrence.kingdomkey = 1492 OR occurrence.phylumkey = 1492 OR occurrence.classkey = 1492 OR occurrence.orderkey = 1492 OR occurrence.familykey = 1492 OR occurrence.genuskey = 1492 OR occurrence.specieskey = 1492)
 AND NOT GBIF_STRINGARRAYCONTAINS(occurrence.issue, 'TAXON_MATCH_FUZZY', TRUE)
 AND (occurrence.distancefromcentroidinmeters &gt;= 2000.0 OR occurrence.distancefromcentroidinmeters IS NULL)
 AND NOT occurrence.basisofrecord IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN')
 AND (occurrence.specieskey IS NOT NULL AND occurrence."year" IS NOT NULL)
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,
 occurrence."year"

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