Calculating country from lat long - latitude longitude

Options
CarolineRogg1
CarolineRogg1 Member
in Magic ETL

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

Best Answer

  • ColemenWilson
    ColemenWilson Coach
    edited January 9 Answer ✓

    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.

    If I solved your problem, please select "yes" above

Answers

  • ColemenWilson
    ColemenWilson Coach
    edited January 9 Answer ✓

    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.

    If I solved your problem, please select "yes" above

  • CarolineRogg1
    CarolineRogg1 Member

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

Categories