https://community.splunk.com/t5/Dashboards-Visualizations/Choropleth-Map-count-by-counties/m-p/538487#M36836 <P>Hello All,</P><P>I am trying to visualize data in a choropleth map using shapefiles. My goal is to show a count of a field by county in PA. I have yet to find a well configured shapefile for all counties in PA, so I had to use one for the counties in all of the US. Unfortunately when I use the geom command this includes any other counties of the same name in the map vis.&nbsp; Is there a way to filter out other states and just include PA? or can I set bounds for this map so it only visualizes PA?</P><P>Image of Choropleth map as is</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dholz_0-1612368054450.png" style="width: 999px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/12810i8E237D838288F05D/image-size/large?v=v2&amp;px=999" role="button" title="dholz_0-1612368054450.png" alt="dholz_0-1612368054450.png" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">dholz_0-1612368054450.png</span></span></P><P>Search:</P><P>sourcetype=*sourcetype* province=Pennsylvania<BR />| stats latest(*stats*) as "*name*" by county<BR />| geom nat_counties_lookup featureIdField=county</P> Wed, 03 Feb 2021 16:03:16 GMT dholz 2021-02-03T16:03:16Z https://community.splunk.com/t5/Dashboards-Visualizations/Choropleth-Map-count-by-counties/m-p/538487#M36836 <P>Hello All,</P><P>I am trying to visualize data in a choropleth map using shapefiles. My goal is to show a count of a field by county in PA. I have yet to find a well configured shapefile for all counties in PA, so I had to use one for the counties in all of the US. Unfortunately when I use the geom command this includes any other counties of the same name in the map vis.&nbsp; Is there a way to filter out other states and just include PA? or can I set bounds for this map so it only visualizes PA?</P><P>Image of Choropleth map as is</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dholz_0-1612368054450.png" style="width: 999px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/12810i8E237D838288F05D/image-size/large?v=v2&amp;px=999" role="button" title="dholz_0-1612368054450.png" alt="dholz_0-1612368054450.png" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">dholz_0-1612368054450.png</span></span></P><P>Search:</P><P>sourcetype=*sourcetype* province=Pennsylvania<BR />| stats latest(*stats*) as "*name*" by county<BR />| geom nat_counties_lookup featureIdField=county</P> Wed, 03 Feb 2021 16:03:16 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Choropleth-Map-count-by-counties/m-p/538487#M36836 dholz 2021-02-03T16:03:16Z https://community.splunk.com/t5/Dashboards-Visualizations/Choropleth-Map-count-by-counties/m-p/538620#M36849 <P>Solved using this blog to make my own kml file using a shapefile:&nbsp;<A href="https://www.splunk.com/en_us/blog/tips-and-tricks/use-custom-polygons-in-your-choropleth-maps.html" target="_blank">https://www.splunk.com/en_us/blog/tips-and-tricks/use-custom-polygons-in-your-choropleth-maps.html</A>&nbsp;</P> Thu, 04 Feb 2021 14:18:37 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Choropleth-Map-count-by-counties/m-p/538620#M36849 dholz 2021-02-04T14:18:37Z