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