Changes

{{Project|Has project output=Tool|Has sponsor=McNair ProjectsCenter|Has title=Geocode (Python).py

E:\tools\Geocode\Geocode.py (python3) E:\McNair\Software\Scripts\Geocode.py (python2)

Input There are two versions of this script. The one in McNair\Software\Scripts takes a single key field "firm name" and is written for python2. The other version in E:\tools\geocode takes a three part tab delimited "-delimined key (coname, statecode, datefirst), which we still refer to as <firm name> below, and is rewritten for python3.txt" file with columns:

In this location on ''powershell'' from the RDP (Must be from the RDP so it can import files). The script itself is also located here, if you would like to update it.  E:\McNairtools\SoftwareGeocode\ScriptsGeocode.py

python python3 Geocode.py <input.txt>

inputOut.txt_coordstxt

Which you will have to open with a right click into textpad. If you would like to change the input so that you can geo code while keeping a primary key with more than one column simply change the output commands on lines 22, 35, and 37 to reflect the changes. Also change line 28 to reflect the inputted file.

Use the following a Google API key in this script (note that it . Currently, the live key is billed not activated. If you would like to Ed's PCard use the API and queries over 2are sure that your process will work,500 transactions per day are charged)uncomment the live key and comment out the test key. Use it only with permission and not for debugging:  AIzaSyCdu9TfyYg9UNubz5IlPp4XXrj9HYXTLKs

The output is currently a tab delimited with the three columns:

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

Meaning Name, Latitude, Longitude in a tab delimited .txt file. This can be changed by accessing the Geocode.py file and going to the lines 33 and 35 (in the latest version).