How to get MGRS grids of different sizes using coordinates(Lat/Longs) in Redash?

Support Usage Support
,
1

I’m trying to get MGRS grids from the coordinates available in my redash tables. Is there any way to get it?

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.