https://community.splunk.com/t5/Splunk-Search/How-to-get-started-with-making-a-choropleth-map-using-data/m-p/305880#M91832 <P>I went through documentation but not able to relate with my requirement. If someone is already in practice with maps, any tips will be helpful.</P> <P>Problem Description:<BR /> I have a .csv file which have product data including name of US state (eg: California). So each row represents product details including state name, they belong to.<BR /> I have to achieve following:<BR /> 1.) Create a US map, showing states<BR /> 2.) Showing count of products over each state, they belongs to.<BR /> The .csv file can only have state name, it can't have Latitude/altitude or ip information of states.<BR /> If any .KMZ or any other lookup file required, pls provide some way to create/get it.</P> Mon, 22 May 2017 05:18:37 GMT dsiob 2017-05-22T05:18:37Z https://community.splunk.com/t5/Splunk-Search/How-to-get-started-with-making-a-choropleth-map-using-data/m-p/305880#M91832 <P>I went through documentation but not able to relate with my requirement. If someone is already in practice with maps, any tips will be helpful.</P> <P>Problem Description:<BR /> I have a .csv file which have product data including name of US state (eg: California). So each row represents product details including state name, they belong to.<BR /> I have to achieve following:<BR /> 1.) Create a US map, showing states<BR /> 2.) Showing count of products over each state, they belongs to.<BR /> The .csv file can only have state name, it can't have Latitude/altitude or ip information of states.<BR /> If any .KMZ or any other lookup file required, pls provide some way to create/get it.</P> Mon, 22 May 2017 05:18:37 GMT https://community.splunk.com/t5/Splunk-Search/How-to-get-started-with-making-a-choropleth-map-using-data/m-p/305880#M91832 dsiob 2017-05-22T05:18:37Z https://community.splunk.com/t5/Splunk-Search/How-to-get-started-with-making-a-choropleth-map-using-data/m-p/305881#M91833 <P>you could put this table into a csv and use it as a lookup table against yours by joining the states together, perhaps. that'll give you a lat/long to work with.</P> <P><A href="https://inkplant.com/code/state-latitudes-longitudes">https://inkplant.com/code/state-latitudes-longitudes</A></P> Tue, 23 May 2017 16:15:29 GMT https://community.splunk.com/t5/Splunk-Search/How-to-get-started-with-making-a-choropleth-map-using-data/m-p/305881#M91833 cmerriman 2017-05-23T16:15:29Z https://community.splunk.com/t5/Splunk-Search/How-to-get-started-with-making-a-choropleth-map-using-data/m-p/305882#M91834 <P>did this work for what you needed? if so, could you please accept the answer to finish the question?</P> Wed, 24 May 2017 13:54:58 GMT https://community.splunk.com/t5/Splunk-Search/How-to-get-started-with-making-a-choropleth-map-using-data/m-p/305882#M91834 cmerriman 2017-05-24T13:54:58Z https://community.splunk.com/t5/Splunk-Search/How-to-get-started-with-making-a-choropleth-map-using-data/m-p/305883#M91835 <P>thanks @cmerriman it worked out..sorry for delay</P> Thu, 25 May 2017 06:33:23 GMT https://community.splunk.com/t5/Splunk-Search/How-to-get-started-with-making-a-choropleth-map-using-data/m-p/305883#M91835 dsiob 2017-05-25T06:33:23Z