Calculating country from lat long - latitude longitude

CarolineRogg1

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

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.

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.

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.

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.

CarolineRogg1

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