#!/usr/bin/env python

import string
import sys
import sys
sys.path.append('../old')
import distance

target = (-115.19611, 36.212500)
max_dist = 200

def seconds_to_degrees(seconds):
	if seconds[-1] in ['W', 'S']:
		return(float(seconds[:-1]) / -3600)
	else:
		return(float(seconds[:-1]) / 3600)

null_trans = string.maketrans('', '')

results = []

airports_file = open('../raw_data/FAA_ATA-100/APT.del', 'r')

for line in airports_file.readlines():
	fields = string.split(line, '|')
	entry_type = fields[0]

	if entry_type == 'APT':
		position = (seconds_to_degrees(fields[26]), seconds_to_degrees(fields[24]))
		site_number = fields[1]
		landing_facility = fields[2]
		identifier = fields[3]
		elevation = int(fields[28])

		state = fields[8]
		county = fields[9]
		state_abbrev = fields[10]
		city = fields[11]
		usage = fields[13]
		county = string.translate(county, null_trans, ". '")

		#if not usage == 'PU':
		#	continue


		#if not landing_facility == 'AIRPORT':
		#	continue

		#print identifier

		results.append((identifier, city, state, elevation))

def sortby_elevation(a, b):
	return(cmp(b[3], a[3]))

results.sort(sortby_elevation)

for result in results:
	print string.join(map(str, result), ', ')