Open Source NASR Data
A wealth of data pertaining to using and navigating the airspace of the USA is freely published by the Federal Aviation Administration (FAA). The data is typically published in delightfully-formatted text files or atrocious XML files. It is updated on a 28-day cycle. I have created Alteryx workflows to parse these data files and publish them to a publicly-available Snowflake database.
In addition to airspace-related data, I have also included ground elevation data sourced from the United States Geological Survey (USGS). This data is also freely available to the public, but in the form of geotiff files. Geotiff files are image files that are geocoded with coordinates. In the geotiffs provided with elevation data, each pixel represents the elevation of an area of the ground. The geotiffs used to fill the ground elevation data are each 1 degree x 1 degree. One pixel represents 1 arc-second of ground.
In addition to airspace-related data, I have also included ground elevation data sourced from the United States Geological Survey (USGS). This data is also freely available to the public, but in the form of geotiff files. Geotiff files are image files that are geocoded with coordinates. In the geotiffs provided with elevation data, each pixel represents the elevation of an area of the ground. The geotiffs used to fill the ground elevation data are each 1 degree x 1 degree. One pixel represents 1 arc-second of ground.
Reading the geotiff files required creating a custom Alteryx tool using the Python SDK. More details about the custom tool, including the code, are available on GitHub.
|
More details about the open source NASR project, including the workflows used to perform the ETL operations, are available on GitHub.