I’m trying to get MGRS grids from the coordinates available in my redash tables. Is there any way to get it?
This site is in read only mode. Please continue to browse, but replying, likes,
and other actions are disabled for now.
jesse
2
Welcome to the forum!
I think you’ll need some custom script / tool to gather this for you. MGRS grids aren’t JOINable since there is a many-to-one relationship between LatLong and MGRS.
You could probably use something like this mgrs library to read coordinates from your database tables and then UPDATE a new column with the calculated MGRS grid. Then in Redash you could just SELECT from this new column.