# Kibana tilemap not showing any results

**URL:** <https://discuss.elastic.co/t/kibana-tilemap-not-showing-any-results/51074>\
**Category:** Kibana\
**Created:** [May 26, 2016, 3:25pm UTC](https://discuss.elastic.co/t/kibana-tilemap-not-showing-any-results/51074 "2016-05-26T15:25:01Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![PCO](https://avatars.discourse-cdn.com/v4/letter/p/c89c15/32.png) [@PCO](https://discuss.elastic.co/u/PCO)\
**Post date:** [May 26, 2016, 3:25pm UTC](https://discuss.elastic.co/t/kibana-tilemap-not-showing-any-results/51074/1 "2016-05-26T15:25:01Z")

</div>

Hi there,

I have an ELK stack running correctly without geo data.

I started to add a new kind of data with geo data and unfortunately I can not visualize any data.

- Logstash receives data from filebeat (data source is a log file)
- I created a new template for ES on logstash side
- I was able to add a new index pattern in Kibana and my "location" field appears as "geo\_point" type
- I can see data in the discover section and the location field contains correct values
- In visualize section, the only possible choice in Aggregation is 'Geohash' and the field contains the location value but I only get a "no results found" message instead of the tile map.

* * *

Versions

> Logstash 2.1.3  
> Kibana 4.3.0  
> ES 2.1.0

* * *

Logstash filter

> mutate {  
> add\_field =\> {  
> "[location][lat]" =\> "%{lat}"  
> "[location][lon]" =\> "%{lon}"  
> }  
> }  
> mutate {  
> convert =\> {  
> "[location][lat]" =\> "float"  
> "[location][lon]" =\> "float"  
> }  
> }

* * *

Template definition

> {  
> "template":"elk-xxx-status-geo-\*",  
> "settings":{  
> "index.refreshinterval":"5s"  
> },  
> "mappings": {  
> "elk-xxx": {  
> "properties" : {  
> "location" : {  
> "type" : "geo\_point"  
> }  
> }  
> }  
> }  
> }

* * *

Here is an event in ES (displayed through Kibana)

> {  
> "\_index": "elk-xxx-status-geo-2016.05.26",  
> "\_type": "xxx-msg-status",  
> "\_id": "AVTtoVu0MqnIx4T11oGX",  
> "\_score": null,  
> "\_source": {  
> "message": ""26/05/16-17:14:01 RSP-G UPDATE 47.5611 -1.1867"",  
> "@version": "1",  
> "@timestamp": "2016-05-26T15:14:08.450Z",  
> "beat": {  
> "hostname": "elk-yyy",  
> "name": "elk-yyy"  
> },  
> "count": 1,  
> "fields": null,  
> "input\_type": "log",  
> "offset": 210417,  
> "source": "/var/log/xxx/filebeat-input-status.log",  
> "type": "xxx-msg-status",  
> "host": "elk-yyy",  
> "tags": [  
> "beats\_input\_codec\_plain\_applied"  
> ],  
> "msgdate": "26/05/16-17:14:01",  
> "device": "RSP-G",  
> "status": "UPDATE",  
> "lat": "47.5611",  
> "lon": "-1.1867",  
> "msgtype": "status",  
> "location": {  
> "lat": 47.5611,  
> "lon": -1.1867  
> }  
> },  
> "fields": {  
> "@timestamp": [  
> 1464275648450  
> ]  
> },  
> "sort": [  
> 1464275648450  
> ]  
> }

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [May 26, 2016, 11:22pm UTC](https://discuss.elastic.co/t/kibana-tilemap-not-showing-any-results/51074/2 "2016-05-26T23:22:16Z")

</div>

You need a single field like;

```auto
"location": {
["47.5611", "-1.1867"]
}

```

---

<div class="post-metadata">

**Author:** ![PCO](https://avatars.discourse-cdn.com/v4/letter/p/c89c15/32.png) [@PCO](https://discuss.elastic.co/u/PCO)\
**Post date:** [May 27, 2016, 8:42am UTC](https://discuss.elastic.co/t/kibana-tilemap-not-showing-any-results/51074/3 "2016-05-27T08:42:35Z")

</div>

would you mind to share your template & filter syntax ?

(the syntax you are using does not seem to be one of the 3 documented )

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [May 28, 2016, 12:55am UTC](https://discuss.elastic.co/t/kibana-tilemap-not-showing-any-results/51074/4 "2016-05-28T00:55:08Z")

</div>

You are right, I shouldn't have the quotes in there - [https://www.elastic.co/guide/en/elasticsearch/reference/current/geo-point.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/geo-point.html)

---

<div class="post-metadata">

**Author:** ![PCO](https://avatars.discourse-cdn.com/v4/letter/p/c89c15/32.png) [@PCO](https://discuss.elastic.co/u/PCO)\
**Post date:** [June 9, 2016, 3:08pm UTC](https://discuss.elastic.co/t/kibana-tilemap-not-showing-any-results/51074/5 "2016-06-09T15:08:10Z")

</div>

I am still trying to fix this but with no luck ;-(

When I perform manual requests, I can get results for "location.lat" and "location.lon" fields but nothing for "location", that's strange no ?

```
curl -XPOST @:port/elk-xxx-geoloc-2016.06.09/_search?pretty -d '{"from":0,"size":1,"sort":{"_score":{"order":"asc"}},"fields":["location.lat"],"explain":false}:'

{
  "took" : 12,
  "timed_out" : false,
  "_shards" : {
    "total" : 3,
    "successful" : 3,
    "failed" : 0
  },
  "hits" : {
    "total" : 25,
    "max_score" : null,
    "hits" : [ {
      "_index" : "elk-xxx-geoloc-2016.06.09",
      "_type" : "xxx-msg-geoloc",
      "_id" : "AVU1nBLAJrc3WfM_96XR",
      "_score" : 1.0,
      "fields" : {
        "location.lat" : [48.5364]
      },
      "sort" : [1.0]
    } ]
  }
}

curl -XPOST @:port/elk-xxx-geoloc-2016.06.09/_search?pretty -d '{"from":0,"size":1,"sort":{"_score":{"order":"asc"}},"fields":["location.lon"],"explain":false}:'
{
  "took" : 10,
  "timed_out" : false,
  "_shards" : {
    "total" : 3,
    "successful" : 3,
    "failed" : 0
  },
  "hits" : {
    "total" : 26,
    "max_score" : null,
    "hits" : [ {
      "_index" : "elk-xxx-geoloc-2016.06.09",
      "_type" : "xxx-msg-geoloc",
      "_id" : "AVU1nBLAJrc3WfM_96XR",
      "_score" : 1.0,
      "fields" : {
        "location.lon" : [-1.7748]
      },
      "sort" : [1.0]
    } ]
  }
}

curl -XPOST @:port/elk-xxx-geoloc-2016.06.09/_search?pretty -d '{"from":0,"size":1,"sort":{"_score":{"order":"asc"}},"fields":["location"],"explain":false}:'
{
  "took" : 14,
  "timed_out" : false,
  "_shards" : {
    "total" : 3,
    "successful" : 3,
    "failed" : 0
  },
  "hits" : {
    "total" : 26,
    "max_score" : null,
    "hits" : [ {
      "_index" : "elk-xxx-geoloc-2016.06.09",
      "_type" : "xxx-msg-geoloc",
      "_id" : "AVU1nBLAJrc3WfM_96XR",
      "_score" : 1.0,
      "sort" : [1.0]
    } ]
  }
}
```

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 1:51pm UTC](https://discuss.elastic.co/t/kibana-tilemap-not-showing-any-results/51074/6 "2017-07-06T13:51:00Z")

</div>


