Centroid, Kansas

centroidGeocoder.py

#!/usr/bin/env python
# encoding: utf-8

"""
1. Load places from CSV file
2. Run geocoders
3. Write results to files
"""

import geocoder
import csv
import time
from retrying import retry
from apikeys import *

@retry(wait_exponential_multiplier=1000, wait_exponential_max=10000)
def geocode(latlngstring):
	g = geocoder.google(latlngstring)
	latitude,longitude = g.latlng
	return [latitude,longitude]


with open("cities-cartodb2.csv","rb") as cdbfile:
	reader = csv.DictReader(cdbfile)
	
	with open("cities-google2.csv","wb") as gfile:
		fieldnames = ["longitude","latitude","city","state","citystate"]
		writer = csv.DictWriter(gfile, fieldnames=fieldnames)
		writer.writeheader()

		for row in reader:
			print "geocoding",row["citystate"]
			time.sleep(3)
			latitude,longitude = geocode(row["citystate"])
			
			if latitude != row["latitude"] or longitude != row["longitude"]:
				print latitude,longitude,"does not match"
				print row["latitude"],row["longitude"]
			writer.writerow({"latitude":latitude,"longitude":longitude,"city":row["city"],"state":row["state"],"citystate":row["citystate"]})
		

cities-cartodb.csv

cities-google.csv

large-us-cities.csv

requirements.txt

cffi==1.2.1
click==5.1
cryptography==1.0.2
decorator==4.0.4
enum34==1.0.4
geocoder==1.6.4
idna==2.0
ipaddress==1.0.14
ndg-httpsclient==0.4.0
pyasn1==0.1.9
pycparser==2.14
pyOpenSSL==0.15.1
ratelim==0.1.6
requests==2.8.1
retrying==1.3.3
six==1.10.0
urllib3==1.12