def main():
year = '12'
args = sys.argv
if len(args) == 2:
year = args[1]
db = ScraperDatabase()
try:
rows = db.get_year(year)
except Exeption as e:
print(e)
pat = re.compile('[a-zA-Z]{4}%s[0-9]{2}@stcloudstate\.edu' % year)
for row in rows:
if re.match(pat, row[5]) != None:
print(row[5])
import math
from scraperdb import ScraperDatabase
#SCSU campus
LAT = 45.5480263
LON = -94.1509631
def degree_to_radian(deg):
return deg * (math.pi/180)
def km_to_mi(km):
return km * 0.621371192
def distance(lat1, lon1, lat2, lon2):
R = 6371
deltaLat = degree_to_radian(lat2 - lat1)
deltaLon = degree_to_radian(lon2 - lon1)
a = (math.sin(deltaLat/2) * math.sin(deltaLat/2))
a += math.cos(degree_to_radian(lat1)) * math.cos(degree_to_radian(lat2)) * math.sin(deltaLon/2) * math.sin(deltaLon/2)
c = 2 * math.atan2(math.sqrt(a), math.sqrt(1-a))
d = R * c
return km_to_mi(d)
db = ScraperDatabase()
rows = db.get_addresses()
for row in rows:
lat = float(row[2])
lon = float(row[3])
print('%s {%f, %f}: %f' % (row[1].replace('\n',', '), lat, lon, distance(LAT, LON, lat, lon)))
