Importing Waypoints to AWN and sample files

The Waypoints import file structure

(Please bear with me - this is a lot easier than it looks!)

Waypoints can be loaded into AWN using a Comma Separated Variable file (.csv extension) (which is just a text file with columns separated by commas and text enclosed within inverted commas (being " type quote marks).

The contents of a typical waypoints import file will look like this:


    "EGYE","Barkston Heath",52.962225,-0.561625,367,
    "EGYM","Marham",52.648353,0.550692,75,
    "EGYP","Mount Pleasant",-51.822777,-58.447222,244,


The five comma delimited columns are

  • A quoted text string of maximum 6 characters giving a unique identification of the waypoint
  • A quoted text string giving a brief description the waypoint
  • A number between -90 and 90 being the Latitude of the waypoint
  • A number between -180 and 180 being the Longitude of the waypoint
  • The Altitude of the waypoint (feet or metres depending on your chosen units)

Please note:

  • Latitudes and Longitudes are in decimal degrees
  • If your data is in degrees and minutes you will need to divide the minutes by 60 to get the decimals of degree
  • Negative Latitudes are degrees South of the Equator
  • Negative Longitudes are degrees West of the Greenwich Meridian
  • You can have additional columns in your file however columns after the first five will be ignored during the data import

top

Creating the Waypoints file

The easiest way to create or edit your waypoints file is to use a spreadsheet program such as LibreOffice Calc (recommended) or Microsoft Excel.
Use the "Export" or "Save as..." feature of the spreadsheet program to save the spreadsheet as type "csv".

After you have saved the file, check it with a text editor to ensure that it is in the correct format.
If it is not correct then confirm that the spreadsheet Save settings are:
"Variable length", comma separated(delimited), Text quoted ".

Import your file to your Mobile device

Attach your Android device ('phone or tablet) to a computer. Browse the files on the device to find the Download directory (folder) which is probably at:
{device name} \Internal storage\Download

Copy your CSV file into the Download directory. If there is more than one CSV file in the directory then AWN will give you the choice of which file to import.

If you already have wayponts in AWN's database you will be given the choice of deleting the existing waypoints before import.

Waypoint Idents should be unique.

If you do not delete any existing waypoints or there is more than one Waypoint with the same Ident then the imported Waypoint will ovewrite the existing Waypoint having that Ident.

top

Sources of waypoints data on the web

There are a number of sites on the Internet where you can download data sets of waypoint information.

To get you started

Here are download linls for CSV files as extracted from airports.dat available at openflights.org.
You can use the files as they are however the information is untested and you chould check the accuracy of the data before serious use.
Please Contact us to advise any errors in the data or to add more airports to improve the data for others.

Rest of the World Afghanistan Algeria Angola Antarctica
Argentina Armenia Australia Austria Azerbaijan
Bahamas Bangladesh Belarus Belgium Belize
Bermuda Bolivia Bosnia Herzegovina Botswana Brazil
Brit.Virgin Islands Bulgaria Burma Cambodia Cameroon
Canada CapeVerde Cayman Islands Chad Chile
China Colombia Congo Cook Islands CostaRica
Croatia Cuba Cyprus Czech Republic Denmark
Dominican Republic Ecuador Egypt Estonia Ethiopia
Fiji Finland France French Guiana French Polynesia
Gabon Germany Ghana Greece Greenland
Guatemala Guinea Guyana Haiti Honduras
Hong Kong Hungary Iceland India Indonesia
Iran Iraq Ireland Israel Italy
Jamaica Japan Jordan Kazakhstan Kenya
Kiribati Kuwait Laos Latvia Libya
Lithuania Madagascar Malawi Malaysia Maldives
Mali Malta Marshall Islands Mauritania Mexico
Mongolia Morocco Mozambique Namibia Nepal
Netherlands Netherlands Antilles New Caledonia New Zealand Nicaragua
Niger Nigeria Norway Oman Pakistan
Panama Papua New Guinea Paraguay Peru Philippines
Poland Portugal Puerto Rico Qatar Romania
Russia Saint Lucia Saint Vincent Saudi Arabia Senegal
Serbia Seychelles Sierra Leone Singapore Slovakia
Slovenia Solomon Islands Somalia South Africa SouthKorea
Spain Sri Lanka Sudan Suriname Sweden
Switzerland Syria Taiwan Tanzania Thailand
Tonga Trinidad Tobago Tunisia Turkey Turkmenistan
TurksCaicosIsl Uganda Ukraine Utd Arab Emirates United Kingdom
United States Uruguay Uzbekistan Vanuatu Venezuela
Vietnam Virgin Islands Yemen Zambia Zimbabwe

top