# Visualize Geohash using JSON input **URL:** \ **Category:** Kibana\ **Created:** [October 8, 2015, 12:22pm UTC](https://discuss.elastic.co/t/visualize-geohash-using-json-input/31845 "2015-10-08T12:22:38Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![David\_L](https://avatars.discourse-cdn.com/v4/letter/d/eada6e/32.png) [@David\_L](https://discuss.elastic.co/u/David_L)\ **Post date:** [October 8, 2015, 12:22pm UTC](https://discuss.elastic.co/t/visualize-geohash-using-json-input/31845/1 "2015-10-08T12:22:38Z")
Hi All, I indexed huge machine generted time series data in elastic db. We want to visualize in kibana machines locations and statiscs regarding each machine. My naive solution is to store geohash data in each record and than visualize it. However machine location is static and its not make sense to store geohash data in each record/document. Our idea is to "burned" machines location as geohash data in JSON query ( "JSON input which allows you to specify additional aggregation parameters to send with your request"). Did this idea make sense? Is there any example how to do that ? references? Is there better solutions? Thanks ---
**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:** [October 8, 2015, 9:15pm UTC](https://discuss.elastic.co/t/visualize-geohash-using-json-input/31845/2 "2015-10-08T21:15:21Z")
You can do it but it'd have to be done external to ES. ---
**Author:** ![David\_L](https://avatars.discourse-cdn.com/v4/letter/d/eada6e/32.png) [@David\_L](https://discuss.elastic.co/u/David_L)\ **Post date:** [October 9, 2015, 5:11am UTC](https://discuss.elastic.co/t/visualize-geohash-using-json-input/31845/3 "2015-10-09T05:11:55Z")
Thank you about your response Mark. I understand that such approach is feasible. What did you mean "external to ES" ? Did you mean to read static (never changing) parameters such machine Geohash data from "external" file ? Similar topics/ examples? Thanks in Advance, David ---
**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:** [October 9, 2015, 5:15am UTC](https://discuss.elastic.co/t/visualize-geohash-using-json-input/31845/4 "2015-10-09T05:15:55Z")
When you read the data from ES you could have another index that contains these coordinates, then you could merge them via some external code. But you can't do a join in ES to merge them. ---
**Author:** ![David\_L](https://avatars.discourse-cdn.com/v4/letter/d/eada6e/32.png) [@David\_L](https://discuss.elastic.co/u/David_L)\ **Post date:** [October 10, 2015, 11:31am UTC](https://discuss.elastic.co/t/visualize-geohash-using-json-input/31845/5 "2015-10-10T11:31:37Z")
HI Mark, I have another index that contains these coordinates What do you mean "merge them via some external code" ? Did you mean groovy script that return "script fields" as part of a search request? Namely to retrive the coordinates and store/"borned" them as { ...location clause... } similar to the script\_score describe in the end of [https://www.elastic.co/guide/en/elasticsearch/guide/current/script-score.html](https://www.elastic.co/guide/en/elasticsearch/guide/current/script-score.html) ? Thanks, David ---
**Author:** ![David\_L](https://avatars.discourse-cdn.com/v4/letter/d/eada6e/32.png) [@David\_L](https://discuss.elastic.co/u/David_L)\ **Post date:** [October 13, 2015, 10:47am UTC](https://discuss.elastic.co/t/visualize-geohash-using-json-input/31845/6 "2015-10-13T10:47:18Z")
Guys, Any hint are highly welcome. Thanks, David ---
**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:** [October 13, 2015, 8:12pm UTC](https://discuss.elastic.co/t/visualize-geohash-using-json-input/31845/7 "2015-10-13T20:12:31Z")
You need to put all of the data in the one index. Each document needs to have the data and the geo info in it. ---
**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, 2:11pm UTC](https://discuss.elastic.co/t/visualize-geohash-using-json-input/31845/8 "2017-07-06T14:11:26Z")