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!

Splunk Answers Content Calendar, June Edition

Get ready for this week’s post dedicated to Splunk Dashboards! We're celebrating the power of community by ...

What You Read The Most: Splunk Lantern’s Most Popular Articles!

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

See your relevant APM services, dashboards, and alerts in one place with the updated ...

As a Splunk Observability user, you have a lot of data you have to manage, prioritize, and troubleshoot on a ...