plotting count on gmaps

[kavyatim]

Hi I am trying to plot TOTALPLANTA on GMaps but not able to do this. .

Data used is as below:

cityy TOTAL_PLANTA latitude longitude
GASTAO VIDIGAL 48 -20.8 -50.1667
INUBIA PAULISTA 29 -21.75 -50.9667
SANTA MERCEDES 12 -21.35 -51.75
SANTO ANDRE 12 -7.2167 -36.6333
CAMPINAS 7025 -22.1667 -42.6833
CAMPINAS 44 -22.1667 -42.6833
INUBIA PAULISTA 4271 -21.75 -50.9667
VERA CRUZ 148 -2.95 -40.1833

Query is :
source="results.csv" | table cityy,latitude,longitude,TOTAL_PLANTA | eval _geo=(latitude+","+longitude)

can any one correct me so that i can plot total planta count exactly on gmaps

thanking you,

[dmaislin_splunk · Accepted solution]

If running Splunk 6.0+...

source="results.csv" | geostats latfield=latitude longfield=longitude by city

Then you can just use the internal maps, with internal iplocation and geostats mapping.

Just get this app to learn how: http://apps.splunk.com/app/1603/

[dmaislin_splunk]

source="results.csv" | geostats latfield=latitude longfield=longitude count by cityy globallimit=10

[kavyatim]

I am not able to understand why i am not able to plot results on gmaps when data is straight forward.

I have lat, long,cityy,as well as count which need to be plotted as per lat and long. .

I posted sample data above can any one help me to get this soon please

[kavyatim]

And also i tried with following queries:
source="results.csv" | table latitude,longitude,cityy,TOTAL_PLANTA |geostats latfield=latitude longfield=longitude sum(TOTAL_PLANTA)
source="results.csv" | table latitude,longitude,cityy,TOTAL_PLANTA |geostats latfield=latitude longfield=longitude sum(TOTAL_PLANTA) by cityy globallimit=10
But not able to get required results,sum is not plotting on gmaps.
But no results on gmaps

[kavyatim]

Hi Thank you for your answer,
I used the same above query given by you but getting error as below :
Error in 'xyseries' command: At least one data field must be specified
sum(TOTAL_PLANTA) is 3 lacs,my requirement is to depict this sum on gmaps and this needed to be spread as per lat and long from results.csv when i zoom in.

I know this is possible in splunk and
kindly help me in writing query and results as required.

Thanking you. .

[ncbshiva]

Hi - Even I have the same problem. How do I show sum of events on a GMAP when I do not have the base events data and only want to map the summary depiction? For example in above example provided by 'kavyatim' I want to show the cities on GMAP based on their lat - long and depict the total number of plants I have in each city on the GMAP. Pls help with a solution...