topic Re: I have a Field which display source city, but I dont have the longitude and latitude details, needs to show the cities on Map with count in Splunk Search https://community.splunk.com/t5/Splunk-Search/I-have-a-Field-which-display-source-city-but-I-dont-have-the/m-p/347045#M160674 <P>Hello there,<BR /> take a look at this answer:<BR /> <A href="https://answers.splunk.com/answers/148542/how-to-plot-data-on-the-splunk-map-from-lookup-data-using-country-name-country-code-city-name-but-not-ip.html">https://answers.splunk.com/answers/148542/how-to-plot-data-on-the-splunk-map-from-lookup-data-using-country-name-country-code-city-name-but-not-ip.html</A><BR /> you can find a table online that has cities and geolocation coordinates, save as a lookup and refer to it in your search</P> <P>hope it helps</P> Thu, 15 Jun 2017 10:47:23 GMT adonio 2017-06-15T10:47:23Z I have a Field which display source city, but I dont have the longitude and latitude details, needs to show the cities on Map with count https://community.splunk.com/t5/Splunk-Search/I-have-a-Field-which-display-source-city-but-I-dont-have-the/m-p/347044#M160673 <P>index=XXXX eventtype=XXXXX | iplocation src_ip | geostats globallimit=0 count by src_ip</P> <P>its not working</P> <P>Field I have in result is src_city which consist of city names</P> Tue, 29 Sep 2020 14:27:59 GMT https://community.splunk.com/t5/Splunk-Search/I-have-a-Field-which-display-source-city-but-I-dont-have-the/m-p/347044#M160673 deepak_dhankhar 2020-09-29T14:27:59Z Re: I have a Field which display source city, but I dont have the longitude and latitude details, needs to show the cities on Map with count https://community.splunk.com/t5/Splunk-Search/I-have-a-Field-which-display-source-city-but-I-dont-have-the/m-p/347045#M160674 <P>Hello there,<BR /> take a look at this answer:<BR /> <A href="https://answers.splunk.com/answers/148542/how-to-plot-data-on-the-splunk-map-from-lookup-data-using-country-name-country-code-city-name-but-not-ip.html">https://answers.splunk.com/answers/148542/how-to-plot-data-on-the-splunk-map-from-lookup-data-using-country-name-country-code-city-name-but-not-ip.html</A><BR /> you can find a table online that has cities and geolocation coordinates, save as a lookup and refer to it in your search</P> <P>hope it helps</P> Thu, 15 Jun 2017 10:47:23 GMT https://community.splunk.com/t5/Splunk-Search/I-have-a-Field-which-display-source-city-but-I-dont-have-the/m-p/347045#M160674 adonio 2017-06-15T10:47:23Z