Create sqlite and spatialite databases from the 56-day NASR data freely provided by the FAA
The "spatial56day.db" this creates is used by my Aviation Map project and the sqlite database could be directly used in any Electronic Flight Bag (EFB) program. See "Sample SQL queries.sql" for some examples of querying this database
A sample spatialite version of the database can be found here: https://www.dropbox.com/s/j018ph69x9nduv4/data.tar.xz
These instructions are based on using Ubuntu 16.04
How to get this utility up and running:
Install git
sudo apt-get install git
Download the repository
git clone https://github.com/jlmcgraw/processFaaData.git
Run setup.sh to install necessary dependencies using Carton
./setup.sh
Download the current 56-day data from https://nfdc.faa.gov/xwiki/bin/view/NFDC/56+Day+NASR+Subscription
./freshen_local_nasr.sh ./local_data
Download the current obstacle data (Daily DOF downloaded automatically by create_databases.sh)
http://tod.faa.gov/tod/public/TOD_DOF.html
or
http://tod.faa.gov/tod/DAILY_DOF.ZIP
How to use these utilities
create_databases.sh <name of 56 day .zip file>
Usage: ./create_databases.sh <name of 56 day .zip file>
eg: "create_databases.sh local_data/nfdc.faa.gov/webContent/56DaySub/56DySubscription_March_02__2017_-_April_27__2017.zip"
Creates the sqlite database, expanding text and creating spatialite geometries. Then converts to spatialite database. Also creates airspace spatialite databases
This software and the data it produces come with no guarantees about accuracy or usefulness whatsoever! Don't use it when your life may be on the line!
Thanks for trying this out! If you have any feedback, ideas or patches please submit them to github.
-Jesse McGraw jlmcgraw@gmail.com