# Mapping Geo-location From Database

**URL:** <https://discuss.elastic.co/t/mapping-geo-location-from-database/42553>\
**Category:** Elasticsearch\
**Created:** [February 24, 2016, 5:43am UTC](https://discuss.elastic.co/t/mapping-geo-location-from-database/42553 "2016-02-24T05:43:11Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![Croos](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/croos/32/29489_2.png) [@Croos](https://discuss.elastic.co/u/Croos)\
**Post date:** [February 29, 2016, 9:53am UTC](https://discuss.elastic.co/t/mapping-geo-location-from-database/42553/5 "2016-02-29T09:53:37Z")

</div>

Thanks a lot Magnus.

```
{
       "message" => "16798207,Yonago,35.433,133.333\r",
      "@version" => "1",
    "@timestamp" => "2016-02-29T09:30:26.379Z",
          "path" => "country1.csv",
          "host" => "Lenovo-PC",
          "type" => "data",
            "id" => "16798207",
    "first_name" => "Croos",
      "location" => {
        "lat" => "35.433",
        "lon" => "133.333"
    }
}
{
       "message" => "16798463,Izumo,35.367,132.767\r",
      "@version" => "1",
    "@timestamp" => "2016-02-29T09:30:26.379Z",
          "path" => "country1.csv",
          "host" => "Lenovo-PC",
          "type" => "data",
            "id" => "16798463",
    "first_name" => "Vinith",
      "location" => {
        "lat" => "35.367",
        "lon" => "132.767"
    }
}

```

Now the logstash executed successfully. Now my problem is visualizing the same on kibana. For that, I start another [thread](https://discuss.elastic.co/t/visualizing-geo-points-on-kibana/42985).

---

_[View the full topic](https://discuss.elastic.co/t/mapping-geo-location-from-database/42553)._