DOI: 10.15468/dl.aa4dq5
title: Occurrence Download

description: A dataset containing 1790 records in GBIF matching the query:
SELECT
 gbifid,
 datasetkey,
 materialsampleid,
 catalognumber,
 othercatalognumbers,
 occurrenceid,
 materialentityid,
 ownerinstitutioncode,
 institutionid,
 institutioncode,
 scientificname,
 vernacularname,
 scientificnameid,
 taxonkey,
 preparations,
 license,
 modified,
 locality,
 county,
 municipality,
 verbatimlocality,
 island,
 v_verbatimcoordinates,
 v_verbatimlongitude,
 v_verbatimlatitude,
 continent,
 v_country,
 countrycode,
 islandgroup,
 stateprovince,
 waterbody,
 highergeography,
 locationid,
 decimallatitude,
 decimallongitude,
 footprintwkt,
 recordedby,
 recordedbyid,
 eventdate,
 "year",
 verbatimeventdate,
 fieldnumber,
 recordnumber,
 mediatype,
 v_associatedmedia,
 dwcaextension,
 "references",
 v_geodeticdatum,
 coordinateuncertaintyinmeters,
 coordinateprecision,
 footprintsrs,
 identifiedbyid
FROM
 occurrence
WHERE
 occurrence.basisofrecord = 'PRESERVED_SPECIMEN'
 AND occurrence.datasetkey = 'bf2a4bf0-5f31-11de-b67e-b8a03c50a862'
 AND occurrence.phylum IN ('Rhodophyta', 'Charophyta', 'Chlorophyta', 'Ochrophyta')
 AND (occurrence.materialsampleid IS NOT NULL OR occurrence.catalognumber IS NOT NULL OR occurrence.othercatalognumbers IS NOT NULL OR occurrence.occurrenceid IS NOT NULL OR occurrence.materialentityid IS NOT NULL)
 AND (occurrence.ownerinstitutioncode IS NOT NULL OR occurrence.institutionid IS NOT NULL OR occurrence.institutioncode IS NOT NULL)
 AND (occurrence.scientificname IS NOT NULL OR occurrence.vernacularname IS NOT NULL OR occurrence.scientificnameid IS NOT NULL OR occurrence.taxonkey IS NOT NULL)
 AND occurrence.preparations IS NOT NULL
 AND occurrence.license IS NOT NULL
 AND occurrence.modified IS NOT NULL
 AND (occurrence.locality IS NOT NULL OR occurrence.county IS NOT NULL OR occurrence.municipality IS NOT NULL OR occurrence.verbatimlocality IS NOT NULL OR occurrence.island IS NOT NULL OR occurrence.v_verbatimcoordinates IS NOT NULL OR occurrence.v_verbatimlongitude IS NOT NULL OR occurrence.v_verbatimlatitude IS NOT NULL OR occurrence.continent IS NOT NULL OR occurrence.v_country IS NOT NULL OR occurrence.countrycode IS NOT NULL OR occurrence.islandgroup IS NOT NULL OR occurrence.stateprovince IS NOT NULL OR occurrence.waterbody IS NOT NULL OR occurrence.highergeography IS NOT NULL)
 AND (occurrence.locationid IS NULL OR occurrence.decimallatitude IS NOT NULL OR occurrence.decimallongitude IS NOT NULL OR occurrence.footprintwkt IS NOT NULL)
 AND (occurrence.recordedby IS NOT NULL OR occurrence.recordedbyid IS NOT NULL)
 AND (occurrence.eventdate IS NOT NULL OR occurrence."year" IS NOT NULL OR occurrence.verbatimeventdate IS NOT NULL)
 AND (occurrence.fieldnumber IS NOT NULL OR occurrence.recordnumber IS NOT NULL)
 AND (occurrence.mediatype IS NOT NULL OR occurrence.v_associatedmedia IS NOT NULL)

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