Calculating country from lat long - latitude longitude

CarolineRogg1 · 2025-01-09T08:16:34+00:00

There was an error rendering this rich post.

Hi,

I have a data set containing lat long information, but I need the country information. Any idea how to calculate that in an ETL or Beast?

I see there are lat long maps, which show the country information correctly, but I would need that in my table.

Example:

	Location Longitude		Location Latitude


	-149.5485		-17.7538

	11.609		50.9414

	12.859		56.6709

Thanks!

Caroline

Find more posts tagged with

Accepted answers

ColemenWilson

There is a Domo Dimensions Connector dataset called countries_latitude_longitude.csv but I'm not sure the best way to accurately join this data. You'd need to maybe round the data so it would join cleaner (maybe to the tenth?) but I worry about errors.

Screen Shot 2025-01-09 at 8.39.35 AM.png

The better option would be to use DomoGPT in a Jupyter Workspace model and prompt it to return the Country for each Lat/Long in your data. That would be more accurate but would be more effort and require your InfoSec approving the use of Domo GPT.

All comments

ColemenWilson

CarolineRogg1

Thanks much for the suggestion. I try the connector first!