Difference between revisions of "Geocode.py"
| (7 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | {{McNair | + | {{Project |
| + | |Has project output=Tool | ||
| + | |Has sponsor=McNair Center | ||
|Has title=Geocode.py | |Has title=Geocode.py | ||
|Has keywords=Tool | |Has keywords=Tool | ||
| Line 6: | Line 8: | ||
'''Location:''' | '''Location:''' | ||
| − | E:\tools\Geocode\Geocode.py | + | E:\tools\Geocode\Geocode.py (python3) |
| − | E:\McNair\Software\Scripts\Geocode.py | + | E:\McNair\Software\Scripts\Geocode.py (python2) |
=Name= | =Name= | ||
| Line 19: | Line 21: | ||
=Usage & Features= | =Usage & Features= | ||
| − | There are two versions of this script. The one in McNair\Software\Scripts takes a single key field "firm name". The other version in E:\tools\geocode takes a three part tab-delimined key (coname, statecode, datefirst), which we refer to as <firm name>. | + | 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: | Currently the input is a tab delimited ".txt" file with columns: | ||
| Line 27: | Line 29: | ||
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. | 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:\ | + | E:\tools\Geocode\Geocode.py |
Enter this code: | Enter this code: | ||
| − | + | python3 Geocode.py <input.txt> | |
The program will create an output file that looks like: | The program will create an output file that looks like: | ||
| Line 41: | Line 43: | ||
==Google Key== | ==Google Key== | ||
| − | Use | + | Use a Google API key in this script. 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. |
| − | |||
| − | |||
| − | |||
| − | 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== | ==Output== | ||
| Line 53: | Line 51: | ||
<Firm Name> <Location["lat"]> <Location["lng"]> | <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 | + | 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). |
=Bugs & Feedback= | =Bugs & Feedback= | ||
[[admin_classification::IT Build| ]] | [[admin_classification::IT Build| ]] | ||
Latest revision as of 19:53, 5 January 2021
| Geocode.py | |
|---|---|
| Project Information | |
| Has title | Geocode.py |
| Has start date | |
| Has deadline date | |
| Has keywords | Tool |
| Has project status | Complete |
| Has sponsor | McNair Center |
| Has project output | Tool |
| Copyright © 2019 edegan.com. All Rights Reserved. | |
Location:
E:\tools\Geocode\Geocode.py (python3) E:\McNair\Software\Scripts\Geocode.py (python2)
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
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:
<Firm Name> <Address>
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:\tools\Geocode\Geocode.py
Enter this code:
python3 Geocode.py <input.txt>
The program will create an output file that looks like:
Out.txt
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.
Google Key
Use a Google API key in this script. 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
The output is currently a tab delimited with the three columns:
<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).
