In log data I have city name but not latitude and longitude. From city name how can I get latitude and longitude value? I want to create a map from this value. Please guide...
ES or Logstash can't do this out of the box, but it would certainly be doable to write a plugin for it. I haven't heard of anyone doing it.
Thanks for reply.
It should convert city to geo_point:lat & log. Difficult to add manually. It would be great if it show direct location to map like IBM Cognos BI.
Geo location lookup is not trivial since it involves some sort of lookup for named entities that are ambigous most of the time. Take all the cities named Paris in the world. Without context it's not easy to disambiguate this, so its application specific what to do here (Popularity? Thats what most people do, but its wrong sometimes). If you want to do this by yourself, the open data project Geonames (http://www.geonames.org/) is a good place to start.
If the geographical entities that occur are finite and known in advance you might be able to pull off a simple lookup table driven by a translate filter.