===========================================================================
Start run_io_avstats_dev
---------------------------------------------------------------------------
IO-AVSTATS - Aviation Event Statistics.
---------------------------------------------------------------------------
ENV_FOR_DYNACONF : prod
PYTHONPATH : .
---------------------------------------------------------------------------
TASK : u_p_d
APPLICATION :
COMPOSE_TASK :
MSACCESS : up15FEB
MSEXCEL :
---------------------------------------------------------------------------
The current time is: 11:25:18.23
Enter the new time:
===========================================================================
2025-02-15 11:25:19,160 [root] [io_logger.py ] INFO You are using io-aero's iocommon version 1.2.63 logger (Copyright (c) 2022-2024 IO-Aero)
2025-02-15 11:25:19,160 [root] [io_settings.py ] INFO Starting the configuration management system.
2025-02-15 11:25:19,160 [root] [io_settings.py ] INFO Running in a source (non-compiled) environment. Configuration loading from: D:\SoftDevelopment\Projects\IO-Aero\io-avstats
2025-02-15 11:25:19,161 [root] [io_settings.py ] INFO Dynaconf settings loaded successfully.
Progress update 2025-02-15 10:25:20.512662+00:00 : ===============================================================================.
Progress update 2025-02-15 10:25:20.512662+00:00 : INFO.00.004 Start Launcher.
2025-02-15 11:25:20,512 [root] [launcher.py ] INFO param argv=['scripts\\launcher.py', '-t', 'd_n_a', '-m', 'up15FEB']
2025-02-15 11:25:20,513 [root] [launcher.py ] INFO Start launcher.py
2025-02-15 11:25:20,523 [root] [launcher.py ] INFO locale=('en_US', 'UTF-8')
Progress update 2025-02-15 10:25:20.524663+00:00 : INFO.00.008 Arguments task='d_n_a' msaccess='up15FEB'.
Progress update 2025-02-15 10:25:20.525663+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-15 10:25:20.525663+00:00 : INFO.00.047 Download NTSB MS Access database file 'up15FEB'.
Progress update 2025-02-15 10:25:20.525663+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-15 10:25:20.931181+00:00 : INFO.00.013 The connection to the MS Access database file 'up15FEB.zip' on the NTSB download page was successfully established.
Progress update 2025-02-15 10:25:21.301227+00:00 : INFO.00.014 From the file 'up15FEB.zip' 2 chunks were downloaded.
Progress update 2025-02-15 10:25:21.313227+00:00 : INFO.00.015 The file 'up15FEB.zip' was successfully unpacked.
Progress update 2025-02-15 10:25:21.317228+00:00 : INFO.00.051 msaccess_file='D:\SoftDevelopment\Projects\IO-Aero\io-avstats\data\download\IO-AVSTATS.mdb'.
Progress update 2025-02-15 10:25:21.317228+00:00 : INFO.00.051 msaccess_file='D:\SoftDevelopment\Projects\IO-Aero\io-avstats\data\download\up15FEB.sql'.
Progress update 2025-02-15 10:25:21.317228+00:00 : INFO.00.052 razorsql_jar_file='C:\Program Files\RazorSQL\razorsql.jar'.
Progress update 2025-02-15 10:25:21.317228+00:00 : INFO.00.053 razorsql_java_path='C:\Program Files\RazorSQL\jre11\bin\java'.
1739615121420: launching RazorSQL . . .
1739615121421: args . . .
-backup
IO-AVSTATS
null
null
;
null
D:\SoftDevelopment\Projects\IO-Aero\io-avstats\data\download\up15FEB.sql
NO
tables
YES
null
NO
NO
1739615121453: userName: walte
1739615121454: libraryPath: C:\Program Files\RazorSQL\jre11\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\ProgramData\miniconda3\envs\ioavstats;C:\ProgramData\miniconda3\envs\ioavstats\Library\mingw-w64\bin;C:\ProgramData\miniconda3\envs\ioavstats\Library\usr\bin;C:\ProgramData\miniconda3\envs\ioavstats\Library\bin;C:\ProgramData\miniconda3\envs\ioavstats\Scripts;C:\ProgramData\miniconda3\envs\ioavstats\bin;C:\ProgramData\miniconda3\condabin;C:\Program Files\Python313\Scripts;C:\Program Files\Python313;C:\Program Files (x86)\infogridpacific\AZARDI;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files\dotnet;C:\Program Files\Git LFS;C:\Program Files\Microsoft SQL Server\110\Tools\Binn;C:\Program Files\NVIDIA Corporation\NVIDIA NvDLISR;C:\Software\GnuWin32\bin;C:\WINDOWS;C:\WINDOWS\System32;C:\WINDOWS\System32\OpenSSH;C:\WINDOWS\System32\wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0;\bin;\bin;\bin;C:\ProgramData\miniconda3\condabin;C:\Program Files\PostgreSQL\16\bin;C:\Software\jdk-20.0.1\bin;C:\Program Files\PuTTY;C:\Software\LAStools\bin;C:\Software\GnuPG\bin;C:\Program Files\nodejs;C:\Program Files\Calibre2;C:\Program Files\Go\bin;C:\Program Files\Git\cmd;C:\Program Files\Zero Install;C:\Program Files\GitHub CLI;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0;C:\WINDOWS\System32\OpenSSH;C:\Program Files\TortoiseGit\bin;C:\Program Files\Amazon\AWSCLIV2;C:\Program Files\Docker\Docker\resources\bin;C:\Users\walte\.cargo\bin;C:\Users\walte\AppData\Local\Microsoft\WindowsApps;C:\Software\Microsoft VS Code\bin;c:\users\walte\.local\bin;C:\Users\walte\AppData\Local\JetBrains\Toolbox\scripts;C:\Users\walte\AppData\Local\Pandoc;C:\Users\walte\AppData\Local\GitHubDesktop\bin;C:\Users\walte\AppData\Roaming\npm;C:\Users\walte\AppData\Local\Microsoft\WinGet\Links;D:\Batch;C:\Program Files\Redis;C:\ProgramData\miniconda3\condabin;C:\Program Files\JetBrains\JetBrains Gateway 2024.3\bin;.;C:\Users\walte\AppData\Local\Microsoft\WindowsApps;.
1739615121454: javaVersion: 17.0.7
1739615121454:
1739615121454: Verifying RazorSQL resources location.
1739615121454:
1739615121455: testing base url: / = file:/C:/Program%20Files/RazorSQL/
1739615121455:
1739615121455: testString1: file:/C:/Program%20Files/RazorSQL/razorsql.jar
1739615121455: testString2: file:/C:/Program%20Files/RazorSQL/data/base.ssql
1739615121455: testFile1: C:\Program Files\RazorSQL\razorsql.jar
1739615121455: testFile2: C:\Program Files\RazorSQL\data\base.ssql
1739615121455: both test file exists. Base URL found.
1739615121455: resource directory: file:/C:/Program%20Files/RazorSQL/
1739615121455: user home: C:\Users\walte
1739615121456: user profile: C:\Users\walte
1739615121456: app data: C:\Users\walte\AppData\Roaming
1739615121456: checking write access to: C:\Users\walte\AppData\Roaming
1739615121457: write dir: C:\Users\walte\AppData\Roaming\RichardsonSoftware
1739615121457: can write to C:\Users\walte\AppData\Roaming
1739615121457: user.home: C:\Users\walte\AppData\Roaming
1739615121457: RazorSQL Scratch Directory: C:\Users\walte\AppData\Roaming\RazorSQL
1739615121457: RazorSQL Scratch Directory exists
1739615121457: checking for sub directories
1739615121457: razorsql launch log: C:\Users\walte\AppData\Roaming\RazorSQL\razorsql_launch_log.txt
1739615121457: launch log file = C:\Users\walte\AppData\Roaming\RazorSQL\razorsql_launch_log.txt
1739615121458: Checking for graphics properties
1739615121458: graphics properties file: C:\Users\walte\AppData\Roaming\RazorSQL\data\graphics_properties.txt
1739615121458: gOverride: null
1739615121458: not disabling advanced graphics
1739615121458: path0: file:/C:/Program%20Files/RazorSQL/data/run.ssql
1739615121458: path1: file:/C:/Program%20Files/RazorSQL/razorsql.jar
1739615121458: runArgs: true
1739615121458: showScreen: false
1739615121459: args[0]: -backup
1739615121459: args[1]: IO-AVSTATS
1739615121459: args[2]: null
1739615121459: args[3]: null
1739615121459: args[4]: ;
1739615121459: args[5]: null
1739615121459: args[6]: D:\SoftDevelopment\Projects\IO-Aero\io-avstats\data\download\up15FEB.sql
1739615121459: args[7]: NO
1739615121459: args[8]: tables
1739615121459: args[9]: YES
1739615121459: args[10]: null
1739615121459: args[11]: NO
1739615121459: args[12]: NO
1739615121459: Command: -backup
1739615121459: Running -backup
h: name = C:\Program Files\RazorSQL\data\run.ssql
h: name = C:\Program Files\RazorSQL\razorsql.jar
1739615121466: Attempting to load . . .
command found
uOne: file:/C:/Program%20Files/RazorSQL/
h: name = C:\Program Files\RazorSQL\data\run.ssql
1739615121475reading file . . .C:\Program Files\RazorSQL\data\base.ssql
1739615121494done reading . . .
1739615121503done converting
1739615121503starting lib load.
1739615121511lib load complete.
In command line processor
Max Memory: 30688.0
Current Total Memory: 2048.0
Free Memory: 1916.0260467529297
1739615121575: r init
1739615121575: d init
1739615121575: get default file encoding
1739615121575: end d init
custom home directory: null
Checking for user data from old versions
1739615121576: user home: C:\Users\walte
1739615121576: user profile: C:\Users\walte
1739615121576: app data: C:\Users\walte\AppData\Roaming
1739615121577: checking write access to: C:\Users\walte\AppData\Roaming
1739615121577: write dir: C:\Users\walte\AppData\Roaming\RichardsonSoftware
1739615121577: can write to C:\Users\walte\AppData\Roaming
newHome: C:\Users\walte\AppData\Roaming\RazorSQL
dataHome: C:\Users\walte\AppData\Roaming/RazorSQL/data/
preferences file: C:\Users\walte\AppData\Roaming\RazorSQL\data\preferences.txt
Profiles Exist
1739615121586: loading icons
1739615121835: done r init
Getting connection data from: IO-AVSTATS
1739615121837: r init
1739615121837: d init
1739615121837: get default file encoding
1739615121837: end d init
custom home directory: null
Checking for user data from old versions
newHome: C:\Users\walte\AppData\Roaming\RazorSQL
dataHome: C:\Users\walte\AppData\Roaming/RazorSQL/data/
preferences file: C:\Users\walte\AppData\Roaming\RazorSQL\data\preferences.txt
Profiles Exist
1739615121837: loading icons
1739615121848: done r init
getting connection . . .
Not using SSH Tunnel
driver: sun.jdbc.odbc.JdbcOdbcDriver
classLocation: C:\Program Files\RazorSQL\drivers\common\odbc.jar
loadedCommonJars: false
commonURL: file:/C:/Program%20Files/RazorSQL/drivers/common/
commonDir: C:\Program Files\RazorSQL\drivers\common
commonFiles[0]: file:/C:/Program%20Files/RazorSQL/drivers/common/activation.jar
commonFiles[1]: file:/C:/Program%20Files/RazorSQL/drivers/common/common.jar
commonFiles[2]: file:/C:/Program%20Files/RazorSQL/drivers/common/jaxb-api.jar
commonFiles[3]: file:/C:/Program%20Files/RazorSQL/drivers/common/jaxb-core.jar
commonFiles[4]: file:/C:/Program%20Files/RazorSQL/drivers/common/jaxb-impl.jar
commonFiles[6]: file:/C:/Program%20Files/RazorSQL/drivers/common/odbc.jar
connection type: ODBC
final classLocation: C:\Program Files\RazorSQL\drivers\common\odbc.jar
classLocation file: C:\Program Files\RazorSQL\drivers\common\odbc.jar
building sql manager
Loading driver
Done loading driver
Getting connection with no login info
JdbcOdbcDriver: in initialize
OdbcApi == null
Creating new OdbcApi, nativePrefix:
JdbcOdbc constructor
Attempting to load JdbcOdbc library
Got OdbcApi: sun.jdbc.odbc.JdbcOdbc@77846d2c
Getting charset
JdbcOdbcDriver.OdbcApi.charSet: Cp1252
Connection obtained
obtained connection
database major version = 2
database product name: ACCESS
multiValueInsert: false
includeIdentifyColumns: false
Calling backup . . .
Retrieving Tables . . .
Generating Table DDL . . .
1 of 20
number of columns 93
column map size: 93
foundNull: false
2 of 20
number of columns 2
column map size: 2
foundNull: false
3 of 20
number of columns 11
column map size: 11
foundNull: false
4 of 20
number of columns 2
column map size: 2
foundNull: false
5 of 20
number of columns 6
column map size: 6
foundNull: false
6 of 20
number of columns 5
column map size: 5
foundNull: false
7 of 20
number of columns 7
column map size: 7
foundNull: false
8 of 20
number of columns 13
column map size: 13
foundNull: false
9 of 20
number of columns 17
column map size: 17
foundNull: false
10 of 20
number of columns 73
column map size: 73
foundNull: false
11 of 20
number of columns 10
column map size: 10
foundNull: false
12 of 20
number of columns 14
column map size: 14
foundNull: false
13 of 20
number of columns 33
column map size: 33
foundNull: false
14 of 20
number of columns 8
column map size: 8
foundNull: false
15 of 20
number of columns 7
column map size: 7
foundNull: false
16 of 20
number of columns 8
column map size: 8
foundNull: false
17 of 20
number of columns 5
column map size: 5
foundNull: false
18 of 20
number of columns 8
column map size: 8
foundNull: false
19 of 20
number of columns 11
column map size: 11
foundNull: false
20 of 20
number of columns 3
column map size: 3
foundNull: false
Generating Alter Table DDL . . .
1 of 20
2 of 20
3 of 20
4 of 20
5 of 20
6 of 20
7 of 20
8 of 20
9 of 20
10 of 20
11 of 20
12 of 20
13 of 20
14 of 20
15 of 20
16 of 20
17 of 20
18 of 20
19 of 20
20 of 20
backup finished
closing connection . . .
connection closed.
Shutting down logging streams
Done shutting down logging streams
Exiting . . .
Progress update 2025-02-15 10:25:22.855963+00:00 : INFO.00.011 The DDL script for the MS Access database 'up15FEB.mdb' was created successfully.
Progress update 2025-02-15 10:25:22.857536+00:00 : INFO.00.012 The DDL script for the MS Access database 'up15FEB.mdb' is identical to the reference script.
Progress update 2025-02-15 10:25:22.858061+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-15 10:25:22.858061+00:00 : 2 s - Total time launcher.
Progress update 2025-02-15 10:25:22.858061+00:00 : INFO.00.006 End Launcher.
Progress update 2025-02-15 10:25:22.858061+00:00 : ===============================================================================.
2025-02-15 11:25:24,041 [root] [io_logger.py ] INFO You are using io-aero's iocommon version 1.2.63 logger (Copyright (c) 2022-2024 IO-Aero)
2025-02-15 11:25:24,041 [root] [io_settings.py ] INFO Starting the configuration management system.
2025-02-15 11:25:24,042 [root] [io_settings.py ] INFO Running in a source (non-compiled) environment. Configuration loading from: D:\SoftDevelopment\Projects\IO-Aero\io-avstats
2025-02-15 11:25:24,042 [root] [io_settings.py ] INFO Dynaconf settings loaded successfully.
Progress update 2025-02-15 10:25:25.342701+00:00 : ===============================================================================.
Progress update 2025-02-15 10:25:25.342701+00:00 : INFO.00.004 Start Launcher.
2025-02-15 11:25:25,342 [root] [launcher.py ] INFO param argv=['scripts\\launcher.py', '-t', 'l_n_a', '-m', 'up15FEB']
2025-02-15 11:25:25,356 [root] [launcher.py ] INFO Start launcher.py
2025-02-15 11:25:25,367 [root] [launcher.py ] INFO locale=('en_US', 'UTF-8')
Progress update 2025-02-15 10:25:25.368201+00:00 : INFO.00.008 Arguments task='l_n_a' msaccess='up15FEB'.
Progress update 2025-02-15 10:25:25.368201+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-15 10:25:25.368201+00:00 : INFO.00.049 Load NTSB MS Access database data from file 'up15FEB'.
Progress update 2025-02-15 10:25:25.368201+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-15 10:25:25.369203+00:00 : INFO.00.054 ODBC driver='DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=D:\SoftDevelopment\Projects\IO-Aero\io-avstats\data\download\up15FEB.mdb;'.
2025-02-15 11:25:25,550 [root] [db_utils.py ] INFO INFO.00.080 Admin connect request host=localhost port=5432 dbname=io_aero_db user=io_aero
Progress update 2025-02-15 10:25:25.768571+00:00 : INFO.00.021 The following database table is not processed: 'MSysAccessObjects'.
Progress update 2025-02-15 10:25:25.768571+00:00 : INFO.00.021 The following database table is not processed: 'MSysACEs'.
Progress update 2025-02-15 10:25:25.769088+00:00 : INFO.00.021 The following database table is not processed: 'MSysIMEXColumns'.
Progress update 2025-02-15 10:25:25.769088+00:00 : INFO.00.021 The following database table is not processed: 'MSysIMEXSpecs'.
Progress update 2025-02-15 10:25:25.769088+00:00 : INFO.00.021 The following database table is not processed: 'MSysModules2'.
Progress update 2025-02-15 10:25:25.769088+00:00 : INFO.00.021 The following database table is not processed: 'MSysNavPaneGroupCategories'.
Progress update 2025-02-15 10:25:25.769088+00:00 : INFO.00.021 The following database table is not processed: 'MSysNavPaneGroups'.
Progress update 2025-02-15 10:25:25.769088+00:00 : INFO.00.021 The following database table is not processed: 'MSysNavPaneGroupToObjects'.
Progress update 2025-02-15 10:25:25.769612+00:00 : INFO.00.021 The following database table is not processed: 'MSysNavPaneObjectIDs'.
Progress update 2025-02-15 10:25:25.769612+00:00 : INFO.00.021 The following database table is not processed: 'MSysObjects'.
Progress update 2025-02-15 10:25:25.769612+00:00 : INFO.00.021 The following database table is not processed: 'MSysQueries'.
Progress update 2025-02-15 10:25:25.769612+00:00 : INFO.00.021 The following database table is not processed: 'MSysRelationships'.
Progress update 2025-02-15 10:25:25.769612+00:00 : INFO.00.021 The following database table is not processed: 'Country'.
Progress update 2025-02-15 10:25:25.769612+00:00 : INFO.00.021 The following database table is not processed: 'ct_iaids'.
Progress update 2025-02-15 10:25:25.770134+00:00 : INFO.00.021 The following database table is not processed: 'ct_seqevt'.
Progress update 2025-02-15 10:25:25.770134+00:00 : INFO.00.021 The following database table is not processed: 'eADMSPUB_DataDictionary'.
Progress update 2025-02-15 10:25:25.770134+00:00 : INFO.00.021 The following database table is not processed: 'states'.
Progress update 2025-02-15 10:25:25.770134+00:00 :
Progress update 2025-02-15 10:25:25.770134+00:00 : Database table : events <-----------------------------------.
Progress update 2025-02-15 10:25:26.240059+00:00 : Updated ev_id=20250128199610 ev_year=2025.
Progress update 2025-02-15 10:25:26.256215+00:00 : Inserted ev_id=20250123199590 ev_year=2025.
Progress update 2025-02-15 10:25:26.273066+00:00 : Inserted ev_id=20250210199669 ev_year=2025.
Progress update 2025-02-15 10:25:26.314974+00:00 : Updated ev_id=20240812194896 ev_year=2024.
Progress update 2025-02-15 10:25:26.343063+00:00 : Updated ev_id=20250204199647 ev_year=2025.
Progress update 2025-02-15 10:25:26.364979+00:00 : Inserted ev_id=20250206199656 ev_year=2025.
Progress update 2025-02-15 10:25:26.401814+00:00 : Updated ev_id=20240108193625 ev_year=2024.
Progress update 2025-02-15 10:25:26.456204+00:00 : Updated ev_id=20240213193792 ev_year=2024.
Progress update 2025-02-15 10:25:26.481197+00:00 : Updated ev_id=20240610194434 ev_year=2024.
Progress update 2025-02-15 10:25:26.514700+00:00 : Updated ev_id=20240612194456 ev_year=2024.
Progress update 2025-02-15 10:25:26.547949+00:00 : Updated ev_id=20240618194495 ev_year=2024.
Progress update 2025-02-15 10:25:26.573096+00:00 : Updated ev_id=20240903195046 ev_year=2024.
Progress update 2025-02-15 10:25:26.597893+00:00 : Updated ev_id=20240910195095 ev_year=2024.
Progress update 2025-02-15 10:25:26.622904+00:00 : Inserted ev_id=20250210199675 ev_year=2025.
Progress update 2025-02-15 10:25:26.647902+00:00 : Inserted ev_id=20250210199672 ev_year=2025.
Progress update 2025-02-15 10:25:26.673463+00:00 : Inserted ev_id=20250211199682 ev_year=2025.
Progress update 2025-02-15 10:25:26.723137+00:00 : Updated ev_id=20250102199500 ev_year=2025.
Progress update 2025-02-15 10:25:26.864961+00:00 : Inserted ev_id=20250211199678 ev_year=2025.
Progress update 2025-02-15 10:25:26.902059+00:00 : Inserted ev_id=20250211199680 ev_year=2025.
Progress update 2025-02-15 10:25:26.923200+00:00 : Inserted ev_id=20250211199679 ev_year=2025.
Progress update 2025-02-15 10:25:26.972744+00:00 : Updated ev_id=20240826195000 ev_year=2024.
Progress update 2025-02-15 10:25:27.022844+00:00 : Updated ev_id=20250116199555 ev_year=2025.
Progress update 2025-02-15 10:25:27.047753+00:00 : Updated ev_id=20250126199597 ev_year=2025.
Progress update 2025-02-15 10:25:27.072757+00:00 : Inserted ev_id=20250203199634 ev_year=2025.
Progress update 2025-02-15 10:25:27.097763+00:00 : Inserted ev_id=20250210199668 ev_year=2025.
Progress update 2025-02-15 10:25:27.123276+00:00 : Inserted ev_id=20250205199651 ev_year=2025.
Progress update 2025-02-15 10:25:27.148277+00:00 : Inserted ev_id=20250121199576 ev_year=2025.
Progress update 2025-02-15 10:25:27.173278+00:00 : Inserted ev_id=20250212199686 ev_year=2025.
Progress update 2025-02-15 10:25:27.198281+00:00 : Inserted ev_id=20250201199630 ev_year=2025.
Progress update 2025-02-15 10:25:27.256051+00:00 : Updated ev_id=20240604194378 ev_year=2024.
Progress update 2025-02-15 10:25:27.280800+00:00 : Updated ev_id=20240606194409 ev_year=2024.
Progress update 2025-02-15 10:25:27.306473+00:00 : Updated ev_id=20240612194455 ev_year=2024.
Progress update 2025-02-15 10:25:27.339238+00:00 : Updated ev_id=20240618194493 ev_year=2024.
Progress update 2025-02-15 10:25:27.364237+00:00 : Updated ev_id=20240624194535 ev_year=2024.
Progress update 2025-02-15 10:25:27.389241+00:00 : Updated ev_id=20240624194539 ev_year=2024.
Progress update 2025-02-15 10:25:27.414237+00:00 : Updated ev_id=20240624194540 ev_year=2024.
Progress update 2025-02-15 10:25:27.465152+00:00 : Updated ev_id=20240624194541 ev_year=2024.
Progress update 2025-02-15 10:25:27.489156+00:00 : Updated ev_id=20240625194548 ev_year=2024.
Progress update 2025-02-15 10:25:27.522683+00:00 : Updated ev_id=20240701194592 ev_year=2024.
Progress update 2025-02-15 10:25:27.547682+00:00 : Updated ev_id=20240701194595 ev_year=2024.
Progress update 2025-02-15 10:25:27.572682+00:00 : Updated ev_id=20240701194596 ev_year=2024.
Progress update 2025-02-15 10:25:27.597691+00:00 : Updated ev_id=20240702194598 ev_year=2024.
Progress update 2025-02-15 10:25:27.623204+00:00 : Updated ev_id=20240702194599 ev_year=2024.
Progress update 2025-02-15 10:25:27.673204+00:00 : Updated ev_id=20240703194611 ev_year=2024.
Progress update 2025-02-15 10:25:27.698113+00:00 : Updated ev_id=20240708194645 ev_year=2024.
Progress update 2025-02-15 10:25:27.723005+00:00 : Updated ev_id=20241120195518 ev_year=2024.
Progress update 2025-02-15 10:25:27.747893+00:00 : Updated ev_id=20240715194697 ev_year=2024.
Progress update 2025-02-15 10:25:27.772485+00:00 : Inserted ev_id=20250115199550 ev_year=2025.
Progress update 2025-02-15 10:25:27.797491+00:00 : Updated ev_id=20250116199556 ev_year=2025.
Progress update 2025-02-15 10:25:27.823001+00:00 : Inserted ev_id=20250121199574 ev_year=2024.
Progress update 2025-02-15 10:25:27.847244+00:00 : Updated ev_id=20240510194238 ev_year=2024.
Progress update 2025-02-15 10:25:27.873243+00:00 : Updated ev_id=20241125195545 ev_year=2024.
Progress update 2025-02-15 10:25:27.897222+00:00 : Inserted ev_id=20250212199685 ev_year=2025.
Progress update 2025-02-15 10:25:27.922648+00:00 : Inserted ev_id=20250211199684 ev_year=2025.
Progress update 2025-02-15 10:25:27.947758+00:00 : Inserted ev_id=20250213199694 ev_year=2024.
Progress update 2025-02-15 10:25:27.972129+00:00 : Inserted ev_id=20250130199620 ev_year=2025.
Progress update 2025-02-15 10:25:27.997132+00:00 : Inserted ev_id=20250213199697 ev_year=2024.
Progress update 2025-02-15 10:25:28.022646+00:00 : Inserted ev_id=20250213199696 ev_year=2024.
Progress update 2025-02-15 10:25:28.047642+00:00 : Inserted ev_id=20250213199693 ev_year=2025.
Progress update 2025-02-15 10:25:28.072844+00:00 : Inserted ev_id=20250212199690 ev_year=2025.
Progress update 2025-02-15 10:25:28.106369+00:00 : Updated ev_id=20230117106588 ev_year=2023.
Progress update 2025-02-15 10:25:28.139367+00:00 : Updated ev_id=20230130106646 ev_year=2023.
Progress update 2025-02-15 10:25:28.164367+00:00 : Updated ev_id=20230222106756 ev_year=2023.
Progress update 2025-02-15 10:25:28.189079+00:00 : Updated ev_id=20230307106841 ev_year=2023.
Progress update 2025-02-15 10:25:28.213957+00:00 : Updated ev_id=20230413107053 ev_year=2023.
Progress update 2025-02-15 10:25:28.239963+00:00 : Updated ev_id=20230419107087 ev_year=2023.
Progress update 2025-02-15 10:25:28.263961+00:00 : Updated ev_id=20230424107114 ev_year=2023.
Progress update 2025-02-15 10:25:28.289962+00:00 : Updated ev_id=20230807192813 ev_year=2023.
Progress update 2025-02-15 10:25:28.314063+00:00 : Updated ev_id=20240112193642 ev_year=2024.
Progress update 2025-02-15 10:25:28.339063+00:00 : Updated ev_id=20240624194536 ev_year=2024.
Progress update 2025-02-15 10:25:28.363964+00:00 : Updated ev_id=20250122199577 ev_year=2025.
Progress update 2025-02-15 10:25:28.389593+00:00 : Inserted ev_id=20250207199662 ev_year=2025.
Progress update 2025-02-15 10:25:28.414063+00:00 : Inserted ev_id=20250214199699 ev_year=2024.
Progress update 2025-02-15 10:25:28.439063+00:00 : Inserted ev_id=20250115199549 ev_year=2024.
Progress update 2025-02-15 10:25:28.464064+00:00 : Inserted ev_id=20250214199703 ev_year=2025.
Progress update 2025-02-15 10:25:28.464064+00:00 : Number rows selected : 75.
Progress update 2025-02-15 10:25:28.465065+00:00 : Number rows inserted : 29.
Progress update 2025-02-15 10:25:28.465065+00:00 : Number rows updated : 46.
Progress update 2025-02-15 10:25:28.465065+00:00 :
Progress update 2025-02-15 10:25:28.465065+00:00 : Database table : aircraft <-----------------------------------.
Progress update 2025-02-15 10:25:28.588652+00:00 : Updated ev_id=20250128199610 aircraft_key=1.
Progress update 2025-02-15 10:25:28.614216+00:00 : Updated ev_id=20250128199610 aircraft_key=2.
Progress update 2025-02-15 10:25:28.705727+00:00 : Updated ev_id=20240812194896 aircraft_key=1.
Progress update 2025-02-15 10:25:28.731397+00:00 : Updated ev_id=20250204199647 aircraft_key=1.
Progress update 2025-02-15 10:25:28.755501+00:00 : Updated ev_id=20250204199647 aircraft_key=2.
Progress update 2025-02-15 10:25:28.813898+00:00 : Updated ev_id=20240108193625 aircraft_key=1.
Progress update 2025-02-15 10:25:28.838899+00:00 : Updated ev_id=20240213193792 aircraft_key=1.
Progress update 2025-02-15 10:25:28.863899+00:00 : Updated ev_id=20240610194434 aircraft_key=1.
Progress update 2025-02-15 10:25:28.889565+00:00 : Updated ev_id=20240612194456 aircraft_key=1.
Progress update 2025-02-15 10:25:28.913791+00:00 : Updated ev_id=20240618194495 aircraft_key=1.
Progress update 2025-02-15 10:25:28.939304+00:00 : Updated ev_id=20240903195046 aircraft_key=1.
Progress update 2025-02-15 10:25:28.964339+00:00 : Updated ev_id=20240910195095 aircraft_key=1.
Progress update 2025-02-15 10:25:29.063422+00:00 : Updated ev_id=20250102199500 aircraft_key=1.
Progress update 2025-02-15 10:25:29.164246+00:00 : Updated ev_id=20240826195000 aircraft_key=1.
Progress update 2025-02-15 10:25:29.188892+00:00 : Updated ev_id=20250116199555 aircraft_key=1.
Progress update 2025-02-15 10:25:29.213554+00:00 : Updated ev_id=20250126199597 aircraft_key=1.
Progress update 2025-02-15 10:25:29.389411+00:00 : Updated ev_id=20240604194378 aircraft_key=1.
Progress update 2025-02-15 10:25:29.413922+00:00 : Updated ev_id=20240606194409 aircraft_key=1.
Progress update 2025-02-15 10:25:29.438922+00:00 : Updated ev_id=20240612194455 aircraft_key=1.
Progress update 2025-02-15 10:25:29.471615+00:00 : Updated ev_id=20240618194493 aircraft_key=1.
Progress update 2025-02-15 10:25:29.497812+00:00 : Updated ev_id=20240624194535 aircraft_key=1.
Progress update 2025-02-15 10:25:29.522337+00:00 : Updated ev_id=20240624194539 aircraft_key=1.
Progress update 2025-02-15 10:25:29.547337+00:00 : Updated ev_id=20240624194540 aircraft_key=1.
Progress update 2025-02-15 10:25:29.572354+00:00 : Updated ev_id=20240624194541 aircraft_key=1.
Progress update 2025-02-15 10:25:29.597357+00:00 : Updated ev_id=20240625194548 aircraft_key=1.
Progress update 2025-02-15 10:25:29.622867+00:00 : Updated ev_id=20240701194592 aircraft_key=1.
Progress update 2025-02-15 10:25:29.646867+00:00 : Updated ev_id=20240701194595 aircraft_key=1.
Progress update 2025-02-15 10:25:29.672867+00:00 : Updated ev_id=20240701194596 aircraft_key=1.
Progress update 2025-02-15 10:25:29.697872+00:00 : Updated ev_id=20240702194598 aircraft_key=1.
Progress update 2025-02-15 10:25:29.721381+00:00 : Updated ev_id=20240702194599 aircraft_key=1.
Progress update 2025-02-15 10:25:29.755485+00:00 : Updated ev_id=20240703194611 aircraft_key=1.
Progress update 2025-02-15 10:25:29.780484+00:00 : Updated ev_id=20240708194645 aircraft_key=1.
Progress update 2025-02-15 10:25:29.805489+00:00 : Updated ev_id=20241120195518 aircraft_key=1.
Progress update 2025-02-15 10:25:29.831000+00:00 : Updated ev_id=20240715194697 aircraft_key=1.
Progress update 2025-02-15 10:25:29.880424+00:00 : Updated ev_id=20250116199556 aircraft_key=1.
Progress update 2025-02-15 10:25:29.930455+00:00 : Updated ev_id=20240510194238 aircraft_key=1.
Progress update 2025-02-15 10:25:29.955454+00:00 : Updated ev_id=20241125195545 aircraft_key=1.
Progress update 2025-02-15 10:25:30.214144+00:00 : Updated ev_id=20230117106588 aircraft_key=1.
Progress update 2025-02-15 10:25:30.255099+00:00 : Updated ev_id=20230130106646 aircraft_key=1.
Progress update 2025-02-15 10:25:30.279669+00:00 : Updated ev_id=20230222106756 aircraft_key=1.
Progress update 2025-02-15 10:25:30.305675+00:00 : Updated ev_id=20230307106841 aircraft_key=1.
Progress update 2025-02-15 10:25:30.330184+00:00 : Updated ev_id=20230413107053 aircraft_key=1.
Progress update 2025-02-15 10:25:30.356189+00:00 : Updated ev_id=20230419107087 aircraft_key=1.
Progress update 2025-02-15 10:25:30.380189+00:00 : Updated ev_id=20230424107114 aircraft_key=1.
Progress update 2025-02-15 10:25:30.405337+00:00 : Updated ev_id=20230807192813 aircraft_key=1.
Progress update 2025-02-15 10:25:30.430275+00:00 : Updated ev_id=20240112193642 aircraft_key=1.
Progress update 2025-02-15 10:25:30.455520+00:00 : Updated ev_id=20240624194536 aircraft_key=1.
Progress update 2025-02-15 10:25:30.480521+00:00 : Updated ev_id=20250122199577 aircraft_key=1.
Progress update 2025-02-15 10:25:30.574410+00:00 : Number rows selected : 78.
Progress update 2025-02-15 10:25:30.574410+00:00 : Number rows inserted : 30.
Progress update 2025-02-15 10:25:30.574410+00:00 : Number rows updated : 48.
Progress update 2025-02-15 10:25:30.575411+00:00 :
Progress update 2025-02-15 10:25:30.575411+00:00 : Database table : dt_events <-----------------------------------.
Progress update 2025-02-15 10:25:30.655936+00:00 : Updated ev_id=20250128199610 col_name=followup_travel code=N.
Progress update 2025-02-15 10:25:30.679936+00:00 : Updated ev_id=20250128199610 col_name=launch code=None.
Progress update 2025-02-15 10:25:30.825587+00:00 : Updated ev_id=20240812194896 col_name=launch code=None.
Progress update 2025-02-15 10:25:30.846584+00:00 : Updated ev_id=20240812194896 col_name=wx_brief_src code=COMP.
Progress update 2025-02-15 10:25:30.871584+00:00 : Updated ev_id=20250204199647 col_name=followup_travel code=N.
Progress update 2025-02-15 10:25:30.896590+00:00 : Updated ev_id=20250204199647 col_name=launch code=None.
Progress update 2025-02-15 10:25:30.980106+00:00 : Updated ev_id=20240108193625 col_name=followup_travel code=N.
Progress update 2025-02-15 10:25:31.005110+00:00 : Updated ev_id=20240108193625 col_name=launch code=None.
Progress update 2025-02-15 10:25:31.163139+00:00 : Updated ev_id=20240213193792 col_name=followup_travel code=N.
Progress update 2025-02-15 10:25:31.189080+00:00 : Updated ev_id=20240213193792 col_name=launch code=None.
Progress update 2025-02-15 10:25:31.355182+00:00 : Updated ev_id=20240610194434 col_name=followup_travel code=N.
Progress update 2025-02-15 10:25:31.380182+00:00 : Updated ev_id=20240610194434 col_name=launch code=None.
Progress update 2025-02-15 10:25:31.513484+00:00 : Updated ev_id=20240612194456 col_name=launch code=None.
Progress update 2025-02-15 10:25:31.538488+00:00 : Updated ev_id=20240612194456 col_name=icing_actual_amt code=NONE.
Progress update 2025-02-15 10:25:31.563486+00:00 : Updated ev_id=20240612194456 col_name=icing_actual_type code=NA.
Progress update 2025-02-15 10:25:31.588485+00:00 : Updated ev_id=20240612194456 col_name=icing_forecast_amt code=NONE.
Progress update 2025-02-15 10:25:31.613815+00:00 : Updated ev_id=20240612194456 col_name=icing_forecast_type code=NA.
Progress update 2025-02-15 10:25:31.638815+00:00 : Updated ev_id=20240612194456 col_name=turb_fc_type code=NONE.
Progress update 2025-02-15 10:25:31.663815+00:00 : Updated ev_id=20240612194456 col_name=turb_severity code=NA.
Progress update 2025-02-15 10:25:31.688817+00:00 : Updated ev_id=20240612194456 col_name=turb_type code=NONE.
Progress update 2025-02-15 10:25:31.713338+00:00 : Updated ev_id=20240612194456 col_name=wx_brief_src code=AUTR.
Progress update 2025-02-15 10:25:31.755342+00:00 : Updated ev_id=20240618194495 col_name=followup_travel code=N.
Progress update 2025-02-15 10:25:31.779915+00:00 : Updated ev_id=20240618194495 col_name=launch code=None.
Progress update 2025-02-15 10:25:31.804919+00:00 : Updated ev_id=20240618194495 col_name=icing_actual_amt code=NONE.
Progress update 2025-02-15 10:25:31.830429+00:00 : Updated ev_id=20240618194495 col_name=icing_actual_type code=NA.
Progress update 2025-02-15 10:25:31.855431+00:00 : Updated ev_id=20240618194495 col_name=icing_forecast_amt code=NONE.
Progress update 2025-02-15 10:25:31.880431+00:00 : Updated ev_id=20240618194495 col_name=icing_forecast_type code=NA.
Progress update 2025-02-15 10:25:31.905435+00:00 : Updated ev_id=20240618194495 col_name=turb_fc_type code=NONE.
Progress update 2025-02-15 10:25:31.929944+00:00 : Updated ev_id=20240618194495 col_name=turb_severity code=NA.
Progress update 2025-02-15 10:25:31.954947+00:00 : Updated ev_id=20240618194495 col_name=turb_type code=NONE.
Progress update 2025-02-15 10:25:31.979946+00:00 : Updated ev_id=20240618194495 col_name=wx_brief_src code=NONE.
Progress update 2025-02-15 10:25:32.030655+00:00 : Updated ev_id=20240903195046 col_name=launch code=None.
Progress update 2025-02-15 10:25:32.071656+00:00 : Updated ev_id=20240910195095 col_name=followup_travel code=N.
Progress update 2025-02-15 10:25:32.096661+00:00 : Updated ev_id=20240910195095 col_name=launch code=None.
Progress update 2025-02-15 10:25:32.205140+00:00 : Updated ev_id=20250102199500 col_name=launch code=None.
Progress update 2025-02-15 10:25:32.230143+00:00 : Updated ev_id=20250102199500 col_name=wx_brief_src code=AUTR.
Progress update 2025-02-15 10:25:32.355673+00:00 : Updated ev_id=20240826195000 col_name=launch code=None.
Progress update 2025-02-15 10:25:32.380735+00:00 : Updated ev_id=20240826195000 col_name=icing_actual_amt code=NONE.
Progress update 2025-02-15 10:25:32.405636+00:00 : Updated ev_id=20240826195000 col_name=icing_actual_type code=NA.
Progress update 2025-02-15 10:25:32.429720+00:00 : Updated ev_id=20240826195000 col_name=icing_forecast_amt code=NONE.
Progress update 2025-02-15 10:25:32.455055+00:00 : Updated ev_id=20240826195000 col_name=icing_forecast_type code=NA.
Progress update 2025-02-15 10:25:32.471406+00:00 : Updated ev_id=20240826195000 col_name=wx_brief_src0 code=UNK.
Progress update 2025-02-15 10:25:32.488270+00:00 : Updated ev_id=20250116199555 col_name=followup_travel code=N.
Progress update 2025-02-15 10:25:32.513308+00:00 : Updated ev_id=20250116199555 col_name=launch code=None.
Progress update 2025-02-15 10:25:32.672483+00:00 : Updated ev_id=20250126199597 col_name=launch code=None.
Progress update 2025-02-15 10:25:33.238512+00:00 : Updated ev_id=20240604194378 col_name=launch code=None.
Progress update 2025-02-15 10:25:33.264140+00:00 : Updated ev_id=20240604194378 col_name=icing_actual_amt code=NONE.
Progress update 2025-02-15 10:25:33.289995+00:00 : Updated ev_id=20240604194378 col_name=icing_actual_type code=NA.
Progress update 2025-02-15 10:25:33.313177+00:00 : Updated ev_id=20240604194378 col_name=icing_forecast_amt code=NONE.
Progress update 2025-02-15 10:25:33.338558+00:00 : Updated ev_id=20240604194378 col_name=icing_forecast_type code=NA.
Progress update 2025-02-15 10:25:33.363718+00:00 : Updated ev_id=20240604194378 col_name=turb_fc_type code=NONE.
Progress update 2025-02-15 10:25:33.388255+00:00 : Updated ev_id=20240604194378 col_name=turb_severity code=NA.
Progress update 2025-02-15 10:25:33.413107+00:00 : Updated ev_id=20240604194378 col_name=turb_type code=NONE.
Progress update 2025-02-15 10:25:33.454789+00:00 : Updated ev_id=20240606194409 col_name=launch code=None.
Progress update 2025-02-15 10:25:33.630030+00:00 : Updated ev_id=20240612194455 col_name=launch code=None.
Progress update 2025-02-15 10:25:33.655033+00:00 : Updated ev_id=20240612194455 col_name=wx_brief_src code=AUTR.
Progress update 2025-02-15 10:25:33.688031+00:00 : Updated ev_id=20240618194493 col_name=launch code=None.
Progress update 2025-02-15 10:25:33.779554+00:00 : Updated ev_id=20240624194535 col_name=launch code=None.
Progress update 2025-02-15 10:25:33.929242+00:00 : Updated ev_id=20240624194539 col_name=launch code=None.
Progress update 2025-02-15 10:25:34.088303+00:00 : Updated ev_id=20240624194540 col_name=launch code=None.
Progress update 2025-02-15 10:25:34.237755+00:00 : Updated ev_id=20240624194541 col_name=launch code=None.
Progress update 2025-02-15 10:25:34.254812+00:00 : Updated ev_id=20240624194541 col_name=icing_actual_amt code=NONE.
Progress update 2025-02-15 10:25:34.270817+00:00 : Updated ev_id=20240624194541 col_name=icing_actual_type code=NA.
Progress update 2025-02-15 10:25:34.287824+00:00 : Updated ev_id=20240624194541 col_name=icing_forecast_amt code=NONE.
Progress update 2025-02-15 10:25:34.304433+00:00 : Updated ev_id=20240624194541 col_name=icing_forecast_type code=NA.
Progress update 2025-02-15 10:25:34.320949+00:00 : Updated ev_id=20240624194541 col_name=turb_fc_type code=NONE.
Progress update 2025-02-15 10:25:34.337950+00:00 : Updated ev_id=20240624194541 col_name=turb_severity code=NA.
Progress update 2025-02-15 10:25:34.354950+00:00 : Updated ev_id=20240624194541 col_name=turb_type code=NONE.
Progress update 2025-02-15 10:25:34.370953+00:00 : Updated ev_id=20240624194541 col_name=wx_brief_src code=NWS.
Progress update 2025-02-15 10:25:34.387952+00:00 : Updated ev_id=20240625194548 col_name=launch code=None.
Progress update 2025-02-15 10:25:34.403956+00:00 : Updated ev_id=20240625194548 col_name=icing_actual_amt code=NONE.
Progress update 2025-02-15 10:25:34.421475+00:00 : Updated ev_id=20240625194548 col_name=icing_actual_type code=NA.
Progress update 2025-02-15 10:25:34.438078+00:00 : Updated ev_id=20240625194548 col_name=icing_forecast_amt code=NONE.
Progress update 2025-02-15 10:25:34.455282+00:00 : Updated ev_id=20240625194548 col_name=icing_forecast_type code=NA.
Progress update 2025-02-15 10:25:34.479285+00:00 : Updated ev_id=20240625194548 col_name=turb_fc_type code=NONE.
Progress update 2025-02-15 10:25:34.496288+00:00 : Updated ev_id=20240625194548 col_name=turb_severity code=NA.
Progress update 2025-02-15 10:25:34.513327+00:00 : Updated ev_id=20240625194548 col_name=turb_type code=NONE.
Progress update 2025-02-15 10:25:34.554324+00:00 : Updated ev_id=20240701194592 col_name=launch code=None.
Progress update 2025-02-15 10:25:34.713353+00:00 : Updated ev_id=20240701194595 col_name=launch code=None.
Progress update 2025-02-15 10:25:34.746479+00:00 : Updated ev_id=20240701194596 col_name=launch code=None.
Progress update 2025-02-15 10:25:34.862284+00:00 : Updated ev_id=20240702194598 col_name=launch code=None.
Progress update 2025-02-15 10:25:34.962418+00:00 : Updated ev_id=20240702194599 col_name=launch code=None.
Progress update 2025-02-15 10:25:34.979418+00:00 : Updated ev_id=20240702194599 col_name=icing_actual_amt code=NONE.
Progress update 2025-02-15 10:25:34.997425+00:00 : Updated ev_id=20240702194599 col_name=icing_actual_type code=NA.
Progress update 2025-02-15 10:25:35.021946+00:00 : Updated ev_id=20240702194599 col_name=icing_forecast_amt code=NONE.
Progress update 2025-02-15 10:25:35.051945+00:00 : Updated ev_id=20240702194599 col_name=icing_forecast_type code=NA.
Progress update 2025-02-15 10:25:35.113466+00:00 : Updated ev_id=20240702194599 col_name=turb_fc_type code=NONE.
Progress update 2025-02-15 10:25:35.138990+00:00 : Updated ev_id=20240702194599 col_name=turb_severity code=NA.
Progress update 2025-02-15 10:25:35.163990+00:00 : Updated ev_id=20240702194599 col_name=turb_type code=NONE.
Progress update 2025-02-15 10:25:35.188990+00:00 : Updated ev_id=20240702194599 col_name=wx_brief_src code=COWX.
Progress update 2025-02-15 10:25:35.221829+00:00 : Updated ev_id=20240703194611 col_name=launch code=None.
Progress update 2025-02-15 10:25:35.379186+00:00 : Updated ev_id=20240708194645 col_name=launch code=None.
Progress update 2025-02-15 10:25:35.396186+00:00 : Updated ev_id=20240708194645 col_name=wx_brief_src code=AUTR.
Progress update 2025-02-15 10:25:35.429707+00:00 : Updated ev_id=20241120195518 col_name=launch code=None.
Progress update 2025-02-15 10:25:35.445720+00:00 : Updated ev_id=20240715194697 col_name=launch code=None.
Progress update 2025-02-15 10:25:35.629482+00:00 : Updated ev_id=20250116199556 col_name=launch code=None.
Progress update 2025-02-15 10:25:35.654483+00:00 : Updated ev_id=20250116199556 col_name=wx_brief_src code=AUTR.
Progress update 2025-02-15 10:25:35.721883+00:00 : Updated ev_id=20240510194238 col_name=followup_travel code=Y.
Progress update 2025-02-15 10:25:35.737885+00:00 : Updated ev_id=20240510194238 col_name=launch code=None.
Progress update 2025-02-15 10:25:35.753890+00:00 : Updated ev_id=20241125195545 col_name=launch code=None.
Progress update 2025-02-15 10:25:36.312782+00:00 : Updated ev_id=20230117106588 col_name=launch code=Part.
Progress update 2025-02-15 10:25:36.328789+00:00 : Updated ev_id=20230117106588 col_name=spec_hand code=PA.
Progress update 2025-02-15 10:25:36.345789+00:00 : Updated ev_id=20230117106588 col_name=icing_actual_amt code=NONE.
Progress update 2025-02-15 10:25:36.362787+00:00 : Updated ev_id=20230117106588 col_name=icing_actual_type code=NA.
Progress update 2025-02-15 10:25:36.378791+00:00 : Updated ev_id=20230117106588 col_name=icing_forecast_amt code=NONE.
Progress update 2025-02-15 10:25:36.395792+00:00 : Updated ev_id=20230117106588 col_name=icing_forecast_type code=NA.
Progress update 2025-02-15 10:25:36.412306+00:00 : Updated ev_id=20230117106588 col_name=turb_fc_type code=NONE.
Progress update 2025-02-15 10:25:36.429314+00:00 : Updated ev_id=20230117106588 col_name=turb_severity code=NA.
Progress update 2025-02-15 10:25:36.446314+00:00 : Updated ev_id=20230117106588 col_name=turb_type code=NONE.
Progress update 2025-02-15 10:25:36.471313+00:00 : Updated ev_id=20230117106588 col_name=wx_brief_src code=COWX.
Progress update 2025-02-15 10:25:36.504323+00:00 : Updated ev_id=20230130106646 col_name=launch code=None.
Progress update 2025-02-15 10:25:36.520344+00:00 : Updated ev_id=20230130106646 col_name=wx_brief_src0 code=UNK.
Progress update 2025-02-15 10:25:36.545346+00:00 : Updated ev_id=20230222106756 col_name=launch code=Part.
Progress update 2025-02-15 10:25:36.562344+00:00 : Updated ev_id=20230222106756 col_name=spec_hand code=PA.
Progress update 2025-02-15 10:25:36.578345+00:00 : Updated ev_id=20230222106756 col_name=icing_actual_amt code=NONE.
Progress update 2025-02-15 10:25:36.595344+00:00 : Updated ev_id=20230222106756 col_name=icing_actual_type code=NA.
Progress update 2025-02-15 10:25:36.612353+00:00 : Updated ev_id=20230222106756 col_name=icing_forecast_amt code=NONE.
Progress update 2025-02-15 10:25:36.629865+00:00 : Updated ev_id=20230222106756 col_name=icing_forecast_type code=NA.
Progress update 2025-02-15 10:25:36.662867+00:00 : Updated ev_id=20230222106756 col_name=turb_fc_type code=UNKN.
Progress update 2025-02-15 10:25:36.687866+00:00 : Updated ev_id=20230222106756 col_name=turb_severity code=UNKN.
Progress update 2025-02-15 10:25:36.712384+00:00 : Updated ev_id=20230222106756 col_name=turb_type code=UNKN.
Progress update 2025-02-15 10:25:36.729391+00:00 : Updated ev_id=20230222106756 col_name=wx_brief_src code=AUTR.
Progress update 2025-02-15 10:25:36.754391+00:00 : Updated ev_id=20230307106841 col_name=launch code=None.
Progress update 2025-02-15 10:25:36.771151+00:00 : Updated ev_id=20230307106841 col_name=icing_actual_amt code=NONE.
Progress update 2025-02-15 10:25:36.787067+00:00 : Updated ev_id=20230307106841 col_name=icing_actual_type code=NA.
Progress update 2025-02-15 10:25:36.804075+00:00 : Updated ev_id=20230307106841 col_name=icing_forecast_amt code=NONE.
Progress update 2025-02-15 10:25:36.829583+00:00 : Updated ev_id=20230307106841 col_name=icing_forecast_type code=NA.
Progress update 2025-02-15 10:25:36.854585+00:00 : Updated ev_id=20230307106841 col_name=turb_fc_type code=NONE.
Progress update 2025-02-15 10:25:36.878584+00:00 : Updated ev_id=20230307106841 col_name=turb_severity code=NA.
Progress update 2025-02-15 10:25:36.896587+00:00 : Updated ev_id=20230307106841 col_name=turb_type code=NONE.
Progress update 2025-02-15 10:25:36.920682+00:00 : Updated ev_id=20230307106841 col_name=wx_brief_src code=NET.
Progress update 2025-02-15 10:25:36.945682+00:00 : Updated ev_id=20230413107053 col_name=launch code=Part.
Progress update 2025-02-15 10:25:36.970679+00:00 : Updated ev_id=20230413107053 col_name=spec_hand code=TDA.
Progress update 2025-02-15 10:25:36.987682+00:00 : Updated ev_id=20230413107053 col_name=icing_actual_amt code=NONE.
Progress update 2025-02-15 10:25:37.003686+00:00 : Updated ev_id=20230413107053 col_name=icing_actual_type code=NA.
Progress update 2025-02-15 10:25:37.021089+00:00 : Updated ev_id=20230413107053 col_name=icing_forecast_amt code=NONE.
Progress update 2025-02-15 10:25:37.053995+00:00 : Updated ev_id=20230413107053 col_name=icing_forecast_type code=NA.
Progress update 2025-02-15 10:25:37.070993+00:00 : Updated ev_id=20230413107053 col_name=turb_fc_type code=NONE.
Progress update 2025-02-15 10:25:37.086998+00:00 : Updated ev_id=20230413107053 col_name=turb_severity code=NA.
Progress update 2025-02-15 10:25:37.114520+00:00 : Updated ev_id=20230413107053 col_name=turb_type code=NONE.
Progress update 2025-02-15 10:25:37.137518+00:00 : Updated ev_id=20230413107053 col_name=wx_brief_src0 code=UNK.
Progress update 2025-02-15 10:25:37.162518+00:00 : Updated ev_id=20230419107087 col_name=launch code=None.
Progress update 2025-02-15 10:25:37.337065+00:00 : Updated ev_id=20230419107087 col_name=wx_brief_src0 code=UNK.
Progress update 2025-02-15 10:25:37.370067+00:00 : Updated ev_id=20230424107114 col_name=launch code=Part.
Progress update 2025-02-15 10:25:37.387066+00:00 : Updated ev_id=20230424107114 col_name=icing_actual_amt code=NONE.
Progress update 2025-02-15 10:25:37.412071+00:00 : Updated ev_id=20230424107114 col_name=icing_actual_type code=NA.
Progress update 2025-02-15 10:25:37.437582+00:00 : Updated ev_id=20230424107114 col_name=icing_forecast_amt code=NONE.
Progress update 2025-02-15 10:25:37.453586+00:00 : Updated ev_id=20230424107114 col_name=icing_forecast_type code=NA.
Progress update 2025-02-15 10:25:37.470584+00:00 : Updated ev_id=20230424107114 col_name=turb_fc_type code=NONE.
Progress update 2025-02-15 10:25:37.486582+00:00 : Updated ev_id=20230424107114 col_name=turb_severity code=NA.
Progress update 2025-02-15 10:25:37.503585+00:00 : Updated ev_id=20230424107114 col_name=turb_type code=NONE.
Progress update 2025-02-15 10:25:37.545610+00:00 : Updated ev_id=20230807192813 col_name=launch code=None.
Progress update 2025-02-15 10:25:37.561611+00:00 : Updated ev_id=20230807192813 col_name=icing_actual_amt code=NONE.
Progress update 2025-02-15 10:25:37.578610+00:00 : Updated ev_id=20230807192813 col_name=icing_actual_type code=NA.
Progress update 2025-02-15 10:25:37.595611+00:00 : Updated ev_id=20230807192813 col_name=icing_forecast_amt code=NONE.
Progress update 2025-02-15 10:25:37.637132+00:00 : Updated ev_id=20230807192813 col_name=icing_forecast_type code=NA.
Progress update 2025-02-15 10:25:37.695134+00:00 : Updated ev_id=20230807192813 col_name=turb_fc_type code=NONE.
Progress update 2025-02-15 10:25:37.745653+00:00 : Updated ev_id=20230807192813 col_name=turb_severity code=NA.
Progress update 2025-02-15 10:25:37.761657+00:00 : Updated ev_id=20230807192813 col_name=turb_type code=NONE.
Progress update 2025-02-15 10:25:37.812660+00:00 : Updated ev_id=20240112193642 col_name=launch code=None.
Progress update 2025-02-15 10:25:37.828702+00:00 : Updated ev_id=20240112193642 col_name=icing_forecast_type code=NA.
Progress update 2025-02-15 10:25:37.845702+00:00 : Updated ev_id=20240112193642 col_name=wx_brief_src code=NET.
Progress update 2025-02-15 10:25:37.870706+00:00 : Updated ev_id=20240624194536 col_name=launch code=None.
Progress update 2025-02-15 10:25:37.895702+00:00 : Updated ev_id=20240624194536 col_name=spec_hand code=TDA.
Progress update 2025-02-15 10:25:37.928894+00:00 : Updated ev_id=20250122199577 col_name=launch code=None.
Progress update 2025-02-15 10:25:38.137591+00:00 : Number rows selected : 365.
Progress update 2025-02-15 10:25:38.137591+00:00 : Number rows inserted : 200.
Progress update 2025-02-15 10:25:38.137591+00:00 : Number rows updated : 165.
Progress update 2025-02-15 10:25:38.137591+00:00 :
Progress update 2025-02-15 10:25:38.138589+00:00 : Database table : ntsb_admin <-----------------------------------.
Progress update 2025-02-15 10:25:38.220110+00:00 : Updated ev_id=20250128199610.
Progress update 2025-02-15 10:25:38.270109+00:00 : Updated ev_id=20240812194896.
Progress update 2025-02-15 10:25:38.287111+00:00 : Updated ev_id=20250204199647.
Progress update 2025-02-15 10:25:38.356153+00:00 : Updated ev_id=20240108193625.
Progress update 2025-02-15 10:25:38.370154+00:00 : Updated ev_id=20240213193792.
Progress update 2025-02-15 10:25:38.387156+00:00 : Updated ev_id=20240610194434.
Progress update 2025-02-15 10:25:38.420208+00:00 : Updated ev_id=20240612194456.
Progress update 2025-02-15 10:25:38.437209+00:00 : Updated ev_id=20240618194495.
Progress update 2025-02-15 10:25:38.453210+00:00 : Updated ev_id=20240903195046.
Progress update 2025-02-15 10:25:38.470209+00:00 : Updated ev_id=20240910195095.
Progress update 2025-02-15 10:25:38.537199+00:00 : Updated ev_id=20250102199500.
Progress update 2025-02-15 10:25:38.604204+00:00 : Updated ev_id=20240826195000.
Progress update 2025-02-15 10:25:38.619715+00:00 : Updated ev_id=20250116199555.
Progress update 2025-02-15 10:25:38.636715+00:00 : Updated ev_id=20250126199597.
Progress update 2025-02-15 10:25:38.754232+00:00 : Updated ev_id=20240604194378.
Progress update 2025-02-15 10:25:38.778231+00:00 : Updated ev_id=20240606194409.
Progress update 2025-02-15 10:25:38.795239+00:00 : Updated ev_id=20240612194455.
Progress update 2025-02-15 10:25:38.812365+00:00 : Updated ev_id=20240618194493.
Progress update 2025-02-15 10:25:38.844876+00:00 : Updated ev_id=20240624194535.
Progress update 2025-02-15 10:25:38.861877+00:00 : Updated ev_id=20240624194539.
Progress update 2025-02-15 10:25:38.877876+00:00 : Updated ev_id=20240624194540.
Progress update 2025-02-15 10:25:38.895877+00:00 : Updated ev_id=20240624194541.
Progress update 2025-02-15 10:25:38.911884+00:00 : Updated ev_id=20240625194548.
Progress update 2025-02-15 10:25:38.928397+00:00 : Updated ev_id=20240701194592.
Progress update 2025-02-15 10:25:38.944398+00:00 : Updated ev_id=20240701194595.
Progress update 2025-02-15 10:25:38.978398+00:00 : Updated ev_id=20240701194596.
Progress update 2025-02-15 10:25:39.019911+00:00 : Updated ev_id=20240702194598.
Progress update 2025-02-15 10:25:39.081253+00:00 : Updated ev_id=20240702194599.
Progress update 2025-02-15 10:25:39.136463+00:00 : Updated ev_id=20240703194611.
Progress update 2025-02-15 10:25:39.153463+00:00 : Updated ev_id=20240708194645.
Progress update 2025-02-15 10:25:39.169465+00:00 : Updated ev_id=20241120195518.
Progress update 2025-02-15 10:25:39.186467+00:00 : Updated ev_id=20240715194697.
Progress update 2025-02-15 10:25:39.219614+00:00 : Updated ev_id=20250116199556.
Progress update 2025-02-15 10:25:39.252615+00:00 : Updated ev_id=20240510194238.
Progress update 2025-02-15 10:25:39.269617+00:00 : Updated ev_id=20241125195545.
Progress update 2025-02-15 10:25:39.444764+00:00 : Updated ev_id=20230117106588.
Progress update 2025-02-15 10:25:39.469762+00:00 : Updated ev_id=20230130106646.
Progress update 2025-02-15 10:25:39.486763+00:00 : Updated ev_id=20230222106756.
Progress update 2025-02-15 10:25:39.511283+00:00 : Updated ev_id=20230307106841.
Progress update 2025-02-15 10:25:39.527797+00:00 : Updated ev_id=20230413107053.
Progress update 2025-02-15 10:25:39.552799+00:00 : Updated ev_id=20230419107087.
Progress update 2025-02-15 10:25:39.569798+00:00 : Updated ev_id=20230424107114.
Progress update 2025-02-15 10:25:39.594799+00:00 : Updated ev_id=20230807192813.
Progress update 2025-02-15 10:25:39.620309+00:00 : Updated ev_id=20240112193642.
Progress update 2025-02-15 10:25:39.644309+00:00 : Updated ev_id=20240624194536.
Progress update 2025-02-15 10:25:39.661310+00:00 : Updated ev_id=20250122199577.
Progress update 2025-02-15 10:25:39.744824+00:00 : Number rows selected : 75.
Progress update 2025-02-15 10:25:39.744824+00:00 : Number rows inserted : 29.
Progress update 2025-02-15 10:25:39.744824+00:00 : Number rows updated : 46.
Progress update 2025-02-15 10:25:39.745824+00:00 :
Progress update 2025-02-15 10:25:39.745824+00:00 : Database table : dt_aircraft <-----------------------------------.
Progress update 2025-02-15 10:25:39.836067+00:00 : Updated ev_id=20250128199610 aircraft_key=1 col_name=addtl_equip0 code=UNK.
Progress update 2025-02-15 10:25:40.011164+00:00 : Updated ev_id=20250128199610 aircraft_key=2 col_name=addtl_equip0 code=UNK.
Progress update 2025-02-15 10:25:40.202370+00:00 : Updated ev_id=20240812194896 aircraft_key=1 col_name=acft_awy_cert code=SPR.
Progress update 2025-02-15 10:25:40.219935+00:00 : Updated ev_id=20240812194896 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-02-15 10:25:40.244975+00:00 : Updated ev_id=20240812194896 aircraft_key=1 col_name=aircar_cert code=AGR.
Progress update 2025-02-15 10:25:40.261564+00:00 : Updated ev_id=20240812194896 aircraft_key=1 col_name=airspc_type code=CLG.
Progress update 2025-02-15 10:25:40.286323+00:00 : Updated ev_id=20240812194896 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-15 10:25:40.311434+00:00 : Updated ev_id=20240812194896 aircraft_key=1 col_name=landing_gear1 code=TAIL.
Progress update 2025-02-15 10:25:40.336515+00:00 : Updated ev_id=20240812194896 aircraft_key=1 col_name=rwy_cond1 code=VEGE.
Progress update 2025-02-15 10:25:40.411536+00:00 : Updated ev_id=20240812194896 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-15 10:25:40.456229+00:00 : Updated ev_id=20240812194896 aircraft_key=1 col_name=vfr_appr code=FLND.
Progress update 2025-02-15 10:25:41.011205+00:00 : Updated ev_id=20240108193625 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:41.353057+00:00 : Updated ev_id=20240213193792 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:41.813486+00:00 : Updated ev_id=20240610194434 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:41.868998+00:00 : Updated ev_id=20240610194434 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-15 10:25:41.903003+00:00 : Updated ev_id=20240610194434 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-02-15 10:25:41.927516+00:00 : Updated ev_id=20240610194434 aircraft_key=1 col_name=landing_surf code=ASPH.
Progress update 2025-02-15 10:25:41.960517+00:00 : Updated ev_id=20240610194434 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-02-15 10:25:41.985520+00:00 : Updated ev_id=20240610194434 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-15 10:25:42.036044+00:00 : Updated ev_id=20240612194456 aircraft_key=1 col_name=acft_awy_cert code=SPE.
Progress update 2025-02-15 10:25:42.064527+00:00 : Updated ev_id=20240612194456 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-02-15 10:25:42.093652+00:00 : Updated ev_id=20240612194456 aircraft_key=1 col_name=addtl_equip code=EMFD.
Progress update 2025-02-15 10:25:42.119167+00:00 : Updated ev_id=20240612194456 aircraft_key=1 col_name=addtl_equip code=EPFD.
Progress update 2025-02-15 10:25:42.152166+00:00 : Updated ev_id=20240612194456 aircraft_key=1 col_name=addtl_equip code=STWS.
Progress update 2025-02-15 10:25:42.169172+00:00 : Updated ev_id=20240612194456 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:42.210930+00:00 : Updated ev_id=20240612194456 aircraft_key=1 col_name=airspc_type code=CLG.
Progress update 2025-02-15 10:25:42.235251+00:00 : Updated ev_id=20240612194456 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-15 10:25:42.264523+00:00 : Updated ev_id=20240612194456 aircraft_key=1 col_name=landing_gear1 code=TAIL.
Progress update 2025-02-15 10:25:42.285525+00:00 : Updated ev_id=20240612194456 aircraft_key=1 col_name=landing_surf code=GRAV.
Progress update 2025-02-15 10:25:42.302527+00:00 : Updated ev_id=20240612194456 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-02-15 10:25:42.356037+00:00 : Updated ev_id=20240612194456 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-15 10:25:42.386037+00:00 : Updated ev_id=20240612194456 aircraft_key=1 col_name=vfr_appr code=TPAT.
Progress update 2025-02-15 10:25:42.451905+00:00 : Updated ev_id=20240618194495 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-02-15 10:25:42.480511+00:00 : Updated ev_id=20240618194495 aircraft_key=1 col_name=addtl_equip code=EMFD.
Progress update 2025-02-15 10:25:42.510023+00:00 : Updated ev_id=20240618194495 aircraft_key=1 col_name=addtl_equip code=STWS.
Progress update 2025-02-15 10:25:42.544071+00:00 : Updated ev_id=20240618194495 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:42.569071+00:00 : Updated ev_id=20240618194495 aircraft_key=1 col_name=airspc_type code=CLD.
Progress update 2025-02-15 10:25:42.635248+00:00 : Updated ev_id=20240618194495 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-15 10:25:42.669246+00:00 : Updated ev_id=20240618194495 aircraft_key=1 col_name=landing_gear1 code=TAIL.
Progress update 2025-02-15 10:25:42.694246+00:00 : Updated ev_id=20240618194495 aircraft_key=1 col_name=landing_surf code=ASPH.
Progress update 2025-02-15 10:25:42.722385+00:00 : Updated ev_id=20240618194495 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-02-15 10:25:42.747385+00:00 : Updated ev_id=20240618194495 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-15 10:25:42.777667+00:00 : Updated ev_id=20240618194495 aircraft_key=1 col_name=vfr_appr0 code=NONE.
Progress update 2025-02-15 10:25:42.872872+00:00 : Updated ev_id=20240903195046 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:43.172774+00:00 : Updated ev_id=20240910195095 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:43.485483+00:00 : Updated ev_id=20250102199500 aircraft_key=1 col_name=addtl_equip code=AUTO.
Progress update 2025-02-15 10:25:43.509991+00:00 : Updated ev_id=20250102199500 aircraft_key=1 col_name=addtl_equip code=DREC.
Progress update 2025-02-15 10:25:43.543504+00:00 : Updated ev_id=20250102199500 aircraft_key=1 col_name=addtl_equip code=EFB.
Progress update 2025-02-15 10:25:43.576503+00:00 : Updated ev_id=20250102199500 aircraft_key=1 col_name=addtl_equip code=STWS.
Progress update 2025-02-15 10:25:43.660017+00:00 : Updated ev_id=20250102199500 aircraft_key=1 col_name=elt_oper_no_reason code=UNK.
Progress update 2025-02-15 10:25:45.084685+00:00 : Updated ev_id=20240604194378 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:45.143735+00:00 : Updated ev_id=20240604194378 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-15 10:25:45.230913+00:00 : Updated ev_id=20240604194378 aircraft_key=1 col_name=rwy_cond1 code=ROUG.
Progress update 2025-02-15 10:25:45.275911+00:00 : Updated ev_id=20240604194378 aircraft_key=1 col_name=vfr_appr code=FLND.
Progress update 2025-02-15 10:25:45.392484+00:00 : Updated ev_id=20240606194409 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:45.676048+00:00 : Updated ev_id=20240612194455 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-02-15 10:25:45.701048+00:00 : Updated ev_id=20240612194455 aircraft_key=1 col_name=addtl_equip0 code=NONE.
Progress update 2025-02-15 10:25:45.734562+00:00 : Updated ev_id=20240612194455 aircraft_key=1 col_name=aircar_cert code=141.
Progress update 2025-02-15 10:25:45.768177+00:00 : Updated ev_id=20240612194455 aircraft_key=1 col_name=airspc_type code=CLD.
Progress update 2025-02-15 10:25:45.801860+00:00 : Updated ev_id=20240612194455 aircraft_key=1 col_name=elt_oper_no_reason code=UNK.
Progress update 2025-02-15 10:25:46.081974+00:00 : Updated ev_id=20240612194455 aircraft_key=1 col_name=type_clear code=VFR.
Progress update 2025-02-15 10:25:46.201490+00:00 : Updated ev_id=20240618194493 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:46.230880+00:00 : Updated ev_id=20240618194493 aircraft_key=1 col_name=airspc_type code=CLG.
Progress update 2025-02-15 10:25:46.259876+00:00 : Updated ev_id=20240618194493 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-15 10:25:46.334662+00:00 : Updated ev_id=20240618194493 aircraft_key=1 col_name=landing_surf code=ASPH.
Progress update 2025-02-15 10:25:46.367660+00:00 : Updated ev_id=20240618194493 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-02-15 10:25:46.401662+00:00 : Updated ev_id=20240618194493 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-15 10:25:46.426074+00:00 : Updated ev_id=20240618194493 aircraft_key=1 col_name=vfr_appr code=FSTP.
Progress update 2025-02-15 10:25:46.642904+00:00 : Updated ev_id=20240624194535 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:46.793352+00:00 : Updated ev_id=20240624194535 aircraft_key=1 col_name=landing_surf code=ASPH.
Progress update 2025-02-15 10:25:47.017398+00:00 : Updated ev_id=20240624194539 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:47.101432+00:00 : Updated ev_id=20240624194539 aircraft_key=1 col_name=landing_gear1 code=TAIL.
Progress update 2025-02-15 10:25:47.355559+00:00 : Updated ev_id=20240624194540 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:47.442911+00:00 : Updated ev_id=20240624194540 aircraft_key=1 col_name=landing_gear1 code=TAIL.
Progress update 2025-02-15 10:25:47.471911+00:00 : Updated ev_id=20240624194540 aircraft_key=1 col_name=landing_surf code=DIRT.
Progress update 2025-02-15 10:25:47.500916+00:00 : Updated ev_id=20240624194540 aircraft_key=1 col_name=landing_surf code=GRAS.
Progress update 2025-02-15 10:25:47.742118+00:00 : Updated ev_id=20240624194541 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-02-15 10:25:47.776119+00:00 : Updated ev_id=20240624194541 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-02-15 10:25:47.834458+00:00 : Updated ev_id=20240624194541 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:47.867464+00:00 : Updated ev_id=20240624194541 aircraft_key=1 col_name=airspc_type code=CLG.
Progress update 2025-02-15 10:25:47.900599+00:00 : Updated ev_id=20240624194541 aircraft_key=1 col_name=elt_oper_no_reason code=UNK.
Progress update 2025-02-15 10:25:47.941835+00:00 : Updated ev_id=20240624194541 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-15 10:25:47.975835+00:00 : Updated ev_id=20240624194541 aircraft_key=1 col_name=landing_gear1 code=TAIL.
Progress update 2025-02-15 10:25:48.004835+00:00 : Updated ev_id=20240624194541 aircraft_key=1 col_name=landing_surf code=DIRT.
Progress update 2025-02-15 10:25:48.033968+00:00 : Updated ev_id=20240624194541 aircraft_key=1 col_name=landing_surf code=GRAS.
Progress update 2025-02-15 10:25:48.058969+00:00 : Updated ev_id=20240624194541 aircraft_key=1 col_name=landing_surf code=GRAV.
Progress update 2025-02-15 10:25:48.083968+00:00 : Updated ev_id=20240624194541 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-02-15 10:25:48.117633+00:00 : Updated ev_id=20240624194541 aircraft_key=1 col_name=rwy_cond1 code=HOLE.
Progress update 2025-02-15 10:25:48.142227+00:00 : Updated ev_id=20240624194541 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-15 10:25:48.175232+00:00 : Updated ev_id=20240624194541 aircraft_key=1 col_name=vfr_appr0 code=NONE.
Progress update 2025-02-15 10:25:48.205234+00:00 : Updated ev_id=20240625194548 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-02-15 10:25:48.234587+00:00 : Updated ev_id=20240625194548 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-02-15 10:25:48.263586+00:00 : Updated ev_id=20240625194548 aircraft_key=1 col_name=addtl_equip code=AOAI.
Progress update 2025-02-15 10:25:48.292590+00:00 : Updated ev_id=20240625194548 aircraft_key=1 col_name=addtl_equip code=AUTO.
Progress update 2025-02-15 10:25:48.326074+00:00 : Updated ev_id=20240625194548 aircraft_key=1 col_name=addtl_equip code=EFB.
Progress update 2025-02-15 10:25:48.401074+00:00 : Updated ev_id=20240625194548 aircraft_key=1 col_name=addtl_equip code=SATD.
Progress update 2025-02-15 10:25:48.434585+00:00 : Updated ev_id=20240625194548 aircraft_key=1 col_name=addtl_equip code=STWS.
Progress update 2025-02-15 10:25:48.480027+00:00 : Updated ev_id=20240625194548 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:48.501032+00:00 : Updated ev_id=20240625194548 aircraft_key=1 col_name=elt_oper_no_reason code=UNK.
Progress update 2025-02-15 10:25:48.525736+00:00 : Updated ev_id=20240625194548 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-15 10:25:48.573737+00:00 : Updated ev_id=20240625194548 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-02-15 10:25:48.629252+00:00 : Updated ev_id=20240625194548 aircraft_key=1 col_name=landing_surf code=ASPH.
Progress update 2025-02-15 10:25:48.667254+00:00 : Updated ev_id=20240625194548 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-02-15 10:25:48.726026+00:00 : Updated ev_id=20240625194548 aircraft_key=1 col_name=type_clear code=VFR.
Progress update 2025-02-15 10:25:48.775026+00:00 : Updated ev_id=20240625194548 aircraft_key=1 col_name=vfr_appr code=STIN.
Progress update 2025-02-15 10:25:48.975228+00:00 : Updated ev_id=20240701194592 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:49.317145+00:00 : Updated ev_id=20240701194595 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:49.892770+00:00 : Updated ev_id=20240701194596 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:49.958822+00:00 : Updated ev_id=20240701194596 aircraft_key=1 col_name=airspc_type code=CLE.
Progress update 2025-02-15 10:25:50.033341+00:00 : Updated ev_id=20240701194596 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-15 10:25:50.108348+00:00 : Updated ev_id=20240701194596 aircraft_key=1 col_name=landing_surf code=ASPH.
Progress update 2025-02-15 10:25:50.137859+00:00 : Updated ev_id=20240701194596 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-02-15 10:25:50.166848+00:00 : Updated ev_id=20240701194596 aircraft_key=1 col_name=type_clear code=VFR.
Progress update 2025-02-15 10:25:50.196678+00:00 : Updated ev_id=20240701194596 aircraft_key=1 col_name=vfr_appr code=FSTP.
Progress update 2025-02-15 10:25:50.225062+00:00 : Updated ev_id=20240701194596 aircraft_key=1 col_name=vfr_appr code=TPAT.
Progress update 2025-02-15 10:25:50.366756+00:00 : Updated ev_id=20240702194598 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:50.624199+00:00 : Updated ev_id=20240702194599 aircraft_key=1 col_name=acft_awy_cert code=STB.
Progress update 2025-02-15 10:25:50.650198+00:00 : Updated ev_id=20240702194599 aircraft_key=1 col_name=addtl_equip code=HGPS.
Progress update 2025-02-15 10:25:50.683199+00:00 : Updated ev_id=20240702194599 aircraft_key=1 col_name=aircar_cert code=136.
Progress update 2025-02-15 10:25:50.708204+00:00 : Updated ev_id=20240702194599 aircraft_key=1 col_name=airspc_type code=CLG.
Progress update 2025-02-15 10:25:50.799889+00:00 : Updated ev_id=20240702194599 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-15 10:25:50.916081+00:00 : Updated ev_id=20240703194611 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:51.008105+00:00 : Updated ev_id=20240703194611 aircraft_key=1 col_name=landing_gear1 code=TAIL.
Progress update 2025-02-15 10:25:51.100175+00:00 : Updated ev_id=20240708194645 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-02-15 10:25:51.133667+00:00 : Updated ev_id=20240708194645 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-02-15 10:25:51.162671+00:00 : Updated ev_id=20240708194645 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:51.191284+00:00 : Updated ev_id=20240708194645 aircraft_key=1 col_name=airspc_type code=CLE.
Progress update 2025-02-15 10:25:51.216288+00:00 : Updated ev_id=20240708194645 aircraft_key=1 col_name=elt_oper_no_reason code=UNK.
Progress update 2025-02-15 10:25:51.249467+00:00 : Updated ev_id=20240708194645 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-15 10:25:51.301469+00:00 : Updated ev_id=20240708194645 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-02-15 10:25:51.346615+00:00 : Updated ev_id=20240708194645 aircraft_key=1 col_name=landing_surf code=ASPH.
Progress update 2025-02-15 10:25:51.383615+00:00 : Updated ev_id=20240708194645 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-02-15 10:25:51.438243+00:00 : Updated ev_id=20240708194645 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-15 10:25:51.458244+00:00 : Updated ev_id=20240708194645 aircraft_key=1 col_name=vfr_appr code=FSTP.
Progress update 2025-02-15 10:25:51.491244+00:00 : Updated ev_id=20240708194645 aircraft_key=1 col_name=vfr_appr code=TPAT.
Progress update 2025-02-15 10:25:51.674783+00:00 : Updated ev_id=20240715194697 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:52.132598+00:00 : Updated ev_id=20250116199556 aircraft_key=1 col_name=acft_awy_cert code=SPE.
Progress update 2025-02-15 10:25:52.183105+00:00 : Updated ev_id=20250116199556 aircraft_key=1 col_name=addtl_equip code=EPFD.
Progress update 2025-02-15 10:25:52.215857+00:00 : Updated ev_id=20250116199556 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:52.241752+00:00 : Updated ev_id=20250116199556 aircraft_key=1 col_name=airspc_type code=CLG.
Progress update 2025-02-15 10:25:52.274663+00:00 : Updated ev_id=20250116199556 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-15 10:25:52.307664+00:00 : Updated ev_id=20250116199556 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-02-15 10:25:52.329178+00:00 : Updated ev_id=20250116199556 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-02-15 10:25:52.349178+00:00 : Updated ev_id=20250116199556 aircraft_key=1 col_name=rwy_cond1 code=VEGE.
Progress update 2025-02-15 10:25:52.383179+00:00 : Updated ev_id=20250116199556 aircraft_key=1 col_name=type_clear code=VFR.
Progress update 2025-02-15 10:25:52.416183+00:00 : Updated ev_id=20250116199556 aircraft_key=1 col_name=vfr_appr code=FLND.
Progress update 2025-02-15 10:25:53.674036+00:00 : Updated ev_id=20230117106588 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-02-15 10:25:53.696038+00:00 : Updated ev_id=20230117106588 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-02-15 10:25:53.724041+00:00 : Updated ev_id=20230117106588 aircraft_key=1 col_name=addtl_equip code=AUTO.
Progress update 2025-02-15 10:25:53.757235+00:00 : Updated ev_id=20230117106588 aircraft_key=1 col_name=addtl_equip code=EMFD.
Progress update 2025-02-15 10:25:53.782236+00:00 : Updated ev_id=20230117106588 aircraft_key=1 col_name=addtl_equip code=EPFD.
Progress update 2025-02-15 10:25:53.840680+00:00 : Updated ev_id=20230117106588 aircraft_key=1 col_name=addtl_equip code=STWS.
Progress update 2025-02-15 10:25:53.873680+00:00 : Updated ev_id=20230117106588 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:53.898680+00:00 : Updated ev_id=20230117106588 aircraft_key=1 col_name=airspc_type code=CLG.
Progress update 2025-02-15 10:25:53.932191+00:00 : Updated ev_id=20230117106588 aircraft_key=1 col_name=instm_appr code=GPS.
Progress update 2025-02-15 10:25:53.965191+00:00 : Updated ev_id=20230117106588 aircraft_key=1 col_name=instm_appr code=RNAV.
Progress update 2025-02-15 10:25:54.024196+00:00 : Updated ev_id=20230117106588 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-02-15 10:25:54.132394+00:00 : Updated ev_id=20230117106588 aircraft_key=1 col_name=rwy_cond1 code=VEGE.
Progress update 2025-02-15 10:25:54.207136+00:00 : Updated ev_id=20230117106588 aircraft_key=1 col_name=type_clear code=IFR.
Progress update 2025-02-15 10:25:54.307196+00:00 : Updated ev_id=20230130106646 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-02-15 10:25:54.332710+00:00 : Updated ev_id=20230130106646 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-02-15 10:25:54.353710+00:00 : Updated ev_id=20230130106646 aircraft_key=1 col_name=addtl_equip code=AOAI.
Progress update 2025-02-15 10:25:54.382714+00:00 : Updated ev_id=20230130106646 aircraft_key=1 col_name=addtl_equip code=AUTO.
Progress update 2025-02-15 10:25:54.407713+00:00 : Updated ev_id=20230130106646 aircraft_key=1 col_name=addtl_equip code=EPFD.
Progress update 2025-02-15 10:25:54.440736+00:00 : Updated ev_id=20230130106646 aircraft_key=1 col_name=addtl_equip code=HGPS.
Progress update 2025-02-15 10:25:54.490542+00:00 : Updated ev_id=20230130106646 aircraft_key=1 col_name=addtl_equip code=OBWX.
Progress update 2025-02-15 10:25:54.524558+00:00 : Updated ev_id=20230130106646 aircraft_key=1 col_name=addtl_equip code=STWS.
Progress update 2025-02-15 10:25:54.557564+00:00 : Updated ev_id=20230130106646 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:54.582564+00:00 : Updated ev_id=20230130106646 aircraft_key=1 col_name=airspc_type code=CLE.
Progress update 2025-02-15 10:25:54.624571+00:00 : Updated ev_id=20230130106646 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-15 10:25:54.656649+00:00 : Updated ev_id=20230130106646 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-02-15 10:25:54.690650+00:00 : Updated ev_id=20230130106646 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-02-15 10:25:54.715654+00:00 : Updated ev_id=20230130106646 aircraft_key=1 col_name=type_clear code=VFR.
Progress update 2025-02-15 10:25:54.749077+00:00 : Updated ev_id=20230130106646 aircraft_key=1 col_name=vfr_appr code=FLND.
Progress update 2025-02-15 10:25:54.773282+00:00 : Updated ev_id=20230130106646 aircraft_key=1 col_name=vfr_appr code=TPAT.
Progress update 2025-02-15 10:25:54.799281+00:00 : Updated ev_id=20230222106756 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-02-15 10:25:54.832349+00:00 : Updated ev_id=20230222106756 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-02-15 10:25:54.857420+00:00 : Updated ev_id=20230222106756 aircraft_key=1 col_name=addtl_equip code=AUTO.
Progress update 2025-02-15 10:25:54.890421+00:00 : Updated ev_id=20230222106756 aircraft_key=1 col_name=addtl_equip code=EMFD.
Progress update 2025-02-15 10:25:54.912087+00:00 : Updated ev_id=20230222106756 aircraft_key=1 col_name=addtl_equip code=OBWX.
Progress update 2025-02-15 10:25:54.940601+00:00 : Updated ev_id=20230222106756 aircraft_key=1 col_name=addtl_equip code=STWS.
Progress update 2025-02-15 10:25:54.973601+00:00 : Updated ev_id=20230222106756 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:55.015607+00:00 : Updated ev_id=20230222106756 aircraft_key=1 col_name=airspc_type code=CLC.
Progress update 2025-02-15 10:25:55.040116+00:00 : Updated ev_id=20230222106756 aircraft_key=1 col_name=elt_oper_no_reason code=UNK.
Progress update 2025-02-15 10:25:55.082121+00:00 : Updated ev_id=20230222106756 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-15 10:25:55.107191+00:00 : Updated ev_id=20230222106756 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-02-15 10:25:55.140702+00:00 : Updated ev_id=20230222106756 aircraft_key=1 col_name=type_clear code=IFR.
Progress update 2025-02-15 10:25:55.173703+00:00 : Updated ev_id=20230222106756 aircraft_key=1 col_name=vfr_appr0 code=NONE.
Progress update 2025-02-15 10:25:55.206703+00:00 : Updated ev_id=20230307106841 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-02-15 10:25:55.232221+00:00 : Updated ev_id=20230307106841 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-02-15 10:25:55.265222+00:00 : Updated ev_id=20230307106841 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:55.299222+00:00 : Updated ev_id=20230307106841 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-15 10:25:55.323231+00:00 : Updated ev_id=20230307106841 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-02-15 10:25:55.357646+00:00 : Updated ev_id=20230307106841 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-02-15 10:25:55.440160+00:00 : Updated ev_id=20230307106841 aircraft_key=1 col_name=type_clear code=VFR.
Progress update 2025-02-15 10:25:55.490164+00:00 : Updated ev_id=20230307106841 aircraft_key=1 col_name=vfr_appr code=FLND.
Progress update 2025-02-15 10:25:55.528586+00:00 : Updated ev_id=20230413107053 aircraft_key=1 col_name=acft_awy_cert code=SPX.
Progress update 2025-02-15 10:25:55.556587+00:00 : Updated ev_id=20230413107053 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:55.590587+00:00 : Updated ev_id=20230413107053 aircraft_key=1 col_name=airspc_type code=CLE.
Progress update 2025-02-15 10:25:55.614592+00:00 : Updated ev_id=20230413107053 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-15 10:25:55.649106+00:00 : Updated ev_id=20230413107053 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-02-15 10:25:55.674106+00:00 : Updated ev_id=20230413107053 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-02-15 10:25:55.699106+00:00 : Updated ev_id=20230413107053 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-15 10:25:55.732316+00:00 : Updated ev_id=20230413107053 aircraft_key=1 col_name=vfr_appr0 code=NONE.
Progress update 2025-02-15 10:25:55.765648+00:00 : Updated ev_id=20230419107087 aircraft_key=1 col_name=acft_awy_cert code=SPX.
Progress update 2025-02-15 10:25:55.799088+00:00 : Updated ev_id=20230419107087 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-02-15 10:25:55.824094+00:00 : Updated ev_id=20230419107087 aircraft_key=1 col_name=addtl_equip code=EFB.
Progress update 2025-02-15 10:25:55.857201+00:00 : Updated ev_id=20230419107087 aircraft_key=1 col_name=addtl_equip code=EPFD.
Progress update 2025-02-15 10:25:55.890202+00:00 : Updated ev_id=20230419107087 aircraft_key=1 col_name=addtl_equip code=HGPS.
Progress update 2025-02-15 10:25:55.923717+00:00 : Updated ev_id=20230419107087 aircraft_key=1 col_name=addtl_equip code=SATD.
Progress update 2025-02-15 10:25:55.957227+00:00 : Updated ev_id=20230419107087 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:55.990226+00:00 : Updated ev_id=20230419107087 aircraft_key=1 col_name=airspc_type code=CLD.
Progress update 2025-02-15 10:25:56.023230+00:00 : Updated ev_id=20230419107087 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-15 10:25:56.048248+00:00 : Updated ev_id=20230419107087 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-02-15 10:25:56.082251+00:00 : Updated ev_id=20230419107087 aircraft_key=1 col_name=landing_surf code=ASPH.
Progress update 2025-02-15 10:25:56.107251+00:00 : Updated ev_id=20230419107087 aircraft_key=1 col_name=landing_surf code=CONC.
Progress update 2025-02-15 10:25:56.140781+00:00 : Updated ev_id=20230419107087 aircraft_key=1 col_name=landing_surf code=GRAV.
Progress update 2025-02-15 10:25:56.173783+00:00 : Updated ev_id=20230419107087 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-02-15 10:25:56.198782+00:00 : Updated ev_id=20230419107087 aircraft_key=1 col_name=type_clear code=VFR.
Progress update 2025-02-15 10:25:56.231297+00:00 : Updated ev_id=20230419107087 aircraft_key=1 col_name=vfr_appr0 code=NONE.
Progress update 2025-02-15 10:25:56.257298+00:00 : Updated ev_id=20230424107114 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-02-15 10:25:56.290302+00:00 : Updated ev_id=20230424107114 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-02-15 10:25:56.312303+00:00 : Updated ev_id=20230424107114 aircraft_key=1 col_name=addtl_equip code=AOAI.
Progress update 2025-02-15 10:25:56.339815+00:00 : Updated ev_id=20230424107114 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:56.365816+00:00 : Updated ev_id=20230424107114 aircraft_key=1 col_name=airspc_type code=CLE.
Progress update 2025-02-15 10:25:56.398817+00:00 : Updated ev_id=20230424107114 aircraft_key=1 col_name=elt_oper_no_reason code=UNK.
Progress update 2025-02-15 10:25:56.432333+00:00 : Updated ev_id=20230424107114 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-15 10:25:56.465334+00:00 : Updated ev_id=20230424107114 aircraft_key=1 col_name=landing_gear1 code=TAIL.
Progress update 2025-02-15 10:25:56.498337+00:00 : Updated ev_id=20230424107114 aircraft_key=1 col_name=rwy_cond1 code=VEGE.
Progress update 2025-02-15 10:25:56.531354+00:00 : Updated ev_id=20230424107114 aircraft_key=1 col_name=rwy_cond1 code=WET.
Progress update 2025-02-15 10:25:56.565354+00:00 : Updated ev_id=20230424107114 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-15 10:25:56.590355+00:00 : Updated ev_id=20230424107114 aircraft_key=1 col_name=vfr_appr code=PLND.
Progress update 2025-02-15 10:25:56.623358+00:00 : Updated ev_id=20230807192813 aircraft_key=1 col_name=acft_awy_cert code=SPE.
Progress update 2025-02-15 10:25:56.823044+00:00 : Updated ev_id=20230807192813 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:56.856557+00:00 : Updated ev_id=20230807192813 aircraft_key=1 col_name=airspc_type code=CLG.
Progress update 2025-02-15 10:25:56.914559+00:00 : Updated ev_id=20230807192813 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-15 10:25:56.947780+00:00 : Updated ev_id=20230807192813 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-02-15 10:25:57.056295+00:00 : Updated ev_id=20230807192813 aircraft_key=1 col_name=vfr_appr code=FLND.
Progress update 2025-02-15 10:25:57.089296+00:00 : Updated ev_id=20240112193642 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-02-15 10:25:57.124310+00:00 : Updated ev_id=20240112193642 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-02-15 10:25:57.156823+00:00 : Updated ev_id=20240112193642 aircraft_key=1 col_name=addtl_equip code=EMFD.
Progress update 2025-02-15 10:25:57.189824+00:00 : Updated ev_id=20240112193642 aircraft_key=1 col_name=addtl_equip code=EPFD.
Progress update 2025-02-15 10:25:57.214830+00:00 : Updated ev_id=20240112193642 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:57.247964+00:00 : Updated ev_id=20240112193642 aircraft_key=1 col_name=airspc_type code=CLE.
Progress update 2025-02-15 10:25:57.280964+00:00 : Updated ev_id=20240112193642 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-15 10:25:57.314967+00:00 : Updated ev_id=20240112193642 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-02-15 10:25:57.348080+00:00 : Updated ev_id=20240112193642 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-15 10:25:57.362079+00:00 : Updated ev_id=20240112193642 aircraft_key=1 col_name=vfr_appr code=FLND.
Progress update 2025-02-15 10:25:57.615268+00:00 : Updated ev_id=20240624194536 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-15 10:25:58.056279+00:00 : Number rows selected : 575.
Progress update 2025-02-15 10:25:58.056279+00:00 : Number rows inserted : 326.
Progress update 2025-02-15 10:25:58.056279+00:00 : Number rows updated : 249.
Progress update 2025-02-15 10:25:58.056279+00:00 :
Progress update 2025-02-15 10:25:58.056279+00:00 : Database table : engines <-----------------------------------.
Progress update 2025-02-15 10:25:59.280436+00:00 : Number rows selected : 38.
Progress update 2025-02-15 10:25:59.280436+00:00 : Number rows inserted : 38.
Progress update 2025-02-15 10:25:59.280436+00:00 :
Progress update 2025-02-15 10:25:59.281439+00:00 : Database table : events_sequence <-----------------------------------.
Progress update 2025-02-15 10:25:59.497947+00:00 : Updated ev_id=20250128199610 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:25:59.664495+00:00 : Updated ev_id=20240812194896 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:25:59.689502+00:00 : Updated ev_id=20250204199647 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:25:59.880395+00:00 : Updated ev_id=20240108193625 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:25:59.956079+00:00 : Updated ev_id=20240213193792 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:26:00.031117+00:00 : Updated ev_id=20240610194434 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:26:00.081116+00:00 : Updated ev_id=20240612194456 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:26:00.164263+00:00 : Updated ev_id=20240618194495 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:26:00.189386+00:00 : Updated ev_id=20240903195046 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:26:00.247215+00:00 : Updated ev_id=20240910195095 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:26:00.447762+00:00 : Updated ev_id=20250102199500 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:26:00.580600+00:00 : Updated ev_id=20250116199555 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:26:00.639113+00:00 : Updated ev_id=20250126199597 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:26:00.897092+00:00 : Updated ev_id=20240604194378 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:26:00.939132+00:00 : Updated ev_id=20240606194409 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:26:01.071748+00:00 : Updated ev_id=20240612194455 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:26:01.296927+00:00 : Updated ev_id=20240624194539 Aircraft_Key=1 Occurrence_No=2.
Progress update 2025-02-15 10:26:01.421757+00:00 : Updated ev_id=20240625194548 Aircraft_Key=1 Occurrence_No=3.
Progress update 2025-02-15 10:26:01.447057+00:00 : Updated ev_id=20240625194548 Aircraft_Key=1 Occurrence_No=4.
Progress update 2025-02-15 10:26:01.472326+00:00 : Updated ev_id=20240625194548 Aircraft_Key=1 Occurrence_No=2.
Progress update 2025-02-15 10:26:01.536473+00:00 : Updated ev_id=20240625194548 Aircraft_Key=1 Occurrence_No=5.
Progress update 2025-02-15 10:26:01.555321+00:00 : Updated ev_id=20240625194548 Aircraft_Key=1 Occurrence_No=6.
Progress update 2025-02-15 10:26:01.605325+00:00 : Updated ev_id=20240701194592 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:26:01.880281+00:00 : Updated ev_id=20240702194598 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:26:02.004795+00:00 : Updated ev_id=20240703194611 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:26:02.080342+00:00 : Updated ev_id=20240708194645 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:26:02.113450+00:00 : Updated ev_id=20241120195518 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:26:02.375423+00:00 : Updated ev_id=20250116199556 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:26:02.405301+00:00 : Updated ev_id=20250116199556 Aircraft_Key=1 Occurrence_No=2.
Progress update 2025-02-15 10:26:02.496333+00:00 : Updated ev_id=20240510194238 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:26:02.533300+00:00 : Updated ev_id=20241125195545 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:26:03.088664+00:00 : Updated ev_id=20230222106756 Aircraft_Key=1 Occurrence_No=2.
Progress update 2025-02-15 10:26:03.213521+00:00 : Updated ev_id=20230419107087 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:26:03.304218+00:00 : Updated ev_id=20230424107114 Aircraft_Key=1 Occurrence_No=2.
Progress update 2025-02-15 10:26:03.423216+00:00 : Updated ev_id=20230807192813 Aircraft_Key=1 Occurrence_No=2.
Progress update 2025-02-15 10:26:03.643482+00:00 : Updated ev_id=20240624194536 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:26:03.702964+00:00 : Updated ev_id=20250122199577 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-15 10:26:03.813841+00:00 : Number rows selected : 143.
Progress update 2025-02-15 10:26:03.813841+00:00 : Number rows inserted : 106.
Progress update 2025-02-15 10:26:03.813841+00:00 : Number rows updated : 37.
Progress update 2025-02-15 10:26:03.813841+00:00 :
Progress update 2025-02-15 10:26:03.814841+00:00 : Database table : findings <-----------------------------------.
Progress update 2025-02-15 10:26:06.645589+00:00 : Number rows selected : 100.
Progress update 2025-02-15 10:26:06.645589+00:00 : Number rows inserted : 100.
Progress update 2025-02-15 10:26:06.645589+00:00 :
Progress update 2025-02-15 10:26:06.645589+00:00 : Database table : flight_crew <-----------------------------------.
Progress update 2025-02-15 10:26:08.061946+00:00 : Number rows selected : 51.
Progress update 2025-02-15 10:26:08.061946+00:00 : Number rows inserted : 51.
Progress update 2025-02-15 10:26:08.061946+00:00 :
Progress update 2025-02-15 10:26:08.061946+00:00 : Database table : injury <-----------------------------------.
Progress update 2025-02-15 10:26:08.162124+00:00 : Updated ev_id=20250128199610 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-15 10:26:08.189080+00:00 : Updated ev_id=20250128199610 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:08.211986+00:00 : Updated ev_id=20250128199610 aircraft_key=2 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-15 10:26:08.228089+00:00 : Updated ev_id=20250128199610 aircraft_key=2 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:08.344487+00:00 : Updated ev_id=20240812194896 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-15 10:26:08.370227+00:00 : Updated ev_id=20240812194896 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:08.386124+00:00 : Updated ev_id=20240812194896 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-02-15 10:26:08.411508+00:00 : Updated ev_id=20240812194896 aircraft_key=1 inj_person_category=Pass injury_level=SERS.
Progress update 2025-02-15 10:26:08.439564+00:00 : Updated ev_id=20240812194896 aircraft_key=1 inj_person_category=Pass injury_level=MINR.
Progress update 2025-02-15 10:26:08.464569+00:00 : Updated ev_id=20240812194896 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-15 10:26:08.489571+00:00 : Updated ev_id=20240812194896 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-15 10:26:08.520084+00:00 : Updated ev_id=20250204199647 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-15 10:26:08.548573+00:00 : Updated ev_id=20250204199647 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:09.278053+00:00 : Updated ev_id=20240610194434 aircraft_key=1 inj_person_category=Cabi injury_level=FATL.
Progress update 2025-02-15 10:26:09.303646+00:00 : Updated ev_id=20240610194434 aircraft_key=1 inj_person_category=Cabi injury_level=SERS.
Progress update 2025-02-15 10:26:09.331703+00:00 : Updated ev_id=20240610194434 aircraft_key=1 inj_person_category=Cabi injury_level=MINR.
Progress update 2025-02-15 10:26:09.361605+00:00 : Updated ev_id=20240610194434 aircraft_key=1 inj_person_category=Cabi injury_level=NONE.
Progress update 2025-02-15 10:26:09.385816+00:00 : Updated ev_id=20240610194434 aircraft_key=1 inj_person_category=Cabi injury_level=TOTL.
Progress update 2025-02-15 10:26:09.415217+00:00 : Updated ev_id=20240610194434 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-02-15 10:26:09.445220+00:00 : Updated ev_id=20240610194434 aircraft_key=1 inj_person_category=Flig injury_level=SERS.
Progress update 2025-02-15 10:26:09.470221+00:00 : Updated ev_id=20240610194434 aircraft_key=1 inj_person_category=Flig injury_level=MINR.
Progress update 2025-02-15 10:26:09.486258+00:00 : Updated ev_id=20240610194434 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-15 10:26:09.515262+00:00 : Updated ev_id=20240610194434 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:09.544884+00:00 : Updated ev_id=20240610194434 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-02-15 10:26:09.561327+00:00 : Updated ev_id=20240610194434 aircraft_key=1 inj_person_category=Pass injury_level=SERS.
Progress update 2025-02-15 10:26:09.577478+00:00 : Updated ev_id=20240610194434 aircraft_key=1 inj_person_category=Pass injury_level=MINR.
Progress update 2025-02-15 10:26:09.603043+00:00 : Updated ev_id=20240610194434 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-15 10:26:09.620002+00:00 : Updated ev_id=20240610194434 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-15 10:26:09.645086+00:00 : Updated ev_id=20240612194456 aircraft_key=1 inj_person_category=Cabi injury_level=FATL.
Progress update 2025-02-15 10:26:09.670095+00:00 : Updated ev_id=20240612194456 aircraft_key=1 inj_person_category=Cabi injury_level=SERS.
Progress update 2025-02-15 10:26:09.698627+00:00 : Updated ev_id=20240612194456 aircraft_key=1 inj_person_category=Cabi injury_level=MINR.
Progress update 2025-02-15 10:26:09.728186+00:00 : Updated ev_id=20240612194456 aircraft_key=1 inj_person_category=Cabi injury_level=NONE.
Progress update 2025-02-15 10:26:09.761475+00:00 : Updated ev_id=20240612194456 aircraft_key=1 inj_person_category=Cabi injury_level=TOTL.
Progress update 2025-02-15 10:26:09.790082+00:00 : Updated ev_id=20240612194456 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-02-15 10:26:09.814461+00:00 : Updated ev_id=20240612194456 aircraft_key=1 inj_person_category=Flig injury_level=SERS.
Progress update 2025-02-15 10:26:09.839909+00:00 : Updated ev_id=20240612194456 aircraft_key=1 inj_person_category=Flig injury_level=MINR.
Progress update 2025-02-15 10:26:09.864286+00:00 : Updated ev_id=20240612194456 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-15 10:26:09.894329+00:00 : Updated ev_id=20240612194456 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:09.922372+00:00 : Updated ev_id=20240612194456 aircraft_key=1 inj_person_category=LapC injury_level=FATL.
Progress update 2025-02-15 10:26:09.952393+00:00 : Updated ev_id=20240612194456 aircraft_key=1 inj_person_category=LapC injury_level=SERS.
Progress update 2025-02-15 10:26:09.970394+00:00 : Updated ev_id=20240612194456 aircraft_key=1 inj_person_category=LapC injury_level=MINR.
Progress update 2025-02-15 10:26:10.003418+00:00 : Updated ev_id=20240612194456 aircraft_key=1 inj_person_category=LapC injury_level=NONE.
Progress update 2025-02-15 10:26:10.027766+00:00 : Updated ev_id=20240612194456 aircraft_key=1 inj_person_category=LapC injury_level=TOTL.
Progress update 2025-02-15 10:26:10.053275+00:00 : Updated ev_id=20240612194456 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-02-15 10:26:10.078399+00:00 : Updated ev_id=20240612194456 aircraft_key=1 inj_person_category=Pass injury_level=SERS.
Progress update 2025-02-15 10:26:10.111094+00:00 : Updated ev_id=20240612194456 aircraft_key=1 inj_person_category=Pass injury_level=MINR.
Progress update 2025-02-15 10:26:10.136605+00:00 : Updated ev_id=20240612194456 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-15 10:26:10.161752+00:00 : Updated ev_id=20240612194456 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-15 10:26:10.198330+00:00 : Updated ev_id=20240618194495 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-15 10:26:10.223396+00:00 : Updated ev_id=20240618194495 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:10.252827+00:00 : Updated ev_id=20240618194495 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-15 10:26:10.277261+00:00 : Updated ev_id=20240618194495 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-15 10:26:10.311255+00:00 : Updated ev_id=20240910195095 aircraft_key=1 inj_person_category=Flig injury_level=MINR.
Progress update 2025-02-15 10:26:10.344059+00:00 : Updated ev_id=20240910195095 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:10.586084+00:00 : Updated ev_id=20240910195095 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-02-15 10:26:10.610991+00:00 : Updated ev_id=20240910195095 aircraft_key=1 inj_person_category=Pass injury_level=SERS.
Progress update 2025-02-15 10:26:10.636039+00:00 : Updated ev_id=20240910195095 aircraft_key=1 inj_person_category=Pass injury_level=MINR.
Progress update 2025-02-15 10:26:10.665002+00:00 : Updated ev_id=20240910195095 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-15 10:26:10.689335+00:00 : Updated ev_id=20240910195095 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-15 10:26:10.919352+00:00 : Updated ev_id=20250102199500 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-15 10:26:10.952866+00:00 : Updated ev_id=20250102199500 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:10.969434+00:00 : Updated ev_id=20250102199500 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-15 10:26:10.998433+00:00 : Updated ev_id=20250102199500 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-15 10:26:11.128164+00:00 : Updated ev_id=20240826195000 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-15 10:26:11.161673+00:00 : Updated ev_id=20240826195000 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:11.473273+00:00 : Updated ev_id=20250116199555 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-15 10:26:11.541594+00:00 : Updated ev_id=20250116199555 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:11.851988+00:00 : Updated ev_id=20250116199555 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-15 10:26:11.877325+00:00 : Updated ev_id=20250116199555 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-15 10:26:12.135998+00:00 : Updated ev_id=20250126199597 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-15 10:26:12.169439+00:00 : Updated ev_id=20250126199597 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:13.381997+00:00 : Updated ev_id=20240604194378 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:13.443500+00:00 : Updated ev_id=20240604194378 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-15 10:26:13.476523+00:00 : Updated ev_id=20240606194409 aircraft_key=1 inj_person_category=Flig injury_level=SERS.
Progress update 2025-02-15 10:26:13.506125+00:00 : Updated ev_id=20240606194409 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:13.660251+00:00 : Updated ev_id=20240612194455 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-15 10:26:13.685003+00:00 : Updated ev_id=20240612194455 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:13.772346+00:00 : Updated ev_id=20240618194493 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-15 10:26:13.801682+00:00 : Updated ev_id=20240618194493 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:14.197569+00:00 : Updated ev_id=20240624194539 aircraft_key=1 inj_person_category=Flig injury_level=SERS.
Progress update 2025-02-15 10:26:14.226602+00:00 : Updated ev_id=20240624194539 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:14.351872+00:00 : Updated ev_id=20240624194540 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-15 10:26:14.376872+00:00 : Updated ev_id=20240624194540 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:14.498726+00:00 : Updated ev_id=20240624194541 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-15 10:26:14.549781+00:00 : Updated ev_id=20240624194541 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:14.584947+00:00 : Updated ev_id=20240624194541 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-15 10:26:14.609632+00:00 : Updated ev_id=20240624194541 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-15 10:26:14.635358+00:00 : Updated ev_id=20240625194548 aircraft_key=1 inj_person_category=Cabi injury_level=FATL.
Progress update 2025-02-15 10:26:14.668731+00:00 : Updated ev_id=20240625194548 aircraft_key=1 inj_person_category=Cabi injury_level=SERS.
Progress update 2025-02-15 10:26:14.727290+00:00 : Updated ev_id=20240625194548 aircraft_key=1 inj_person_category=Cabi injury_level=MINR.
Progress update 2025-02-15 10:26:14.759809+00:00 : Updated ev_id=20240625194548 aircraft_key=1 inj_person_category=Cabi injury_level=NONE.
Progress update 2025-02-15 10:26:14.794228+00:00 : Updated ev_id=20240625194548 aircraft_key=1 inj_person_category=Cabi injury_level=TOTL.
Progress update 2025-02-15 10:26:14.822491+00:00 : Updated ev_id=20240625194548 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-02-15 10:26:14.852139+00:00 : Updated ev_id=20240625194548 aircraft_key=1 inj_person_category=Flig injury_level=SERS.
Progress update 2025-02-15 10:26:14.884406+00:00 : Updated ev_id=20240625194548 aircraft_key=1 inj_person_category=Flig injury_level=MINR.
Progress update 2025-02-15 10:26:14.922621+00:00 : Updated ev_id=20240625194548 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-15 10:26:14.951135+00:00 : Updated ev_id=20240625194548 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:14.981135+00:00 : Updated ev_id=20240625194548 aircraft_key=1 inj_person_category=LapC injury_level=FATL.
Progress update 2025-02-15 10:26:15.002136+00:00 : Updated ev_id=20240625194548 aircraft_key=1 inj_person_category=LapC injury_level=SERS.
Progress update 2025-02-15 10:26:15.030968+00:00 : Updated ev_id=20240625194548 aircraft_key=1 inj_person_category=LapC injury_level=MINR.
Progress update 2025-02-15 10:26:15.059529+00:00 : Updated ev_id=20240625194548 aircraft_key=1 inj_person_category=LapC injury_level=NONE.
Progress update 2025-02-15 10:26:15.085537+00:00 : Updated ev_id=20240625194548 aircraft_key=1 inj_person_category=LapC injury_level=TOTL.
Progress update 2025-02-15 10:26:15.118063+00:00 : Updated ev_id=20240625194548 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-02-15 10:26:15.143572+00:00 : Updated ev_id=20240625194548 aircraft_key=1 inj_person_category=Pass injury_level=SERS.
Progress update 2025-02-15 10:26:15.176575+00:00 : Updated ev_id=20240625194548 aircraft_key=1 inj_person_category=Pass injury_level=MINR.
Progress update 2025-02-15 10:26:15.210574+00:00 : Updated ev_id=20240625194548 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-15 10:26:15.235578+00:00 : Updated ev_id=20240625194548 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-15 10:26:15.543002+00:00 : Updated ev_id=20240701194596 aircraft_key=1 inj_person_category=Cabi injury_level=FATL.
Progress update 2025-02-15 10:26:15.568004+00:00 : Updated ev_id=20240701194596 aircraft_key=1 inj_person_category=Cabi injury_level=SERS.
Progress update 2025-02-15 10:26:15.602003+00:00 : Updated ev_id=20240701194596 aircraft_key=1 inj_person_category=Cabi injury_level=MINR.
Progress update 2025-02-15 10:26:15.626007+00:00 : Updated ev_id=20240701194596 aircraft_key=1 inj_person_category=Cabi injury_level=NONE.
Progress update 2025-02-15 10:26:15.676522+00:00 : Updated ev_id=20240701194596 aircraft_key=1 inj_person_category=Cabi injury_level=TOTL.
Progress update 2025-02-15 10:26:15.709523+00:00 : Updated ev_id=20240701194596 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-02-15 10:26:15.743043+00:00 : Updated ev_id=20240701194596 aircraft_key=1 inj_person_category=Flig injury_level=SERS.
Progress update 2025-02-15 10:26:15.776335+00:00 : Updated ev_id=20240701194596 aircraft_key=1 inj_person_category=Flig injury_level=MINR.
Progress update 2025-02-15 10:26:15.810336+00:00 : Updated ev_id=20240701194596 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-15 10:26:15.859850+00:00 : Updated ev_id=20240701194596 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:15.901850+00:00 : Updated ev_id=20240701194596 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-02-15 10:26:15.930856+00:00 : Updated ev_id=20240701194596 aircraft_key=1 inj_person_category=Pass injury_level=SERS.
Progress update 2025-02-15 10:26:15.959367+00:00 : Updated ev_id=20240701194596 aircraft_key=1 inj_person_category=Pass injury_level=MINR.
Progress update 2025-02-15 10:26:15.984369+00:00 : Updated ev_id=20240701194596 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-15 10:26:16.018369+00:00 : Updated ev_id=20240701194596 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-15 10:26:16.168394+00:00 : Updated ev_id=20240702194599 aircraft_key=1 inj_person_category=Flig injury_level=SERS.
Progress update 2025-02-15 10:26:16.234406+00:00 : Updated ev_id=20240702194599 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:16.325757+00:00 : Updated ev_id=20240702194599 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-15 10:26:16.360270+00:00 : Updated ev_id=20240702194599 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-15 10:26:16.514052+00:00 : Updated ev_id=20240708194645 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-15 10:26:16.543091+00:00 : Updated ev_id=20240708194645 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:16.576090+00:00 : Updated ev_id=20240708194645 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-15 10:26:16.609428+00:00 : Updated ev_id=20240708194645 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-15 10:26:16.638169+00:00 : Updated ev_id=20241120195518 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-02-15 10:26:16.663679+00:00 : Updated ev_id=20241120195518 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-15 10:26:16.684323+00:00 : Updated ev_id=20241120195518 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:17.459618+00:00 : Updated ev_id=20250116199556 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-15 10:26:17.484638+00:00 : Updated ev_id=20250116199556 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:17.513643+00:00 : Updated ev_id=20250116199556 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-02-15 10:26:17.543352+00:00 : Updated ev_id=20250116199556 aircraft_key=1 inj_person_category=Pass injury_level=SERS.
Progress update 2025-02-15 10:26:17.567353+00:00 : Updated ev_id=20250116199556 aircraft_key=1 inj_person_category=Pass injury_level=MINR.
Progress update 2025-02-15 10:26:17.600631+00:00 : Updated ev_id=20250116199556 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-15 10:26:17.625701+00:00 : Updated ev_id=20250116199556 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-15 10:26:17.784496+00:00 : Updated ev_id=20240510194238 aircraft_key=1 inj_person_category=Cabi injury_level=NONE.
Progress update 2025-02-15 10:26:17.809024+00:00 : Updated ev_id=20240510194238 aircraft_key=1 inj_person_category=Cabi injury_level=TOTL.
Progress update 2025-02-15 10:26:17.843117+00:00 : Updated ev_id=20240510194238 aircraft_key=1 inj_person_category=Flig injury_level=SERS.
Progress update 2025-02-15 10:26:17.871977+00:00 : Updated ev_id=20240510194238 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-15 10:26:17.901021+00:00 : Updated ev_id=20240510194238 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:17.933497+00:00 : Updated ev_id=20240510194238 aircraft_key=1 inj_person_category=Pass injury_level=SERS.
Progress update 2025-02-15 10:26:17.959398+00:00 : Updated ev_id=20240510194238 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-15 10:26:17.983404+00:00 : Updated ev_id=20240510194238 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-15 10:26:18.017198+00:00 : Updated ev_id=20241125195545 aircraft_key=1 inj_person_category=Cabi injury_level=FATL.
Progress update 2025-02-15 10:26:18.042197+00:00 : Updated ev_id=20241125195545 aircraft_key=1 inj_person_category=Cabi injury_level=TOTL.
Progress update 2025-02-15 10:26:18.072065+00:00 : Updated ev_id=20241125195545 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-02-15 10:26:18.101049+00:00 : Updated ev_id=20241125195545 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:18.133902+00:00 : Updated ev_id=20241125195545 aircraft_key=1 inj_person_category=LapC injury_level=FATL.
Progress update 2025-02-15 10:26:18.166977+00:00 : Updated ev_id=20241125195545 aircraft_key=1 inj_person_category=LapC injury_level=TOTL.
Progress update 2025-02-15 10:26:18.201086+00:00 : Updated ev_id=20241125195545 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-02-15 10:26:18.224997+00:00 : Updated ev_id=20241125195545 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-15 10:26:20.217457+00:00 : Updated ev_id=20230117106588 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-02-15 10:26:20.242149+00:00 : Updated ev_id=20230117106588 aircraft_key=1 inj_person_category=Flig injury_level=SERS.
Progress update 2025-02-15 10:26:20.280371+00:00 : Updated ev_id=20230117106588 aircraft_key=1 inj_person_category=Flig injury_level=MINR.
Progress update 2025-02-15 10:26:20.308824+00:00 : Updated ev_id=20230117106588 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-15 10:26:20.341373+00:00 : Updated ev_id=20230117106588 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:20.524712+00:00 : Updated ev_id=20230117106588 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-02-15 10:26:20.549801+00:00 : Updated ev_id=20230117106588 aircraft_key=1 inj_person_category=Pass injury_level=SERS.
Progress update 2025-02-15 10:26:20.574954+00:00 : Updated ev_id=20230117106588 aircraft_key=1 inj_person_category=Pass injury_level=MINR.
Progress update 2025-02-15 10:26:20.604315+00:00 : Updated ev_id=20230117106588 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-15 10:26:20.632797+00:00 : Updated ev_id=20230117106588 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-15 10:26:20.666294+00:00 : Updated ev_id=20230130106646 aircraft_key=1 inj_person_category=Flig injury_level=MINR.
Progress update 2025-02-15 10:26:20.699470+00:00 : Updated ev_id=20230130106646 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:20.730088+00:00 : Updated ev_id=20230130106646 aircraft_key=1 inj_person_category=Pass injury_level=SERS.
Progress update 2025-02-15 10:26:20.757682+00:00 : Updated ev_id=20230130106646 aircraft_key=1 inj_person_category=Pass injury_level=MINR.
Progress update 2025-02-15 10:26:20.792246+00:00 : Updated ev_id=20230130106646 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-15 10:26:20.866764+00:00 : Updated ev_id=20230222106756 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-02-15 10:26:20.891764+00:00 : Updated ev_id=20230222106756 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:20.916764+00:00 : Updated ev_id=20230222106756 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-02-15 10:26:20.941570+00:00 : Updated ev_id=20230222106756 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-15 10:26:20.971266+00:00 : Updated ev_id=20230307106841 aircraft_key=1 inj_person_category=Flig injury_level=MINR.
Progress update 2025-02-15 10:26:20.991465+00:00 : Updated ev_id=20230307106841 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:21.033528+00:00 : Updated ev_id=20230413107053 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-02-15 10:26:21.066492+00:00 : Updated ev_id=20230413107053 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:21.420089+00:00 : Updated ev_id=20230419107087 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-15 10:26:21.449193+00:00 : Updated ev_id=20230419107087 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:21.633215+00:00 : Updated ev_id=20230424107114 aircraft_key=1 inj_person_category=Flig injury_level=SERS.
Progress update 2025-02-15 10:26:21.666725+00:00 : Updated ev_id=20230424107114 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:21.704911+00:00 : Updated ev_id=20230807192813 aircraft_key=1 inj_person_category=Flig injury_level=MINR.
Progress update 2025-02-15 10:26:21.733099+00:00 : Updated ev_id=20230807192813 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:21.824778+00:00 : Updated ev_id=20240112193642 aircraft_key=1 inj_person_category=Flig injury_level=MINR.
Progress update 2025-02-15 10:26:21.858565+00:00 : Updated ev_id=20240112193642 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:21.883258+00:00 : Updated ev_id=20240112193642 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-15 10:26:21.916668+00:00 : Updated ev_id=20240112193642 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-15 10:26:21.962710+00:00 : Updated ev_id=20240624194536 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:22.041495+00:00 : Updated ev_id=20250122199577 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-02-15 10:26:22.067005+00:00 : Updated ev_id=20250122199577 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-15 10:26:22.644419+00:00 : Number rows selected : 464.
Progress update 2025-02-15 10:26:22.644419+00:00 : Number rows inserted : 272.
Progress update 2025-02-15 10:26:22.644419+00:00 : Number rows updated : 192.
Progress update 2025-02-15 10:26:22.645419+00:00 :
Progress update 2025-02-15 10:26:22.645419+00:00 : Database table : narratives <-----------------------------------.
Progress update 2025-02-15 10:26:23.916334+00:00 : Updated ev_id=20230117106588 aircraft_key=1.
Progress update 2025-02-15 10:26:24.040107+00:00 : Updated ev_id=20230130106646 aircraft_key=1.
Progress update 2025-02-15 10:26:24.148274+00:00 : Updated ev_id=20230222106756 aircraft_key=1.
Progress update 2025-02-15 10:26:24.214507+00:00 : Updated ev_id=20230307106841 aircraft_key=1.
Progress update 2025-02-15 10:26:24.315665+00:00 : Updated ev_id=20230413107053 aircraft_key=1.
Progress update 2025-02-15 10:26:24.407270+00:00 : Updated ev_id=20230419107087 aircraft_key=1.
Progress update 2025-02-15 10:26:24.490753+00:00 : Updated ev_id=20230424107114 aircraft_key=1.
Progress update 2025-02-15 10:26:24.557811+00:00 : Updated ev_id=20230807192813 aircraft_key=1.
Progress update 2025-02-15 10:26:24.590592+00:00 : Updated ev_id=20240112193642 aircraft_key=1.
Progress update 2025-02-15 10:26:24.641093+00:00 : Number rows selected : 39.
Progress update 2025-02-15 10:26:24.641093+00:00 : Number rows inserted : 30.
Progress update 2025-02-15 10:26:24.641093+00:00 : Number rows updated : 9.
Progress update 2025-02-15 10:26:24.641093+00:00 :
Progress update 2025-02-15 10:26:24.641093+00:00 : Database table : occurrences <-----------------------------------.
Progress update 2025-02-15 10:26:24.642092+00:00 : Number rows selected : 0.
Progress update 2025-02-15 10:26:24.642092+00:00 :
Progress update 2025-02-15 10:26:24.642092+00:00 : Database table : dt_flight_crew <-----------------------------------.
Progress update 2025-02-15 10:26:32.388557+00:00 : Number rows selected : 252.
Progress update 2025-02-15 10:26:32.388557+00:00 : Number rows inserted : 252.
Progress update 2025-02-15 10:26:32.389564+00:00 :
Progress update 2025-02-15 10:26:32.389564+00:00 : Database table : flight_time <-----------------------------------.
Progress update 2025-02-15 10:26:49.666510+00:00 : Number rows selected : 607.
Progress update 2025-02-15 10:26:49.667512+00:00 : Number rows inserted : 607.
Progress update 2025-02-15 10:26:49.667512+00:00 :
Progress update 2025-02-15 10:26:49.667512+00:00 : Database table : seq_of_events <-----------------------------------.
Progress update 2025-02-15 10:26:49.668511+00:00 : Number rows selected : 0.
Progress update 2025-02-15 10:26:50.555704+00:00 : INFO.00.065 Cleansing PostgreSQL data.
Progress update 2025-02-15 10:26:50.555704+00:00 : --------------------------------------------------------------------------------
2025-02-15 11:26:50,555 [root] [db_utils.py ] INFO INFO.00.080 Admin connect request host=localhost port=5432 dbname=io_aero_db user=io_aero
Progress update 2025-02-15 10:26:50.648287+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'acft_category'.
Progress update 2025-02-15 10:26:52.996873+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-15 10:26:52.997873+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'dest_country'.
Progress update 2025-02-15 10:26:54.214012+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-15 10:26:54.214012+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'dprt_country'.
Progress update 2025-02-15 10:26:55.427491+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-15 10:26:55.427491+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'far_part'.
Progress update 2025-02-15 10:26:56.586295+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-15 10:26:56.587294+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'oper_country'.
Progress update 2025-02-15 10:26:57.740246+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-15 10:26:57.740246+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'owner_country'.
Progress update 2025-02-15 10:26:58.902911+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-15 10:26:58.902911+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'regis_no'.
Progress update 2025-02-15 10:27:00.020758+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-15 10:27:00.020758+00:00 : INFO.00.066 Cleansing table 'events' column 'ev_city'.
Progress update 2025-02-15 10:27:04.103864+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-15 10:27:04.103864+00:00 : INFO.00.066 Cleansing table 'events' column 'ev_site_zipcode'.
Progress update 2025-02-15 10:27:06.400865+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-15 10:27:06.400865+00:00 : INFO.00.066 Cleansing table 'events' column 'latitude'.
Progress update 2025-02-15 10:27:08.664143+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-15 10:27:08.664143+00:00 : INFO.00.066 Cleansing table 'events' column 'longitude'.
Progress update 2025-02-15 10:27:10.937335+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-15 10:27:10.937335+00:00 : INFO.00.066 Cleansing table 'events_sequence' column 'occurrence_code'.
Progress update 2025-02-15 10:27:11.586844+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-15 10:27:11.586844+00:00 : 106 s - Total time launcher.
Progress update 2025-02-15 10:27:11.586844+00:00 : INFO.00.006 End Launcher.
Progress update 2025-02-15 10:27:11.586844+00:00 : ===============================================================================.
2025-02-15 11:27:12,774 [root] [io_logger.py ] INFO You are using io-aero's iocommon version 1.2.63 logger (Copyright (c) 2022-2024 IO-Aero)
2025-02-15 11:27:12,774 [root] [io_settings.py ] INFO Starting the configuration management system.
2025-02-15 11:27:12,774 [root] [io_settings.py ] INFO Running in a source (non-compiled) environment. Configuration loading from: D:\SoftDevelopment\Projects\IO-Aero\io-avstats
2025-02-15 11:27:12,774 [root] [io_settings.py ] INFO Dynaconf settings loaded successfully.
Progress update 2025-02-15 10:27:14.090884+00:00 : ===============================================================================.
Progress update 2025-02-15 10:27:14.090884+00:00 : INFO.00.004 Start Launcher.
2025-02-15 11:27:14,090 [root] [launcher.py ] INFO param argv=['scripts\\launcher.py', '-t', 'c_l_l']
2025-02-15 11:27:14,090 [root] [launcher.py ] INFO Start launcher.py
2025-02-15 11:27:14,101 [root] [launcher.py ] INFO locale=('en_US', 'UTF-8')
Progress update 2025-02-15 10:27:14.102884+00:00 : INFO.00.005 Argument task='c_l_l'.
Progress update 2025-02-15 10:27:14.103390+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-15 10:27:14.103390+00:00 : INFO.00.040 Correct decimal US latitudes and longitudes.
Progress update 2025-02-15 10:27:14.103390+00:00 : --------------------------------------------------------------------------------
2025-02-15 11:27:14,103 [root] [db_utils.py ] INFO INFO.00.080 Admin connect request host=localhost port=5432 dbname=io_aero_db user=io_aero
Progress update 2025-02-15 10:27:18.267356+00:00 : INFO.00.063 Processed data source 'events'.
Progress update 2025-02-15 10:27:18.268356+00:00 : Number cols deleted : 60543.
Progress update 2025-02-15 10:27:18.268356+00:00 : --------------------------------------------------------------------------------
2025-02-15 11:27:18,268 [root] [db_utils.py ] INFO INFO.00.080 Admin connect request host=localhost port=5432 dbname=io_aero_db user=io_aero
Progress update 2025-02-15 10:27:26.298991+00:00 : Number of rows so far read : 10000.
Progress update 2025-02-15 10:27:31.638892+00:00 : Number of rows so far read : 20000.
Progress update 2025-02-15 10:27:36.984354+00:00 : Number of rows so far read : 30000.
Progress update 2025-02-15 10:27:42.449121+00:00 : Number of rows so far read : 40000.
Progress update 2025-02-15 10:27:47.834679+00:00 : Number of rows so far read : 50000.
Progress update 2025-02-15 10:27:53.217197+00:00 : Number of rows so far read : 60000.
Progress update 2025-02-15 10:27:58.573091+00:00 : Number of rows so far read : 70000.
Progress update 2025-02-15 10:28:03.921864+00:00 : Number of rows so far read : 80000.
Progress update 2025-02-15 10:28:09.229280+00:00 : Number of rows so far read : 90000.
Progress update 2025-02-15 10:28:14.594066+00:00 : Number of rows so far read : 100000.
Progress update 2025-02-15 10:28:20.001811+00:00 : Number of rows so far read : 110000.
Progress update 2025-02-15 10:28:25.374872+00:00 : Number of rows so far read : 120000.
Progress update 2025-02-15 10:28:30.731207+00:00 : Number of rows so far read : 130000.
Progress update 2025-02-15 10:28:36.049156+00:00 : Number of rows so far read : 140000.
Progress update 2025-02-15 10:28:37.662596+00:00 : Number rows selected : 142880.
Progress update 2025-02-15 10:28:37.663596+00:00 : Number rows updated : 142880.
Progress update 2025-02-15 10:28:37.683672+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-15 10:28:37.683672+00:00 : 83 s - Total time launcher.
Progress update 2025-02-15 10:28:37.683672+00:00 : INFO.00.006 End Launcher.
Progress update 2025-02-15 10:28:37.683672+00:00 : ===============================================================================.
2025-02-15 11:28:38,843 [root] [io_logger.py ] INFO You are using io-aero's iocommon version 1.2.63 logger (Copyright (c) 2022-2024 IO-Aero)
2025-02-15 11:28:38,843 [root] [io_settings.py ] INFO Starting the configuration management system.
2025-02-15 11:28:38,843 [root] [io_settings.py ] INFO Running in a source (non-compiled) environment. Configuration loading from: D:\SoftDevelopment\Projects\IO-Aero\io-avstats
2025-02-15 11:28:38,844 [root] [io_settings.py ] INFO Dynaconf settings loaded successfully.
Progress update 2025-02-15 10:28:40.066332+00:00 : ===============================================================================.
Progress update 2025-02-15 10:28:40.066332+00:00 : INFO.00.004 Start Launcher.
2025-02-15 11:28:40,066 [root] [launcher.py ] INFO param argv=['scripts\\launcher.py', '-t', 'f_n_a']
2025-02-15 11:28:40,066 [root] [launcher.py ] INFO Start launcher.py
2025-02-15 11:28:40,077 [root] [launcher.py ] INFO locale=('en_US', 'UTF-8')
Progress update 2025-02-15 10:28:40.078332+00:00 : INFO.00.005 Argument task='f_n_a'.
Progress update 2025-02-15 10:28:40.078332+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-15 10:28:40.078332+00:00 : INFO.00.086 Find the nearest airports.
Progress update 2025-02-15 10:28:40.078332+00:00 : --------------------------------------------------------------------------------
2025-02-15 11:28:40,079 [root] [db_utils.py ] INFO INFO.00.080 Admin connect request host=localhost port=5432 dbname=io_aero_db user=io_aero
Progress update 2025-02-15 10:28:41.070012+00:00 : INFO.00.063 Processed data source 'events'.
Progress update 2025-02-15 10:28:41.071015+00:00 : Number cols deleted : 70933.
Progress update 2025-02-15 10:28:41.071015+00:00 : --------------------------------------------------------------------------------
2025-02-15 11:28:41,071 [root] [db_utils.py ] INFO INFO.00.080 Admin connect request host=localhost port=5432 dbname=io_aero_db user=io_aero
Progress update 2025-02-15 10:29:07.013078+00:00 : Number of rows so far read : 10000.
Progress update 2025-02-15 10:29:31.297902+00:00 : Number of rows so far read : 20000.
Progress update 2025-02-15 10:29:55.700518+00:00 : Number of rows so far read : 30000.
Progress update 2025-02-15 10:30:20.876827+00:00 : Number of rows so far read : 40000.
Progress update 2025-02-15 10:30:44.941538+00:00 : Number of rows so far read : 50000.
Progress update 2025-02-15 10:30:45.089191+00:00 : ERROR.00.942 Event '20220711105442': issue with the Haversine algorithm: 'Longitude -894627.0 is out of range [-180, 180]'.
Progress update 2025-02-15 10:31:08.513227+00:00 : Number of rows so far read : 60000.
Progress update 2025-02-15 10:31:32.915990+00:00 : Number of rows so far read : 70000.
Progress update 2025-02-15 10:31:35.176006+00:00 : ERROR.00.942 Event '20210419102938': issue with the Haversine algorithm: 'Latitude 4603.0 is out of range [-90, 90]'.
Progress update 2025-02-15 10:31:35.176006+00:00 : ERROR.00.942 Event '20221027106211': issue with the Haversine algorithm: 'Latitude 36940.21 is out of range [-90, 90]'.
Progress update 2025-02-15 10:31:35.176006+00:00 : ERROR.00.942 Event '20221108106263': issue with the Haversine algorithm: 'Latitude 390408.0 is out of range [-90, 90]'.
Progress update 2025-02-15 10:31:35.176006+00:00 : ERROR.00.942 Event '20220803105651': issue with the Haversine algorithm: 'Latitude 41370104.0 is out of range [-90, 90]'.
Progress update 2025-02-15 10:31:35.176006+00:00 : ERROR.00.942 Event '20221108106264': issue with the Haversine algorithm: 'Latitude 43511185.0 is out of range [-90, 90]'.
Progress update 2025-02-15 10:31:35.207009+00:00 : Number rows selected : 70959.
Progress update 2025-02-15 10:31:35.207009+00:00 : Number rows updated : 70953.
Progress update 2025-02-15 10:31:35.209005+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-15 10:31:35.209005+00:00 : 175 s - Total time launcher.
Progress update 2025-02-15 10:31:35.209005+00:00 : INFO.00.006 End Launcher.
Progress update 2025-02-15 10:31:35.209005+00:00 : ===============================================================================.
2025-02-15 11:31:36,406 [root] [io_logger.py ] INFO You are using io-aero's iocommon version 1.2.63 logger (Copyright (c) 2022-2024 IO-Aero)
2025-02-15 11:31:36,406 [root] [io_settings.py ] INFO Starting the configuration management system.
2025-02-15 11:31:36,407 [root] [io_settings.py ] INFO Running in a source (non-compiled) environment. Configuration loading from: D:\SoftDevelopment\Projects\IO-Aero\io-avstats
2025-02-15 11:31:36,407 [root] [io_settings.py ] INFO Dynaconf settings loaded successfully.
Progress update 2025-02-15 10:31:37.629974+00:00 : ===============================================================================.
Progress update 2025-02-15 10:31:37.629974+00:00 : INFO.00.004 Start Launcher.
2025-02-15 11:31:37,629 [root] [launcher.py ] INFO param argv=['scripts\\launcher.py', '-t', 'v_n_d']
2025-02-15 11:31:37,629 [root] [launcher.py ] INFO Start launcher.py
2025-02-15 11:31:37,641 [root] [launcher.py ] INFO locale=('en_US', 'UTF-8')
Progress update 2025-02-15 10:31:37.642975+00:00 : INFO.00.005 Argument task='v_n_d'.
Progress update 2025-02-15 10:31:37.642975+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-15 10:31:37.642975+00:00 : INFO.00.043 Verify selected NTSB data.
Progress update 2025-02-15 10:31:37.642975+00:00 : --------------------------------------------------------------------------------
2025-02-15 11:31:37,642 [root] [db_utils.py ] INFO INFO.00.080 Admin connect request host=localhost port=5432 dbname=io_aero_db user=io_aero
Progress update 2025-02-15 10:31:37.939063+00:00 : INFO.00.063 Processed data source 'events'.
Progress update 2025-02-15 10:31:37.939063+00:00 : Number cols deleted : 24395.
Progress update 2025-02-15 10:31:37.940064+00:00 : --------------------------------------------------------------------------------
2025-02-15 11:31:37,940 [root] [db_utils.py ] INFO INFO.00.080 Admin connect request host=localhost port=5432 dbname=io_aero_db user=io_aero
Progress update 2025-02-15 10:31:38.013582+00:00 : INFO.00.064 Verification of table 'events' column(s) 'latitude & longitude'.
Progress update 2025-02-15 10:31:38.013582+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-15 10:31:40.104702+00:00 : Number of rows so far read : 10000.
Progress update 2025-02-15 10:31:41.779350+00:00 : Number of rows so far read : 20000.
Progress update 2025-02-15 10:31:43.404420+00:00 : Number of rows so far read : 30000.
Progress update 2025-02-15 10:31:45.137606+00:00 : Number of rows so far read : 40000.
Progress update 2025-02-15 10:31:47.711478+00:00 : Number of rows so far read : 50000.
Progress update 2025-02-15 10:31:51.061121+00:00 : Number of rows so far read : 60000.
Progress update 2025-02-15 10:31:54.517233+00:00 : Number of rows so far read : 70000.
Progress update 2025-02-15 10:31:56.830224+00:00 : Number rows errors : 27978.
Progress update 2025-02-15 10:31:56.830224+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-15 10:31:56.830224+00:00 : INFO.00.064 Verification of table 'events' column(s) 'ev_city'.
Progress update 2025-02-15 10:31:57.228522+00:00 : Number rows errors : 6254.
Progress update 2025-02-15 10:31:57.229522+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-15 10:31:57.229522+00:00 : INFO.00.064 Verification of table 'events' column(s) 'ev_city & ev_site_zipcode'.
Progress update 2025-02-15 10:31:57.793440+00:00 : Number rows errors : 16963.
Progress update 2025-02-15 10:31:57.793440+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-15 10:31:57.793440+00:00 : INFO.00.064 Verification of table 'events' column(s) 'ev_state'.
Progress update 2025-02-15 10:31:57.825457+00:00 : Number rows errors : 176.
Progress update 2025-02-15 10:31:57.826457+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-15 10:31:57.826457+00:00 : INFO.00.064 Verification of table 'events' column(s) 'ev_site_zipcode'.
Progress update 2025-02-15 10:31:58.003704+00:00 : Number rows errors : 5140.
Progress update 2025-02-15 10:31:58.003704+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-15 10:31:58.003704+00:00 : Number rows selected : 76799.
Progress update 2025-02-15 10:31:58.004705+00:00 : Number rows updated : 56511.
Progress update 2025-02-15 10:31:58.004705+00:00 : Number rows errors : 56511.
Progress update 2025-02-15 10:31:58.007216+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-15 10:31:58.007216+00:00 : 20 s - Total time launcher.
Progress update 2025-02-15 10:31:58.007216+00:00 : INFO.00.006 End Launcher.
Progress update 2025-02-15 10:31:58.007216+00:00 : ===============================================================================.
2025-02-15 11:31:59,124 [root] [io_logger.py ] INFO You are using io-aero's iocommon version 1.2.63 logger (Copyright (c) 2022-2024 IO-Aero)
2025-02-15 11:31:59,124 [root] [io_settings.py ] INFO Starting the configuration management system.
2025-02-15 11:31:59,124 [root] [io_settings.py ] INFO Running in a source (non-compiled) environment. Configuration loading from: D:\SoftDevelopment\Projects\IO-Aero\io-avstats
2025-02-15 11:31:59,125 [root] [io_settings.py ] INFO Dynaconf settings loaded successfully.
Progress update 2025-02-15 10:32:00.362473+00:00 : ===============================================================================.
Progress update 2025-02-15 10:32:00.362473+00:00 : INFO.00.004 Start Launcher.
2025-02-15 11:32:00,362 [root] [launcher.py ] INFO param argv=['scripts\\launcher.py', '-t', 'r_d_s']
2025-02-15 11:32:00,363 [root] [launcher.py ] INFO Start launcher.py
2025-02-15 11:32:00,374 [root] [launcher.py ] INFO locale=('en_US', 'UTF-8')
Progress update 2025-02-15 10:32:00.375473+00:00 : INFO.00.005 Argument task='r_d_s'.
Progress update 2025-02-15 10:32:00.375473+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-15 10:32:00.375473+00:00 : INFO.00.071 Refreshing the database schema.
Progress update 2025-02-15 10:32:00.375473+00:00 : --------------------------------------------------------------------------------
2025-02-15 11:32:00,376 [root] [db_utils.py ] INFO INFO.00.080 Admin connect request host=localhost port=5432 dbname=io_aero_db user=io_aero
Progress update 2025-02-15 10:32:00.434714+00:00 :
Progress update 2025-02-15 10:32:00.434714+00:00 : Database table : io_md_codes_eventsoe <-----------------------------------.
Progress update 2025-02-15 10:32:00.492132+00:00 : Number rows deleted : 96.
Progress update 2025-02-15 10:32:00.551597+00:00 : Number rows selected : 1559.
Progress update 2025-02-15 10:32:02.207687+00:00 : Number rows inserted : 96.
Progress update 2025-02-15 10:32:02.207687+00:00 :
Progress update 2025-02-15 10:32:02.207687+00:00 : Database table : io_md_codes_phase <-----------------------------------.
Progress update 2025-02-15 10:32:02.249482+00:00 : Number rows deleted : 48.
Progress update 2025-02-15 10:32:02.302505+00:00 : Number rows selected : 1559.
Progress update 2025-02-15 10:32:03.165521+00:00 : Number rows inserted : 48.
Progress update 2025-02-15 10:32:03.165521+00:00 :
Progress update 2025-02-15 10:32:03.165521+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-15 10:32:03.165521+00:00 : INFO.00.084 Database table io_md_codes_phase: Load description_main_phase from file 'data/Main_Phases_of_Flight/main_phases_of_flight.xlsx'.
Progress update 2025-02-15 10:32:03.165521+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-15 10:32:03.990011+00:00 : Number rows selected : 48.
Progress update 2025-02-15 10:32:03.990011+00:00 : Number rows updated : 48.
Progress update 2025-02-15 10:32:03.991013+00:00 :
Progress update 2025-02-15 10:32:03.991013+00:00 : Database table : io_md_codes_category <-----------------------------------.
Progress update 2025-02-15 10:32:04.099154+00:00 : Number rows deleted : 5.
Progress update 2025-02-15 10:32:04.653422+00:00 : Number rows selected : 7615.
Progress update 2025-02-15 10:32:04.731722+00:00 : Number rows inserted : 5.
Progress update 2025-02-15 10:32:04.732726+00:00 :
Progress update 2025-02-15 10:32:04.732726+00:00 : Database table : io_md_codes_subcategory <-----------------------------------.
Progress update 2025-02-15 10:32:05.027739+00:00 : Number rows selected : 7615.
Progress update 2025-02-15 10:32:05.422913+00:00 : Number rows inserted : 21.
Progress update 2025-02-15 10:32:05.423920+00:00 :
Progress update 2025-02-15 10:32:05.424919+00:00 : Database table : io_md_codes_section <-----------------------------------.
Progress update 2025-02-15 10:32:05.679222+00:00 : Number rows selected : 7615.
Progress update 2025-02-15 10:32:08.106485+00:00 : Number rows inserted : 129.
Progress update 2025-02-15 10:32:08.107485+00:00 :
Progress update 2025-02-15 10:32:08.107485+00:00 : Database table : io_md_codes_subsection <-----------------------------------.
Progress update 2025-02-15 10:32:08.362528+00:00 : Number rows selected : 7615.
Progress update 2025-02-15 10:32:21.644069+00:00 : Number rows inserted : 776.
Progress update 2025-02-15 10:32:21.645075+00:00 :
Progress update 2025-02-15 10:32:21.645075+00:00 : Database table : io_md_codes_modifier <-----------------------------------.
Progress update 2025-02-15 10:32:21.687402+00:00 : Number rows deleted : 74.
Progress update 2025-02-15 10:32:21.926547+00:00 : Number rows selected : 7615.
Progress update 2025-02-15 10:32:23.184827+00:00 : Number rows inserted : 74.
Progress update 2025-02-15 10:35:32.235330+00:00 : INFO.00.069 Materialized database view is refreshed: io_app_ae1982.
Progress update 2025-02-15 10:35:32.235330+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-15 10:35:32.236334+00:00 : 211 s - Total time launcher.
Progress update 2025-02-15 10:35:32.236334+00:00 : INFO.00.006 End Launcher.
Progress update 2025-02-15 10:35:32.236334+00:00 : ===============================================================================.
---------------------------------------------------------------------------
The current time is: 11:35:32.68
Enter the new time:
---------------------------------------------------------------------------
End run_io_avstats_dev
===========================================================================