=======================================================================
d_f_n - Download and prepare the FAA NASR data
d_f_t - Download and prepare the FAA TFR data
d_n_e - Download and prepare the Natural Earth data
r_f_n - Retrieve and prepare the FAA NOTAMS API data
-----------------------------------------------------------------------
version - Show the IO-MAP-APPS version
-----------------------------------------------------------------------
Enter the desired task [default: ]: d_f_n
Script run_io_map_apps_aws is now running
2024-08-11 19:59:14,936 INFO You are using io-aero's iocommon version 1.2.58 logger (Copyright (c) 2022-2024 IO-Aero)
2024-08-11 19:59:14,937 INFO Starting the configuration management system.
2024-08-11 19:59:14,937 INFO Running in a source (non-compiled) environment. Configuration loading from: D:\SoftDevelopment\Projects\IO-Aero\io-map-apps
2024-08-11 19:59:14,937 INFO Dynaconf settings loaded successfully.
2024-08-11 19:59:15,717 INFO ================================================================================
2024-08-11 19:59:15,717 INFO INFO.00.004 Start Launcher
2024-08-11 19:59:15,717 INFO param argv=['scripts\\launcher.py', '-t', 'd_f_n']
2024-08-11 19:59:15,717 INFO Start launcher.py
2024-08-11 19:59:15,727 INFO locale=('en_US', 'UTF-8')
2024-08-11 19:59:15,727 INFO INFO.00.005 Argument 'task'='d_f_n'
2024-08-11 19:59:15,728 INFO INFO.00.125 Retrieve and prepare the FAA NOTAMS API data
2024-08-11 19:59:15,728 INFO --------------------------------------------------------------------------------
2024-08-11 19:59:15,728 INFO ================================================================================
2024-08-11 19:59:15,728 INFO INFO.00.126 Process FAA NASR data: Class Airspace
2024-08-11 19:59:15,728 INFO --------------------------------------------------------------------------------
2024-08-11 19:59:15,760 INFO
2024-08-11 19:59:15,760 INFO INFO.00.127 Processing file: 'https://nfdc.faa.gov/webContent/28DaySub/2024-08-08/class_airspace_shape_files.zip'
2024-08-11 19:59:24,778 INFO
2024-08-11 19:59:24,778 INFO ================================================================================
2024-08-11 19:59:24,779 INFO FAA NASR Data
2024-08-11 19:59:24,779 INFO --------------------------------------------------------------------------------
2024-08-11 19:59:24,779 INFO IDENT NAME UPPER_DESC UPPER_VAL UPPER_UOM UPPER_CODE ... WKHR_RMK DST GMTOFFSET SHAPE_Leng SHAPE_Area
geometry
0 None HILLSBORO CLASS E5 AA -9998 None None ... None None None 0.841514 0.055045 POLYGON Z ((-83.53658 39.07185 0, -83.53889 39...
1 None BURLINGTON CLASS E5 AA -9998 None None ... None None None 0.965722 0.057262 POLYGON Z ((-90.91047 40.75103 0, -90.94131 40...
2 None BURLINGTON CLASS E5 AA -9998 None None ... None None None 0.775777 0.046888 POLYGON Z ((-95.72496 38.41093 0, -95.72482 38...
3 None CAMPBELLTON CLASS E5 AA -9998 None None ... None None None 1.033239 0.059772 POLYGON Z ((-98.21504 28.59481 0, -98.33754 28...
4 None CANADIAN CLASS E5 AA -9998 None None ... None None None 0.768261 0.045543 POLYGON Z ((-100.32708 35.80643 0, -100.3289 3...
[5 rows x 26 columns]
2024-08-11 19:59:24,810 INFO --------------------------------------------------------------------------------
2024-08-11 19:59:24,810 INFO
2024-08-11 20:02:51,901 INFO Created 5,597 records
2024-08-11 20:04:02,853 INFO Created 1,288 records
2024-08-11 20:04:02,874 INFO
2024-08-11 20:04:02,874 INFO ================================================================================
2024-08-11 20:04:02,875 INFO IO-Aero Data
2024-08-11 20:04:02,875 INFO --------------------------------------------------------------------------------
2024-08-11 20:04:02,875 INFO IDENT NAME CLASS UPPER_VAL UPPER_CODE LOWER_VAL LOWER_CODE geometry
21 OZR FORT NOVOSEL (OZARK) CLASS D D 2800 MSL 0 SFC POLYGON Z ((-85.70556 31.39185 0, -85.70546 31...
24 06FA JUPITER CLASS D D 2500 MSL 0 SFC POLYGON Z ((-80.32841 26.98337 0, -80.32833 26...
28 SAF SANTA FE CLASS D D 8800 MSL 0 SFC POLYGON Z ((-106.08944 35.7004 0, -106.08934 3...
31 MQY SMYRNA CLASS D D 2500 MSL 0 SFC POLYGON Z ((-86.43228 35.94937 0, -86.4339 35....
33 VRB VERO BEACH CLASS D D 2500 MSL 0 SFC POLYGON Z ((-80.41806 27.72575 0, -80.41798 27...
2024-08-11 20:04:02,903 INFO --------------------------------------------------------------------------------
2024-08-11 20:04:02,903 INFO
2024-08-11 20:04:02,903 INFO
2024-08-11 20:04:02,903 INFO Rows in total : 5597
2024-08-11 20:04:02,903 INFO Rows relevant : 1288
2024-08-11 20:04:02,903 INFO Columns in total : 26
2024-08-11 20:04:02,903 INFO Columns relevant : 8
2024-08-11 20:04:02,904 INFO ================================================================================
2024-08-11 20:04:02,904 INFO Starting FAA data file transfer to S3 bucket.
2024-08-11 20:04:02,904 INFO
2024-08-11 20:04:02,912 INFO Found credentials in shared credentials file: ~/.aws/credentials
2024-08-11 20:04:42,540 INFO Files processed in total: 1
2024-08-11 20:04:42,540 INFO
2024-08-11 20:04:42,540 INFO FAA data file transfer completed.
2024-08-11 20:04:42,566 INFO ================================================================================
2024-08-11 20:04:42,566 INFO INFO.00.126 Process FAA NASR data: PJA Airspace
2024-08-11 20:04:42,566 INFO --------------------------------------------------------------------------------
2024-08-11 20:04:42,567 INFO INFO.00.080 Admin connect request host=io-xpa-db.io-swiss.ch port=5432 dbname=io_xpa_db user=io_aero
2024-08-11 20:04:42,567 INFO INFO.00.083 keepalives=1 idle=60 interval=10 count=6
2024-08-11 20:04:50,503 INFO
2024-08-11 20:04:50,504 INFO Rows selected : 667
2024-08-11 20:04:50,504 INFO Rows inserted : 667
2024-08-11 20:04:50,504 INFO ================================================================================
2024-08-11 20:04:50,504 INFO Starting FAA data file transfer to S3 bucket.
2024-08-11 20:04:50,504 INFO
2024-08-11 20:04:53,431 INFO Files processed in total: 1
2024-08-11 20:04:53,431 INFO
2024-08-11 20:04:53,432 INFO FAA data file transfer completed.
2024-08-11 20:04:53,437 INFO --------------------------------------------------------------------------------
2024-08-11 20:04:53,437 INFO 337 s - Total time launcher
2024-08-11 20:04:53,437 INFO INFO.00.006 End Launcher
2024-08-11 20:04:53,437 INFO ================================================================================
---------------------------------------------------------------------------
The current time is: 20:04:53.63
Enter the new time:
---------------------------------------------------------------------------
End run_io_map_apps_aws
===========================================================================