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
  • 36 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!

This topic has been closed for replies.

2 replies

Forum|alt.badge.img+19
  • Inspiring
  • 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
  • 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