I have a little challenge. I have GPS location as a column in the user table. I used Radar to get addresses from the GPS co-ordinates. The addresses are not in a uniform format. They all have a city and a country. However sometime the city is second, sometimes it’s third. Sometimes there no delineation between the city and the country.
I am finding it very difficult to get a column with the city and a column with a country.
ChatGPT suggests Javascript. But the suggestions don’t return anything.
The radar reverse geocoding API returns separate attributes for both city & country. You should be able to extract them directly with a pair of Query JSON columns.
Just looking at the API docs, you should be able to use something like:
$addresses[0].country
$addresses[0].city
If that doesn’t work, can you show me an example of the JSON response you get from Radar?
Thank you so much for your input Darren. This was shockingly simple with Glide AI columns (I went through the course ) I didn’t even need radar or anything of that sort. I created a text to text AI column with the questions “What is the country” and "what is the city) using the GPS location column. Voila!
Please beware that this uses additional updates on top of what you have from Radar. I would still check if Radar can offer you directly the country and city in their response, and also prevent the possiblity of hallucinating from AI.
) I didn’t even need radar or anything of that sort. I created a text to text AI column with the questions “What is the country” and "what is the city) using the GPS location column. Voila!