Skip to content

Python utilities to convert openAIP data from XLM to SQLite

License

Notifications You must be signed in to change notification settings

acrovato/openaip2sqlite

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

openaip2sqlite

Python utilities to convert openAIP data to SQLite

Requirements

Python 2.7 (with the xml.etree and sqlite3 standard packages).
Tested with python 2.7.18 on windows 7 and python 2.7.15 on ubuntu18.04.

Usage

Open a terminal/command prompt and run

python run.py path/to/source airac [--verbose]

Where path/to/source is the relative path to the directory where the openAIP files are, and airac is the AIRAC number related to the files. Currently supported input formats:

  • XML
  • cup
  • dat

The resulting database file will be located under sqlite/world.db.

Doc

Tables in the database:

  • Airac (only has 1 row)
    • id PRIMARY KEY INTEGER
    • number INTEGER
  • Countries
    • id PRIMARY KEY INTEGER
    • name TEXT
    • code TEXT
  • Airports
    • id PRIMARY KEY INTEGER
    • countryId FOREIGN KEY INTEGER (references id of Countries entry)
    • name TEXT
    • icao TEXT
    • type TEXT
    • country TEXT
    • latitude REAL
    • longitude REAL
    • elevation INTEGER
    • elevationUnit TEXT
  • Airspaces
    • id PRIMARY KEY INTEGER
    • countryId FOREIGN KEY INTEGER (references id of Countries entry)
    • name TEXT
    • category TEXT
    • ceiling TEXT
    • ceilingUnit TEXT
    • ceilingRef TEXT (altimetry: height, altitude, flight level)
    • floor TEXT
    • floorUnit TEXT
    • floorRef TEXT (altimetry: height, altitude, flight level)
    • lat TEXT (comma-separated values of latitude perimeter points)
    • lng TEXT (comma-separated values of longitude perimeter points)
  • Navaids
    • id PRIMARY KEY INTEGER
    • countryId FOREIGN KEY INTEGER (references id of Countries entry)
    • name TEXT
    • type TEXT (ndb, vor, ...)
    • callsign TEXT
    • latitude REAL
    • longitude REAL
    • elevation INTEGER
    • elevationUnit TEXT
    • frequency TEXT
    • channel TEXT
    • range TEXT
    • rangeUnit TEXT
  • Runways
    • id PRIMARY KEY INTEGER
    • airportId FOREIGN KEY INTEGER (references id of Airports entry)
    • name TEXT
    • surface TEXT
    • length INTEGER
    • lengthUnit TEXT
    • width INTEGER
    • widthUnit TEXT
  • Frequencies
    • id PRIMARY KEY INTEGER
    • airportId FOREIGN KEY INTEGER (references id of Airports entry)
    • callsign TEXT
    • frequency TEXT
    • category TEXT (communication, navigation, ...)
    • type TEXT (tower, ground, ...)

About

Python utilities to convert openAIP data from XLM to SQLite

Topics

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages