Occurrence Download

A dataset containing 16713 records in GBIF matching the query:SELECT '361' 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 >= 28.773895969281842 AND decimalLatitude <= 33.06103686093294 AND decimalLongitude >= 113.67301865001613 AND decimalLongitude <= 122.45456395408395 AND "year" >= 2015 AND "year" <= 2026 AND (coordinateUncertaintyInMeters <= 100 OR coordinateUncertaintyInMeters IS NULL) GROUP BY fish_cell, cell The dataset's 16713 records were derived from 210 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0010053-260120142942310/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.