Occurrence Download

A dataset containing 198 records in GBIF matching the query: SELECT "gbifid", "taxonkey", "phylum", "class", "order", "eventdate", "year", "month", "day", "georeferenceddate", "dateidentified", "lastinterpreted", "basisofrecord", "hasgeospatialissues", "hascoordinate", "occurrencestatus", CASE WHEN ROW_NUMBER() OVER ( PARTITION BY "taxonkey" ORDER BY "gbifid" ) = 1 THEN 1 ELSE 0 END AS "is_new_taxon" FROM occurrence WHERE ("hasgeospatialissues" = 'false') AND ("hascoordinate" = 'true') AND ("occurrencestatus" = 'PRESENT') AND "decimallatitude" > 41.9 AND "decimallatitude" -70.6 AND "decimallongitude"