Getting Data In

Map ZipCodes without lat long

tb5821
Communicator

My splunk event data has a mv list of zip codes that I'd like to put on a map but it looks like theres nothing out of the box to do the zip to long/lat and that I need to find a way to lookup the data?

0 Karma
1 Solution

spayneort
Contributor

The Google GeoCode app can give you the latitude and longitude for a zip code.

https://splunkbase.splunk.com/app/3597/

View solution in original post

0 Karma

spayneort
Contributor

The Google GeoCode app can give you the latitude and longitude for a zip code.

https://splunkbase.splunk.com/app/3597/

0 Karma

tb5821
Communicator

hmm is there no way to shade things in by zip once I have the lat/lon info? I can see I can make a pie chart with a count of things at a lat/lon but I want to shade the zip codes

0 Karma

woodcock
Esteemed Legend

Ask a new question. Also click Accept on the best answer (post your own if you did something different).

0 Karma

woodcock
Esteemed Legend

Splunk natively supports KMZ (gzipped KML) files:
https://docs.splunk.com/Documentation/Splunk/7.2.3/Knowledge/Configuregeospatiallookups

So use this file from the US government census bureau:
https://www.census.gov/geo/maps-data/data/kml/kml_zcta.html

woodcock
Esteemed Legend
0 Karma

tb5821
Communicator

I saw and read that page but that csv is from 2013!! there were zips I have now that google finds that are nowhere to be found in that doc! - there's gotta be a better way.

0 Karma

woodcock
Esteemed Legend

If you already know there is something obvious that doesn't work, you should add that to the details of your question.

0 Karma
Get Updates on the Splunk Community!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...