How can we help?

New post
0

Get country defined from longitude and latitude

Avatar
Steve Walker
None
Follow

Hi there,

I have a data set with lng and lat - but i dont have a country column. Is there any way to use Klipfolio to take the lng/lat values and create a column against my data with the countries defined?

Many thanks, Steve

Date Votes

2 comments

  • 0
    Avatar
    Janice Janczyn

    Hi Steve,

    Google Maps has a Geocoding API that can convert lat/long to country, etc, however this can be cumbersome to use as it requires a query per lat/long pair. A better option would be to either get the country information into your data set (which service are you using?) or possibly maintain a spreadsheet with the mapping from approximate lat/long ranges to country. 

    Thanks,
            Janice

  • 0
    Avatar
    Steve Walker

    Thanks Janice - yes, the aim is not to store this in our data source we provide to KF as it bloats the json.

    Ideally a merge that would look at our lng/lat and add a country column would be ideal...

    We are using json from our rest api - our business is Task.io which collects remote data among other things.

    Kind regards, Steve.

Please sign in to leave a comment.