# Translating geo coordinates into location names

**URL:** <https://community.glideapps.com/t/translating-geo-coordinates-into-location-names/46683>\
**Category:** Ask for Help\
**Created:** [August 14, 2022, 2:53am UTC](https://community.glideapps.com/t/translating-geo-coordinates-into-location-names/46683 "2022-08-14T02:53:15Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Michael\_Zaps](https://avatars.discourse-cdn.com/v4/letter/m/c5a1d2/32.png) [@Michael\_Zaps](https://community.glideapps.com/u/Michael_Zaps)\
**Post date:** [August 14, 2022, 2:53am UTC](https://community.glideapps.com/t/translating-geo-coordinates-into-location-names/46683/1 "2022-08-14T02:53:15Z")

</div>

Does anyone know how to translate the coordinates recovered from the Location component and translate it into the actual names of the locations?

I’m trying to have my users input their location, then use those coordinates to automatically identify their location names and include it in their public profile.

---

<div class="post-metadata">

**Author:** ![Alexey\_Baranov1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexey_baranov1/32/43581_2.png) [@Alexey\_Baranov1](https://community.glideapps.com/u/Alexey_Baranov1)\
**Post date:** [August 14, 2022, 9:22pm UTC](https://community.glideapps.com/t/translating-geo-coordinates-into-location-names/46683/2 "2022-08-14T21:22:00Z")

</div>

Hi!  
PLease see @Robert_Petitto [Geoapify Tutorial](https://www.youtube.com/watch?v=4a8t7fRhdo4), use the same API - only change is to use another kind of the same API. Details here [Reverse Geocoding API | Developer Documentation | Geoapify](https://apidocs.geoapify.com/docs/geocoding/reverse-geocoding)  
Be @ Glide)  
Just be careful from picking API to match, elsewhere you will fire all the limits of free plan 🫣

---

<div class="post-metadata">

**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\
**Post date:** [August 14, 2022, 10:26pm UTC](https://community.glideapps.com/t/translating-geo-coordinates-into-location-names/46683/3 "2022-08-14T22:26:07Z")

</div>

Found another one that may help! : [Get Address.mp4 on Vimeo](https://vimeo.com/739470080)

```auto
 http://nominatim.openstreetmap.org/reverse?format=json&lat=52.5487429714954&lon=-1.81602098644987&zoom=18&addressdetails=1

```

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 15, 2022, 12:23am UTC](https://community.glideapps.com/t/translating-geo-coordinates-into-location-names/46683/4 "2022-08-15T00:23:26Z")

</div>

I use Nominatim a lot nowadays, mostly for auto-fill purposes. Works pretty well.

---

<div class="post-metadata">

**Author:** ![Michael\_Zaps](https://avatars.discourse-cdn.com/v4/letter/m/c5a1d2/32.png) [@Michael\_Zaps](https://community.glideapps.com/u/Michael_Zaps)\
**Post date:** [August 15, 2022, 3:34am UTC](https://community.glideapps.com/t/translating-geo-coordinates-into-location-names/46683/5 "2022-08-15T03:34:57Z")

</div>

> [@Dilon\_Perera](#):
>
> ` http://nominatim.openstreetmap.org/`

Thanks guys! I watched @Dilon_Perera’s video and will be using the Nominatim API. I was looking through the video and I saw they use an external code column where they used Javascript code to split the collected coordinates. How do I do that exactly? Not sure if I should be plugging in some sort of URL to the external code column setting to get things going or if theres another way to separate the coordinates that are in one column. Thanks!

---

<div class="post-metadata">

**Author:** ![Michael\_Zaps](https://avatars.discourse-cdn.com/v4/letter/m/c5a1d2/32.png) [@Michael\_Zaps](https://community.glideapps.com/u/Michael_Zaps)\
**Post date:** [August 15, 2022, 5:13am UTC](https://community.glideapps.com/t/translating-geo-coordinates-into-location-names/46683/6 "2022-08-15T05:13:06Z")

</div>

Actually, nvm I figured it out - the information I needed was in the plugins section [Plugins • Glide](https://www.glideapps.com/plugins).

I have new a question now; any advice on parsing out the location to just the city, county, and state?

For example, instead of

3625, Glendon Avenue, Palms, Los Angeles, Los Angeles County, California, 90034, United States

I would like

Palms, Los Angeles County, California

---

<div class="post-metadata">

**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\
**Post date:** [August 15, 2022, 7:47am UTC](https://community.glideapps.com/t/translating-geo-coordinates-into-location-names/46683/7 "2022-08-15T07:47:59Z")

</div>

> [@Michael\_Zaps](#):
>
> I have new a question now; any advice on parsing out the location to just the city, county, and state?

Yeah, buddy it’s possible!

Made a video! : [fetch city , county, state.mp4 on Vimeo](https://vimeo.com/739560441)

I forgot tell you that once you get the values separately you can use a template column to join them together!

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/1/c19eacf6a75ce5fa0a92006327ded61d3499e10d.png)

And the JQ Query for get them in one column!

`.address.suburb + " , " + .address.county + " , " + .address.state`

Thank you

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 15, 2022, 11:21am UTC](https://community.glideapps.com/t/translating-geo-coordinates-into-location-names/46683/8 "2022-08-15T11:21:12Z")

</div>

> [@Dilon\_Perera](#):
>
> And the JQ Query for get them in one column!

I think this should be the preferred way. Less computation to be done compared to 4 columns, I think.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [August 16, 2022, 11:21am UTC](https://community.glideapps.com/t/translating-geo-coordinates-into-location-names/46683/9 "2022-08-16T11:21:27Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
