# Ratel Point Location not shown correctly in Geo Tab

**URL:** <https://discuss.dgraph.io/t/ratel-point-location-not-shown-correctly-in-geo-tab/14647>\
**Category:** Ratel\
**Tags:** kind:question, ratel\
**Created:** [June 18, 2021, 2:30pm UTC](https://discuss.dgraph.io/t/ratel-point-location-not-shown-correctly-in-geo-tab/14647 "2021-06-18T14:30:39Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![4j4y](https://avatars.discourse-cdn.com/v4/letter/4/3e96dc/32.png) [@4j4y](https://discuss.dgraph.io/u/4j4y)\
**Post date:** [June 18, 2021, 2:30pm UTC](https://discuss.dgraph.io/t/ratel-point-location-not-shown-correctly-in-geo-tab/14647/1 "2021-06-18T14:30:40Z")

</div>

Hi Folks,  
I recently deployed Dgraph in production in our Organization(GoJek/GoTo), and it’s really working well for us. I am currently facing an issue while using Dgraph Ratel (latest). While querying the point location data, I want to see it mapped into Geo Tab of the UI. But currently, it doesn’t show it correctly.  
Here is the sample data:

```auto
{
  "data": {
    "node": [
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.0590391,
            112.7943516
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.0590391,
            112.7943516
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.283551,
            112.6789635
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2054482,
            113.2519578
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2064759,
            113.2519137
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2067641,
            113.2523103
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2835697,
            112.6789588
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2736745,
            112.683357
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2835697,
            112.6789588
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2835697,
            112.6789588
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.0590391,
            112.7943516
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2029214,
            113.2498783
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2835697,
            112.6789588
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2076692,
            113.2530302
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2834917,
            112.6789961
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2835697,
            112.6789588
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2577314,
            112.6477523
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2835697,
            112.6789588
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2835912,
            112.6789742
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2835697,
            112.6789588
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2067641,
            113.2523103
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2835697,
            112.6789588
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2064759,
            113.2519137
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2835495,
            112.6789655
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2835697,
            112.6789588
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2835697,
            112.6789588
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2834623,
            112.6789715
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2835697,
            112.6789588
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2064759,
            113.2519137
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2835697,
            112.6789588
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.273525,
            112.6831765
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2070905,
            113.2530418
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2835697,
            112.6789588
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2054761,
            113.2522589
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2836572,
            112.6788511
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.0590391,
            112.7943516
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.0590391,
            112.7943516
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2076692,
            113.2530302
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2067641,
            113.2523103
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2835827,
            112.6789431
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2836218,
            112.6788218
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2835697,
            112.6789588
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.0590391,
            112.7943516
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.283551,
            112.6789635
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2837332,
            112.6790435
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2836129,
            112.6786464
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.0590391,
            112.7943516
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2076692,
            113.2530302
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2835693,
            112.6790351
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2835697,
            112.6789588
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2738247,
            112.6603553
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2834237,
            112.6784343
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2067641,
            113.2523103
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.0590391,
            112.7943516
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2835697,
            112.6789588
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2835697,
            112.6789588
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.0590391,
            112.7943516
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.283551,
            112.6789635
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2835084,
            112.6788298
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2835697,
            112.6789588
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2029478,
            113.2498898
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.20537,
            113.2523317
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2067641,
            113.2523103
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2736126,
            112.6832642
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2834783,
            112.6788974
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2067641,
            113.2523103
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2835697,
            112.6789588
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2064759,
            113.2519137
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2835822,
            112.6790467
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2053473,
            113.2520368
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2067641,
            113.2523103
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.28357,
            112.678955
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.28357,
            112.678955
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.27393,
            112.6603
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.27393,
            112.6603
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.2055182,
            113.25224
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.205699,
            113.25174
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.205699,
            113.25174
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.205699,
            113.25174
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.205699,
            113.25174
          ]
        }
      },
      {
        "location": {
          "type": "Point",
          "coordinates": [
            -7.205699,
            113.25174
          ]
        }
      }
    ]
  }
}

```

and corresponding image shown in Geo tab:

 ![image](https://canada1.discourse-cdn.com/flex007/uploads/dgraph/original/2X/4/40b6020fedf18bb3c90d038a2f417b5f9f458f0e.jpeg)  
This doesn’t seem to be correct, because I checked a few of these locations on [internet](https://www.latlong.net/c/?lat=-7.090923&long=112.795801) as well and this seems to be correct.

---

<div class="post-metadata">

**Author:** ![MichelDiz](https://yyz1.discourse-cdn.com/flex007/user_avatar/discuss.dgraph.io/micheldiz/32/11873_2.png) [@MichelDiz](https://discuss.dgraph.io/u/MichelDiz)\
**Post date:** [June 18, 2021, 2:46pm UTC](https://discuss.dgraph.io/t/ratel-point-location-not-shown-correctly-in-geo-tab/14647/2 "2021-06-18T14:46:22Z")

</div>

Can you invert the coordinates? just to check. I think some geo data comes inverted in relation to Dgraph’s standard.

---

<div class="post-metadata">

**Author:** ![4j4y](https://avatars.discourse-cdn.com/v4/letter/4/3e96dc/32.png) [@4j4y](https://discuss.dgraph.io/u/4j4y)\
**Post date:** [June 18, 2021, 4:13pm UTC](https://discuss.dgraph.io/t/ratel-point-location-not-shown-correctly-in-geo-tab/14647/3 "2021-06-18T16:13:09Z")

</div>

Data is already ingested, is there a way to invert in query?

---

<div class="post-metadata">

**Author:** ![MichelDiz](https://yyz1.discourse-cdn.com/flex007/user_avatar/discuss.dgraph.io/micheldiz/32/11873_2.png) [@MichelDiz](https://discuss.dgraph.io/u/MichelDiz)\
**Post date:** [June 18, 2021, 4:16pm UTC](https://discuss.dgraph.io/t/ratel-point-location-not-shown-correctly-in-geo-tab/14647/4 "2021-06-18T16:16:33Z")

</div>

> [@4j4y](#):
>
> is there a way to invert in query?

Nope.

---

<div class="post-metadata">

**Author:** ![dmai](https://yyz1.discourse-cdn.com/flex007/user_avatar/discuss.dgraph.io/dmai/32/1254_2.png) [@dmai](https://discuss.dgraph.io/u/dmai)\
**Post date:** [June 18, 2021, 4:21pm UTC](https://discuss.dgraph.io/t/ratel-point-location-not-shown-correctly-in-geo-tab/14647/5 "2021-06-18T16:21:32Z")

</div>

> [@MichelDiz](#):
>
> I think some geo data comes inverted in relation to Dgraph’s standard.

Dgraph uses the [GeoJSON](https://geojson.org/) standard where [Points are defined as [longitude, latitude]](https://datatracker.ietf.org/doc/html/rfc7946#appendix-A.1). It looks like your data is in [latitude, longitude]. The visualization will be correct once your data is set in the right format.

---

<div class="post-metadata">

**Author:** ![4j4y](https://avatars.discourse-cdn.com/v4/letter/4/3e96dc/32.png) [@4j4y](https://discuss.dgraph.io/u/4j4y)\
**Post date:** [June 18, 2021, 4:28pm UTC](https://discuss.dgraph.io/t/ratel-point-location-not-shown-correctly-in-geo-tab/14647/6 "2021-06-18T16:28:19Z")

</div>

Dumb question,  
What if I change map data i.e. revert coordinates in

 ![image](https://canada1.discourse-cdn.com/flex007/uploads/dgraph/original/2X/9/95b186e827c3f5ce0408158dc4062cd859555c56.png)

as temporary fix? Will it work theoretically?

---

<div class="post-metadata">

**Author:** ![dmai](https://yyz1.discourse-cdn.com/flex007/user_avatar/discuss.dgraph.io/dmai/32/1254_2.png) [@dmai](https://discuss.dgraph.io/u/dmai)\
**Post date:** [June 18, 2021, 4:38pm UTC](https://discuss.dgraph.io/t/ratel-point-location-not-shown-correctly-in-geo-tab/14647/7 "2021-06-18T16:38:19Z")

</div>

Is that a `raw.githubusercontent.com` URL you wanted to share? I’m not able to see it so I don’t know what the data looks like.

---

<div class="post-metadata">

**Author:** ![4j4y](https://avatars.discourse-cdn.com/v4/letter/4/3e96dc/32.png) [@4j4y](https://discuss.dgraph.io/u/4j4y)\
**Post date:** [June 18, 2021, 5:03pm UTC](https://discuss.dgraph.io/t/ratel-point-location-not-shown-correctly-in-geo-tab/14647/8 "2021-06-18T17:03:05Z")

</div>

oh, my bad. Here is the map url: [https://raw.githubusercontent.com/zcreativelabs/react-simple-maps/master/topojson-maps/world-110m.json](https://raw.githubusercontent.com/zcreativelabs/react-simple-maps/master/topojson-maps/world-110m.json)

---

<div class="post-metadata">

**Author:** ![dmai](https://yyz1.discourse-cdn.com/flex007/user_avatar/discuss.dgraph.io/dmai/32/1254_2.png) [@dmai](https://discuss.dgraph.io/u/dmai)\
**Post date:** [June 18, 2021, 7:28pm UTC](https://discuss.dgraph.io/t/ratel-point-location-not-shown-correctly-in-geo-tab/14647/9 "2021-06-18T19:28:52Z")

</div>

If the points are in [latitude, longitude] format, then yes, reversing the coordinates would work.