Occurrence Download

A dataset containing 11034 records in GBIF matching the query: SELECT '10' AS fish_cell, GBIF_MGRSCode(1000, decimalLatitude, decimalLongitude, 0) AS cell, -- NO randomization COUNT(DISTINCT speciesKey) AS species_richness FROM occurrence WHERE hasCoordinate = TRUE AND speciesKey IS NOT NULL AND NOT ARRAY_CONTAINS(issue, 'ZERO_COORDINATE') AND NOT ARRAY_CONTAINS(issue, 'COORDINATE_OUT_OF_RANGE') AND NOT ARRAY_CONTAINS(issue, 'COORDINATE_INVALID') AND NOT ARRAY_CONTAINS(issue, 'COUNTRY_COORDINATE_MISMATCH') AND decimalLatitude >= -37.42857426825602 AND decimalLatitude = -74.83335833227108 AND decimalLongitude = 2015 AND "year" 0 AND coordinateUncertaintyInMeters