Skip to main content

I have a list of coordinates and want to plug them in a return what city/state/country they are in

  • March 12, 2022
  • 2 replies
  • 26 views

Forum|alt.badge.img+4

I have a table with many thousands of coordinates. I would like to search these data points by city or state or country but I only have the pairs. Does anyone know whether the Maps app can return such data?

Alternatively, does anyone have any solutions other than the Maps app?

Thank you!

2 replies

Forum|alt.badge.img+19
  • Inspiring
  • 3263 replies
  • March 12, 2022

The maps app can show you where these locations are, but it doesn’t have the search functionality you need as near as I recall.

You can create a search feature with lat/lngs though - create an automation script (or script block) that reverse geo-encodes the city, state, country from the lat/lng pairs. Then use Airtable search features to find the records based on the city/state/country values.


Forum|alt.badge.img+4
  • Author
  • New Participant
  • 4 replies
  • March 14, 2022

The maps app can show you where these locations are, but it doesn’t have the search functionality you need as near as I recall.

You can create a search feature with lat/lngs though - create an automation script (or script block) that reverse geo-encodes the city, state, country from the lat/lng pairs. Then use Airtable search features to find the records based on the city/state/country values.


Very cool! Going to look into that in the next couple hours, will let you know if it works