You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SELECT
GBIF_MGRSCode(
100000,
decimalLatitude,
decimalLongitude,
COALESCE(coordinateUncertaintyInMeters, 0)
) AS mgrs,
COUNT(DISTINCT speciesKey) AS unique_species_count
FROM
occurrence
GROUP BY
mgrs
The text was updated successfully, but these errors were encountered:
I think some of the smallest values like 01CCA are invalid, see image where the grid starts at D for -180°.
Zones 1-9 are currently formatted without a leading zero. I can't see an official specification, but if it's this then I should add that zero.
I haven't looked at what's happening in Australia.
Note you should filter for coordinateUncertaintyInMeters being reasonable, there are some extremely large values. (We should probably add a geospatial issue for very large values in this field.)
@MattBlissett
It seems like certain bands of MGRS ids are not returned.
https://www.gbif.org/occurrence/download/0017153-240425142415019
Here is a sample of ids that were not found in the download but should seemingly be present unless I have misinterpreted something...
The text was updated successfully, but these errors were encountered: