All Apps and Add-ons

Google Maps - geo lookup a ZIP code?

msarro
Builder

Hey everyone. I have a ton of customer records with both IP's and ZIP codes. The issue is that the IP's, despite being around the nation, are all registered to our company in NYC so the geolookup doesn't work. I do have the zip codes though. I know there are latitude and longitude DB's out there based on postal codes. Is this functionality built into the google maps app?

fabiocaldas
Contributor

tb5821
Communicator

I downvoted this post because this starts off ok as in he has only zips but then his csv file magically has long lat in it with no explanation on where it came from!

0 Karma

ziegfried
Influencer

I planned on adding that to the app but haven't gotten to that yet. You should be able to do it yourself, though. Just add a lookup table (Such tables should be easy to find somewhere on the web) which maps the zip code to the geo coordinates.

| zip    | _geo       |
| 47111  | 47.11,8.15 |
| 47112  | 28.77,7.99 |

Here's an example of such a freely available list: http://geocoder.ca/?freedata=1

It should be pretty easy to transform it to a lookup list like the example above.

Get Updates on the Splunk Community!

The Splunk Success Framework: Your Guide to Successful Splunk Implementations

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

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...