cometadata/datacite-titles-descriptions-related-identifiers huggingface dataset:
DOI: 10.3535/53f-rdt-5vx
title: Cryptolarella abyssicola (Allman, 1888)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/ndt-vnn-610
title: Achatina Lamarck, 1799

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/9ac-p1c-wak
title: Clytia Lamouroux, 1812

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/h7x-ana-n4v
title: Aglaophenia octodonta (Heller, 1868)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/4x7-k43-lkh
title: Eudendrium album Nutting, 1898

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/z23-yqw-v0l
title: Euplica varians (G. B. Sowerby I, 1832)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/ggt-vng-yt1
title: Leptoconchus inpleuractis A. Gittenberger & E. Gittenberger, 2011

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/dp3-8cr-20y
title: Mulinia cleryana (A. d'Orbigny, 1846)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/m3k-87c-9ys
title: Oxychilus alliarius (J. S. Miller, 1822)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/g63-0zv-pv5
title: Punctum pygmaeum (Draparnaud, 1801)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/r5x-01p-zag
title: Phyllodina tenuisculpta (G. B. Sowerby II, 1868)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/m1e-7b8-xt9
title: Bivalvia Linnaeus, 1758

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/ple-fah-7tf
title: Eudendrium cyathiferum Jäderholm, 1904

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/je3-23g-bxc
title: Lignus Gray, 1834

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/sr9-9dp-snm
title: Abida cylindrica (Michaud, 1829)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/4bb-6t1-gd5
title: Abida secale brauniopsis Altimira, 1963

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/rr0-lsp-prf
title: Vallonia costata (O. F. Müller, 1774)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/qqa-mj6-xxn
title: Striosubulina Thiele, 1933

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/s52-gsw-1z9
title: Lottiidae Gray, 1840

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/fne-79a-bec
title: Bulimulus buenavistensis Pilsbry, 1897

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/w6k-qe5-211
title: Sertularella polyzonias (Linnaeus, 1758)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/nzj-4h3-plj
title: Plaxiphora caelata (Reeve, 1847)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/f5e-dcq-qk7
title: Synthecium gordoni Vervoort & Watson, 2003

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/tbx-fdq-ncj
title: Schizotricha anderssoni Jäderholm, 1904

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/lr9-mse-rd9
title: Tritia pellucida (Risso, 1826)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/z47-py9-c4b
title: Schizochiton incisus (G. B. Sowerby II, 1841)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/gqe-tea-kve
title: Gonyodiscus rotundatus (O. F. Müller, 1774)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/hrl-5dk-mvl
title: Acryptolaria conferta (Allman, 1877)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/ter-q7f-j5w
title: Cavolinia inflexa (Lesueur, 1813)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/03j-hkr-fep
title: Neritidae Rafinesque, 1815

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/ke4-lj0-tgk
title: Saphtia granulosa de Winter, 2008

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/1sf-72f-pxa
title: Cochlicopa lubrica (O. F. Müller, 1774)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/fzh-psq-grc
title: Nerita tessellata Gmelin, 1791

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/2vg-tmg-gy8
title: Animalia

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/3a5-nss-2vd
title: Omalogyra Jeffreys, 1859

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/tek-3f2-lxh
title: Succinella oblonga (Draparnaud, 1801)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/aas-8xz-qr8
title: Nemertesia ventriculiformis (Marktanner-Turneretscher, 1890)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/n4g-db2-6km
title: Vallonia costata (O. F. Müller, 1774)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/49m-a4d-w59
title: Chondrina tenuimarginata (Des Moulins, 1835)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/hl0-hs1-sxp
title: Aglaophenia tubiformis Marktanner-Turneretscher, 1890

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/345-lxs-p7w
title: Nemertesia belini Bedot, 1916

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/z9q-cx9-j52
title: Dynamena pumila (Linnaeus, 1758)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/vkc-h3f-s8g
title: Limacina lesueurii (A. d'Orbigny, 1836)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/ghh-6bt-rl4
title: Sepiola atlantica A. d'Orbigny, 1842

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/sq0-18e-p2z
title: Sepiola atlantica A. d'Orbigny, 1842

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/h2y-llw-vg2
title: Succinea putris (Linnaeus, 1758)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/x35-1wj-qcd
title: Arcinella arcinella (Linnaeus, 1767)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/11l-2d5-sl0
title: Neopycnodonte cochlear (Poli, 1795)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/cc1-vfm-rgs
title: Eudendrium rameum (Pallas, 1766)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/k84-v64-vdz
title: Sepiola intermedia Naef, 1912

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/j1z-hy7-hsn
title: Anatoma S. P. Woodward, 1859

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/xbk-tmf-vdw
title: Aglaophenia octodonta (Heller, 1868)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/gys-ssz-ldx
title: Tonicella marmorea (O. Fabricius, 1780)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/0sa-z4t-2p3
title: Nassarius consensus (Ravenel, 1861)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/nkx-x0f-ca2
title: Halecium delicatulum Coughtrey, 1876

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/jt4-4eg-dz8
title: Stenoplax floridana (Pilsbry, 1892)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/yy3-1qg-wf7
title: Hubendickia cingulata Brandt, 1974

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/74d-wcx-gz4
title: Lucinoma borealis (Linnaeus, 1767)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/eq8-3rm-xge
title: Vitrea crystallina (O. F. Müller, 1774)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/jqf-je0-vte
title: Monetaria annulus (Linnaeus, 1758)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/702-52v-gac
title: Mauritia scurra scurra (Gmelin, 1791)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/9bg-4q3-3nw
title: Eudendrium Ehrenberg, 1834

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/2wv-e6z-5wb
title: Gastropoda Cuvier, 1795

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/y99-3n7-w1t
title: Kirchenpaueria bonnevieae (Billard, 1906)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/2la-6v7-gfj
title: Everettia Godwin-Austen, 1891

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/7pp-aqc-0f6
title: Haliotidae Rafinesque, 1815

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/gbb-ea6-5av
title: Hiatula boeddinghausi (Lischke, 1870)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/9wk-bsj-9es
title: Aplus assimilis (Reeve, 1846)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/fbd-gqy-x96
title: Laevicardium serratum (Linnaeus, 1758)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/4v7-97p-3rc
title: Anatoma aspera (R. A. Philippi, 1844)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/pfc-p0l-gll
title: Papyridea lata (Born, 1778)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/25a-blt-x73
title: Alloteuthis subulata (Lamarck, 1798)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/rs2-609-1vq
title: Balea Gray, 1824

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/39f-cs1-h17
title: Halewisia expansa (Brandt, 1970)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/edq-qc8-ble
title: Ascarosepion bandense (Adam, 1939)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/acq-wwg-fe8
title: Calliostoma adspersum (R. A. Philippi, 1851)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/22h-ykt-xxk
title: Monoplex krebsii (Mörch, 1877)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/vkd-ntg-05g
title: Gulella L. Pfeiffer, 1856

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/ebk-97z-0kr
title: Carychium tridentatum (Risso, 1826)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/x0t-6m8-277
title: Zoila marginata marginata (Gaskoin, 1849)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/s06-psg-ylf
title: Lindbergia parnonensis E. Gittenberger, 2008

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/xz9-hgn-0cd
title: Pupilla muscorum (Linnaeus, 1758)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/4db-acx-hxv
title: Sertularella mediterranea Hartlaub, 1901

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/y09-k54-18w
title: Gymnarion Pilsbry, 1919

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/gc0-8d1-0cc
title: Macrorhynchia philippina Kirchenpauer, 1872

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/nrm-fa6-d6k
title: Anachis avaroides F. Nordsieck, 1975

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/pcw-bq2-12z
title: Coneuplecta calculosa (A. Gould, 1852)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/c6r-6x6-azq
title: Cyclophoridae J. E. Gray, 1847

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/t8z-hjk-7kg
title: Trigoniocardia antillarum (A. d'Orbigny, 1853)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/0hp-gc3-2tb
title: Corbula dietziana C. B. Adams, 1852

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/g67-3lv-1xq
title: Obscurella obscura obscura (Draparnaud, 1805)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/qvj-wb3-v2m
title: Nerita versicolor Gmelin, 1791

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/rkr-epy-p6r
title: Chondrina farinesii (Des Moulins, 1835)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/mmy-cfz-vfb
title: Eurytellina trinitatis Tomlin, 1929

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/v7y-bc7-wx3
title: Vitrea crystallina (O. F. Müller, 1774)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/8nc-agj-78a
title: Canarium mutabile (Swainson, 1821)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/gaa-9dq-057
title: Gulella planidens (E. von Martens, 1892)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/kw6-0yt-n2q
title: Thyroscyphus marginatus (Allman, 1877)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/lpp-jne-q43
title: Nuculana acuta (Conrad, 1832)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/ek4-z20-7tj
title: Aegopinella nitidula (Draparnaud, 1805)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.15468/dl.2qcp3q
title: Occurrence Download

description: A dataset containing 595006 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Cichlidae"
 ]
}

 The dataset includes 595006 records from 784 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0021668-260208012135463/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.5281/zenodo.18152249
title: ReHousIn EU project - Dataset for Deliverable 2.2: Urban Greening and Gentrification

description: The ReHousIn project aims to spark innovative policy solutions towards inclusionary and quality housing. To achieve this, it investigates the complex relationship between green transition initiatives and housing inequalities in European urban and rural contexts, and develops innovative policy recommendations for better and context-sensitive integration between environmentally sustainable interventions and socially inclusive housing.

The database contains the results of a study on urban greening and gentrification. Each GeoPackage (.gpkg) file includes spatial data representing the share of green areas by statistical units for the years 1991 (field GR_91), 2001 (field GR_01), 2011 (field GR_11), and 2021 (field GR_21) for the following cities: Barcelona, Budapest, London, Milan, Oslo, Paris, Vienna, and Warsaw.

The share of green areas for each reference year was calculated based on satellite imagery using the Normalized Difference Vegetation Index (NDVI). The procedure used to compute the green area share follows the code provided in the accompanying files gee_NDVI_processing and ndvi_allyears_stats.

For each city (i.e. each GeoPackage file), a gentrification indicator was also calculated (field GIXX_XX, where XX_XX denotes the years for which the indicator was computed). The indicator takes binary values (0 or 1), where a value of 1 indicates that a given statistical unit experienced gentrification during the analysed period. The gentrification indicator was computed following the methodology proposed by Friesenecker et al. (2025).
DOI: 10.5281/zenodo.18152248
title: ReHousIn EU project - Dataset for Deliverable 2.2: Urban Greening and Gentrification

description: The ReHousIn project aims to spark innovative policy solutions towards inclusionary and quality housing. To achieve this, it investigates the complex relationship between green transition initiatives and housing inequalities in European urban and rural contexts, and develops innovative policy recommendations for better and context-sensitive integration between environmentally sustainable interventions and socially inclusive housing.

The database contains the results of a study on urban greening and gentrification. Each GeoPackage (.gpkg) file includes spatial data representing the share of green areas by statistical units for the years 1991 (field GR_91), 2001 (field GR_01), 2011 (field GR_11), and 2021 (field GR_21) for the following cities: Barcelona, Budapest, London, Milan, Oslo, Paris, Vienna, and Warsaw.

The share of green areas for each reference year was calculated based on satellite imagery using the Normalized Difference Vegetation Index (NDVI). The procedure used to compute the green area share follows the code provided in the accompanying files gee_NDVI_processing and ndvi_allyears_stats.

For each city (i.e. each GeoPackage file), a gentrification indicator was also calculated (field GIXX_XX, where XX_XX denotes the years for which the indicator was computed). The indicator takes binary values (0 or 1), where a value of 1 indicates that a given statistical unit experienced gentrification during the analysed period. The gentrification indicator was computed following the methodology proposed by Friesenecker et al. (2025).
DOI: 10.15468/dl.gwz8zu
title: Occurrence Download

description: A dataset listing the 61 species recorded in GBIF matching the query:
{
 "and" : [
 "Geometry POLYGON((-60.02546 -18.61284,-60.19566 -18.63681,-60.50251 -18.9029,-60.52408 -19.09228,-60.21724 -19.17619,-59.88642 -19.05393,-60.02546 -18.61284))",
 "OccurrenceStatus is Present",
 "TaxonKey is Plantae"
 ]
}

 The dataset's 61 records were derived from 22 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0021692-260208012135463/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.47ktpg
title: Occurrence Download

description: A dataset containing 1000136 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Geometry POLYGON((-20 -38,55 -38,55 38,-20 38,-20 -38))",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "OccurrenceStatus is Present",
 "TaxonKey is Cuculiformes"
 ]
}

 The dataset includes 1000136 records from 228 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0021681-260208012135463/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.rvwvx4
title: Occurrence Download

description: A dataset containing 840704 records in GBIF matching the query:
SELECT
 kingdom,
 kingdomkey,
 phylum,
 phylumkey,
 class,
 classkey,
 "order",
 orderkey,
 family,
 familykey,
 genus,
 genuskey,
 species,
 specieskey,
 countrycode countrycode,
 IF(ISNULL(kingdomkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY kingdomkey, countrycode)) kingdomcount,
 IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY phylumkey, countrycode)) phylumcount,
 IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY classkey, countrycode)) classcount,
 IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY orderkey, countrycode)) ordercount,
 IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY familykey, countrycode)) familycount,
 IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY genuskey, countrycode)) genuscount,
 COUNT(*) occurrences,
 MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty,
 MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters
FROM
 occurrence
WHERE
 occurrence.continent = 'ASIA'
 AND occurrence.occurrencestatus = 'PRESENT'
 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 NOT occurrence.basisofrecord IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN')
 AND (occurrence.classificationdetails['d7dddbf4-2cf0-4f39-9b2a-bb099caae36c']['specieskey'] &lt;&gt; '' 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,
 occurrence.countrycode

 The dataset's 840704 records were derived from 10607 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0021672-260208012135463/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.e6hbgx
title: Occurrence Download

description: A dataset listing the 0 species recorded in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Cyrenidae",
 "GadmGid is CAN.11_1",
 "HasGeospatialIssue is false"
 ]
}

 The dataset's 0 records were derived from 0 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0258513-220831081235567/datasets/export for details.