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/

View solution in original post

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
.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!