7,612
edits
Changes
Jump to navigation
Jump to search
python python3 Geocode.py <input.txt>
no edit summary
{{Project|Has project output=Tool|Has sponsor=McNair ProjectsCenter
|Has title=Geocode.py
|Has keywords=Tool
'''Location:'''
E:\tools\Geocode\Geocode.py (python3) E:\McNair\Software\Scripts\Geocode.py (python2)
=Name=
=Usage & Features=
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-delimined key (coname, statecode, datefirst), which we still refer to as <firm name> below, and is rewritten for python3.
Currently the input is a tab delimited ".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
Enter this code:
The program will create an output file that looks like:
==Google Key==
Use the following a 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 Currently, the live key is not activated. If you would like to use the API and are sure that your process will work, uncomment the live key and comment out the test key.
==Output==
<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 specified above33 and 35 (in the latest version).
=Bugs & Feedback=
[[admin_classification::IT Build| ]]
