Difference between revisions of "Waypoints file format/es"

Revision as of 15:17, 21 October 2015

Para importar una lista de waypoints con el servidor Webserver, los datos deben estar ordenados en archivos de texto separados, cifrados en UTF8 para soportar caracteres especiales.

Pueden usar su aplicación favorita de hojas de cálculo o convertir los waypoints desde otra base de datos para que concuerde con la estructura descripta abajo.

We strongly recommend that you create a custom waypoint on the iPhone/iPod first and download it from the website to get the correct file structure, then you don’t have to type the columns names manually (which could result in typos and/or bad structure that would not be recognized as a valid file on importation).

File structure for waypoints

To be valid, a waypoint file must start with a row listing the columns names separated by a tab character (TAB key). The other lines are the actual waypoints values (one line per waypoint). Values can be empty but they must be separated by a tab character.

The best would be to work on MS EXCEL and when having finished, then copy the columns and paste them into a TXT file with a program like «Notepad»:

Columns names and definition are:

waypoint_id (text, usually less than 6 characters, required value)
waypoint_name (text, longer description of the waypoint)
waypoint_type (number: 1=Airport, 2=fix, 3=waypoint, 4=Helipad, 5=seaplane base, 8=IFR waypoint, 10=DME, 11=NDB, 12=VOR, 13=NDB/DME, 14=VOR/DME, 15=TACAN, 16=VORTAC)
waypoint_longitude (number with decimal)
waypoint_latitude (number with decimal)
waypoint_elevation (number, elevation in feet)
waypoint_country (text)
waypoint_state (text, example California)
waypoint_channel (text)
waypoint_frequency (number, for navaids only)
main_runway_orientation (number 1 to 360)

File structure for frequencies

To be valid, a frequencies file must start with a row listing the columns names separated by a tab character. The other lines are the actual frequencies values (1 line per frequency). Values can be empty but they must be separated by a tab character.

Columns names and definition are:

waypoint_id (text, must match a waypoint waypoint_id to be associated with it)
type (text, short name of the frequency)
description (text, long name of the frequency)
frequency_mhz (number with decimal, the actual frequency).

File structure for runways

To be valid, a runways file must start with a row listing the columns names separated by a tab character. The other lines are the actual runways values (1 line per runway). Values can be empty but they must be separated by a tab character.

Columns names and definition are:

waypoint_id (text, must match a waypoint waypoint_id to be associated with it)
rw_id (text, name of the runway)
rw_orientation (number 1-360)
wid_ft (number, width in feet)
len_ft (number, length in feet)
sfc_ty (number, unknown=0, Asphalt=1, Concrete=2, Grass=3, Gravel=4, Dirt=5, Sand=6, Snow=7, Ice=8, Water=9)

Note: remember that all the files described in this chapter will be imported into Air Navigation Pro through the embedded WebServer.

Back to index

@@ Line 2: / Line 2: @@
 Para importar una lista de waypoints con el '''servidor Webserver''', los datos deben estar ordenados en archivos de texto separados, cifrados en UTF8 para soportar caracteres especiales.
-You can use your favorite spreadsheet application or convert waypoints from another database to match the structure described below.
+Pueden usar su aplicación favorita de hojas de cálculo o convertir los waypoints desde otra base de datos para que concuerde con la estructura descripta abajo.
 '''We strongly recommend''' that you create a custom waypoint on the iPhone/iPod first and download it from the website to get the correct file structure, then you don’t have to type the columns names manually (which could result in typos and/or bad structure that would not be recognized as a valid file on importation).