===========================================================================
Start run_io_avstats_dev
---------------------------------------------------------------------------
IO-AVSTATS - Aviation Event Statistics.
---------------------------------------------------------------------------
ENV_FOR_DYNACONF : prod
PYTHONPATH : .
---------------------------------------------------------------------------
TASK : u_p_d
APPLICATION :
COMPOSE_TASK :
MSACCESS : up22JAN
MSEXCEL :
---------------------------------------------------------------------------
The current time is: 10:17:53.30
Enter the new time:
===========================================================================
2025-01-21 10:17:54,981 [root] [io_logger.py ] INFO You are using io-aero's iocommon version 1.2.63 logger (Copyright (c) 2022-2024 IO-Aero)
2025-01-21 10:17:54,981 [root] [io_settings.py ] INFO Starting the configuration management system.
2025-01-21 10:17:54,982 [root] [io_settings.py ] INFO Running in a source (non-compiled) environment. Configuration loading from: D:\SoftDevelopment\Projects\IO-Aero\io-avstats
2025-01-21 10:17:54,986 [root] [io_settings.py ] INFO Dynaconf settings loaded successfully.
Progress update 2025-01-21 09:17:57.308652+00:00 : ===============================================================================.
Progress update 2025-01-21 09:17:57.308652+00:00 : INFO.00.004 Start Launcher.
2025-01-21 10:17:57,309 [root] [launcher.py ] INFO param argv=['scripts\\launcher.py', '-t', 'd_n_a', '-m', 'up22JAN']
2025-01-21 10:17:57,309 [root] [launcher.py ] INFO Start launcher.py
2025-01-21 10:17:57,320 [root] [launcher.py ] INFO locale=('en_US', 'UTF-8')
Progress update 2025-01-21 09:17:57.321759+00:00 : INFO.00.008 Arguments task='d_n_a' msaccess='up22JAN'.
Progress update 2025-01-21 09:17:57.321759+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-01-21 09:17:57.321759+00:00 : INFO.00.047 Download NTSB MS Access database file 'up22JAN'.
Progress update 2025-01-21 09:17:57.321759+00:00 : --------------------------------------------------------------------------------
Progress update 2025-01-21 09:17:57.748412+00:00 : INFO.00.013 The connection to the MS Access database file 'up22JAN.zip' on the NTSB download page was successfully established.
Progress update 2025-01-21 09:17:58.081411+00:00 : INFO.00.014 From the file 'up22JAN.zip' 1 chunks were downloaded.
Progress update 2025-01-21 09:17:58.091923+00:00 : INFO.00.015 The file 'up22JAN.zip' was successfully unpacked.
Progress update 2025-01-21 09:17:58.095565+00:00 : INFO.00.051 msaccess_file='D:\SoftDevelopment\Projects\IO-Aero\io-avstats\data\download\IO-AVSTATS.mdb'.
Progress update 2025-01-21 09:17:58.095565+00:00 : INFO.00.051 msaccess_file='D:\SoftDevelopment\Projects\IO-Aero\io-avstats\data\download\up22JAN.sql'.
Progress update 2025-01-21 09:17:58.096068+00:00 : INFO.00.052 razorsql_jar_file='C:\Program Files\RazorSQL\razorsql.jar'.
Progress update 2025-01-21 09:17:58.096580+00:00 : INFO.00.053 razorsql_java_path='C:\Program Files\RazorSQL\jre11\bin\java'.
1737451078351: launching RazorSQL . . .
1737451078352: args . . .
-backup
IO-AVSTATS
null
null
;
null
D:\SoftDevelopment\Projects\IO-Aero\io-avstats\data\download\up22JAN.sql
NO
tables
YES
null
NO
NO
1737451078512: userName: walte
1737451078512: 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\Amazon\AWSCLIV2;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\Docker\Docker\resources\bin;C:\Program Files\TortoiseGit\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;C:\Users\walte\AppData\Local\Programs\Windsurf\bin;.
1737451078513: javaVersion: 17.0.7
1737451078513:
1737451078513: Verifying RazorSQL resources location.
1737451078513:
1737451078513: testing base url: / = file:/C:/Program%20Files/RazorSQL/
1737451078513:
1737451078513: testString1: file:/C:/Program%20Files/RazorSQL/razorsql.jar
1737451078513: testString2: file:/C:/Program%20Files/RazorSQL/data/base.ssql
1737451078514: testFile1: C:\Program Files\RazorSQL\razorsql.jar
1737451078514: testFile2: C:\Program Files\RazorSQL\data\base.ssql
1737451078514: both test file exists. Base URL found.
1737451078514: resource directory: file:/C:/Program%20Files/RazorSQL/
1737451078514: user home: C:\Users\walte
1737451078516: user profile: C:\Users\walte
1737451078516: app data: C:\Users\walte\AppData\Roaming
1737451078516: checking write access to: C:\Users\walte\AppData\Roaming
1737451078516: write dir: C:\Users\walte\AppData\Roaming\RichardsonSoftware
1737451078517: can write to C:\Users\walte\AppData\Roaming
1737451078517: user.home: C:\Users\walte\AppData\Roaming
1737451078517: RazorSQL Scratch Directory: C:\Users\walte\AppData\Roaming\RazorSQL
1737451078517: RazorSQL Scratch Directory exists
1737451078517: checking for sub directories
1737451078517: razorsql launch log: C:\Users\walte\AppData\Roaming\RazorSQL\razorsql_launch_log.txt
1737451078518: launch log file = C:\Users\walte\AppData\Roaming\RazorSQL\razorsql_launch_log.txt
1737451078518: Checking for graphics properties
1737451078518: graphics properties file: C:\Users\walte\AppData\Roaming\RazorSQL\data\graphics_properties.txt
1737451078519: gOverride: null
1737451078519: not disabling advanced graphics
1737451078519: path0: file:/C:/Program%20Files/RazorSQL/data/run.ssql
1737451078519: path1: file:/C:/Program%20Files/RazorSQL/razorsql.jar
1737451078519: runArgs: true
1737451078519: showScreen: false
1737451078520: args[0]: -backup
1737451078520: args[1]: IO-AVSTATS
1737451078520: args[2]: null
1737451078520: args[3]: null
1737451078520: args[4]: ;
1737451078520: args[5]: null
1737451078520: args[6]: D:\SoftDevelopment\Projects\IO-Aero\io-avstats\data\download\up22JAN.sql
1737451078520: args[7]: NO
1737451078520: args[8]: tables
1737451078520: args[9]: YES
1737451078520: args[10]: null
1737451078520: args[11]: NO
1737451078520: args[12]: NO
1737451078520: Command: -backup
1737451078520: Running -backup
h: name = C:\Program Files\RazorSQL\data\run.ssql
h: name = C:\Program Files\RazorSQL\razorsql.jar
1737451078529: Attempting to load . . .
command found
uOne: file:/C:/Program%20Files/RazorSQL/
h: name = C:\Program Files\RazorSQL\data\run.ssql
1737451078540reading file . . .C:\Program Files\RazorSQL\data\base.ssql
1737451078569done reading . . .
1737451078579done converting
1737451078579starting lib load.
1737451078589lib load complete.
In command line processor
Max Memory: 30688.0
Current Total Memory: 2048.0
Free Memory: 1918.071891784668
1737451078699: r init
1737451078699: d init
1737451078699: get default file encoding
1737451078699: end d init
custom home directory: null
Checking for user data from old versions
1737451078701: user home: C:\Users\walte
1737451078702: user profile: C:\Users\walte
1737451078702: app data: C:\Users\walte\AppData\Roaming
1737451078702: checking write access to: C:\Users\walte\AppData\Roaming
1737451078702: write dir: C:\Users\walte\AppData\Roaming\RichardsonSoftware
1737451078702: 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
1737451078714: loading icons
1737451079310: done r init
Getting connection data from: IO-AVSTATS
1737451079311: r init
1737451079311: d init
1737451079311: get default file encoding
1737451079311: 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
1737451079312: loading icons
1737451079322: 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-01-21 09:18:00.625210+00:00 : INFO.00.011 The DDL script for the MS Access database 'up22JAN.mdb' was created successfully.
Progress update 2025-01-21 09:18:00.626209+00:00 : INFO.00.012 The DDL script for the MS Access database 'up22JAN.mdb' is identical to the reference script.
Progress update 2025-01-21 09:18:00.626786+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-01-21 09:18:00.627289+00:00 : 3 s - Total time launcher.
Progress update 2025-01-21 09:18:00.627289+00:00 : INFO.00.006 End Launcher.
Progress update 2025-01-21 09:18:00.627289+00:00 : ===============================================================================.
2025-01-21 10:18:02,282 [root] [io_logger.py ] INFO You are using io-aero's iocommon version 1.2.63 logger (Copyright (c) 2022-2024 IO-Aero)
2025-01-21 10:18:02,282 [root] [io_settings.py ] INFO Starting the configuration management system.
2025-01-21 10:18:02,283 [root] [io_settings.py ] INFO Running in a source (non-compiled) environment. Configuration loading from: D:\SoftDevelopment\Projects\IO-Aero\io-avstats
2025-01-21 10:18:02,283 [root] [io_settings.py ] INFO Dynaconf settings loaded successfully.
Progress update 2025-01-21 09:18:03.801834+00:00 : ===============================================================================.
Progress update 2025-01-21 09:18:03.801834+00:00 : INFO.00.004 Start Launcher.
2025-01-21 10:18:03,801 [root] [launcher.py ] INFO param argv=['scripts\\launcher.py', '-t', 'l_n_a', '-m', 'up22JAN']
2025-01-21 10:18:03,802 [root] [launcher.py ] INFO Start launcher.py
2025-01-21 10:18:03,813 [root] [launcher.py ] INFO locale=('en_US', 'UTF-8')
Progress update 2025-01-21 09:18:03.814834+00:00 : INFO.00.008 Arguments task='l_n_a' msaccess='up22JAN'.
Progress update 2025-01-21 09:18:03.814834+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-01-21 09:18:03.814834+00:00 : INFO.00.049 Load NTSB MS Access database data from file 'up22JAN'.
Progress update 2025-01-21 09:18:03.815834+00:00 : --------------------------------------------------------------------------------
Progress update 2025-01-21 09:18:03.815834+00:00 : INFO.00.054 ODBC driver='DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=D:\SoftDevelopment\Projects\IO-Aero\io-avstats\data\download\up22JAN.mdb;'.
2025-01-21 10:18:04,548 [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-01-21 09:18:05.028858+00:00 : INFO.00.021 The following database table is not processed: 'MSysAccessObjects'.
Progress update 2025-01-21 09:18:05.028858+00:00 : INFO.00.021 The following database table is not processed: 'MSysACEs'.
Progress update 2025-01-21 09:18:05.028858+00:00 : INFO.00.021 The following database table is not processed: 'MSysIMEXColumns'.
Progress update 2025-01-21 09:18:05.028858+00:00 : INFO.00.021 The following database table is not processed: 'MSysIMEXSpecs'.
Progress update 2025-01-21 09:18:05.028858+00:00 : INFO.00.021 The following database table is not processed: 'MSysModules2'.
Progress update 2025-01-21 09:18:05.028858+00:00 : INFO.00.021 The following database table is not processed: 'MSysNavPaneGroupCategories'.
Progress update 2025-01-21 09:18:05.029859+00:00 : INFO.00.021 The following database table is not processed: 'MSysNavPaneGroups'.
Progress update 2025-01-21 09:18:05.029859+00:00 : INFO.00.021 The following database table is not processed: 'MSysNavPaneGroupToObjects'.
Progress update 2025-01-21 09:18:05.029859+00:00 : INFO.00.021 The following database table is not processed: 'MSysNavPaneObjectIDs'.
Progress update 2025-01-21 09:18:05.029859+00:00 : INFO.00.021 The following database table is not processed: 'MSysObjects'.
Progress update 2025-01-21 09:18:05.029859+00:00 : INFO.00.021 The following database table is not processed: 'MSysQueries'.
Progress update 2025-01-21 09:18:05.029859+00:00 : INFO.00.021 The following database table is not processed: 'MSysRelationships'.
Progress update 2025-01-21 09:18:05.029859+00:00 : INFO.00.021 The following database table is not processed: 'Country'.
Progress update 2025-01-21 09:18:05.029859+00:00 : INFO.00.021 The following database table is not processed: 'ct_iaids'.
Progress update 2025-01-21 09:18:05.029859+00:00 : INFO.00.021 The following database table is not processed: 'ct_seqevt'.
Progress update 2025-01-21 09:18:05.029859+00:00 : INFO.00.021 The following database table is not processed: 'eADMSPUB_DataDictionary'.
Progress update 2025-01-21 09:18:05.029859+00:00 : INFO.00.021 The following database table is not processed: 'states'.
Progress update 2025-01-21 09:18:05.030858+00:00 :
Progress update 2025-01-21 09:18:05.030858+00:00 : Database table : events <-----------------------------------.
Progress update 2025-01-21 09:18:06.252386+00:00 : Updated ev_id=20231206193486 ev_year=2023.
Progress update 2025-01-21 09:18:06.309431+00:00 : Updated ev_id=20231207193495 ev_year=2023.
Progress update 2025-01-21 09:18:06.368430+00:00 : Updated ev_id=20231218193537 ev_year=2023.
Progress update 2025-01-21 09:18:06.411017+00:00 : Updated ev_id=20231227193575 ev_year=2023.
Progress update 2025-01-21 09:18:06.451417+00:00 : Updated ev_id=20240102193582 ev_year=2024.
Progress update 2025-01-21 09:18:06.501684+00:00 : Updated ev_id=20240102193586 ev_year=2023.
Progress update 2025-01-21 09:18:06.543162+00:00 : Updated ev_id=20240103193598 ev_year=2024.
Progress update 2025-01-21 09:18:06.568857+00:00 : Updated ev_id=20240104193602 ev_year=2023.
Progress update 2025-01-21 09:18:06.610415+00:00 : Updated ev_id=20240104193612 ev_year=2024.
Progress update 2025-01-21 09:18:06.635414+00:00 : Updated ev_id=20240109193633 ev_year=2024.
Progress update 2025-01-21 09:18:06.660154+00:00 : Updated ev_id=20240109193635 ev_year=2023.
Progress update 2025-01-21 09:18:06.729060+00:00 : Updated ev_id=20240110193637 ev_year=2024.
Progress update 2025-01-21 09:18:06.760415+00:00 : Updated ev_id=20240111193640 ev_year=2024.
Progress update 2025-01-21 09:18:06.785427+00:00 : Updated ev_id=20240111193641 ev_year=2024.
Progress update 2025-01-21 09:18:06.819040+00:00 : Updated ev_id=20240112193642 ev_year=2024.
Progress update 2025-01-21 09:18:06.843602+00:00 : Updated ev_id=20240114193645 ev_year=2024.
Progress update 2025-01-21 09:18:06.868328+00:00 : Updated ev_id=20240114193646 ev_year=2024.
Progress update 2025-01-21 09:18:06.893427+00:00 : Updated ev_id=20240114193647 ev_year=2024.
Progress update 2025-01-21 09:18:06.918809+00:00 : Updated ev_id=20240115193650 ev_year=2023.
Progress update 2025-01-21 09:18:06.952182+00:00 : Updated ev_id=20240115193651 ev_year=2023.
Progress update 2025-01-21 09:18:06.976804+00:00 : Updated ev_id=20240115193654 ev_year=2024.
Progress update 2025-01-21 09:18:07.001656+00:00 : Updated ev_id=20240115193655 ev_year=2024.
Progress update 2025-01-21 09:18:07.027408+00:00 : Updated ev_id=20240115193656 ev_year=2024.
Progress update 2025-01-21 09:18:07.069072+00:00 : Updated ev_id=20240115193662 ev_year=2024.
Progress update 2025-01-21 09:18:07.102690+00:00 : Updated ev_id=20240116193664 ev_year=2024.
Progress update 2025-01-21 09:18:07.126694+00:00 : Updated ev_id=20240116193666 ev_year=2024.
Progress update 2025-01-21 09:18:07.160203+00:00 : Updated ev_id=20240116193667 ev_year=2024.
Progress update 2025-01-21 09:18:07.202686+00:00 : Updated ev_id=20240116193669 ev_year=2024.
Progress update 2025-01-21 09:18:07.227482+00:00 : Updated ev_id=20240117193673 ev_year=2024.
Progress update 2025-01-21 09:18:07.251987+00:00 : Updated ev_id=20240117193677 ev_year=2024.
Progress update 2025-01-21 09:18:07.276810+00:00 : Updated ev_id=20240118193678 ev_year=2023.
Progress update 2025-01-21 09:18:07.302330+00:00 : Updated ev_id=20240118193680 ev_year=2024.
Progress update 2025-01-21 09:18:07.351645+00:00 : Updated ev_id=20240119193682 ev_year=2024.
Progress update 2025-01-21 09:18:07.368386+00:00 : Updated ev_id=20240119193683 ev_year=2024.
Progress update 2025-01-21 09:18:07.368386+00:00 : Number rows selected : 44.
Progress update 2025-01-21 09:18:07.368386+00:00 : Number rows updated : 34.
Progress update 2025-01-21 09:18:07.368386+00:00 :
Progress update 2025-01-21 09:18:07.368386+00:00 : Database table : aircraft <-----------------------------------.
Progress update 2025-01-21 09:18:07.643917+00:00 : Updated ev_id=20231206193486 aircraft_key=1.
Progress update 2025-01-21 09:18:07.676321+00:00 : Updated ev_id=20231207193495 aircraft_key=1.
Progress update 2025-01-21 09:18:07.727061+00:00 : Updated ev_id=20231218193537 aircraft_key=1.
Progress update 2025-01-21 09:18:07.768651+00:00 : Updated ev_id=20231227193575 aircraft_key=1.
Progress update 2025-01-21 09:18:07.827052+00:00 : Updated ev_id=20240102193582 aircraft_key=1.
Progress update 2025-01-21 09:18:07.860023+00:00 : Updated ev_id=20240102193586 aircraft_key=1.
Progress update 2025-01-21 09:18:07.884947+00:00 : Updated ev_id=20240103193598 aircraft_key=1.
Progress update 2025-01-21 09:18:07.918413+00:00 : Updated ev_id=20240104193602 aircraft_key=1.
Progress update 2025-01-21 09:18:07.934648+00:00 : Updated ev_id=20240104193612 aircraft_key=1.
Progress update 2025-01-21 09:18:07.960396+00:00 : Updated ev_id=20240109193633 aircraft_key=1.
Progress update 2025-01-21 09:18:07.993449+00:00 : Updated ev_id=20240109193635 aircraft_key=1.
Progress update 2025-01-21 09:18:08.019068+00:00 : Updated ev_id=20240110193637 aircraft_key=1.
Progress update 2025-01-21 09:18:08.087252+00:00 : Updated ev_id=20240111193640 aircraft_key=1.
Progress update 2025-01-21 09:18:08.156186+00:00 : Updated ev_id=20240111193641 aircraft_key=1.
Progress update 2025-01-21 09:18:08.193413+00:00 : Updated ev_id=20240112193642 aircraft_key=1.
Progress update 2025-01-21 09:18:08.218593+00:00 : Updated ev_id=20240114193645 aircraft_key=1.
Progress update 2025-01-21 09:18:08.243296+00:00 : Updated ev_id=20240114193646 aircraft_key=1.
Progress update 2025-01-21 09:18:08.268688+00:00 : Updated ev_id=20240114193647 aircraft_key=1.
Progress update 2025-01-21 09:18:08.318462+00:00 : Updated ev_id=20240115193650 aircraft_key=1.
Progress update 2025-01-21 09:18:08.343084+00:00 : Updated ev_id=20240115193651 aircraft_key=1.
Progress update 2025-01-21 09:18:08.369050+00:00 : Updated ev_id=20240115193654 aircraft_key=1.
Progress update 2025-01-21 09:18:08.393532+00:00 : Updated ev_id=20240115193655 aircraft_key=1.
Progress update 2025-01-21 09:18:08.434825+00:00 : Updated ev_id=20240115193656 aircraft_key=1.
Progress update 2025-01-21 09:18:08.468691+00:00 : Updated ev_id=20240115193662 aircraft_key=1.
Progress update 2025-01-21 09:18:08.502412+00:00 : Updated ev_id=20240116193664 aircraft_key=1.
Progress update 2025-01-21 09:18:08.527231+00:00 : Updated ev_id=20240116193666 aircraft_key=1.
Progress update 2025-01-21 09:18:08.543497+00:00 : Updated ev_id=20240116193667 aircraft_key=1.
Progress update 2025-01-21 09:18:08.569026+00:00 : Updated ev_id=20240116193669 aircraft_key=1.
Progress update 2025-01-21 09:18:08.618629+00:00 : Updated ev_id=20240117193673 aircraft_key=1.
Progress update 2025-01-21 09:18:08.643951+00:00 : Updated ev_id=20240117193677 aircraft_key=1.
Progress update 2025-01-21 09:18:08.677165+00:00 : Updated ev_id=20240118193678 aircraft_key=1.
Progress update 2025-01-21 09:18:08.693026+00:00 : Updated ev_id=20240118193680 aircraft_key=1.
Progress update 2025-01-21 09:18:08.727164+00:00 : Updated ev_id=20240119193682 aircraft_key=1.
Progress update 2025-01-21 09:18:08.760277+00:00 : Updated ev_id=20240119193683 aircraft_key=1.
Progress update 2025-01-21 09:18:08.761282+00:00 : Number rows selected : 44.
Progress update 2025-01-21 09:18:08.761282+00:00 : Number rows updated : 34.
Progress update 2025-01-21 09:18:08.761282+00:00 :
Progress update 2025-01-21 09:18:08.761282+00:00 : Database table : dt_events <-----------------------------------.
Progress update 2025-01-21 09:18:08.926889+00:00 : Updated ev_id=20231206193486 col_name=launch code=None.
Progress update 2025-01-21 09:18:08.960483+00:00 : Updated ev_id=20231206193486 col_name=icing_forecast_type code=NA.
Progress update 2025-01-21 09:18:08.976621+00:00 : Updated ev_id=20231206193486 col_name=wx_brief_src code=AUTR.
Progress update 2025-01-21 09:18:09.001526+00:00 : Updated ev_id=20231207193495 col_name=launch code=None.
Progress update 2025-01-21 09:18:09.035237+00:00 : Updated ev_id=20231207193495 col_name=icing_actual_amt code=NONE.
Progress update 2025-01-21 09:18:09.060553+00:00 : Updated ev_id=20231207193495 col_name=icing_actual_type code=CLR.
Progress update 2025-01-21 09:18:09.076690+00:00 : Updated ev_id=20231207193495 col_name=icing_forecast_amt code=NONE.
Progress update 2025-01-21 09:18:09.101761+00:00 : Updated ev_id=20231207193495 col_name=icing_forecast_type code=CLR.
Progress update 2025-01-21 09:18:09.117400+00:00 : Updated ev_id=20231207193495 col_name=turb_fc_type code=NONE.
Progress update 2025-01-21 09:18:09.144010+00:00 : Updated ev_id=20231207193495 col_name=turb_severity code=NA.
Progress update 2025-01-21 09:18:09.168111+00:00 : Updated ev_id=20231207193495 col_name=turb_type code=NONE.
Progress update 2025-01-21 09:18:09.194101+00:00 : Updated ev_id=20231207193495 col_name=wx_brief_src0 code=UNK.
Progress update 2025-01-21 09:18:09.302122+00:00 : Updated ev_id=20231218193537 col_name=launch code=None.
Progress update 2025-01-21 09:18:09.335703+00:00 : Updated ev_id=20231227193575 col_name=launch code=Part.
Progress update 2025-01-21 09:18:09.350795+00:00 : Updated ev_id=20231227193575 col_name=spec_hand code=TDA.
Progress update 2025-01-21 09:18:09.376461+00:00 : Updated ev_id=20231227193575 col_name=icing_actual_amt code=NONE.
Progress update 2025-01-21 09:18:09.419490+00:00 : Updated ev_id=20231227193575 col_name=icing_actual_type code=NA.
Progress update 2025-01-21 09:18:09.471657+00:00 : Updated ev_id=20231227193575 col_name=icing_forecast_amt code=NONE.
Progress update 2025-01-21 09:18:09.508418+00:00 : Updated ev_id=20231227193575 col_name=icing_forecast_type code=NA.
Progress update 2025-01-21 09:18:09.534529+00:00 : Updated ev_id=20231227193575 col_name=turb_fc_type code=NONE.
Progress update 2025-01-21 09:18:09.568442+00:00 : Updated ev_id=20231227193575 col_name=turb_severity code=NA.
Progress update 2025-01-21 09:18:09.602593+00:00 : Updated ev_id=20231227193575 col_name=turb_type code=NONE.
Progress update 2025-01-21 09:18:09.668666+00:00 : Updated ev_id=20240102193582 col_name=launch code=None.
Progress update 2025-01-21 09:18:09.684410+00:00 : Updated ev_id=20240102193582 col_name=wx_brief_src code=AUTR.
Progress update 2025-01-21 09:18:09.710702+00:00 : Updated ev_id=20240102193586 col_name=launch code=None.
Progress update 2025-01-21 09:18:09.725830+00:00 : Updated ev_id=20240103193598 col_name=launch code=None.
Progress update 2025-01-21 09:18:09.760138+00:00 : Updated ev_id=20240103193598 col_name=icing_actual_amt code=NONE.
Progress update 2025-01-21 09:18:09.786057+00:00 : Updated ev_id=20240103193598 col_name=icing_actual_type code=NA.
Progress update 2025-01-21 09:18:09.809138+00:00 : Updated ev_id=20240103193598 col_name=icing_forecast_amt code=NONE.
Progress update 2025-01-21 09:18:09.835146+00:00 : Updated ev_id=20240103193598 col_name=icing_forecast_type code=NA.
Progress update 2025-01-21 09:18:09.850855+00:00 : Updated ev_id=20240103193598 col_name=turb_fc_type code=NONE.
Progress update 2025-01-21 09:18:09.885209+00:00 : Updated ev_id=20240103193598 col_name=turb_severity code=NA.
Progress update 2025-01-21 09:18:09.901282+00:00 : Updated ev_id=20240103193598 col_name=turb_type code=NONE.
Progress update 2025-01-21 09:18:09.927693+00:00 : Updated ev_id=20240103193598 col_name=wx_brief_src code=AUTR.
Progress update 2025-01-21 09:18:09.967569+00:00 : Updated ev_id=20240104193602 col_name=launch code=None.
Progress update 2025-01-21 09:18:10.002180+00:00 : Updated ev_id=20240104193612 col_name=launch code=None.
Progress update 2025-01-21 09:18:10.068448+00:00 : Updated ev_id=20240109193633 col_name=launch code=None.
Progress update 2025-01-21 09:18:10.084407+00:00 : Updated ev_id=20240109193635 col_name=launch code=None.
Progress update 2025-01-21 09:18:10.110603+00:00 : Updated ev_id=20240110193637 col_name=launch code=None.
Progress update 2025-01-21 09:18:10.150835+00:00 : Updated ev_id=20240111193640 col_name=launch code=None.
Progress update 2025-01-21 09:18:10.176287+00:00 : Updated ev_id=20240111193640 col_name=icing_actual_amt code=NONE.
Progress update 2025-01-21 09:18:10.201921+00:00 : Updated ev_id=20240111193640 col_name=icing_actual_type code=NA.
Progress update 2025-01-21 09:18:10.226755+00:00 : Updated ev_id=20240111193640 col_name=icing_forecast_amt code=NONE.
Progress update 2025-01-21 09:18:10.242747+00:00 : Updated ev_id=20240111193640 col_name=icing_forecast_type code=NA.
Progress update 2025-01-21 09:18:10.267624+00:00 : Updated ev_id=20240111193640 col_name=turb_fc_type code=NONE.
Progress update 2025-01-21 09:18:10.293083+00:00 : Updated ev_id=20240111193640 col_name=turb_severity code=NA.
Progress update 2025-01-21 09:18:10.309267+00:00 : Updated ev_id=20240111193640 col_name=turb_type code=NONE.
Progress update 2025-01-21 09:18:10.335733+00:00 : Updated ev_id=20240111193640 col_name=wx_brief_src code=AUTR.
Progress update 2025-01-21 09:18:10.377550+00:00 : Updated ev_id=20240111193641 col_name=launch code=None.
Progress update 2025-01-21 09:18:10.401727+00:00 : Updated ev_id=20240112193642 col_name=launch code=None.
Progress update 2025-01-21 09:18:10.459934+00:00 : Updated ev_id=20240114193645 col_name=launch code=Part.
Progress update 2025-01-21 09:18:10.476372+00:00 : Updated ev_id=20240114193645 col_name=spec_hand code=TDA.
Progress update 2025-01-21 09:18:10.510656+00:00 : Updated ev_id=20240114193646 col_name=launch code=Part.
Progress update 2025-01-21 09:18:10.534919+00:00 : Updated ev_id=20240114193646 col_name=spec_hand code=TDA.
Progress update 2025-01-21 09:18:10.576505+00:00 : Updated ev_id=20240114193647 col_name=launch code=Part.
Progress update 2025-01-21 09:18:10.610837+00:00 : Updated ev_id=20240114193647 col_name=spec_hand code=PA.
Progress update 2025-01-21 09:18:10.643796+00:00 : Updated ev_id=20240115193650 col_name=launch code=None.
Progress update 2025-01-21 09:18:10.667971+00:00 : Updated ev_id=20240115193651 col_name=launch code=None.
Progress update 2025-01-21 09:18:10.684562+00:00 : Updated ev_id=20240115193654 col_name=launch code=None.
Progress update 2025-01-21 09:18:10.709726+00:00 : Updated ev_id=20240115193655 col_name=launch code=None.
Progress update 2025-01-21 09:18:10.735599+00:00 : Updated ev_id=20240115193656 col_name=launch code=None.
Progress update 2025-01-21 09:18:10.786091+00:00 : Updated ev_id=20240115193662 col_name=launch code=Part.
Progress update 2025-01-21 09:18:10.835114+00:00 : Updated ev_id=20240115193662 col_name=spec_hand code=TDA.
Progress update 2025-01-21 09:18:10.868916+00:00 : Updated ev_id=20240116193664 col_name=launch code=None.
Progress update 2025-01-21 09:18:10.892898+00:00 : Updated ev_id=20240116193664 col_name=icing_actual_amt code=NONE.
Progress update 2025-01-21 09:18:10.919279+00:00 : Updated ev_id=20240116193664 col_name=icing_actual_type code=NA.
Progress update 2025-01-21 09:18:10.943207+00:00 : Updated ev_id=20240116193664 col_name=icing_forecast_amt code=NONE.
Progress update 2025-01-21 09:18:10.967791+00:00 : Updated ev_id=20240116193664 col_name=icing_forecast_type code=NA.
Progress update 2025-01-21 09:18:10.992532+00:00 : Updated ev_id=20240116193664 col_name=turb_fc_type code=NONE.
Progress update 2025-01-21 09:18:11.018434+00:00 : Updated ev_id=20240116193664 col_name=turb_severity code=NA.
Progress update 2025-01-21 09:18:11.033939+00:00 : Updated ev_id=20240116193664 col_name=turb_type code=NONE.
Progress update 2025-01-21 09:18:11.050747+00:00 : Updated ev_id=20240116193664 col_name=wx_brief_src code=AUTR.
Progress update 2025-01-21 09:18:11.102427+00:00 : Updated ev_id=20240116193666 col_name=launch code=None.
Progress update 2025-01-21 09:18:11.175964+00:00 : Updated ev_id=20240116193667 col_name=launch code=None.
Progress update 2025-01-21 09:18:11.250722+00:00 : Updated ev_id=20240117193673 col_name=launch code=None.
Progress update 2025-01-21 09:18:11.276193+00:00 : Updated ev_id=20240117193677 col_name=launch code=None.
Progress update 2025-01-21 09:18:11.310756+00:00 : Updated ev_id=20240118193678 col_name=followup_travel code=Y.
Progress update 2025-01-21 09:18:11.335529+00:00 : Updated ev_id=20240118193678 col_name=launch code=None.
Progress update 2025-01-21 09:18:11.375342+00:00 : Updated ev_id=20240118193680 col_name=launch code=None.
Progress update 2025-01-21 09:18:11.427414+00:00 : Updated ev_id=20240119193682 col_name=launch code=None.
Progress update 2025-01-21 09:18:11.451671+00:00 : Updated ev_id=20240119193683 col_name=followup_travel code=N.
Progress update 2025-01-21 09:18:11.476588+00:00 : Updated ev_id=20240119193683 col_name=launch code=None.
Progress update 2025-01-21 09:18:11.477590+00:00 : Number rows selected : 131.
Progress update 2025-01-21 09:18:11.477590+00:00 : Number rows inserted : 15.
Progress update 2025-01-21 09:18:11.477590+00:00 : Number rows updated : 82.
Progress update 2025-01-21 09:18:11.477590+00:00 :
Progress update 2025-01-21 09:18:11.477590+00:00 : Database table : ntsb_admin <-----------------------------------.
Progress update 2025-01-21 09:18:11.626056+00:00 : Updated ev_id=20231206193486.
Progress update 2025-01-21 09:18:11.651800+00:00 : Updated ev_id=20231207193495.
Progress update 2025-01-21 09:18:11.700942+00:00 : Updated ev_id=20231218193537.
Progress update 2025-01-21 09:18:11.726433+00:00 : Updated ev_id=20231227193575.
Progress update 2025-01-21 09:18:11.742481+00:00 : Updated ev_id=20240102193582.
Progress update 2025-01-21 09:18:11.767325+00:00 : Updated ev_id=20240102193586.
Progress update 2025-01-21 09:18:11.783745+00:00 : Updated ev_id=20240103193598.
Progress update 2025-01-21 09:18:11.809414+00:00 : Updated ev_id=20240104193602.
Progress update 2025-01-21 09:18:11.834137+00:00 : Updated ev_id=20240104193612.
Progress update 2025-01-21 09:18:11.891592+00:00 : Updated ev_id=20240109193633.
Progress update 2025-01-21 09:18:11.926471+00:00 : Updated ev_id=20240109193635.
Progress update 2025-01-21 09:18:11.951744+00:00 : Updated ev_id=20240110193637.
Progress update 2025-01-21 09:18:11.975501+00:00 : Updated ev_id=20240111193640.
Progress update 2025-01-21 09:18:12.001636+00:00 : Updated ev_id=20240111193641.
Progress update 2025-01-21 09:18:12.017077+00:00 : Updated ev_id=20240112193642.
Progress update 2025-01-21 09:18:12.042382+00:00 : Updated ev_id=20240114193645.
Progress update 2025-01-21 09:18:12.068332+00:00 : Updated ev_id=20240114193646.
Progress update 2025-01-21 09:18:12.102068+00:00 : Updated ev_id=20240114193647.
Progress update 2025-01-21 09:18:12.145093+00:00 : Updated ev_id=20240115193650.
Progress update 2025-01-21 09:18:12.192657+00:00 : Updated ev_id=20240115193651.
Progress update 2025-01-21 09:18:12.260657+00:00 : Updated ev_id=20240115193654.
Progress update 2025-01-21 09:18:12.293657+00:00 : Updated ev_id=20240115193655.
Progress update 2025-01-21 09:18:12.327129+00:00 : Updated ev_id=20240115193656.
Progress update 2025-01-21 09:18:12.350802+00:00 : Updated ev_id=20240115193662.
Progress update 2025-01-21 09:18:12.375896+00:00 : Updated ev_id=20240116193664.
Progress update 2025-01-21 09:18:12.401514+00:00 : Updated ev_id=20240116193666.
Progress update 2025-01-21 09:18:12.426771+00:00 : Updated ev_id=20240116193667.
Progress update 2025-01-21 09:18:12.451964+00:00 : Updated ev_id=20240116193669.
Progress update 2025-01-21 09:18:12.477418+00:00 : Updated ev_id=20240117193673.
Progress update 2025-01-21 09:18:12.501592+00:00 : Updated ev_id=20240117193677.
Progress update 2025-01-21 09:18:12.526787+00:00 : Updated ev_id=20240118193678.
Progress update 2025-01-21 09:18:12.542500+00:00 : Updated ev_id=20240118193680.
Progress update 2025-01-21 09:18:12.569034+00:00 : Updated ev_id=20240119193682.
Progress update 2025-01-21 09:18:12.602339+00:00 : Updated ev_id=20240119193683.
Progress update 2025-01-21 09:18:12.602339+00:00 : Number rows selected : 44.
Progress update 2025-01-21 09:18:12.602339+00:00 : Number rows updated : 34.
Progress update 2025-01-21 09:18:12.602339+00:00 :
Progress update 2025-01-21 09:18:12.602339+00:00 : Database table : dt_aircraft <-----------------------------------.
Progress update 2025-01-21 09:18:12.742828+00:00 : Updated ev_id=20231206193486 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-01-21 09:18:12.768358+00:00 : Updated ev_id=20231206193486 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-01-21 09:18:12.793282+00:00 : Updated ev_id=20231206193486 aircraft_key=1 col_name=addtl_equip code=AUTO.
Progress update 2025-01-21 09:18:12.824509+00:00 : Updated ev_id=20231206193486 aircraft_key=1 col_name=addtl_equip code=EPFD.
Progress update 2025-01-21 09:18:12.851659+00:00 : Updated ev_id=20231206193486 aircraft_key=1 col_name=addtl_equip code=STWS.
Progress update 2025-01-21 09:18:12.867054+00:00 : Updated ev_id=20231206193486 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-01-21 09:18:12.884304+00:00 : Updated ev_id=20231206193486 aircraft_key=1 col_name=airspc_type code=CLG.
Progress update 2025-01-21 09:18:12.910265+00:00 : Updated ev_id=20231206193486 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-01-21 09:18:12.933356+00:00 : Updated ev_id=20231206193486 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-01-21 09:18:12.960156+00:00 : Updated ev_id=20231206193486 aircraft_key=1 col_name=landing_surf code=ASPH.
Progress update 2025-01-21 09:18:12.975566+00:00 : Updated ev_id=20231206193486 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-01-21 09:18:13.009802+00:00 : Updated ev_id=20231206193486 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-01-21 09:18:13.034982+00:00 : Updated ev_id=20231206193486 aircraft_key=1 col_name=vfr_appr code=FSTP.
Progress update 2025-01-21 09:18:13.059914+00:00 : Updated ev_id=20231207193495 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-01-21 09:18:13.085645+00:00 : Updated ev_id=20231207193495 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-01-21 09:18:13.109842+00:00 : Updated ev_id=20231207193495 aircraft_key=1 col_name=addtl_equip code=EFB.
Progress update 2025-01-21 09:18:13.134845+00:00 : Updated ev_id=20231207193495 aircraft_key=1 col_name=addtl_equip code=EMFD.
Progress update 2025-01-21 09:18:13.158476+00:00 : Updated ev_id=20231207193495 aircraft_key=1 col_name=addtl_equip code=STWS.
Progress update 2025-01-21 09:18:13.183846+00:00 : Updated ev_id=20231207193495 aircraft_key=1 col_name=aircar_cert code=141.
Progress update 2025-01-21 09:18:13.209772+00:00 : Updated ev_id=20231207193495 aircraft_key=1 col_name=airspc_type code=CLG.
Progress update 2025-01-21 09:18:13.234069+00:00 : Updated ev_id=20231207193495 aircraft_key=1 col_name=elt_oper_no_reason code=UNK.
Progress update 2025-01-21 09:18:13.258768+00:00 : Updated ev_id=20231207193495 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-01-21 09:18:13.283584+00:00 : Updated ev_id=20231207193495 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-01-21 09:18:13.318549+00:00 : Updated ev_id=20231207193495 aircraft_key=1 col_name=landing_surf code=ASPH.
Progress update 2025-01-21 09:18:13.333086+00:00 : Updated ev_id=20231207193495 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-01-21 09:18:13.393652+00:00 : Updated ev_id=20231207193495 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-01-21 09:18:13.427151+00:00 : Updated ev_id=20231207193495 aircraft_key=1 col_name=vfr_appr0 code=NONE.
Progress update 2025-01-21 09:18:13.540049+00:00 : Updated ev_id=20231227193575 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-01-21 09:18:13.568523+00:00 : Updated ev_id=20231227193575 aircraft_key=1 col_name=addtl_equip0 code=NONE.
Progress update 2025-01-21 09:18:13.592377+00:00 : Updated ev_id=20231227193575 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-01-21 09:18:13.617565+00:00 : Updated ev_id=20231227193575 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-01-21 09:18:13.643419+00:00 : Updated ev_id=20231227193575 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-01-21 09:18:13.658462+00:00 : Updated ev_id=20231227193575 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-01-21 09:18:13.674746+00:00 : Updated ev_id=20231227193575 aircraft_key=1 col_name=vfr_appr0 code=NONE.
Progress update 2025-01-21 09:18:13.708848+00:00 : Updated ev_id=20240102193582 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-01-21 09:18:13.733948+00:00 : Updated ev_id=20240102193582 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-01-21 09:18:13.759820+00:00 : Updated ev_id=20240102193582 aircraft_key=1 col_name=addtl_equip code=EFB.
Progress update 2025-01-21 09:18:13.783266+00:00 : Updated ev_id=20240102193582 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-01-21 09:18:13.810011+00:00 : Updated ev_id=20240102193582 aircraft_key=1 col_name=airspc_type code=CLG.
Progress update 2025-01-21 09:18:13.835958+00:00 : Updated ev_id=20240102193582 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-01-21 09:18:13.858732+00:00 : Updated ev_id=20240102193582 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-01-21 09:18:13.885637+00:00 : Updated ev_id=20240102193582 aircraft_key=1 col_name=landing_surf code=ASPH.
Progress update 2025-01-21 09:18:13.918307+00:00 : Updated ev_id=20240102193582 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-01-21 09:18:13.933449+00:00 : Updated ev_id=20240102193582 aircraft_key=1 col_name=type_clear code=VFR.
Progress update 2025-01-21 09:18:13.958863+00:00 : Updated ev_id=20240102193582 aircraft_key=1 col_name=vfr_appr code=FSTP.
Progress update 2025-01-21 09:18:13.974882+00:00 : Updated ev_id=20240102193582 aircraft_key=1 col_name=vfr_appr code=TPAT.
Progress update 2025-01-21 09:18:14.000940+00:00 : Updated ev_id=20240102193586 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-01-21 09:18:14.035049+00:00 : Updated ev_id=20240103193598 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-01-21 09:18:14.060280+00:00 : Updated ev_id=20240103193598 aircraft_key=1 col_name=addtl_equip code=AUTO.
Progress update 2025-01-21 09:18:14.093503+00:00 : Updated ev_id=20240103193598 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-01-21 09:18:14.125020+00:00 : Updated ev_id=20240103193598 aircraft_key=1 col_name=airspc_type code=CLG.
Progress update 2025-01-21 09:18:14.150663+00:00 : Updated ev_id=20240103193598 aircraft_key=1 col_name=elt_oper_no_reason code=OTHR.
Progress update 2025-01-21 09:18:14.167053+00:00 : Updated ev_id=20240103193598 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-01-21 09:18:14.190663+00:00 : Updated ev_id=20240103193598 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-01-21 09:18:14.218660+00:00 : Updated ev_id=20240103193598 aircraft_key=1 col_name=landing_surf code=CONC.
Progress update 2025-01-21 09:18:14.243598+00:00 : Updated ev_id=20240103193598 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-01-21 09:18:14.257916+00:00 : Updated ev_id=20240103193598 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-01-21 09:18:14.284855+00:00 : Updated ev_id=20240103193598 aircraft_key=1 col_name=vfr_appr code=FLND.
Progress update 2025-01-21 09:18:14.318708+00:00 : Updated ev_id=20240103193598 aircraft_key=1 col_name=vfr_appr code=STIN.
Progress update 2025-01-21 09:18:14.343521+00:00 : Updated ev_id=20240104193602 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-01-21 09:18:14.368608+00:00 : Updated ev_id=20240104193602 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-01-21 09:18:14.393239+00:00 : Updated ev_id=20240104193602 aircraft_key=1 col_name=vfr_appr0 code=NONE.
Progress update 2025-01-21 09:18:14.426916+00:00 : Updated ev_id=20240109193635 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-01-21 09:18:14.460208+00:00 : Updated ev_id=20240109193635 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-01-21 09:18:14.485580+00:00 : Updated ev_id=20240109193635 aircraft_key=1 col_name=landing_surf code=GRAS.
Progress update 2025-01-21 09:18:14.500323+00:00 : Updated ev_id=20240109193635 aircraft_key=1 col_name=vfr_appr code=TPAT.
Progress update 2025-01-21 09:18:14.527159+00:00 : Updated ev_id=20240111193640 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-01-21 09:18:14.551958+00:00 : Updated ev_id=20240111193640 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-01-21 09:18:14.585716+00:00 : Updated ev_id=20240111193640 aircraft_key=1 col_name=airspc_type code=CLG.
Progress update 2025-01-21 09:18:14.600529+00:00 : Updated ev_id=20240111193640 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-01-21 09:18:14.635563+00:00 : Updated ev_id=20240111193640 aircraft_key=1 col_name=landing_gear1 code=TAIL.
Progress update 2025-01-21 09:18:14.649939+00:00 : Updated ev_id=20240111193640 aircraft_key=1 col_name=landing_surf code=GRAS.
Progress update 2025-01-21 09:18:14.677484+00:00 : Updated ev_id=20240111193640 aircraft_key=1 col_name=rwy_cond1 code=SNOW.
Progress update 2025-01-21 09:18:14.710129+00:00 : Updated ev_id=20240111193640 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-01-21 09:18:14.733271+00:00 : Updated ev_id=20240111193640 aircraft_key=1 col_name=vfr_appr0 code=NONE.
Progress update 2025-01-21 09:18:14.761210+00:00 : Updated ev_id=20240114193645 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-01-21 09:18:14.782879+00:00 : Updated ev_id=20240114193645 aircraft_key=1 col_name=elt_oper_no_reason code=UNK.
Progress update 2025-01-21 09:18:14.810501+00:00 : Updated ev_id=20240116193664 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-01-21 09:18:14.833179+00:00 : Updated ev_id=20240116193664 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-01-21 09:18:14.891967+00:00 : Updated ev_id=20240116193664 aircraft_key=1 col_name=addtl_equip code=EFB.
Progress update 2025-01-21 09:18:14.949612+00:00 : Updated ev_id=20240116193664 aircraft_key=1 col_name=addtl_equip code=STWS.
Progress update 2025-01-21 09:18:14.991833+00:00 : Updated ev_id=20240116193664 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-01-21 09:18:15.033589+00:00 : Updated ev_id=20240116193664 aircraft_key=1 col_name=airspc_type code=CLD.
Progress update 2025-01-21 09:18:15.060049+00:00 : Updated ev_id=20240116193664 aircraft_key=1 col_name=elt_oper_no_reason code=UNK.
Progress update 2025-01-21 09:18:15.074765+00:00 : Updated ev_id=20240116193664 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-01-21 09:18:15.091531+00:00 : Updated ev_id=20240116193664 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-01-21 09:18:15.126356+00:00 : Updated ev_id=20240116193664 aircraft_key=1 col_name=landing_surf code=ASPH.
Progress update 2025-01-21 09:18:15.159758+00:00 : Updated ev_id=20240116193664 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-01-21 09:18:15.216294+00:00 : Updated ev_id=20240116193664 aircraft_key=1 col_name=type_clear code=VFR.
Progress update 2025-01-21 09:18:15.243503+00:00 : Updated ev_id=20240116193664 aircraft_key=1 col_name=vfr_appr code=TOGO.
Progress update 2025-01-21 09:18:15.258311+00:00 : Updated ev_id=20240116193666 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-01-21 09:18:15.275006+00:00 : Updated ev_id=20240116193666 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-01-21 09:18:15.291503+00:00 : Updated ev_id=20240117193677 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-01-21 09:18:15.316703+00:00 : Updated ev_id=20240117193677 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-01-21 09:18:15.332603+00:00 : Updated ev_id=20240117193677 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-01-21 09:18:15.360472+00:00 : Updated ev_id=20240117193677 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-01-21 09:18:15.384814+00:00 : Updated ev_id=20240117193677 aircraft_key=1 col_name=type_clear code=VFR.
Progress update 2025-01-21 09:18:15.400234+00:00 : Updated ev_id=20240117193677 aircraft_key=1 col_name=vfr_appr0 code=NONE.
Progress update 2025-01-21 09:18:15.400234+00:00 : Number rows selected : 178.
Progress update 2025-01-21 09:18:15.400234+00:00 : Number rows updated : 98.
Progress update 2025-01-21 09:18:15.400234+00:00 :
Progress update 2025-01-21 09:18:15.400234+00:00 : Database table : engines <-----------------------------------.
Progress update 2025-01-21 09:18:15.400234+00:00 : Number rows selected : 0.
Progress update 2025-01-21 09:18:15.400234+00:00 :
Progress update 2025-01-21 09:18:15.400234+00:00 : Database table : events_sequence <-----------------------------------.
Progress update 2025-01-21 09:18:15.557778+00:00 : Updated ev_id=20231206193486 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:15.574231+00:00 : Updated ev_id=20231206193486 Aircraft_Key=1 Occurrence_No=2.
Progress update 2025-01-21 09:18:15.599999+00:00 : Updated ev_id=20231206193486 Aircraft_Key=1 Occurrence_No=3.
Progress update 2025-01-21 09:18:15.635445+00:00 : Updated ev_id=20231206193486 Aircraft_Key=1 Occurrence_No=4.
Progress update 2025-01-21 09:18:15.710606+00:00 : Updated ev_id=20231218193537 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:15.743417+00:00 : Updated ev_id=20240102193582 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:15.766708+00:00 : Updated ev_id=20240102193582 Aircraft_Key=1 Occurrence_No=2.
Progress update 2025-01-21 09:18:15.800038+00:00 : Updated ev_id=20240103193598 Aircraft_Key=1 Occurrence_No=3.
Progress update 2025-01-21 09:18:15.826606+00:00 : Updated ev_id=20240103193598 Aircraft_Key=1 Occurrence_No=4.
Progress update 2025-01-21 09:18:15.877264+00:00 : Updated ev_id=20240104193602 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:15.890799+00:00 : Updated ev_id=20240104193612 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:15.915889+00:00 : Updated ev_id=20240109193633 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:15.940793+00:00 : Updated ev_id=20240109193635 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:15.966136+00:00 : Updated ev_id=20240110193637 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:16.026909+00:00 : Updated ev_id=20240111193641 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:16.041222+00:00 : Updated ev_id=20240112193642 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:16.068880+00:00 : Updated ev_id=20240112193642 Aircraft_Key=1 Occurrence_No=2.
Progress update 2025-01-21 09:18:16.099161+00:00 : Updated ev_id=20240112193642 Aircraft_Key=1 Occurrence_No=3.
Progress update 2025-01-21 09:18:16.124536+00:00 : Updated ev_id=20240114193645 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:16.160472+00:00 : Updated ev_id=20240114193646 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:16.193333+00:00 : Updated ev_id=20240114193647 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:16.241303+00:00 : Updated ev_id=20240115193650 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:16.293591+00:00 : Updated ev_id=20240115193651 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:16.324721+00:00 : Updated ev_id=20240115193654 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:16.357380+00:00 : Updated ev_id=20240115193655 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:16.382794+00:00 : Updated ev_id=20240115193656 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:16.409516+00:00 : Updated ev_id=20240115193662 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:16.435374+00:00 : Updated ev_id=20240116193664 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:16.494263+00:00 : Updated ev_id=20240116193667 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:16.517484+00:00 : Updated ev_id=20240116193669 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:16.549591+00:00 : Updated ev_id=20240117193673 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:16.590819+00:00 : Updated ev_id=20240118193678 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:16.615997+00:00 : Updated ev_id=20240118193680 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:16.657662+00:00 : Updated ev_id=20240119193683 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-01-21 09:18:16.658188+00:00 : Number rows selected : 53.
Progress update 2025-01-21 09:18:16.658188+00:00 : Number rows inserted : 6.
Progress update 2025-01-21 09:18:16.658188+00:00 : Number rows updated : 34.
Progress update 2025-01-21 09:18:16.658188+00:00 :
Progress update 2025-01-21 09:18:16.658717+00:00 : Database table : findings <-----------------------------------.
Progress update 2025-01-21 09:18:16.659250+00:00 : Number rows selected : 0.
Progress update 2025-01-21 09:18:16.659250+00:00 :
Progress update 2025-01-21 09:18:16.659250+00:00 : Database table : flight_crew <-----------------------------------.
Progress update 2025-01-21 09:18:16.659250+00:00 : Number rows selected : 0.
Progress update 2025-01-21 09:18:16.659250+00:00 :
Progress update 2025-01-21 09:18:16.659250+00:00 : Database table : injury <-----------------------------------.
Progress update 2025-01-21 09:18:16.802176+00:00 : Updated ev_id=20231206193486 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-01-21 09:18:16.835597+00:00 : Updated ev_id=20231206193486 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-01-21 09:18:16.857632+00:00 : Updated ev_id=20231206193486 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-01-21 09:18:16.884333+00:00 : Updated ev_id=20231206193486 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-01-21 09:18:16.918341+00:00 : Updated ev_id=20231207193495 aircraft_key=1 inj_person_category=Cabi injury_level=FATL.
Progress update 2025-01-21 09:18:16.932120+00:00 : Updated ev_id=20231207193495 aircraft_key=1 inj_person_category=Cabi injury_level=SERS.
Progress update 2025-01-21 09:18:16.957616+00:00 : Updated ev_id=20231207193495 aircraft_key=1 inj_person_category=Cabi injury_level=MINR.
Progress update 2025-01-21 09:18:16.982923+00:00 : Updated ev_id=20231207193495 aircraft_key=1 inj_person_category=Cabi injury_level=NONE.
Progress update 2025-01-21 09:18:16.999245+00:00 : Updated ev_id=20231207193495 aircraft_key=1 inj_person_category=Cabi injury_level=TOTL.
Progress update 2025-01-21 09:18:17.024008+00:00 : Updated ev_id=20231207193495 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-01-21 09:18:17.049188+00:00 : Updated ev_id=20231207193495 aircraft_key=1 inj_person_category=Flig injury_level=SERS.
Progress update 2025-01-21 09:18:17.065612+00:00 : Updated ev_id=20231207193495 aircraft_key=1 inj_person_category=Flig injury_level=MINR.
Progress update 2025-01-21 09:18:17.091309+00:00 : Updated ev_id=20231207193495 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-01-21 09:18:17.127419+00:00 : Updated ev_id=20231207193495 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-01-21 09:18:17.151450+00:00 : Updated ev_id=20231207193495 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-01-21 09:18:17.176615+00:00 : Updated ev_id=20231207193495 aircraft_key=1 inj_person_category=Pass injury_level=SERS.
Progress update 2025-01-21 09:18:17.201591+00:00 : Updated ev_id=20231207193495 aircraft_key=1 inj_person_category=Pass injury_level=MINR.
Progress update 2025-01-21 09:18:17.248468+00:00 : Updated ev_id=20231207193495 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-01-21 09:18:17.265488+00:00 : Updated ev_id=20231207193495 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-01-21 09:18:17.309783+00:00 : Updated ev_id=20231218193537 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-01-21 09:18:17.332611+00:00 : Updated ev_id=20231218193537 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-01-21 09:18:17.390576+00:00 : Updated ev_id=20231227193575 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-01-21 09:18:17.418954+00:00 : Updated ev_id=20231227193575 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-01-21 09:18:17.448416+00:00 : Updated ev_id=20231227193575 aircraft_key=1 inj_person_category=Pass injury_level=MINR.
Progress update 2025-01-21 09:18:17.474494+00:00 : Updated ev_id=20231227193575 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-01-21 09:18:17.490209+00:00 : Updated ev_id=20231227193575 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-01-21 09:18:17.515385+00:00 : Updated ev_id=20240102193582 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-01-21 09:18:17.544209+00:00 : Updated ev_id=20240102193582 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-01-21 09:18:17.565589+00:00 : Updated ev_id=20240102193582 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-01-21 09:18:17.618980+00:00 : Updated ev_id=20240102193582 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-01-21 09:18:17.682600+00:00 : Updated ev_id=20240102193586 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-01-21 09:18:17.707729+00:00 : Updated ev_id=20240102193586 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-01-21 09:18:17.748598+00:00 : Updated ev_id=20240103193598 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-01-21 09:18:17.774328+00:00 : Updated ev_id=20240103193598 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-01-21 09:18:17.802176+00:00 : Updated ev_id=20240104193602 aircraft_key=1 inj_person_category=Cabi injury_level=FATL.
Progress update 2025-01-21 09:18:17.835384+00:00 : Updated ev_id=20240104193602 aircraft_key=1 inj_person_category=Cabi injury_level=SERS.
Progress update 2025-01-21 09:18:17.856736+00:00 : Updated ev_id=20240104193602 aircraft_key=1 inj_person_category=Cabi injury_level=MINR.
Progress update 2025-01-21 09:18:17.874568+00:00 : Updated ev_id=20240104193602 aircraft_key=1 inj_person_category=Cabi injury_level=NONE.
Progress update 2025-01-21 09:18:17.898506+00:00 : Updated ev_id=20240104193602 aircraft_key=1 inj_person_category=Cabi injury_level=TOTL.
Progress update 2025-01-21 09:18:17.918047+00:00 : Updated ev_id=20240104193602 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-01-21 09:18:17.940287+00:00 : Updated ev_id=20240104193602 aircraft_key=1 inj_person_category=Flig injury_level=SERS.
Progress update 2025-01-21 09:18:17.968824+00:00 : Updated ev_id=20240104193602 aircraft_key=1 inj_person_category=Flig injury_level=MINR.
Progress update 2025-01-21 09:18:17.998401+00:00 : Updated ev_id=20240104193602 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-01-21 09:18:18.023706+00:00 : Updated ev_id=20240104193602 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-01-21 09:18:18.051741+00:00 : Updated ev_id=20240104193602 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-01-21 09:18:18.076245+00:00 : Updated ev_id=20240104193602 aircraft_key=1 inj_person_category=Pass injury_level=SERS.
Progress update 2025-01-21 09:18:18.107080+00:00 : Updated ev_id=20240104193602 aircraft_key=1 inj_person_category=Pass injury_level=MINR.
Progress update 2025-01-21 09:18:18.135176+00:00 : Updated ev_id=20240104193602 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-01-21 09:18:18.159731+00:00 : Updated ev_id=20240104193602 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-01-21 09:18:18.185419+00:00 : Updated ev_id=20240104193612 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-01-21 09:18:18.207006+00:00 : Updated ev_id=20240104193612 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-01-21 09:18:18.260419+00:00 : Updated ev_id=20240109193633 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-01-21 09:18:18.289944+00:00 : Updated ev_id=20240109193633 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-01-21 09:18:18.315842+00:00 : Updated ev_id=20240109193635 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-01-21 09:18:18.348664+00:00 : Updated ev_id=20240109193635 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-01-21 09:18:18.376680+00:00 : Updated ev_id=20240109193635 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-01-21 09:18:18.401428+00:00 : Updated ev_id=20240109193635 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-01-21 09:18:18.423596+00:00 : Updated ev_id=20240111193640 aircraft_key=1 inj_person_category=Cabi injury_level=FATL.
Progress update 2025-01-21 09:18:18.452253+00:00 : Updated ev_id=20240111193640 aircraft_key=1 inj_person_category=Cabi injury_level=SERS.
Progress update 2025-01-21 09:18:18.476767+00:00 : Updated ev_id=20240111193640 aircraft_key=1 inj_person_category=Cabi injury_level=MINR.
Progress update 2025-01-21 09:18:18.507421+00:00 : Updated ev_id=20240111193640 aircraft_key=1 inj_person_category=Cabi injury_level=NONE.
Progress update 2025-01-21 09:18:18.523918+00:00 : Updated ev_id=20240111193640 aircraft_key=1 inj_person_category=Cabi injury_level=TOTL.
Progress update 2025-01-21 09:18:18.540525+00:00 : Updated ev_id=20240111193640 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-01-21 09:18:18.557647+00:00 : Updated ev_id=20240111193640 aircraft_key=1 inj_person_category=Flig injury_level=SERS.
Progress update 2025-01-21 09:18:18.590042+00:00 : Updated ev_id=20240111193640 aircraft_key=1 inj_person_category=Flig injury_level=MINR.
Progress update 2025-01-21 09:18:18.617916+00:00 : Updated ev_id=20240111193640 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-01-21 09:18:18.651814+00:00 : Updated ev_id=20240111193640 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-01-21 09:18:18.665685+00:00 : Updated ev_id=20240111193640 aircraft_key=1 inj_person_category=LapC injury_level=FATL.
Progress update 2025-01-21 09:18:18.690205+00:00 : Updated ev_id=20240111193640 aircraft_key=1 inj_person_category=LapC injury_level=SERS.
Progress update 2025-01-21 09:18:18.726602+00:00 : Updated ev_id=20240111193640 aircraft_key=1 inj_person_category=LapC injury_level=MINR.
Progress update 2025-01-21 09:18:18.756377+00:00 : Updated ev_id=20240111193640 aircraft_key=1 inj_person_category=LapC injury_level=NONE.
Progress update 2025-01-21 09:18:18.790686+00:00 : Updated ev_id=20240111193640 aircraft_key=1 inj_person_category=LapC injury_level=TOTL.
Progress update 2025-01-21 09:18:18.824072+00:00 : Updated ev_id=20240111193640 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-01-21 09:18:18.848691+00:00 : Updated ev_id=20240111193640 aircraft_key=1 inj_person_category=Pass injury_level=SERS.
Progress update 2025-01-21 09:18:18.881703+00:00 : Updated ev_id=20240111193640 aircraft_key=1 inj_person_category=Pass injury_level=MINR.
Progress update 2025-01-21 09:18:18.898894+00:00 : Updated ev_id=20240111193640 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-01-21 09:18:18.926598+00:00 : Updated ev_id=20240111193640 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-01-21 09:18:18.990059+00:00 : Updated ev_id=20240112193642 aircraft_key=1 inj_person_category=Flig injury_level=MINR.
Progress update 2025-01-21 09:18:19.044415+00:00 : Updated ev_id=20240112193642 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-01-21 09:18:19.090061+00:00 : Updated ev_id=20240114193645 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-01-21 09:18:19.142895+00:00 : Updated ev_id=20240114193645 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-01-21 09:18:19.164743+00:00 : Updated ev_id=20240114193645 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-01-21 09:18:19.193077+00:00 : Updated ev_id=20240114193645 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-01-21 09:18:19.223307+00:00 : Updated ev_id=20240114193646 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-01-21 09:18:19.251597+00:00 : Updated ev_id=20240114193646 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-01-21 09:18:19.290439+00:00 : Updated ev_id=20240114193646 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-01-21 09:18:19.318130+00:00 : Updated ev_id=20240114193646 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-01-21 09:18:19.348293+00:00 : Updated ev_id=20240114193647 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-01-21 09:18:19.365208+00:00 : Updated ev_id=20240114193647 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-01-21 09:18:19.389965+00:00 : Updated ev_id=20240114193647 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-01-21 09:18:19.406651+00:00 : Updated ev_id=20240114193647 aircraft_key=1 inj_person_category=Pass injury_level=SERS.
Progress update 2025-01-21 09:18:19.431154+00:00 : Updated ev_id=20240114193647 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-01-21 09:18:19.459543+00:00 : Updated ev_id=20240114193647 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-01-21 09:18:19.498814+00:00 : Updated ev_id=20240115193662 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-01-21 09:18:19.526964+00:00 : Updated ev_id=20240115193662 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-01-21 09:18:19.548213+00:00 : Updated ev_id=20240115193662 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-01-21 09:18:19.564739+00:00 : Updated ev_id=20240115193662 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-01-21 09:18:19.598509+00:00 : Updated ev_id=20240116193664 aircraft_key=1 inj_person_category=Cabi injury_level=FATL.
Progress update 2025-01-21 09:18:19.615539+00:00 : Updated ev_id=20240116193664 aircraft_key=1 inj_person_category=Cabi injury_level=SERS.
Progress update 2025-01-21 09:18:19.639752+00:00 : Updated ev_id=20240116193664 aircraft_key=1 inj_person_category=Cabi injury_level=MINR.
Progress update 2025-01-21 09:18:19.665337+00:00 : Updated ev_id=20240116193664 aircraft_key=1 inj_person_category=Cabi injury_level=NONE.
Progress update 2025-01-21 09:18:19.701683+00:00 : Updated ev_id=20240116193664 aircraft_key=1 inj_person_category=Cabi injury_level=TOTL.
Progress update 2025-01-21 09:18:19.723511+00:00 : Updated ev_id=20240116193664 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-01-21 09:18:19.751674+00:00 : Updated ev_id=20240116193664 aircraft_key=1 inj_person_category=Flig injury_level=SERS.
Progress update 2025-01-21 09:18:19.773602+00:00 : Updated ev_id=20240116193664 aircraft_key=1 inj_person_category=Flig injury_level=MINR.
Progress update 2025-01-21 09:18:19.801635+00:00 : Updated ev_id=20240116193664 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-01-21 09:18:19.823972+00:00 : Updated ev_id=20240116193664 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-01-21 09:18:19.847876+00:00 : Updated ev_id=20240116193664 aircraft_key=1 inj_person_category=LapC injury_level=FATL.
Progress update 2025-01-21 09:18:19.876473+00:00 : Updated ev_id=20240116193664 aircraft_key=1 inj_person_category=LapC injury_level=SERS.
Progress update 2025-01-21 09:18:19.906476+00:00 : Updated ev_id=20240116193664 aircraft_key=1 inj_person_category=LapC injury_level=MINR.
Progress update 2025-01-21 09:18:19.923649+00:00 : Updated ev_id=20240116193664 aircraft_key=1 inj_person_category=LapC injury_level=NONE.
Progress update 2025-01-21 09:18:19.948782+00:00 : Updated ev_id=20240116193664 aircraft_key=1 inj_person_category=LapC injury_level=TOTL.
Progress update 2025-01-21 09:18:19.965126+00:00 : Updated ev_id=20240116193664 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-01-21 09:18:19.990006+00:00 : Updated ev_id=20240116193664 aircraft_key=1 inj_person_category=Pass injury_level=SERS.
Progress update 2025-01-21 09:18:20.015329+00:00 : Updated ev_id=20240116193664 aircraft_key=1 inj_person_category=Pass injury_level=MINR.
Progress update 2025-01-21 09:18:20.048243+00:00 : Updated ev_id=20240116193664 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-01-21 09:18:20.073386+00:00 : Updated ev_id=20240116193664 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-01-21 09:18:20.090200+00:00 : Updated ev_id=20240116193666 aircraft_key=1 inj_person_category=Cabi injury_level=FATL.
Progress update 2025-01-21 09:18:20.115596+00:00 : Updated ev_id=20240116193666 aircraft_key=1 inj_person_category=Cabi injury_level=SERS.
Progress update 2025-01-21 09:18:20.151053+00:00 : Updated ev_id=20240116193666 aircraft_key=1 inj_person_category=Cabi injury_level=MINR.
Progress update 2025-01-21 09:18:20.173558+00:00 : Updated ev_id=20240116193666 aircraft_key=1 inj_person_category=Cabi injury_level=NONE.
Progress update 2025-01-21 09:18:20.206703+00:00 : Updated ev_id=20240116193666 aircraft_key=1 inj_person_category=Cabi injury_level=TOTL.
Progress update 2025-01-21 09:18:20.234809+00:00 : Updated ev_id=20240116193666 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-01-21 09:18:20.272969+00:00 : Updated ev_id=20240116193666 aircraft_key=1 inj_person_category=Flig injury_level=SERS.
Progress update 2025-01-21 09:18:20.301602+00:00 : Updated ev_id=20240116193666 aircraft_key=1 inj_person_category=Flig injury_level=MINR.
Progress update 2025-01-21 09:18:20.362150+00:00 : Updated ev_id=20240116193666 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-01-21 09:18:20.404751+00:00 : Updated ev_id=20240116193666 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-01-21 09:18:20.456527+00:00 : Updated ev_id=20240116193666 aircraft_key=1 inj_person_category=LapC injury_level=FATL.
Progress update 2025-01-21 09:18:20.489587+00:00 : Updated ev_id=20240116193666 aircraft_key=1 inj_person_category=LapC injury_level=SERS.
Progress update 2025-01-21 09:18:20.523088+00:00 : Updated ev_id=20240116193666 aircraft_key=1 inj_person_category=LapC injury_level=MINR.
Progress update 2025-01-21 09:18:20.556528+00:00 : Updated ev_id=20240116193666 aircraft_key=1 inj_person_category=LapC injury_level=NONE.
Progress update 2025-01-21 09:18:20.584710+00:00 : Updated ev_id=20240116193666 aircraft_key=1 inj_person_category=LapC injury_level=TOTL.
Progress update 2025-01-21 09:18:20.615258+00:00 : Updated ev_id=20240116193666 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-01-21 09:18:20.640032+00:00 : Updated ev_id=20240116193666 aircraft_key=1 inj_person_category=Pass injury_level=SERS.
Progress update 2025-01-21 09:18:20.656925+00:00 : Updated ev_id=20240116193666 aircraft_key=1 inj_person_category=Pass injury_level=MINR.
Progress update 2025-01-21 09:18:20.684560+00:00 : Updated ev_id=20240116193666 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-01-21 09:18:20.715055+00:00 : Updated ev_id=20240116193666 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-01-21 09:18:20.740048+00:00 : Updated ev_id=20240116193667 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-01-21 09:18:20.756868+00:00 : Updated ev_id=20240116193667 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-01-21 09:18:20.781604+00:00 : Updated ev_id=20240117193677 aircraft_key=1 inj_person_category=Flig injury_level=MINR.
Progress update 2025-01-21 09:18:20.798301+00:00 : Updated ev_id=20240117193677 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-01-21 09:18:20.831229+00:00 : Updated ev_id=20240118193678 aircraft_key=1 inj_person_category=Cabi injury_level=NONE.
Progress update 2025-01-21 09:18:20.848039+00:00 : Updated ev_id=20240118193678 aircraft_key=1 inj_person_category=Cabi injury_level=TOTL.
Progress update 2025-01-21 09:18:20.873114+00:00 : Updated ev_id=20240118193678 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-01-21 09:18:20.907030+00:00 : Updated ev_id=20240118193678 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-01-21 09:18:20.940241+00:00 : Updated ev_id=20240118193678 aircraft_key=1 inj_person_category=LapC injury_level=NONE.
Progress update 2025-01-21 09:18:20.973555+00:00 : Updated ev_id=20240118193678 aircraft_key=1 inj_person_category=LapC injury_level=TOTL.
Progress update 2025-01-21 09:18:20.997799+00:00 : Updated ev_id=20240118193678 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-01-21 09:18:21.031364+00:00 : Updated ev_id=20240118193678 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-01-21 09:18:21.031364+00:00 : Number rows selected : 206.
Progress update 2025-01-21 09:18:21.031364+00:00 : Number rows updated : 149.
Progress update 2025-01-21 09:18:21.032365+00:00 :
Progress update 2025-01-21 09:18:21.032365+00:00 : Database table : narratives <-----------------------------------.
Progress update 2025-01-21 09:18:21.284386+00:00 : Updated ev_id=20231207193495 aircraft_key=1.
Progress update 2025-01-21 09:18:21.443662+00:00 : Updated ev_id=20231227193575 aircraft_key=1.
Progress update 2025-01-21 09:18:21.556578+00:00 : Updated ev_id=20240103193598 aircraft_key=1.
Progress update 2025-01-21 09:18:21.573191+00:00 : Number rows selected : 11.
Progress update 2025-01-21 09:18:21.573191+00:00 : Number rows updated : 3.
Progress update 2025-01-21 09:18:21.574195+00:00 :
Progress update 2025-01-21 09:18:21.574195+00:00 : Database table : occurrences <-----------------------------------.
Progress update 2025-01-21 09:18:21.574195+00:00 : Number rows selected : 0.
Progress update 2025-01-21 09:18:21.574195+00:00 :
Progress update 2025-01-21 09:18:21.574195+00:00 : Database table : dt_flight_crew <-----------------------------------.
Progress update 2025-01-21 09:18:21.575194+00:00 : Number rows selected : 0.
Progress update 2025-01-21 09:18:21.575194+00:00 :
Progress update 2025-01-21 09:18:21.575194+00:00 : Database table : flight_time <-----------------------------------.
Progress update 2025-01-21 09:18:21.575194+00:00 : Number rows selected : 0.
Progress update 2025-01-21 09:18:21.575194+00:00 :
Progress update 2025-01-21 09:18:21.575194+00:00 : Database table : seq_of_events <-----------------------------------.
Progress update 2025-01-21 09:18:21.576194+00:00 : Number rows selected : 0.
Progress update 2025-01-21 09:18:22.533857+00:00 : INFO.00.065 Cleansing PostgreSQL data.
Progress update 2025-01-21 09:18:22.533857+00:00 : --------------------------------------------------------------------------------
2025-01-21 10:18:22,534 [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-01-21 09:18:22.643182+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'acft_category'.
Progress update 2025-01-21 09:18:25.371814+00:00 : --------------------------------------------------------------------------------
Progress update 2025-01-21 09:18:25.371814+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'dest_country'.
Progress update 2025-01-21 09:18:26.524479+00:00 : --------------------------------------------------------------------------------
Progress update 2025-01-21 09:18:26.524479+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'dprt_country'.
Progress update 2025-01-21 09:18:27.676461+00:00 : --------------------------------------------------------------------------------
Progress update 2025-01-21 09:18:27.676461+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'far_part'.
Progress update 2025-01-21 09:18:28.816672+00:00 : --------------------------------------------------------------------------------
Progress update 2025-01-21 09:18:28.816672+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'oper_country'.
Progress update 2025-01-21 09:18:29.928877+00:00 : --------------------------------------------------------------------------------
Progress update 2025-01-21 09:18:29.929877+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'owner_country'.
Progress update 2025-01-21 09:18:31.040396+00:00 : --------------------------------------------------------------------------------
Progress update 2025-01-21 09:18:31.041396+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'regis_no'.
Progress update 2025-01-21 09:18:32.099694+00:00 : --------------------------------------------------------------------------------
Progress update 2025-01-21 09:18:32.099694+00:00 : INFO.00.066 Cleansing table 'events' column 'ev_city'.
Progress update 2025-01-21 09:18:37.117618+00:00 : --------------------------------------------------------------------------------
Progress update 2025-01-21 09:18:37.117618+00:00 : INFO.00.066 Cleansing table 'events' column 'ev_site_zipcode'.
Progress update 2025-01-21 09:18:39.448591+00:00 : --------------------------------------------------------------------------------
Progress update 2025-01-21 09:18:39.448591+00:00 : INFO.00.066 Cleansing table 'events' column 'latitude'.
Progress update 2025-01-21 09:18:41.765662+00:00 : --------------------------------------------------------------------------------
Progress update 2025-01-21 09:18:41.765662+00:00 : INFO.00.066 Cleansing table 'events' column 'longitude'.
Progress update 2025-01-21 09:18:44.077724+00:00 : --------------------------------------------------------------------------------
Progress update 2025-01-21 09:18:44.078728+00:00 : INFO.00.066 Cleansing table 'events_sequence' column 'occurrence_code'.
Progress update 2025-01-21 09:18:44.380219+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-01-21 09:18:44.381220+00:00 : 40 s - Total time launcher.
Progress update 2025-01-21 09:18:44.381220+00:00 : INFO.00.006 End Launcher.
Progress update 2025-01-21 09:18:44.381220+00:00 : ===============================================================================.
2025-01-21 10:18:45,938 [root] [io_logger.py ] INFO You are using io-aero's iocommon version 1.2.63 logger (Copyright (c) 2022-2024 IO-Aero)
2025-01-21 10:18:45,938 [root] [io_settings.py ] INFO Starting the configuration management system.
2025-01-21 10:18:45,939 [root] [io_settings.py ] INFO Running in a source (non-compiled) environment. Configuration loading from: D:\SoftDevelopment\Projects\IO-Aero\io-avstats
2025-01-21 10:18:45,939 [root] [io_settings.py ] INFO Dynaconf settings loaded successfully.
Progress update 2025-01-21 09:18:47.361902+00:00 : ===============================================================================.
Progress update 2025-01-21 09:18:47.361902+00:00 : INFO.00.004 Start Launcher.
2025-01-21 10:18:47,361 [root] [launcher.py ] INFO param argv=['scripts\\launcher.py', '-t', 'c_l_l']
2025-01-21 10:18:47,361 [root] [launcher.py ] INFO Start launcher.py
2025-01-21 10:18:47,373 [root] [launcher.py ] INFO locale=('en_US', 'UTF-8')
Progress update 2025-01-21 09:18:47.374902+00:00 : INFO.00.005 Argument task='c_l_l'.
Progress update 2025-01-21 09:18:47.374902+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-01-21 09:18:47.374902+00:00 : INFO.00.040 Correct decimal US latitudes and longitudes.
Progress update 2025-01-21 09:18:47.374902+00:00 : --------------------------------------------------------------------------------
2025-01-21 10:18:47,375 [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-01-21 09:18:50.715367+00:00 : INFO.00.063 Processed data source 'events'.
Progress update 2025-01-21 09:18:50.715367+00:00 : Number cols deleted : 60542.
Progress update 2025-01-21 09:18:50.715886+00:00 : --------------------------------------------------------------------------------
2025-01-21 10:18:50,715 [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-01-21 09:18:59.753587+00:00 : Number of rows so far read : 10000.
Progress update 2025-01-21 09:19:05.227647+00:00 : Number of rows so far read : 20000.
Progress update 2025-01-21 09:19:10.526008+00:00 : Number of rows so far read : 30000.
Progress update 2025-01-21 09:19:15.784994+00:00 : Number of rows so far read : 40000.
Progress update 2025-01-21 09:19:21.098345+00:00 : Number of rows so far read : 50000.
Progress update 2025-01-21 09:19:26.421951+00:00 : Number of rows so far read : 60000.
Progress update 2025-01-21 09:19:31.731786+00:00 : Number of rows so far read : 70000.
Progress update 2025-01-21 09:19:37.094619+00:00 : Number of rows so far read : 80000.
Progress update 2025-01-21 09:19:42.386705+00:00 : Number of rows so far read : 90000.
Progress update 2025-01-21 09:19:47.699018+00:00 : Number of rows so far read : 100000.
Progress update 2025-01-21 09:19:53.049682+00:00 : Number of rows so far read : 110000.
Progress update 2025-01-21 09:19:58.327140+00:00 : Number of rows so far read : 120000.
Progress update 2025-01-21 09:20:03.769727+00:00 : Number of rows so far read : 130000.
Progress update 2025-01-21 09:20:09.110585+00:00 : Number of rows so far read : 140000.
Progress update 2025-01-21 09:20:10.643772+00:00 : Number rows selected : 142621.
Progress update 2025-01-21 09:20:10.644302+00:00 : Number rows updated : 142621.
Progress update 2025-01-21 09:20:10.670615+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-01-21 09:20:10.671615+00:00 : 83 s - Total time launcher.
Progress update 2025-01-21 09:20:10.671615+00:00 : INFO.00.006 End Launcher.
Progress update 2025-01-21 09:20:10.671615+00:00 : ===============================================================================.
2025-01-21 10:20:12,261 [root] [io_logger.py ] INFO You are using io-aero's iocommon version 1.2.63 logger (Copyright (c) 2022-2024 IO-Aero)
2025-01-21 10:20:12,262 [root] [io_settings.py ] INFO Starting the configuration management system.
2025-01-21 10:20:12,262 [root] [io_settings.py ] INFO Running in a source (non-compiled) environment. Configuration loading from: D:\SoftDevelopment\Projects\IO-Aero\io-avstats
2025-01-21 10:20:12,263 [root] [io_settings.py ] INFO Dynaconf settings loaded successfully.
Progress update 2025-01-21 09:20:13.785498+00:00 : ===============================================================================.
Progress update 2025-01-21 09:20:13.785498+00:00 : INFO.00.004 Start Launcher.
2025-01-21 10:20:13,785 [root] [launcher.py ] INFO param argv=['scripts\\launcher.py', '-t', 'f_n_a']
2025-01-21 10:20:13,786 [root] [launcher.py ] INFO Start launcher.py
2025-01-21 10:20:13,797 [root] [launcher.py ] INFO locale=('en_US', 'UTF-8')
Progress update 2025-01-21 09:20:13.798670+00:00 : INFO.00.005 Argument task='f_n_a'.
Progress update 2025-01-21 09:20:13.799198+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-01-21 09:20:13.799198+00:00 : INFO.00.086 Find the nearest airports.
Progress update 2025-01-21 09:20:13.799198+00:00 : --------------------------------------------------------------------------------
2025-01-21 10:20:13,799 [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-01-21 09:20:15.533960+00:00 : INFO.00.063 Processed data source 'events'.
Progress update 2025-01-21 09:20:15.533960+00:00 : Number cols deleted : 70904.
Progress update 2025-01-21 09:20:15.534960+00:00 : --------------------------------------------------------------------------------
2025-01-21 10:20:15,534 [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-01-21 09:20:41.846214+00:00 : Number of rows so far read : 10000.
Progress update 2025-01-21 09:21:06.128707+00:00 : Number of rows so far read : 20000.
Progress update 2025-01-21 09:21:30.888953+00:00 : Number of rows so far read : 30000.
Progress update 2025-01-21 09:21:56.456481+00:00 : Number of rows so far read : 40000.
Progress update 2025-01-21 09:22:20.516970+00:00 : Number of rows so far read : 50000.
Progress update 2025-01-21 09:22:20.545601+00:00 : ERROR.00.942 Event '20220711105442': issue with the Haversine algorithm: 'Longitude -894627.0 is out of range [-180, 180]'.
Progress update 2025-01-21 09:22:44.251566+00:00 : Number of rows so far read : 60000.
Progress update 2025-01-21 09:23:08.611436+00:00 : Number of rows so far read : 70000.
Progress update 2025-01-21 09:23:10.736222+00:00 : ERROR.00.942 Event '20210419102938': issue with the Haversine algorithm: 'Latitude 4603.0 is out of range [-90, 90]'.
Progress update 2025-01-21 09:23:10.736222+00:00 : ERROR.00.942 Event '20221027106211': issue with the Haversine algorithm: 'Latitude 36940.21 is out of range [-90, 90]'.
Progress update 2025-01-21 09:23:10.736222+00:00 : ERROR.00.942 Event '20221108106263': issue with the Haversine algorithm: 'Latitude 390408.0 is out of range [-90, 90]'.
Progress update 2025-01-21 09:23:10.736222+00:00 : ERROR.00.942 Event '20220803105651': issue with the Haversine algorithm: 'Latitude 41370104.0 is out of range [-90, 90]'.
Progress update 2025-01-21 09:23:10.736222+00:00 : ERROR.00.942 Event '20221108106264': issue with the Haversine algorithm: 'Latitude 43511185.0 is out of range [-90, 90]'.
Progress update 2025-01-21 09:23:10.762173+00:00 : Number rows selected : 70910.
Progress update 2025-01-21 09:23:10.762173+00:00 : Number rows updated : 70904.
Progress update 2025-01-21 09:23:10.764170+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-01-21 09:23:10.764170+00:00 : 176 s - Total time launcher.
Progress update 2025-01-21 09:23:10.764170+00:00 : INFO.00.006 End Launcher.
Progress update 2025-01-21 09:23:10.764170+00:00 : ===============================================================================.
2025-01-21 10:23:12,450 [root] [io_logger.py ] INFO You are using io-aero's iocommon version 1.2.63 logger (Copyright (c) 2022-2024 IO-Aero)
2025-01-21 10:23:12,451 [root] [io_settings.py ] INFO Starting the configuration management system.
2025-01-21 10:23:12,451 [root] [io_settings.py ] INFO Running in a source (non-compiled) environment. Configuration loading from: D:\SoftDevelopment\Projects\IO-Aero\io-avstats
2025-01-21 10:23:12,451 [root] [io_settings.py ] INFO Dynaconf settings loaded successfully.
Progress update 2025-01-21 09:23:13.913792+00:00 : ===============================================================================.
Progress update 2025-01-21 09:23:13.913792+00:00 : INFO.00.004 Start Launcher.
2025-01-21 10:23:13,913 [root] [launcher.py ] INFO param argv=['scripts\\launcher.py', '-t', 'v_n_d']
2025-01-21 10:23:13,913 [root] [launcher.py ] INFO Start launcher.py
2025-01-21 10:23:13,925 [root] [launcher.py ] INFO locale=('en_US', 'UTF-8')
Progress update 2025-01-21 09:23:13.926299+00:00 : INFO.00.005 Argument task='v_n_d'.
Progress update 2025-01-21 09:23:13.926299+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-01-21 09:23:13.926299+00:00 : INFO.00.043 Verify selected NTSB data.
Progress update 2025-01-21 09:23:13.926299+00:00 : --------------------------------------------------------------------------------
2025-01-21 10:23:13,926 [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-01-21 09:23:14.252101+00:00 : INFO.00.063 Processed data source 'events'.
Progress update 2025-01-21 09:23:14.252101+00:00 : Number cols deleted : 24365.
Progress update 2025-01-21 09:23:14.252101+00:00 : --------------------------------------------------------------------------------
2025-01-21 10:23:14,253 [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-01-21 09:23:14.315096+00:00 : INFO.00.064 Verification of table 'events' column(s) 'latitude & longitude'.
Progress update 2025-01-21 09:23:14.315096+00:00 : --------------------------------------------------------------------------------
Progress update 2025-01-21 09:23:16.443432+00:00 : Number of rows so far read : 10000.
Progress update 2025-01-21 09:23:18.092601+00:00 : Number of rows so far read : 20000.
Progress update 2025-01-21 09:23:19.725008+00:00 : Number of rows so far read : 30000.
Progress update 2025-01-21 09:23:21.516582+00:00 : Number of rows so far read : 40000.
Progress update 2025-01-21 09:23:23.607463+00:00 : Number of rows so far read : 50000.
Progress update 2025-01-21 09:23:27.115074+00:00 : Number of rows so far read : 60000.
Progress update 2025-01-21 09:23:30.731432+00:00 : Number of rows so far read : 70000.
Progress update 2025-01-21 09:23:33.087791+00:00 : Number rows errors : 27949.
Progress update 2025-01-21 09:23:33.087791+00:00 : --------------------------------------------------------------------------------
Progress update 2025-01-21 09:23:33.087791+00:00 : INFO.00.064 Verification of table 'events' column(s) 'ev_city'.
Progress update 2025-01-21 09:23:33.557174+00:00 : Number rows errors : 6258.
Progress update 2025-01-21 09:23:33.557174+00:00 : --------------------------------------------------------------------------------
Progress update 2025-01-21 09:23:33.557712+00:00 : INFO.00.064 Verification of table 'events' column(s) 'ev_city & ev_site_zipcode'.
Progress update 2025-01-21 09:23:34.132846+00:00 : Number rows errors : 16956.
Progress update 2025-01-21 09:23:34.132846+00:00 : --------------------------------------------------------------------------------
Progress update 2025-01-21 09:23:34.132846+00:00 : INFO.00.064 Verification of table 'events' column(s) 'ev_state'.
Progress update 2025-01-21 09:23:34.173854+00:00 : Number rows errors : 176.
Progress update 2025-01-21 09:23:34.173854+00:00 : --------------------------------------------------------------------------------
Progress update 2025-01-21 09:23:34.173854+00:00 : INFO.00.064 Verification of table 'events' column(s) 'ev_site_zipcode'.
Progress update 2025-01-21 09:23:34.281401+00:00 : Number rows errors : 5140.
Progress update 2025-01-21 09:23:34.281401+00:00 : --------------------------------------------------------------------------------
Progress update 2025-01-21 09:23:34.281401+00:00 : Number rows selected : 76742.
Progress update 2025-01-21 09:23:34.282412+00:00 : Number rows updated : 56479.
Progress update 2025-01-21 09:23:34.282412+00:00 : Number rows errors : 56479.
Progress update 2025-01-21 09:23:34.285443+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-01-21 09:23:34.285443+00:00 : 20 s - Total time launcher.
Progress update 2025-01-21 09:23:34.285443+00:00 : INFO.00.006 End Launcher.
Progress update 2025-01-21 09:23:34.285443+00:00 : ===============================================================================.
2025-01-21 10:23:35,802 [root] [io_logger.py ] INFO You are using io-aero's iocommon version 1.2.63 logger (Copyright (c) 2022-2024 IO-Aero)
2025-01-21 10:23:35,802 [root] [io_settings.py ] INFO Starting the configuration management system.
2025-01-21 10:23:35,803 [root] [io_settings.py ] INFO Running in a source (non-compiled) environment. Configuration loading from: D:\SoftDevelopment\Projects\IO-Aero\io-avstats
2025-01-21 10:23:35,803 [root] [io_settings.py ] INFO Dynaconf settings loaded successfully.
Progress update 2025-01-21 09:23:37.274911+00:00 : ===============================================================================.
Progress update 2025-01-21 09:23:37.274911+00:00 : INFO.00.004 Start Launcher.
2025-01-21 10:23:37,274 [root] [launcher.py ] INFO param argv=['scripts\\launcher.py', '-t', 'r_d_s']
2025-01-21 10:23:37,274 [root] [launcher.py ] INFO Start launcher.py
2025-01-21 10:23:37,291 [root] [launcher.py ] INFO locale=('en_US', 'UTF-8')
Progress update 2025-01-21 09:23:37.292973+00:00 : INFO.00.005 Argument task='r_d_s'.
Progress update 2025-01-21 09:23:37.293973+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-01-21 09:23:37.293973+00:00 : INFO.00.071 Refreshing the database schema.
Progress update 2025-01-21 09:23:37.293973+00:00 : --------------------------------------------------------------------------------
2025-01-21 10:23:37,293 [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-01-21 09:23:37.354979+00:00 :
Progress update 2025-01-21 09:23:37.354979+00:00 : Database table : io_md_codes_eventsoe <-----------------------------------.
Progress update 2025-01-21 09:23:37.421044+00:00 : Number rows deleted : 96.
Progress update 2025-01-21 09:23:37.483253+00:00 : Number rows selected : 1557.
Progress update 2025-01-21 09:23:39.145316+00:00 : Number rows inserted : 96.
Progress update 2025-01-21 09:23:39.145316+00:00 :
Progress update 2025-01-21 09:23:39.146316+00:00 : Database table : io_md_codes_phase <-----------------------------------.
Progress update 2025-01-21 09:23:39.211856+00:00 : Number rows deleted : 48.
Progress update 2025-01-21 09:23:39.266550+00:00 : Number rows selected : 1557.
Progress update 2025-01-21 09:23:40.085922+00:00 : Number rows inserted : 48.
Progress update 2025-01-21 09:23:40.086922+00:00 :
Progress update 2025-01-21 09:23:40.086922+00:00 : --------------------------------------------------------------------------------
Progress update 2025-01-21 09:23:40.086922+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-01-21 09:23:40.086922+00:00 : --------------------------------------------------------------------------------
Progress update 2025-01-21 09:23:40.961647+00:00 : Number rows selected : 48.
Progress update 2025-01-21 09:23:40.961647+00:00 : Number rows updated : 48.
Progress update 2025-01-21 09:23:40.962647+00:00 :
Progress update 2025-01-21 09:23:40.962647+00:00 : Database table : io_md_codes_category <-----------------------------------.
Progress update 2025-01-21 09:23:41.111551+00:00 : Number rows deleted : 5.
Progress update 2025-01-21 09:23:41.710311+00:00 : Number rows selected : 7607.
Progress update 2025-01-21 09:23:41.794643+00:00 : Number rows inserted : 5.
Progress update 2025-01-21 09:23:41.795649+00:00 :
Progress update 2025-01-21 09:23:41.795649+00:00 : Database table : io_md_codes_subcategory <-----------------------------------.
Progress update 2025-01-21 09:23:42.043583+00:00 : Number rows selected : 7607.
Progress update 2025-01-21 09:23:42.411388+00:00 : Number rows inserted : 21.
Progress update 2025-01-21 09:23:42.412388+00:00 :
Progress update 2025-01-21 09:23:42.412388+00:00 : Database table : io_md_codes_section <-----------------------------------.
Progress update 2025-01-21 09:23:42.669512+00:00 : Number rows selected : 7607.
Progress update 2025-01-21 09:23:44.910342+00:00 : Number rows inserted : 129.
Progress update 2025-01-21 09:23:44.911344+00:00 :
Progress update 2025-01-21 09:23:44.911344+00:00 : Database table : io_md_codes_subsection <-----------------------------------.
Progress update 2025-01-21 09:23:45.175320+00:00 : Number rows selected : 7607.
Progress update 2025-01-21 09:24:00.273611+00:00 : Number rows inserted : 774.
Progress update 2025-01-21 09:24:00.274611+00:00 :
Progress update 2025-01-21 09:24:00.274611+00:00 : Database table : io_md_codes_modifier <-----------------------------------.
Progress update 2025-01-21 09:24:00.351009+00:00 : Number rows deleted : 74.
Progress update 2025-01-21 09:24:00.593809+00:00 : Number rows selected : 7607.
Progress update 2025-01-21 09:24:02.198076+00:00 : Number rows inserted : 74.
Progress update 2025-01-21 09:27:22.304439+00:00 : INFO.00.069 Materialized database view is refreshed: io_app_ae1982.
Progress update 2025-01-21 09:27:22.304439+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-01-21 09:27:22.304957+00:00 : 225 s - Total time launcher.
Progress update 2025-01-21 09:27:22.304957+00:00 : INFO.00.006 End Launcher.
Progress update 2025-01-21 09:27:22.304957+00:00 : ===============================================================================.
---------------------------------------------------------------------------
The current time is: 10:27:22.87
Enter the new time:
---------------------------------------------------------------------------
End run_io_avstats_dev
===========================================================================