Adding Airport Data

You may have noticed that we’re actively working on adding new charts to Avare. Recently we added topo charts for Canada, and are looking for volunteers to help with expanding that effort and adding other countries. Since we want to keep Avare completely free, we’re only adding maps that are free such as the Canadian topo maps we found online, and maps derived from OpenStreetMaps.

Of course, aviators also need airport data and other info, so we’re also seeking free sources and volunteers for that. We’re about to add more data of this kind for Canada, to a future release of Avare. Such free data is often incomplete or may even have errors, so we strongly encourage our users to help with the global efforts by aviators that are making accurate data available to everyone at no cost. So far, the FAA is providing official and accurate data and charts to us at no charge so all U.S. materials in Avare are sourced from the FAA.

For anyone interested in helping us add and correct maps and data for other countries, here is the format information:

LocationID Text,ARPLatitude float,ARPLongitude float,Type Text,FacilityName
Text,Use Text,FSSPhone Text,Manager Text,ManagerPhone Text,ARPElevation
Text,MagneticVariation Text,TrafficPatternAltitude Text,FuelTypes
Text,Customs Text,Beacon Text,LightSchedule Text,SegCircle Text,ATCT
Text,UNICOMFrequencies Text,CTAFFrequency Text,NonCommercialLandingFee Text

For example for SBA
SBA,34.4261944444444,-119.8415,AIRPORT,SANTA BARBARA
MUNI,PU,1-800-WX-BRIEF,KAREN
RAMSDELL,805-967-7111,13.4,14E,,100LLA,NY,CG,SEE RMK,Y,Y,122.950,119.700,N

Airport runways table is (one entry per table):
LocationID Text,Length Text,Width Text,Surface Text,LEIdent Text,HEIdent
Text,LELatitude Text,HELatitude Text,LELongitude Text,HELongitude
Text,LEElevation Text,HEElevation Text,LEHeadingT Text,HEHeading Text,LEDT
Text,HEDT Text,LELights Text,HELights Text,LEILS Text,HEILS Text,LEVGSI
Text,HEVGSI Text,LEPattern Text, HEPattern Text

For example for SBA
SBA,6052,150,ASPH-G,07,25,34.4274977777778,34.4279164166667,-119.854640805556,-119.834578111111,11.4,12.0,088,268,,,MALSR,,ILS/DME,,,P4L,Y,N
SBA,4178,75,ASPH-G,15L,33R,34.4307793888889,34.4196555833333,-119.840368194444,-119.836940027778,11.0,11.3,165,345,217,,,,,,,,N,Y
SBA,4184,100,ASPH-G,15R,33L,34.4305392777778,34.4194004722222,-119.841536166667,-119.838100777778,11.0,10.7,165,345,,,,,,,,,N,Y

Airport frequency table is (also contains tower remarks):
LocationID Text,Type Text, Freq Text

For example for SBA
SBA,LCL/P,119.7
SBA,EMERG,121.5
SBA,GND/P,121.7
SBA,ATIS,132.65
SBA,CD/P,132.9
SBA,EMERG,243.0
SBA,LCL/P,254.35
SBA,Remark,APCH/DEP SVC PRVDD BY LOS ANGELES ARTCC ON FREQS 119.05/269.5
(SANTA BARBARA RCAG) WHEN APCH CTL CLSD.

Navigational aid table is:
LocationID Text,ARPLatitude float,ARPLongitude float,Type Text,FacilityName
Text

For example for LAX
LAX,33.9331438888889,-118.432006388889,VORTAC,LOS ANGELES 113.60
LAX,33.7458508333333,-118.336183055556,VOT,SAN PEDRO HILL 113.90
Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.