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!

Developer Spotlight with William Searle

The Splunk Guy: A Developer’s Path from Web to Cloud William is a Splunk Professional Services Consultant with ...

Major Splunk Upgrade – Prepare your Environment for Splunk 10 Now!

Attention App Developers: Test Your Apps with the Splunk 10.0 Beta and Ensure Compatibility Before the ...

Stay Connected: Your Guide to June Tech Talks, Office Hours, and Webinars!

What are Community Office Hours?Community Office Hours is an interactive 60-minute Zoom series where ...