#!/usr/bin/env python

import FAA_ATA100

if 1:
	data = FAA_ATA100.ATA100zip('../raw_data/FAA/ATA-100/current.zip')

	for record in data.parse('APT'):
		rti = record['RTI']
		if rti == 'APT':
			ident = record['LOCATION IDENTIFIER']

		if not ident == 'RZL':
			continue

		print rti

		#if rti == 'RMK':
		#	print record['REMARK TEXT']

		if rti == 'RWY':
			latitude = FAA_ATA100.seconds_to_degrees(record['LATITUDE OF PHYSICAL RUNWAY END (SECONDS)'])
			longitude = FAA_ATA100.seconds_to_degrees(record['LONGITUDE OF PHYSICAL RUNWAY END (SECONDS)'])

			print longitude, latitude, record['DISPLACED THRESHOLD - LENGTH IN FEET FROM']