Geocode.py

Location:

E:\McNair\Software\Scripts\Geocode.py

Name

This is a python program that uses google maps to find the latitude and longitude for an address.

Synopsis

python Geocode.py <input.txt>

Usage & Features

Input is a tab delimited ".txt" file with columns:

<Business Name> <Address>

In this location on powershell from the RDP (Must be from the RDP so it can import files):

E:\McNair\Software\Scripts

Enter this code:

python Geocode.py <input.txt>

The program will create an output file that looks like:

input.txt_coords

Which you will have to open with a right click into textpad.

Google Key

Use the following Google API key in this script (note that it is billed to Ed's PCard and queries over 2,500 transactions per day are charged). Use it only with permission and not for debugging:

AIzaSyCdu9TfyYg9UNubz5IlPp4XXrj9HYXTLKs

Output

The output is a tab delimited with the three columns:

<Business Name> <Location["lat"]> <Location["lng"]>

Meaning Name, Latitude, Longitude in a tab delimited .txt file