DOI: 10.15468/dl.afzz9t
title: Occurrence Download

description: A dataset containing 118 records in GBIF matching the query:
SELECT
 kingdom,
 kingdomkey,
 phylum,
 phylumkey,
 class,
 classkey,
 "order",
 orderkey,
 family,
 familykey,
 genus,
 genuskey,
 species,
 specieskey,
 IF(ISNULL(kingdomkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY kingdomkey)) kingdomcount,
 IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY phylumkey)) phylumcount,
 IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY classkey)) classcount,
 IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY orderkey)) ordercount,
 IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY familykey)) familycount,
 IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY genuskey)) genuscount,
 COUNT(*) occurrences
FROM
 occurrence
WHERE
 occurrence.decimallatitude &gt;= 30.74559
 AND occurrence.decimallatitude &lt;= 30.96537
 AND (occurrence.decimallongitude &gt;= -115.80079 AND occurrence.decimallongitude &lt;= -115.55424)
 AND GBIF_WITHIN('POLYGON ((-115.6178 30.93832, -115.62258 30.94053, -115.62076 30.9487, -115.6231 30.95625, -115.62752 30.96122, -115.63451 30.96487, -115.64993 30.96537, -115.64993 30.96368, -115.65838 30.9603, -115.65838 30.95861, -115.66823 30.95522, -115.67175 30.94992, -115.67301 30.94375, -115.67204 30.93832, -115.66829 30.9313, -115.6745 30.92792, -115.68172 30.92076, -115.68941 30.90488, -115.70832 30.88597, -115.71868 30.87973, -115.72851 30.86113, -115.74604 30.85234, -115.75465 30.8383, -115.76299 30.82997, -115.7833 30.81514, -115.7875 30.81356, -115.80079 30.81596, -115.79531 30.81153, -115.78179 30.81153, -115.78179 30.81322, -115.77672 30.81491, -115.77672 30.8166, -115.77165 30.81829, -115.77165 30.81998, -115.76657 30.82167, -115.75474 30.81998, -115.75474 30.81829, -115.75136 30.8166, -115.75136 30.80307, -115.75812 30.79124, -115.75812 30.78786, -115.7615 30.7811, -115.7615 30.76757, -115.75981 30.76419, -115.75981 30.75887, -115.7429 30.77571, -115.72201 30.77573, -115.71492 30.77708, -115.70691 30.78215, -115.70261 30.78952, -115.69606 30.79315, -115.67697 30.79238, -115.67697 30.79631, -115.67528 30.79631, -115.67359 30.79969, -115.67021 30.79969, -115.67021 30.798, -115.66345 30.798, -115.66176 30.79631, -115.64823 30.79462, -115.64316 30.79124, -115.64316 30.78955, -115.64147 30.78955, -115.63978 30.78617, -115.6364 30.78448, -115.63471 30.7811, -115.63302 30.7811, -115.63302 30.77771, -115.62964 30.77602, -115.62795 30.77264, -115.6195 30.76926, -115.6195 30.76757, -115.61611 30.76757, -115.61273 30.7625, -115.60935 30.7625, -115.60428 30.75912, -115.59921 30.75912, -115.59076 30.75236, -115.58399 30.74898, -115.58061 30.74898, -115.58061 30.74728, -115.57554 30.74559, -115.56878 30.74559, -115.56878 30.74728, -115.5654 30.74728, -115.56371 30.74898, -115.56202 30.75743, -115.55863 30.76419, -115.55525 30.76588, -115.55424 30.76859, -115.5595 30.8293, -115.58568 30.8521, -115.58737 30.85548, -115.58967 30.85609, -115.6 30.85263, -115.6155 30.85344, -115.62424 30.85142, -115.63534 30.84223, -115.63941 30.834, -115.64503 30.82842, -115.65208 30.82696, -115.65859 30.82839, -115.67585 30.82846, -115.6841 30.83475, -115.69397 30.83679, -115.69044 30.84261, -115.67418 30.84937, -115.66747 30.85492, -115.65539 30.85904, -115.60977 30.8592, -115.60204 30.86146, -115.5961 30.8659, -115.59921 30.87408, -115.59921 30.89101, -115.60126 30.8923, -115.61158 30.89511, -115.64809 30.89512, -115.64681 30.89674, -115.63685 30.8967, -115.62917 30.89894, -115.61875 30.89654, -115.60769 30.8967, -115.6009 30.89852, -115.60259 30.89944, -115.60259 30.90282, -115.60428 30.90282, -115.61104 30.91634, -115.61104 30.91972, -115.61273 30.91972, -115.61273 30.92818, -115.61442 30.92818, -115.61611 30.93663, -115.6178 30.93663, -115.6178 30.93832))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND occurrence.occurrencestatus = 'PRESENT'
 AND GBIF_STRINGARRAYCONTAINS(occurrence.classifications['d7dddbf4-2cf0-4f39-9b2a-bb099caae36c'], '212', TRUE)
 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.classificationdetails['d7dddbf4-2cf0-4f39-9b2a-bb099caae36c']['specieskey'] &lt;&gt; ''
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

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