===========================================================================
Start run_io_avstats_dev
---------------------------------------------------------------------------
IO-AVSTATS - Aviation Event Statistics.
---------------------------------------------------------------------------
ENV_FOR_DYNACONF : prod
PYTHONPATH : .
---------------------------------------------------------------------------
TASK : u_p_d
APPLICATION :
COMPOSE_TASK :
MSACCESS : up01FEB
MSEXCEL :
---------------------------------------------------------------------------
The current time is: 2:12:46.04
Enter the new time:
===========================================================================
2025-02-03 02:12:47,329 [root] [io_logger.py ] INFO You are using io-aero's iocommon version 1.2.63 logger (Copyright (c) 2022-2024 IO-Aero)
2025-02-03 02:12:47,329 [root] [io_settings.py ] INFO Starting the configuration management system.
2025-02-03 02:12:47,329 [root] [io_settings.py ] INFO Running in a source (non-compiled) environment. Configuration loading from: D:\SoftDevelopment\Projects\IO-Aero\io-avstats
2025-02-03 02:12:47,332 [root] [io_settings.py ] INFO Dynaconf settings loaded successfully.
Progress update 2025-02-03 01:12:49.130434+00:00 : ===============================================================================.
Progress update 2025-02-03 01:12:49.130434+00:00 : INFO.00.004 Start Launcher.
2025-02-03 02:12:49,130 [root] [launcher.py ] INFO param argv=['scripts\\launcher.py', '-t', 'd_n_a', '-m', 'up01FEB']
2025-02-03 02:12:49,130 [root] [launcher.py ] INFO Start launcher.py
2025-02-03 02:12:49,142 [root] [launcher.py ] INFO locale=('en_US', 'UTF-8')
Progress update 2025-02-03 01:12:49.143436+00:00 : INFO.00.008 Arguments task='d_n_a' msaccess='up01FEB'.
Progress update 2025-02-03 01:12:49.143436+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-03 01:12:49.143436+00:00 : INFO.00.047 Download NTSB MS Access database file 'up01FEB'.
Progress update 2025-02-03 01:12:49.143436+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-03 01:12:49.543220+00:00 : INFO.00.013 The connection to the MS Access database file 'up01FEB.zip' on the NTSB download page was successfully established.
Progress update 2025-02-03 01:12:49.915336+00:00 : INFO.00.014 From the file 'up01FEB.zip' 2 chunks were downloaded.
Progress update 2025-02-03 01:12:49.927601+00:00 : INFO.00.015 The file 'up01FEB.zip' was successfully unpacked.
Progress update 2025-02-03 01:12:49.985678+00:00 : INFO.00.051 msaccess_file='D:\SoftDevelopment\Projects\IO-Aero\io-avstats\data\download\IO-AVSTATS.mdb'.
Progress update 2025-02-03 01:12:49.985678+00:00 : INFO.00.051 msaccess_file='D:\SoftDevelopment\Projects\IO-Aero\io-avstats\data\download\up01FEB.sql'.
Progress update 2025-02-03 01:12:49.985678+00:00 : INFO.00.052 razorsql_jar_file='C:\Program Files\RazorSQL\razorsql.jar'.
Progress update 2025-02-03 01:12:49.985678+00:00 : INFO.00.053 razorsql_java_path='C:\Program Files\RazorSQL\jre11\bin\java'.
1738545170110: launching RazorSQL . . .
1738545170110: args . . .
-backup
IO-AVSTATS
null
null
;
null
D:\SoftDevelopment\Projects\IO-Aero\io-avstats\data\download\up01FEB.sql
NO
tables
YES
null
NO
NO
1738545170146: userName: walte
1738545170146: libraryPath: C:\Program Files\RazorSQL\jre11\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\ProgramData\miniconda3\envs\ioavstats;C:\ProgramData\miniconda3\envs\ioavstats\Library\mingw-w64\bin;C:\ProgramData\miniconda3\envs\ioavstats\Library\usr\bin;C:\ProgramData\miniconda3\envs\ioavstats\Library\bin;C:\ProgramData\miniconda3\envs\ioavstats\Scripts;C:\ProgramData\miniconda3\envs\ioavstats\bin;C:\ProgramData\miniconda3\condabin;C:\Program Files\Python313\Scripts;C:\Program Files\Python313;C:\Program Files (x86)\infogridpacific\AZARDI;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files\dotnet;C:\Program Files\Git LFS;C:\Program Files\Microsoft SQL Server\110\Tools\Binn;C:\Program Files\NVIDIA Corporation\NVIDIA NvDLISR;C:\Software\GnuWin32\bin;C:\WINDOWS;C:\WINDOWS\System32;C:\WINDOWS\System32\OpenSSH;C:\WINDOWS\System32\wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0;\bin;\bin;\bin;C:\ProgramData\miniconda3\condabin;C:\Program Files\PostgreSQL\16\bin;C:\Software\jdk-20.0.1\bin;C:\Program Files\PuTTY;C:\Software\LAStools\bin;C:\Software\GnuPG\bin;C:\Program Files\nodejs;C:\Program Files\Calibre2;C:\Program Files\Go\bin;C:\Program Files\Git\cmd;C:\Program Files\Zero Install;C:\Program Files\GitHub CLI;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0;C:\WINDOWS\System32\OpenSSH;C:\Program Files\Docker\Docker\resources\bin;C:\Program Files\TortoiseGit\bin;C:\Program Files\Amazon\AWSCLIV2;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;.
1738545170147: javaVersion: 17.0.7
1738545170147:
1738545170147: Verifying RazorSQL resources location.
1738545170147:
1738545170148: testing base url: / = file:/C:/Program%20Files/RazorSQL/
1738545170148:
1738545170148: testString1: file:/C:/Program%20Files/RazorSQL/razorsql.jar
1738545170148: testString2: file:/C:/Program%20Files/RazorSQL/data/base.ssql
1738545170148: testFile1: C:\Program Files\RazorSQL\razorsql.jar
1738545170148: testFile2: C:\Program Files\RazorSQL\data\base.ssql
1738545170148: both test file exists. Base URL found.
1738545170148: resource directory: file:/C:/Program%20Files/RazorSQL/
1738545170148: user home: C:\Users\walte
1738545170149: user profile: C:\Users\walte
1738545170150: app data: C:\Users\walte\AppData\Roaming
1738545170150: checking write access to: C:\Users\walte\AppData\Roaming
1738545170150: write dir: C:\Users\walte\AppData\Roaming\RichardsonSoftware
1738545170150: can write to C:\Users\walte\AppData\Roaming
1738545170150: user.home: C:\Users\walte\AppData\Roaming
1738545170150: RazorSQL Scratch Directory: C:\Users\walte\AppData\Roaming\RazorSQL
1738545170150: RazorSQL Scratch Directory exists
1738545170150: checking for sub directories
1738545170150: razorsql launch log: C:\Users\walte\AppData\Roaming\RazorSQL\razorsql_launch_log.txt
1738545170151: launch log file = C:\Users\walte\AppData\Roaming\RazorSQL\razorsql_launch_log.txt
1738545170151: Checking for graphics properties
1738545170151: graphics properties file: C:\Users\walte\AppData\Roaming\RazorSQL\data\graphics_properties.txt
1738545170151: gOverride: null
1738545170151: not disabling advanced graphics
1738545170152: path0: file:/C:/Program%20Files/RazorSQL/data/run.ssql
1738545170152: path1: file:/C:/Program%20Files/RazorSQL/razorsql.jar
1738545170152: runArgs: true
1738545170152: showScreen: false
1738545170152: args[0]: -backup
1738545170152: args[1]: IO-AVSTATS
1738545170152: args[2]: null
1738545170152: args[3]: null
1738545170152: args[4]: ;
1738545170152: args[5]: null
1738545170152: args[6]: D:\SoftDevelopment\Projects\IO-Aero\io-avstats\data\download\up01FEB.sql
1738545170153: args[7]: NO
1738545170153: args[8]: tables
1738545170153: args[9]: YES
1738545170153: args[10]: null
1738545170153: args[11]: NO
1738545170153: args[12]: NO
1738545170153: Command: -backup
1738545170153: Running -backup
h: name = C:\Program Files\RazorSQL\data\run.ssql
h: name = C:\Program Files\RazorSQL\razorsql.jar
1738545170159: Attempting to load . . .
command found
uOne: file:/C:/Program%20Files/RazorSQL/
h: name = C:\Program Files\RazorSQL\data\run.ssql
1738545170170reading file . . .C:\Program Files\RazorSQL\data\base.ssql
1738545170189done reading . . .
1738545170199done converting
1738545170199starting lib load.
1738545170208lib load complete.
In command line processor
Max Memory: 30688.0
Current Total Memory: 2048.0
Free Memory: 1918.071891784668
1738545170274: r init
1738545170274: d init
1738545170274: get default file encoding
1738545170274: end d init
custom home directory: null
Checking for user data from old versions
1738545170276: user home: C:\Users\walte
1738545170276: user profile: C:\Users\walte
1738545170276: app data: C:\Users\walte\AppData\Roaming
1738545170276: checking write access to: C:\Users\walte\AppData\Roaming
1738545170276: write dir: C:\Users\walte\AppData\Roaming\RichardsonSoftware
1738545170277: 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
1738545170286: loading icons
1738545170749: done r init
Getting connection data from: IO-AVSTATS
1738545170751: r init
1738545170751: d init
1738545170751: get default file encoding
1738545170751: 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
1738545170752: loading icons
1738545170763: done r init
getting connection . . .
Not using SSH Tunnel
driver: sun.jdbc.odbc.JdbcOdbcDriver
classLocation: C:\Program Files\RazorSQL\drivers\common\odbc.jar
loadedCommonJars: false
commonURL: file:/C:/Program%20Files/RazorSQL/drivers/common/
commonDir: C:\Program Files\RazorSQL\drivers\common
commonFiles[0]: file:/C:/Program%20Files/RazorSQL/drivers/common/activation.jar
commonFiles[1]: file:/C:/Program%20Files/RazorSQL/drivers/common/common.jar
commonFiles[2]: file:/C:/Program%20Files/RazorSQL/drivers/common/jaxb-api.jar
commonFiles[3]: file:/C:/Program%20Files/RazorSQL/drivers/common/jaxb-core.jar
commonFiles[4]: file:/C:/Program%20Files/RazorSQL/drivers/common/jaxb-impl.jar
commonFiles[6]: file:/C:/Program%20Files/RazorSQL/drivers/common/odbc.jar
connection type: ODBC
final classLocation: C:\Program Files\RazorSQL\drivers\common\odbc.jar
classLocation file: C:\Program Files\RazorSQL\drivers\common\odbc.jar
building sql manager
Loading driver
Done loading driver
Getting connection with no login info
JdbcOdbcDriver: in initialize
OdbcApi == null
Creating new OdbcApi, nativePrefix:
JdbcOdbc constructor
Attempting to load JdbcOdbc library
Got OdbcApi: sun.jdbc.odbc.JdbcOdbc@77846d2c
Getting charset
JdbcOdbcDriver.OdbcApi.charSet: Cp1252
Connection obtained
obtained connection
database major version = 2
database product name: ACCESS
multiValueInsert: false
includeIdentifyColumns: false
Calling backup . . .
Retrieving Tables . . .
Generating Table DDL . . .
1 of 20
number of columns 93
column map size: 93
foundNull: false
2 of 20
number of columns 2
column map size: 2
foundNull: false
3 of 20
number of columns 11
column map size: 11
foundNull: false
4 of 20
number of columns 2
column map size: 2
foundNull: false
5 of 20
number of columns 6
column map size: 6
foundNull: false
6 of 20
number of columns 5
column map size: 5
foundNull: false
7 of 20
number of columns 7
column map size: 7
foundNull: false
8 of 20
number of columns 13
column map size: 13
foundNull: false
9 of 20
number of columns 17
column map size: 17
foundNull: false
10 of 20
number of columns 73
column map size: 73
foundNull: false
11 of 20
number of columns 10
column map size: 10
foundNull: false
12 of 20
number of columns 14
column map size: 14
foundNull: false
13 of 20
number of columns 33
column map size: 33
foundNull: false
14 of 20
number of columns 8
column map size: 8
foundNull: false
15 of 20
number of columns 7
column map size: 7
foundNull: false
16 of 20
number of columns 8
column map size: 8
foundNull: false
17 of 20
number of columns 5
column map size: 5
foundNull: false
18 of 20
number of columns 8
column map size: 8
foundNull: false
19 of 20
number of columns 11
column map size: 11
foundNull: false
20 of 20
number of columns 3
column map size: 3
foundNull: false
Generating Alter Table DDL . . .
1 of 20
2 of 20
3 of 20
4 of 20
5 of 20
6 of 20
7 of 20
8 of 20
9 of 20
10 of 20
11 of 20
12 of 20
13 of 20
14 of 20
15 of 20
16 of 20
17 of 20
18 of 20
19 of 20
20 of 20
backup finished
closing connection . . .
connection closed.
Shutting down logging streams
Done shutting down logging streams
Exiting . . .
Progress update 2025-02-03 01:12:58.804440+00:00 : INFO.00.011 The DDL script for the MS Access database 'up01FEB.mdb' was created successfully.
Progress update 2025-02-03 01:12:58.805624+00:00 : INFO.00.012 The DDL script for the MS Access database 'up01FEB.mdb' is identical to the reference script.
Progress update 2025-02-03 01:12:58.806624+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-03 01:12:58.806624+00:00 : 9 s - Total time launcher.
Progress update 2025-02-03 01:12:58.806624+00:00 : INFO.00.006 End Launcher.
Progress update 2025-02-03 01:12:58.806624+00:00 : ===============================================================================.
2025-02-03 02:13:00,502 [root] [io_logger.py ] INFO You are using io-aero's iocommon version 1.2.63 logger (Copyright (c) 2022-2024 IO-Aero)
2025-02-03 02:13:00,502 [root] [io_settings.py ] INFO Starting the configuration management system.
2025-02-03 02:13:00,502 [root] [io_settings.py ] INFO Running in a source (non-compiled) environment. Configuration loading from: D:\SoftDevelopment\Projects\IO-Aero\io-avstats
2025-02-03 02:13:00,503 [root] [io_settings.py ] INFO Dynaconf settings loaded successfully.
Progress update 2025-02-03 01:13:02.122711+00:00 : ===============================================================================.
Progress update 2025-02-03 01:13:02.123709+00:00 : INFO.00.004 Start Launcher.
2025-02-03 02:13:02,123 [root] [launcher.py ] INFO param argv=['scripts\\launcher.py', '-t', 'l_n_a', '-m', 'up01FEB']
2025-02-03 02:13:02,123 [root] [launcher.py ] INFO Start launcher.py
2025-02-03 02:13:02,134 [root] [launcher.py ] INFO locale=('en_US', 'UTF-8')
Progress update 2025-02-03 01:13:02.135709+00:00 : INFO.00.008 Arguments task='l_n_a' msaccess='up01FEB'.
Progress update 2025-02-03 01:13:02.135709+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-03 01:13:02.135709+00:00 : INFO.00.049 Load NTSB MS Access database data from file 'up01FEB'.
Progress update 2025-02-03 01:13:02.135709+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-03 01:13:02.136715+00:00 : INFO.00.054 ODBC driver='DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=D:\SoftDevelopment\Projects\IO-Aero\io-avstats\data\download\up01FEB.mdb;'.
2025-02-03 02:13:02,503 [root] [db_utils.py ] INFO INFO.00.080 Admin connect request host=localhost port=5432 dbname=io_aero_db user=io_aero
Progress update 2025-02-03 01:13:02.619126+00:00 : INFO.00.021 The following database table is not processed: 'MSysAccessObjects'.
Progress update 2025-02-03 01:13:02.619126+00:00 : INFO.00.021 The following database table is not processed: 'MSysACEs'.
Progress update 2025-02-03 01:13:02.619126+00:00 : INFO.00.021 The following database table is not processed: 'MSysIMEXColumns'.
Progress update 2025-02-03 01:13:02.620125+00:00 : INFO.00.021 The following database table is not processed: 'MSysIMEXSpecs'.
Progress update 2025-02-03 01:13:02.620125+00:00 : INFO.00.021 The following database table is not processed: 'MSysModules2'.
Progress update 2025-02-03 01:13:02.620125+00:00 : INFO.00.021 The following database table is not processed: 'MSysNavPaneGroupCategories'.
Progress update 2025-02-03 01:13:02.620125+00:00 : INFO.00.021 The following database table is not processed: 'MSysNavPaneGroups'.
Progress update 2025-02-03 01:13:02.620125+00:00 : INFO.00.021 The following database table is not processed: 'MSysNavPaneGroupToObjects'.
Progress update 2025-02-03 01:13:02.620125+00:00 : INFO.00.021 The following database table is not processed: 'MSysNavPaneObjectIDs'.
Progress update 2025-02-03 01:13:02.620125+00:00 : INFO.00.021 The following database table is not processed: 'MSysObjects'.
Progress update 2025-02-03 01:13:02.620125+00:00 : INFO.00.021 The following database table is not processed: 'MSysQueries'.
Progress update 2025-02-03 01:13:02.621124+00:00 : INFO.00.021 The following database table is not processed: 'MSysRelationships'.
Progress update 2025-02-03 01:13:02.621124+00:00 : INFO.00.021 The following database table is not processed: 'Country'.
Progress update 2025-02-03 01:13:02.621124+00:00 : INFO.00.021 The following database table is not processed: 'ct_iaids'.
Progress update 2025-02-03 01:13:02.621124+00:00 : INFO.00.021 The following database table is not processed: 'ct_seqevt'.
Progress update 2025-02-03 01:13:02.621124+00:00 : INFO.00.021 The following database table is not processed: 'eADMSPUB_DataDictionary'.
Progress update 2025-02-03 01:13:02.621124+00:00 : INFO.00.021 The following database table is not processed: 'states'.
Progress update 2025-02-03 01:13:02.621124+00:00 :
Progress update 2025-02-03 01:13:02.622124+00:00 : Database table : events <-----------------------------------.
Progress update 2025-02-03 01:13:02.718800+00:00 : Inserted ev_id=20250107199517 ev_year=2025.
Progress update 2025-02-03 01:13:02.743419+00:00 : Inserted ev_id=20250122199583 ev_year=2025.
Progress update 2025-02-03 01:13:02.834970+00:00 : Updated ev_id=20221115106294 ev_year=2022.
Progress update 2025-02-03 01:13:02.877542+00:00 : Updated ev_id=20231031193330 ev_year=2023.
Progress update 2025-02-03 01:13:02.910548+00:00 : Updated ev_id=20240620194502 ev_year=2024.
Progress update 2025-02-03 01:13:02.935370+00:00 : Inserted ev_id=20241220199454 ev_year=2024.
Progress update 2025-02-03 01:13:02.960369+00:00 : Updated ev_id=20250101199498 ev_year=2024.
Progress update 2025-02-03 01:13:02.985369+00:00 : Inserted ev_id=20250121199566 ev_year=2025.
Progress update 2025-02-03 01:13:03.010662+00:00 : Inserted ev_id=20250104199505 ev_year=2025.
Progress update 2025-02-03 01:13:03.034752+00:00 : Inserted ev_id=20241231199495 ev_year=2024.
Progress update 2025-02-03 01:13:03.059757+00:00 : Inserted ev_id=20250116199556 ev_year=2025.
Progress update 2025-02-03 01:13:03.085420+00:00 : Inserted ev_id=20250122199577 ev_year=2025.
Progress update 2025-02-03 01:13:03.109933+00:00 : Inserted ev_id=20250111199529 ev_year=2025.
Progress update 2025-02-03 01:13:03.136865+00:00 : Inserted ev_id=20250122199580 ev_year=2025.
Progress update 2025-02-03 01:13:03.168871+00:00 : Inserted ev_id=20250122199579 ev_year=2025.
Progress update 2025-02-03 01:13:03.193872+00:00 : Inserted ev_id=20250122199585 ev_year=2024.
Progress update 2025-02-03 01:13:03.238386+00:00 : Inserted ev_id=20241223199462 ev_year=2024.
Progress update 2025-02-03 01:13:03.285505+00:00 : Updated ev_id=20240729194783 ev_year=2024.
Progress update 2025-02-03 01:13:03.310511+00:00 : Updated ev_id=20240816194941 ev_year=2024.
Progress update 2025-02-03 01:13:03.336020+00:00 : Updated ev_id=20241112195476 ev_year=2024.
Progress update 2025-02-03 01:13:03.360136+00:00 : Updated ev_id=20241113195481 ev_year=2024.
Progress update 2025-02-03 01:13:03.395302+00:00 : Inserted ev_id=20241128195559 ev_year=2024.
Progress update 2025-02-03 01:13:03.437819+00:00 : Inserted ev_id=20241230199492 ev_year=2024.
Progress update 2025-02-03 01:13:03.468332+00:00 : Inserted ev_id=20250107199510 ev_year=2025.
Progress update 2025-02-03 01:13:03.493207+00:00 : Inserted ev_id=20250123199588 ev_year=2025.
Progress update 2025-02-03 01:13:03.518419+00:00 : Inserted ev_id=20250103199504 ev_year=2025.
Progress update 2025-02-03 01:13:03.543329+00:00 : Inserted ev_id=20250107199514 ev_year=2024.
Progress update 2025-02-03 01:13:03.568247+00:00 : Inserted ev_id=20250124199593 ev_year=2025.
Progress update 2025-02-03 01:13:03.593246+00:00 : Inserted ev_id=20250124199594 ev_year=2025.
Progress update 2025-02-03 01:13:03.618251+00:00 : Inserted ev_id=20250127199598 ev_year=2025.
Progress update 2025-02-03 01:13:03.643763+00:00 : Inserted ev_id=20250127199602 ev_year=2025.
Progress update 2025-02-03 01:13:03.668936+00:00 : Inserted ev_id=20250106199509 ev_year=2025.
Progress update 2025-02-03 01:13:03.692860+00:00 : Inserted ev_id=20250124199591 ev_year=2025.
Progress update 2025-02-03 01:13:03.718868+00:00 : Inserted ev_id=20250127199605 ev_year=2024.
Progress update 2025-02-03 01:13:03.743947+00:00 : Inserted ev_id=20250127199608 ev_year=2025.
Progress update 2025-02-03 01:13:03.768947+00:00 : Inserted ev_id=20250106199507 ev_year=2025.
Progress update 2025-02-03 01:13:03.793482+00:00 : Inserted ev_id=20250128199610 ev_year=2025.
Progress update 2025-02-03 01:13:03.818965+00:00 : Inserted ev_id=20250117199561 ev_year=2025.
Progress update 2025-02-03 01:13:03.843036+00:00 : Inserted ev_id=20250121199567 ev_year=2025.
Progress update 2025-02-03 01:13:03.868376+00:00 : Inserted ev_id=20241218199442 ev_year=2024.
Progress update 2025-02-03 01:13:03.893333+00:00 : Inserted ev_id=20250122199582 ev_year=2025.
Progress update 2025-02-03 01:13:03.918001+00:00 : Inserted ev_id=20250113199533 ev_year=2025.
Progress update 2025-02-03 01:13:03.943012+00:00 : Updated ev_id=20241231199497 ev_year=2024.
Progress update 2025-02-03 01:13:03.977458+00:00 : Inserted ev_id=20250113199532 ev_year=2025.
Progress update 2025-02-03 01:13:04.001965+00:00 : Inserted ev_id=20250128199611 ev_year=2025.
Progress update 2025-02-03 01:13:04.027012+00:00 : Inserted ev_id=20250126199597 ev_year=2025.
Progress update 2025-02-03 01:13:04.051430+00:00 : Inserted ev_id=20250129199615 ev_year=2025.
Progress update 2025-02-03 01:13:04.076764+00:00 : Inserted ev_id=20250129199617 ev_year=2025.
Progress update 2025-02-03 01:13:04.110279+00:00 : Inserted ev_id=20250125199596 ev_year=2025.
Progress update 2025-02-03 01:13:04.134787+00:00 : Updated ev_id=20221115106296 ev_year=2022.
Progress update 2025-02-03 01:13:04.159791+00:00 : Updated ev_id=20221223106489 ev_year=2022.
Progress update 2025-02-03 01:13:04.184788+00:00 : Updated ev_id=20230110106561 ev_year=2023.
Progress update 2025-02-03 01:13:04.210665+00:00 : Updated ev_id=20230326106956 ev_year=2023.
Progress update 2025-02-03 01:13:04.243267+00:00 : Updated ev_id=20230406107019 ev_year=2023.
Progress update 2025-02-03 01:13:04.268289+00:00 : Updated ev_id=20230630192493 ev_year=2023.
Progress update 2025-02-03 01:13:04.293856+00:00 : Updated ev_id=20230703192503 ev_year=2023.
Progress update 2025-02-03 01:13:04.318366+00:00 : Updated ev_id=20230712192609 ev_year=2023.
Progress update 2025-02-03 01:13:04.343626+00:00 : Updated ev_id=20240722194742 ev_year=2024.
Progress update 2025-02-03 01:13:04.368448+00:00 : Inserted ev_id=20250103199502 ev_year=2025.
Progress update 2025-02-03 01:13:04.393270+00:00 : Inserted ev_id=20250129199618 ev_year=2025.
Progress update 2025-02-03 01:13:04.418016+00:00 : Inserted ev_id=20250124199592 ev_year=2025.
Progress update 2025-02-03 01:13:04.443592+00:00 : Updated ev_id=20071115X01799 ev_year=2007.
Progress update 2025-02-03 01:13:04.468105+00:00 : Updated ev_id=20070508X00530 ev_year=2007.
Progress update 2025-02-03 01:13:04.493454+00:00 : Inserted ev_id=20250130199625 ev_year=2025.
Progress update 2025-02-03 01:13:04.518250+00:00 : Updated ev_id=20070530X00665 ev_year=2007.
Progress update 2025-02-03 01:13:04.543017+00:00 : Updated ev_id=20241230199488 ev_year=2024.
Progress update 2025-02-03 01:13:04.571183+00:00 : Updated ev_id=20241231199496 ev_year=2024.
Progress update 2025-02-03 01:13:04.679994+00:00 : Inserted ev_id=20250116199555 ev_year=2025.
Progress update 2025-02-03 01:13:04.788512+00:00 : Updated ev_id=20070228X00236 ev_year=2007.
Progress update 2025-02-03 01:13:04.809515+00:00 : Inserted ev_id=20250122199578 ev_year=2025.
Progress update 2025-02-03 01:13:04.860075+00:00 : Updated ev_id=20241112195479 ev_year=2024.
Progress update 2025-02-03 01:13:04.884219+00:00 : Inserted ev_id=20250130199623 ev_year=2025.
Progress update 2025-02-03 01:13:04.910223+00:00 : Inserted ev_id=20250128199612 ev_year=2025.
Progress update 2025-02-03 01:13:04.934733+00:00 : Inserted ev_id=20250130199627 ev_year=2025.
Progress update 2025-02-03 01:13:04.959732+00:00 : Inserted ev_id=20250131199629 ev_year=2025.
Progress update 2025-02-03 01:13:04.984733+00:00 : Updated ev_id=20241016195324 ev_year=2024.
Progress update 2025-02-03 01:13:05.009736+00:00 : Inserted ev_id=20250106199508 ev_year=2025.
Progress update 2025-02-03 01:13:05.034246+00:00 : Inserted ev_id=20250113199531 ev_year=2024.
Progress update 2025-02-03 01:13:05.059250+00:00 : Inserted ev_id=20250115199551 ev_year=2025.
Progress update 2025-02-03 01:13:05.084312+00:00 : Inserted ev_id=20250116199557 ev_year=2025.
Progress update 2025-02-03 01:13:05.084312+00:00 : Number rows selected : 80.
Progress update 2025-02-03 01:13:05.085313+00:00 : Number rows inserted : 54.
Progress update 2025-02-03 01:13:05.085313+00:00 : Number rows updated : 26.
Progress update 2025-02-03 01:13:05.085313+00:00 :
Progress update 2025-02-03 01:13:05.085313+00:00 : Database table : aircraft <-----------------------------------.
Progress update 2025-02-03 01:13:05.197336+00:00 : Updated ev_id=20221115106294 aircraft_key=1.
Progress update 2025-02-03 01:13:05.226853+00:00 : Updated ev_id=20231031193330 aircraft_key=1.
Progress update 2025-02-03 01:13:05.251856+00:00 : Updated ev_id=20240620194502 aircraft_key=1.
Progress update 2025-02-03 01:13:05.309940+00:00 : Updated ev_id=20250101199498 aircraft_key=1.
Progress update 2025-02-03 01:13:05.584395+00:00 : Updated ev_id=20240729194783 aircraft_key=1.
Progress update 2025-02-03 01:13:05.610040+00:00 : Updated ev_id=20240816194941 aircraft_key=1.
Progress update 2025-02-03 01:13:05.634548+00:00 : Updated ev_id=20241112195476 aircraft_key=1.
Progress update 2025-02-03 01:13:05.659553+00:00 : Updated ev_id=20241113195481 aircraft_key=1.
Progress update 2025-02-03 01:13:06.292592+00:00 : Updated ev_id=20241231199497 aircraft_key=1.
Progress update 2025-02-03 01:13:06.484156+00:00 : Updated ev_id=20221115106296 aircraft_key=1.
Progress update 2025-02-03 01:13:06.509161+00:00 : Updated ev_id=20221223106489 aircraft_key=1.
Progress update 2025-02-03 01:13:06.534669+00:00 : Updated ev_id=20230110106561 aircraft_key=1.
Progress update 2025-02-03 01:13:06.584593+00:00 : Updated ev_id=20230326106956 aircraft_key=1.
Progress update 2025-02-03 01:13:06.609745+00:00 : Updated ev_id=20230406107019 aircraft_key=1.
Progress update 2025-02-03 01:13:06.634256+00:00 : Updated ev_id=20230630192493 aircraft_key=1.
Progress update 2025-02-03 01:13:06.659259+00:00 : Updated ev_id=20230703192503 aircraft_key=1.
Progress update 2025-02-03 01:13:06.684315+00:00 : Updated ev_id=20230712192609 aircraft_key=1.
Progress update 2025-02-03 01:13:06.709319+00:00 : Updated ev_id=20240722194742 aircraft_key=1.
Progress update 2025-02-03 01:13:06.826344+00:00 : Updated ev_id=20071115X01799 aircraft_key=1.
Progress update 2025-02-03 01:13:06.867861+00:00 : Updated ev_id=20070508X00530 aircraft_key=1.
Progress update 2025-02-03 01:13:06.917779+00:00 : Updated ev_id=20070530X00665 aircraft_key=1.
Progress update 2025-02-03 01:13:06.966148+00:00 : Updated ev_id=20241230199488 aircraft_key=1.
Progress update 2025-02-03 01:13:07.017811+00:00 : Updated ev_id=20241231199496 aircraft_key=1.
Progress update 2025-02-03 01:13:07.084316+00:00 : Updated ev_id=20070228X00236 aircraft_key=1.
Progress update 2025-02-03 01:13:07.134299+00:00 : Updated ev_id=20241112195479 aircraft_key=1.
Progress update 2025-02-03 01:13:07.258813+00:00 : Updated ev_id=20241016195324 aircraft_key=1.
Progress update 2025-02-03 01:13:07.375945+00:00 : Number rows selected : 82.
Progress update 2025-02-03 01:13:07.375945+00:00 : Number rows inserted : 56.
Progress update 2025-02-03 01:13:07.375945+00:00 : Number rows updated : 26.
Progress update 2025-02-03 01:13:07.375945+00:00 :
Progress update 2025-02-03 01:13:07.375945+00:00 : Database table : dt_events <-----------------------------------.
Progress update 2025-02-03 01:13:07.508695+00:00 : Updated ev_id=20221115106294 col_name=launch code=None.
Progress update 2025-02-03 01:13:07.563210+00:00 : Updated ev_id=20221115106294 col_name=wx_brief_src0 code=UNK.
Progress update 2025-02-03 01:13:07.592232+00:00 : Updated ev_id=20231031193330 col_name=launch code=Part.
Progress update 2025-02-03 01:13:07.617383+00:00 : Updated ev_id=20231031193330 col_name=spec_hand code=TDA.
Progress update 2025-02-03 01:13:07.642895+00:00 : Updated ev_id=20231031193330 col_name=icing_actual_amt code=NONE.
Progress update 2025-02-03 01:13:07.668405+00:00 : Updated ev_id=20231031193330 col_name=icing_actual_type code=NA.
Progress update 2025-02-03 01:13:07.691961+00:00 : Updated ev_id=20231031193330 col_name=icing_forecast_amt code=NONE.
Progress update 2025-02-03 01:13:07.718060+00:00 : Updated ev_id=20231031193330 col_name=icing_forecast_type code=NA.
Progress update 2025-02-03 01:13:07.742565+00:00 : Updated ev_id=20231031193330 col_name=turb_fc_type code=NONE.
Progress update 2025-02-03 01:13:07.767946+00:00 : Updated ev_id=20231031193330 col_name=turb_severity code=NA.
Progress update 2025-02-03 01:13:07.792356+00:00 : Updated ev_id=20231031193330 col_name=turb_type code=NONE.
Progress update 2025-02-03 01:13:07.817415+00:00 : Updated ev_id=20231031193330 col_name=wx_brief_src0 code=UNK.
Progress update 2025-02-03 01:13:07.842328+00:00 : Updated ev_id=20240620194502 col_name=launch code=None.
Progress update 2025-02-03 01:13:07.866843+00:00 : Updated ev_id=20240620194502 col_name=icing_actual_amt code=NONE.
Progress update 2025-02-03 01:13:07.892110+00:00 : Updated ev_id=20240620194502 col_name=icing_actual_type code=NA.
Progress update 2025-02-03 01:13:07.917551+00:00 : Updated ev_id=20240620194502 col_name=icing_forecast_amt code=NONE.
Progress update 2025-02-03 01:13:07.942312+00:00 : Updated ev_id=20240620194502 col_name=icing_forecast_type code=NA.
Progress update 2025-02-03 01:13:07.967291+00:00 : Updated ev_id=20240620194502 col_name=turb_fc_type code=NONE.
Progress update 2025-02-03 01:13:07.992317+00:00 : Updated ev_id=20240620194502 col_name=turb_severity code=NA.
Progress update 2025-02-03 01:13:08.017034+00:00 : Updated ev_id=20240620194502 col_name=turb_type code=NONE.
Progress update 2025-02-03 01:13:09.475421+00:00 : Updated ev_id=20240729194783 col_name=launch code=None.
Progress update 2025-02-03 01:13:09.525364+00:00 : Updated ev_id=20240816194941 col_name=launch code=None.
Progress update 2025-02-03 01:13:09.549820+00:00 : Updated ev_id=20240816194941 col_name=icing_actual_amt code=UNKN.
Progress update 2025-02-03 01:13:09.575820+00:00 : Updated ev_id=20240816194941 col_name=icing_actual_type code=NA.
Progress update 2025-02-03 01:13:09.599826+00:00 : Updated ev_id=20240816194941 col_name=icing_forecast_amt code=NONE.
Progress update 2025-02-03 01:13:09.624659+00:00 : Updated ev_id=20240816194941 col_name=icing_forecast_type code=NA.
Progress update 2025-02-03 01:13:09.650174+00:00 : Updated ev_id=20240816194941 col_name=turb_fc_type code=NONE.
Progress update 2025-02-03 01:13:09.675307+00:00 : Updated ev_id=20240816194941 col_name=turb_severity code=NA.
Progress update 2025-02-03 01:13:09.700309+00:00 : Updated ev_id=20240816194941 col_name=turb_type code=NONE.
Progress update 2025-02-03 01:13:09.725312+00:00 : Updated ev_id=20240816194941 col_name=wx_brief_src code=AUTR.
Progress update 2025-02-03 01:13:09.750448+00:00 : Updated ev_id=20241112195476 col_name=launch code=None.
Progress update 2025-02-03 01:13:09.775448+00:00 : Updated ev_id=20241112195476 col_name=icing_actual_amt code=NONE.
Progress update 2025-02-03 01:13:09.799958+00:00 : Updated ev_id=20241112195476 col_name=icing_actual_type code=NA.
Progress update 2025-02-03 01:13:09.824964+00:00 : Updated ev_id=20241112195476 col_name=icing_forecast_amt code=NONE.
Progress update 2025-02-03 01:13:09.849982+00:00 : Updated ev_id=20241112195476 col_name=icing_forecast_type code=NA.
Progress update 2025-02-03 01:13:09.875668+00:00 : Updated ev_id=20241112195476 col_name=turb_fc_type code=NONE.
Progress update 2025-02-03 01:13:09.932874+00:00 : Updated ev_id=20241112195476 col_name=turb_severity code=NA.
Progress update 2025-02-03 01:13:09.975090+00:00 : Updated ev_id=20241112195476 col_name=turb_type code=NONE.
Progress update 2025-02-03 01:13:10.000181+00:00 : Updated ev_id=20241112195476 col_name=wx_brief_src code=NET.
Progress update 2025-02-03 01:13:10.025186+00:00 : Updated ev_id=20241113195481 col_name=launch code=None.
Progress update 2025-02-03 01:13:10.058809+00:00 : Updated ev_id=20241113195481 col_name=icing_actual_amt code=NONE.
Progress update 2025-02-03 01:13:10.083123+00:00 : Updated ev_id=20241113195481 col_name=icing_actual_type code=NA.
Progress update 2025-02-03 01:13:10.108038+00:00 : Updated ev_id=20241113195481 col_name=icing_forecast_amt code=NONE.
Progress update 2025-02-03 01:13:10.133344+00:00 : Updated ev_id=20241113195481 col_name=icing_forecast_type code=NA.
Progress update 2025-02-03 01:13:10.158192+00:00 : Updated ev_id=20241113195481 col_name=turb_fc_type code=NONE.
Progress update 2025-02-03 01:13:10.183195+00:00 : Updated ev_id=20241113195481 col_name=turb_severity code=NA.
Progress update 2025-02-03 01:13:10.208193+00:00 : Updated ev_id=20241113195481 col_name=turb_type code=NONE.
Progress update 2025-02-03 01:13:10.233196+00:00 : Updated ev_id=20241113195481 col_name=wx_brief_src code=COWX.
Progress update 2025-02-03 01:13:12.016342+00:00 : Updated ev_id=20241231199497 col_name=launch code=None.
Progress update 2025-02-03 01:13:12.791376+00:00 : Updated ev_id=20221115106296 col_name=launch code=None.
Progress update 2025-02-03 01:13:12.865501+00:00 : Updated ev_id=20221223106489 col_name=launch code=Part.
Progress update 2025-02-03 01:13:12.903731+00:00 : Updated ev_id=20221223106489 col_name=spec_hand code=TDA.
Progress update 2025-02-03 01:13:12.932733+00:00 : Updated ev_id=20221223106489 col_name=wx_brief_src0 code=UNK.
Progress update 2025-02-03 01:13:12.957939+00:00 : Updated ev_id=20230110106561 col_name=launch code=None.
Progress update 2025-02-03 01:13:12.982465+00:00 : Updated ev_id=20230110106561 col_name=icing_actual_amt code=NONE.
Progress update 2025-02-03 01:13:13.008134+00:00 : Updated ev_id=20230110106561 col_name=icing_actual_type code=NA.
Progress update 2025-02-03 01:13:13.031986+00:00 : Updated ev_id=20230110106561 col_name=icing_forecast_amt code=NONE.
Progress update 2025-02-03 01:13:13.057281+00:00 : Updated ev_id=20230110106561 col_name=icing_forecast_type code=NA.
Progress update 2025-02-03 01:13:13.082983+00:00 : Updated ev_id=20230110106561 col_name=turb_fc_type code=NONE.
Progress update 2025-02-03 01:13:13.107565+00:00 : Updated ev_id=20230110106561 col_name=turb_severity code=NA.
Progress update 2025-02-03 01:13:13.132184+00:00 : Updated ev_id=20230110106561 col_name=turb_type code=NONE.
Progress update 2025-02-03 01:13:13.157284+00:00 : Updated ev_id=20230110106561 col_name=wx_brief_src0 code=UNK.
Progress update 2025-02-03 01:13:13.182186+00:00 : Updated ev_id=20230326106956 col_name=launch code=Part.
Progress update 2025-02-03 01:13:13.208188+00:00 : Updated ev_id=20230326106956 col_name=spec_hand code=TDA.
Progress update 2025-02-03 01:13:13.232189+00:00 : Updated ev_id=20230326106956 col_name=wx_brief_src0 code=UNK.
Progress update 2025-02-03 01:13:13.257698+00:00 : Updated ev_id=20230406107019 col_name=launch code=Part.
Progress update 2025-02-03 01:13:13.282815+00:00 : Updated ev_id=20230406107019 col_name=spec_hand code=PA.
Progress update 2025-02-03 01:13:13.515654+00:00 : Updated ev_id=20230630192493 col_name=launch code=None.
Progress update 2025-02-03 01:13:13.565615+00:00 : Updated ev_id=20230703192503 col_name=launch code=None.
Progress update 2025-02-03 01:13:13.590525+00:00 : Updated ev_id=20230703192503 col_name=wx_brief_src code=AUTR.
Progress update 2025-02-03 01:13:13.615462+00:00 : Updated ev_id=20230712192609 col_name=launch code=None.
Progress update 2025-02-03 01:13:13.665462+00:00 : Updated ev_id=20240722194742 col_name=launch code=None.
Progress update 2025-02-03 01:13:13.690921+00:00 : Updated ev_id=20240722194742 col_name=spec_hand code=TDA.
Progress update 2025-02-03 01:13:13.715526+00:00 : Updated ev_id=20240722194742 col_name=icing_actual_amt code=NONE.
Progress update 2025-02-03 01:13:13.740321+00:00 : Updated ev_id=20240722194742 col_name=icing_actual_type code=NA.
Progress update 2025-02-03 01:13:13.765331+00:00 : Updated ev_id=20240722194742 col_name=icing_forecast_amt code=NONE.
Progress update 2025-02-03 01:13:13.790303+00:00 : Updated ev_id=20240722194742 col_name=icing_forecast_type code=CLR.
Progress update 2025-02-03 01:13:13.816320+00:00 : Updated ev_id=20240722194742 col_name=turb_fc_type code=NONE.
Progress update 2025-02-03 01:13:13.840368+00:00 : Updated ev_id=20240722194742 col_name=turb_severity code=NA.
Progress update 2025-02-03 01:13:13.865419+00:00 : Updated ev_id=20240722194742 col_name=turb_type code=NONE.
Progress update 2025-02-03 01:13:14.048807+00:00 : Updated ev_id=20070508X00530 col_name=wx_brief_src code=NWS.
Progress update 2025-02-03 01:13:14.099031+00:00 : Updated ev_id=20070530X00665 col_name=wx_brief_src code=AUTR.
Progress update 2025-02-03 01:13:14.132286+00:00 : Updated ev_id=20241230199488 col_name=launch code=None.
Progress update 2025-02-03 01:13:14.182797+00:00 : Updated ev_id=20241231199496 col_name=launch code=None.
Progress update 2025-02-03 01:13:14.465820+00:00 : Updated ev_id=20070228X00236 col_name=wx_brief_src code=NET.
Progress update 2025-02-03 01:13:14.565574+00:00 : Updated ev_id=20241112195479 col_name=launch code=None.
Progress update 2025-02-03 01:13:14.949414+00:00 : Updated ev_id=20241016195324 col_name=launch code=None.
Progress update 2025-02-03 01:13:15.382003+00:00 : Number rows selected : 312.
Progress update 2025-02-03 01:13:15.382528+00:00 : Number rows inserted : 225.
Progress update 2025-02-03 01:13:15.382528+00:00 : Number rows updated : 87.
Progress update 2025-02-03 01:13:15.382528+00:00 :
Progress update 2025-02-03 01:13:15.382528+00:00 : Database table : ntsb_admin <-----------------------------------.
Progress update 2025-02-03 01:13:15.465328+00:00 : Updated ev_id=20221115106294.
Progress update 2025-02-03 01:13:15.498926+00:00 : Updated ev_id=20231031193330.
Progress update 2025-02-03 01:13:15.524024+00:00 : Updated ev_id=20240620194502.
Progress update 2025-02-03 01:13:15.573293+00:00 : Updated ev_id=20250101199498.
Progress update 2025-02-03 01:13:15.848210+00:00 : Updated ev_id=20240729194783.
Progress update 2025-02-03 01:13:15.906777+00:00 : Updated ev_id=20240816194941.
Progress update 2025-02-03 01:13:15.931542+00:00 : Updated ev_id=20241112195476.
Progress update 2025-02-03 01:13:15.956842+00:00 : Updated ev_id=20241113195481.
Progress update 2025-02-03 01:13:16.540224+00:00 : Updated ev_id=20241231199497.
Progress update 2025-02-03 01:13:16.715404+00:00 : Updated ev_id=20221115106296.
Progress update 2025-02-03 01:13:16.740400+00:00 : Updated ev_id=20221223106489.
Progress update 2025-02-03 01:13:16.764409+00:00 : Updated ev_id=20230110106561.
Progress update 2025-02-03 01:13:16.790469+00:00 : Updated ev_id=20230326106956.
Progress update 2025-02-03 01:13:16.814467+00:00 : Updated ev_id=20230406107019.
Progress update 2025-02-03 01:13:16.840475+00:00 : Updated ev_id=20230630192493.
Progress update 2025-02-03 01:13:16.863988+00:00 : Updated ev_id=20230703192503.
Progress update 2025-02-03 01:13:16.890131+00:00 : Updated ev_id=20230712192609.
Progress update 2025-02-03 01:13:16.964423+00:00 : Updated ev_id=20240722194742.
Progress update 2025-02-03 01:13:17.074964+00:00 : Updated ev_id=20071115X01799.
Progress update 2025-02-03 01:13:17.097476+00:00 : Updated ev_id=20070508X00530.
Progress update 2025-02-03 01:13:17.139640+00:00 : Updated ev_id=20070530X00665.
Progress update 2025-02-03 01:13:17.164645+00:00 : Updated ev_id=20241230199488.
Progress update 2025-02-03 01:13:17.189728+00:00 : Updated ev_id=20241231199496.
Progress update 2025-02-03 01:13:17.246729+00:00 : Updated ev_id=20070228X00236.
Progress update 2025-02-03 01:13:17.289771+00:00 : Updated ev_id=20241112195479.
Progress update 2025-02-03 01:13:17.414387+00:00 : Updated ev_id=20241016195324.
Progress update 2025-02-03 01:13:17.514732+00:00 : Number rows selected : 80.
Progress update 2025-02-03 01:13:17.514732+00:00 : Number rows inserted : 54.
Progress update 2025-02-03 01:13:17.515732+00:00 : Number rows updated : 26.
Progress update 2025-02-03 01:13:17.515732+00:00 :
Progress update 2025-02-03 01:13:17.515732+00:00 : Database table : dt_aircraft <-----------------------------------.
Progress update 2025-02-03 01:13:17.731409+00:00 : Updated ev_id=20221115106294 aircraft_key=1 col_name=acft_awy_cert0 code=UNK.
Progress update 2025-02-03 01:13:17.756413+00:00 : Updated ev_id=20221115106294 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-03 01:13:17.781934+00:00 : Updated ev_id=20221115106294 aircraft_key=1 col_name=airspc_type code=CLG.
Progress update 2025-02-03 01:13:17.806728+00:00 : Updated ev_id=20221115106294 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-03 01:13:17.830731+00:00 : Updated ev_id=20221115106294 aircraft_key=1 col_name=landing_gear1 code=TAIL.
Progress update 2025-02-03 01:13:17.881710+00:00 : Updated ev_id=20221115106294 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-03 01:13:17.906611+00:00 : Updated ev_id=20221115106294 aircraft_key=1 col_name=vfr_appr code=FLND.
Progress update 2025-02-03 01:13:17.930936+00:00 : Updated ev_id=20231031193330 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-02-03 01:13:17.955938+00:00 : Updated ev_id=20231031193330 aircraft_key=1 col_name=addtl_equip0 code=UNK.
Progress update 2025-02-03 01:13:17.981502+00:00 : Updated ev_id=20231031193330 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-03 01:13:18.006503+00:00 : Updated ev_id=20231031193330 aircraft_key=1 col_name=airspc_type code=CLG.
Progress update 2025-02-03 01:13:18.031502+00:00 : Updated ev_id=20231031193330 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-03 01:13:18.056506+00:00 : Updated ev_id=20231031193330 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-02-03 01:13:18.081089+00:00 : Updated ev_id=20231031193330 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-03 01:13:18.106619+00:00 : Updated ev_id=20231031193330 aircraft_key=1 col_name=vfr_appr0 code=NONE.
Progress update 2025-02-03 01:13:18.181297+00:00 : Updated ev_id=20240620194502 aircraft_key=1 col_name=aircar_cert code=AGR.
Progress update 2025-02-03 01:13:18.206297+00:00 : Updated ev_id=20240620194502 aircraft_key=1 col_name=airspc_type code=CLG.
Progress update 2025-02-03 01:13:18.248300+00:00 : Updated ev_id=20240620194502 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-03 01:13:18.273816+00:00 : Updated ev_id=20240620194502 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-03 01:13:18.297818+00:00 : Updated ev_id=20240620194502 aircraft_key=1 col_name=vfr_appr code=FLND.
Progress update 2025-02-03 01:13:20.521834+00:00 : Updated ev_id=20240729194783 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-03 01:13:20.722050+00:00 : Updated ev_id=20240729194783 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-03 01:13:20.797564+00:00 : Updated ev_id=20240816194941 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-02-03 01:13:20.822564+00:00 : Updated ev_id=20240816194941 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-02-03 01:13:20.847565+00:00 : Updated ev_id=20240816194941 aircraft_key=1 col_name=addtl_equip code=STWS.
Progress update 2025-02-03 01:13:20.872092+00:00 : Updated ev_id=20240816194941 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-03 01:13:20.897095+00:00 : Updated ev_id=20240816194941 aircraft_key=1 col_name=airspc_type code=CLD.
Progress update 2025-02-03 01:13:20.922199+00:00 : Updated ev_id=20240816194941 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-03 01:13:20.983713+00:00 : Updated ev_id=20240816194941 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-02-03 01:13:21.036713+00:00 : Updated ev_id=20240816194941 aircraft_key=1 col_name=landing_surf code=ASPH.
Progress update 2025-02-03 01:13:21.063716+00:00 : Updated ev_id=20240816194941 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-02-03 01:13:21.089231+00:00 : Updated ev_id=20240816194941 aircraft_key=1 col_name=type_clear code=VFR.
Progress update 2025-02-03 01:13:21.121841+00:00 : Updated ev_id=20240816194941 aircraft_key=1 col_name=vfr_appr code=FSTP.
Progress update 2025-02-03 01:13:21.147919+00:00 : Updated ev_id=20241112195476 aircraft_key=1 col_name=acft_awy_cert code=SPE.
Progress update 2025-02-03 01:13:21.172437+00:00 : Updated ev_id=20241112195476 aircraft_key=1 col_name=addtl_equip code=AOAI.
Progress update 2025-02-03 01:13:21.209441+00:00 : Updated ev_id=20241112195476 aircraft_key=1 col_name=addtl_equip code=AUTO.
Progress update 2025-02-03 01:13:21.230951+00:00 : Updated ev_id=20241112195476 aircraft_key=1 col_name=addtl_equip code=EFB.
Progress update 2025-02-03 01:13:21.254955+00:00 : Updated ev_id=20241112195476 aircraft_key=1 col_name=addtl_equip code=EPFD.
Progress update 2025-02-03 01:13:21.280464+00:00 : Updated ev_id=20241112195476 aircraft_key=1 col_name=addtl_equip code=HGPS.
Progress update 2025-02-03 01:13:21.311469+00:00 : Updated ev_id=20241112195476 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-03 01:13:21.355679+00:00 : Updated ev_id=20241112195476 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-03 01:13:21.380712+00:00 : Updated ev_id=20241112195476 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-02-03 01:13:21.405711+00:00 : Updated ev_id=20241112195476 aircraft_key=1 col_name=landing_surf code=GRAS.
Progress update 2025-02-03 01:13:21.431715+00:00 : Updated ev_id=20241112195476 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-02-03 01:13:21.455719+00:00 : Updated ev_id=20241112195476 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-03 01:13:21.481228+00:00 : Updated ev_id=20241112195476 aircraft_key=1 col_name=vfr_appr code=FSTP.
Progress update 2025-02-03 01:13:21.505231+00:00 : Updated ev_id=20241113195481 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-02-03 01:13:21.530748+00:00 : Updated ev_id=20241113195481 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-02-03 01:13:21.563320+00:00 : Updated ev_id=20241113195481 aircraft_key=1 col_name=addtl_equip code=AUTO.
Progress update 2025-02-03 01:13:21.588832+00:00 : Updated ev_id=20241113195481 aircraft_key=1 col_name=addtl_equip code=EMFD.
Progress update 2025-02-03 01:13:21.613833+00:00 : Updated ev_id=20241113195481 aircraft_key=1 col_name=addtl_equip code=EPFD.
Progress update 2025-02-03 01:13:21.638833+00:00 : Updated ev_id=20241113195481 aircraft_key=1 col_name=addtl_equip code=OBWX.
Progress update 2025-02-03 01:13:21.663841+00:00 : Updated ev_id=20241113195481 aircraft_key=1 col_name=addtl_equip code=STWS.
Progress update 2025-02-03 01:13:21.689215+00:00 : Updated ev_id=20241113195481 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-03 01:13:21.713726+00:00 : Updated ev_id=20241113195481 aircraft_key=1 col_name=airspc_type code=CLD.
Progress update 2025-02-03 01:13:21.738868+00:00 : Updated ev_id=20241113195481 aircraft_key=1 col_name=elt_oper_no_reason code=OTHR.
Progress update 2025-02-03 01:13:21.763017+00:00 : Updated ev_id=20241113195481 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-03 01:13:21.788528+00:00 : Updated ev_id=20241113195481 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-02-03 01:13:21.814036+00:00 : Updated ev_id=20241113195481 aircraft_key=1 col_name=landing_surf code=ASPH.
Progress update 2025-02-03 01:13:21.839036+00:00 : Updated ev_id=20241113195481 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-02-03 01:13:21.868042+00:00 : Updated ev_id=20241113195481 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-03 01:13:21.888557+00:00 : Updated ev_id=20241113195481 aircraft_key=1 col_name=vfr_appr code=FSTP.
Progress update 2025-02-03 01:13:21.913563+00:00 : Updated ev_id=20241113195481 aircraft_key=1 col_name=vfr_appr code=PLND.
Progress update 2025-02-03 01:13:21.939072+00:00 : Updated ev_id=20241113195481 aircraft_key=1 col_name=vfr_appr code=STIN.
Progress update 2025-02-03 01:13:25.695894+00:00 : Updated ev_id=20221115106296 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-02-03 01:13:25.796789+00:00 : Updated ev_id=20221115106296 aircraft_key=1 col_name=aircar_cert code=TAXI.
Progress update 2025-02-03 01:13:25.820717+00:00 : Updated ev_id=20221115106296 aircraft_key=1 col_name=airspc_type code=CLD.
Progress update 2025-02-03 01:13:25.846326+00:00 : Updated ev_id=20221115106296 aircraft_key=1 col_name=instm_appr code=ILSF.
Progress update 2025-02-03 01:13:25.871324+00:00 : Updated ev_id=20221115106296 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-02-03 01:13:25.945936+00:00 : Updated ev_id=20221115106296 aircraft_key=1 col_name=type_clear code=IFR.
Progress update 2025-02-03 01:13:25.970939+00:00 : Updated ev_id=20221115106296 aircraft_key=1 col_name=vfr_appr0 code=NONE.
Progress update 2025-02-03 01:13:26.004332+00:00 : Updated ev_id=20221223106489 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-02-03 01:13:26.029331+00:00 : Updated ev_id=20221223106489 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-02-03 01:13:26.054333+00:00 : Updated ev_id=20221223106489 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-03 01:13:26.079338+00:00 : Updated ev_id=20221223106489 aircraft_key=1 col_name=airspc_type code=CLD.
Progress update 2025-02-03 01:13:26.129368+00:00 : Updated ev_id=20221223106489 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-03 01:13:26.153882+00:00 : Updated ev_id=20221223106489 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-02-03 01:13:26.178890+00:00 : Updated ev_id=20221223106489 aircraft_key=1 col_name=rwy_cond1 code=SOFT.
Progress update 2025-02-03 01:13:26.204086+00:00 : Updated ev_id=20221223106489 aircraft_key=1 col_name=rwy_cond1 code=WET.
Progress update 2025-02-03 01:13:26.229083+00:00 : Updated ev_id=20221223106489 aircraft_key=1 col_name=type_clear code=VFR.
Progress update 2025-02-03 01:13:26.254085+00:00 : Updated ev_id=20221223106489 aircraft_key=1 col_name=vfr_appr code=FLND.
Progress update 2025-02-03 01:13:26.279092+00:00 : Updated ev_id=20230110106561 aircraft_key=1 col_name=acft_awy_cert code=SPX.
Progress update 2025-02-03 01:13:26.304227+00:00 : Updated ev_id=20230110106561 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-02-03 01:13:26.328223+00:00 : Updated ev_id=20230110106561 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-03 01:13:26.354918+00:00 : Updated ev_id=20230110106561 aircraft_key=1 col_name=airspc_type0 code=UNK.
Progress update 2025-02-03 01:13:26.378924+00:00 : Updated ev_id=20230110106561 aircraft_key=1 col_name=elt_oper_no_reason code=UNK.
Progress update 2025-02-03 01:13:26.429436+00:00 : Updated ev_id=20230110106561 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-02-03 01:13:26.463437+00:00 : Updated ev_id=20230110106561 aircraft_key=1 col_name=type_clear1 code=UNK.
Progress update 2025-02-03 01:13:26.512683+00:00 : Updated ev_id=20230326106956 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-02-03 01:13:26.595344+00:00 : Updated ev_id=20230326106956 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-03 01:13:26.621502+00:00 : Updated ev_id=20230326106956 aircraft_key=1 col_name=airspc_type code=CLE.
Progress update 2025-02-03 01:13:26.645888+00:00 : Updated ev_id=20230326106956 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-03 01:13:26.671890+00:00 : Updated ev_id=20230326106956 aircraft_key=1 col_name=landing_gear0 code=NONE.
Progress update 2025-02-03 01:13:26.696031+00:00 : Updated ev_id=20230326106956 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-03 01:13:26.721540+00:00 : Updated ev_id=20230326106956 aircraft_key=1 col_name=vfr_appr0 code=NONE.
Progress update 2025-02-03 01:13:26.770915+00:00 : Updated ev_id=20230406107019 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-02-03 01:13:26.795814+00:00 : Updated ev_id=20230406107019 aircraft_key=1 col_name=addtl_equip code=AFPC.
Progress update 2025-02-03 01:13:26.821174+00:00 : Updated ev_id=20230406107019 aircraft_key=1 col_name=addtl_equip code=EMFD.
Progress update 2025-02-03 01:13:26.846182+00:00 : Updated ev_id=20230406107019 aircraft_key=1 col_name=addtl_equip code=EPFD.
Progress update 2025-02-03 01:13:26.870865+00:00 : Updated ev_id=20230406107019 aircraft_key=1 col_name=addtl_equip code=STWS.
Progress update 2025-02-03 01:13:26.895383+00:00 : Updated ev_id=20230406107019 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-03 01:13:26.921384+00:00 : Updated ev_id=20230406107019 aircraft_key=1 col_name=airspc_type code=CLG.
Progress update 2025-02-03 01:13:26.945382+00:00 : Updated ev_id=20230406107019 aircraft_key=1 col_name=elt_oper_no_reason code=OTHR.
Progress update 2025-02-03 01:13:26.971551+00:00 : Updated ev_id=20230406107019 aircraft_key=1 col_name=instm_appr1 code=UNK.
Progress update 2025-02-03 01:13:26.996238+00:00 : Updated ev_id=20230406107019 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-02-03 01:13:27.029643+00:00 : Updated ev_id=20230406107019 aircraft_key=1 col_name=landing_surf code=ASPH.
Progress update 2025-02-03 01:13:27.053673+00:00 : Updated ev_id=20230406107019 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-02-03 01:13:27.079675+00:00 : Updated ev_id=20230406107019 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-03 01:13:27.103700+00:00 : Updated ev_id=20230406107019 aircraft_key=1 col_name=vfr_appr1 code=UNK.
Progress update 2025-02-03 01:13:27.162706+00:00 : Updated ev_id=20230630192493 aircraft_key=1 col_name=aircar_cert code=F121.
Progress update 2025-02-03 01:13:27.211892+00:00 : Updated ev_id=20230630192493 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-02-03 01:13:27.304026+00:00 : Updated ev_id=20230703192503 aircraft_key=1 col_name=acft_awy_cert code=SPE.
Progress update 2025-02-03 01:13:27.329033+00:00 : Updated ev_id=20230703192503 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-02-03 01:13:27.354325+00:00 : Updated ev_id=20230703192503 aircraft_key=1 col_name=addtl_equip code=AUTO.
Progress update 2025-02-03 01:13:27.378954+00:00 : Updated ev_id=20230703192503 aircraft_key=1 col_name=addtl_equip code=DREC.
Progress update 2025-02-03 01:13:27.404463+00:00 : Updated ev_id=20230703192503 aircraft_key=1 col_name=addtl_equip code=EFB.
Progress update 2025-02-03 01:13:27.429464+00:00 : Updated ev_id=20230703192503 aircraft_key=1 col_name=addtl_equip code=EMFD.
Progress update 2025-02-03 01:13:27.453463+00:00 : Updated ev_id=20230703192503 aircraft_key=1 col_name=addtl_equip code=EPFD.
Progress update 2025-02-03 01:13:27.479466+00:00 : Updated ev_id=20230703192503 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-03 01:13:27.504304+00:00 : Updated ev_id=20230703192503 aircraft_key=1 col_name=airspc_type code=CLC.
Progress update 2025-02-03 01:13:27.529591+00:00 : Updated ev_id=20230703192503 aircraft_key=1 col_name=elt_oper_no_reason code=UNK.
Progress update 2025-02-03 01:13:27.554186+00:00 : Updated ev_id=20230703192503 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-03 01:13:27.579317+00:00 : Updated ev_id=20230703192503 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-02-03 01:13:27.603824+00:00 : Updated ev_id=20230703192503 aircraft_key=1 col_name=landing_surf code=CONC.
Progress update 2025-02-03 01:13:27.637827+00:00 : Updated ev_id=20230703192503 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-02-03 01:13:27.662575+00:00 : Updated ev_id=20230703192503 aircraft_key=1 col_name=rwy_cond1 code=ROUG.
Progress update 2025-02-03 01:13:27.703680+00:00 : Updated ev_id=20230703192503 aircraft_key=1 col_name=type_clear code=VFR.
Progress update 2025-02-03 01:13:27.728322+00:00 : Updated ev_id=20230703192503 aircraft_key=1 col_name=vfr_appr code=FLND.
Progress update 2025-02-03 01:13:27.756428+00:00 : Updated ev_id=20230712192609 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-02-03 01:13:27.779536+00:00 : Updated ev_id=20230712192609 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-02-03 01:13:27.815076+00:00 : Updated ev_id=20230712192609 aircraft_key=1 col_name=addtl_equip code=AFPC.
Progress update 2025-02-03 01:13:27.846203+00:00 : Updated ev_id=20230712192609 aircraft_key=1 col_name=addtl_equip code=AUTO.
Progress update 2025-02-03 01:13:27.870838+00:00 : Updated ev_id=20230712192609 aircraft_key=1 col_name=addtl_equip code=EMFD.
Progress update 2025-02-03 01:13:27.896103+00:00 : Updated ev_id=20230712192609 aircraft_key=1 col_name=addtl_equip code=EPFD.
Progress update 2025-02-03 01:13:27.920103+00:00 : Updated ev_id=20230712192609 aircraft_key=1 col_name=addtl_equip code=STWS.
Progress update 2025-02-03 01:13:27.946105+00:00 : Updated ev_id=20230712192609 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-03 01:13:27.970193+00:00 : Updated ev_id=20230712192609 aircraft_key=1 col_name=airspc_type code=CLG.
Progress update 2025-02-03 01:13:27.995706+00:00 : Updated ev_id=20230712192609 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-03 01:13:28.020085+00:00 : Updated ev_id=20230712192609 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-02-03 01:13:28.045353+00:00 : Updated ev_id=20230712192609 aircraft_key=1 col_name=rwy_cond1 code=VEGE.
Progress update 2025-02-03 01:13:28.070531+00:00 : Updated ev_id=20230712192609 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-03 01:13:28.095717+00:00 : Updated ev_id=20230712192609 aircraft_key=1 col_name=vfr_appr code=FLND.
Progress update 2025-02-03 01:13:28.120230+00:00 : Updated ev_id=20240722194742 aircraft_key=1 col_name=acft_awy_cert code=SPE.
Progress update 2025-02-03 01:13:28.153234+00:00 : Updated ev_id=20240722194742 aircraft_key=1 col_name=addtl_equip code=ADSB.
Progress update 2025-02-03 01:13:28.178390+00:00 : Updated ev_id=20240722194742 aircraft_key=1 col_name=addtl_equip code=EFB.
Progress update 2025-02-03 01:13:28.203904+00:00 : Updated ev_id=20240722194742 aircraft_key=1 col_name=addtl_equip code=EMFD.
Progress update 2025-02-03 01:13:28.228501+00:00 : Updated ev_id=20240722194742 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-03 01:13:28.253430+00:00 : Updated ev_id=20240722194742 aircraft_key=1 col_name=airspc_type code=CLG.
Progress update 2025-02-03 01:13:28.278437+00:00 : Updated ev_id=20240722194742 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-03 01:13:28.303657+00:00 : Updated ev_id=20240722194742 aircraft_key=1 col_name=landing_gear1 code=TAIL.
Progress update 2025-02-03 01:13:28.330655+00:00 : Updated ev_id=20240722194742 aircraft_key=1 col_name=landing_surf code=ASPH.
Progress update 2025-02-03 01:13:28.353660+00:00 : Updated ev_id=20240722194742 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-02-03 01:13:28.378784+00:00 : Updated ev_id=20240722194742 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-03 01:13:28.404292+00:00 : Updated ev_id=20240722194742 aircraft_key=1 col_name=vfr_appr0 code=NONE.
Progress update 2025-02-03 01:13:28.695019+00:00 : Updated ev_id=20071115X01799 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-02-03 01:13:28.720182+00:00 : Updated ev_id=20071115X01799 aircraft_key=1 col_name=aircar_cert code=TAXI.
Progress update 2025-02-03 01:13:28.745476+00:00 : Updated ev_id=20071115X01799 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-03 01:13:28.770531+00:00 : Updated ev_id=20071115X01799 aircraft_key=1 col_name=landing_gear code=HISK.
Progress update 2025-02-03 01:13:28.804710+00:00 : Updated ev_id=20070508X00530 aircraft_key=1 col_name=acft_awy_cert code=STN.
Progress update 2025-02-03 01:13:28.819712+00:00 : Updated ev_id=20070508X00530 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-03 01:13:28.845713+00:00 : Updated ev_id=20070508X00530 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-03 01:13:28.870711+00:00 : Updated ev_id=20070508X00530 aircraft_key=1 col_name=landing_gear1 code=TRI.
Progress update 2025-02-03 01:13:28.895224+00:00 : Updated ev_id=20070508X00530 aircraft_key=1 col_name=landing_surf code=ASPH.
Progress update 2025-02-03 01:13:28.924231+00:00 : Updated ev_id=20070508X00530 aircraft_key=1 col_name=landing_surf code=DIRT.
Progress update 2025-02-03 01:13:28.945810+00:00 : Updated ev_id=20070508X00530 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-02-03 01:13:28.969986+00:00 : Updated ev_id=20070508X00530 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-03 01:13:28.995428+00:00 : Updated ev_id=20070508X00530 aircraft_key=1 col_name=vfr_appr code=FLND.
Progress update 2025-02-03 01:13:29.020444+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 col_name=acft_awy_cert code=SPR.
Progress update 2025-02-03 01:13:29.045108+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-03 01:13:29.078112+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 col_name=landing_gear1 code=TAIL.
Progress update 2025-02-03 01:13:29.103895+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-03 01:13:29.136896+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 col_name=vfr_appr0 code=NONE.
Progress update 2025-02-03 01:13:29.220087+00:00 : Updated ev_id=20241230199488 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-03 01:13:29.253739+00:00 : Updated ev_id=20241230199488 aircraft_key=1 col_name=airspc_type code=CLD.
Progress update 2025-02-03 01:13:29.278744+00:00 : Updated ev_id=20241230199488 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-03 01:13:29.337256+00:00 : Updated ev_id=20241230199488 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-03 01:13:29.369779+00:00 : Updated ev_id=20241230199488 aircraft_key=1 col_name=vfr_appr code=FLND.
Progress update 2025-02-03 01:13:29.678420+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 col_name=acft_awy_cert code=SPE.
Progress update 2025-02-03 01:13:29.711931+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 col_name=aircar_cert code=None.
Progress update 2025-02-03 01:13:29.736557+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 col_name=instm_appr0 code=NONE.
Progress update 2025-02-03 01:13:29.769902+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 col_name=landing_gear1 code=TAIL.
Progress update 2025-02-03 01:13:29.795034+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 col_name=landing_surf code=ASPH.
Progress update 2025-02-03 01:13:29.828033+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 col_name=rwy_cond1 code=DRY.
Progress update 2025-02-03 01:13:29.853145+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 col_name=type_clear0 code=NONE.
Progress update 2025-02-03 01:13:29.886149+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 col_name=vfr_appr code=TOGO.
Progress update 2025-02-03 01:13:31.361574+00:00 : Number rows selected : 529.
Progress update 2025-02-03 01:13:31.362112+00:00 : Number rows inserted : 344.
Progress update 2025-02-03 01:13:31.362112+00:00 : Number rows updated : 185.
Progress update 2025-02-03 01:13:31.362648+00:00 :
Progress update 2025-02-03 01:13:31.362648+00:00 : Database table : engines <-----------------------------------.
Progress update 2025-02-03 01:13:31.952885+00:00 : Updated ev_id=20071115X01799 aircraft_key=1 eng_no=1.
Progress update 2025-02-03 01:13:31.986057+00:00 : Updated ev_id=20070508X00530 aircraft_key=1 eng_no=1.
Progress update 2025-02-03 01:13:32.011063+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 eng_no=1.
Progress update 2025-02-03 01:13:32.094575+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 eng_no=1.
Progress update 2025-02-03 01:13:32.094575+00:00 : Number rows selected : 25.
Progress update 2025-02-03 01:13:32.094575+00:00 : Number rows inserted : 21.
Progress update 2025-02-03 01:13:32.095575+00:00 : Number rows updated : 4.
Progress update 2025-02-03 01:13:32.095575+00:00 :
Progress update 2025-02-03 01:13:32.095575+00:00 : Database table : events_sequence <-----------------------------------.
Progress update 2025-02-03 01:13:32.177996+00:00 : Updated ev_id=20221115106294 Aircraft_Key=1 Occurrence_No=2.
Progress update 2025-02-03 01:13:32.228130+00:00 : Updated ev_id=20221115106294 Aircraft_Key=1 Occurrence_No=5.
Progress update 2025-02-03 01:13:32.253132+00:00 : Updated ev_id=20221115106294 Aircraft_Key=1 Occurrence_No=4.
Progress update 2025-02-03 01:13:32.278131+00:00 : Updated ev_id=20221115106294 Aircraft_Key=1 Occurrence_No=6.
Progress update 2025-02-03 01:13:32.303143+00:00 : Updated ev_id=20231031193330 Aircraft_Key=1 Occurrence_No=2.
Progress update 2025-02-03 01:13:32.327684+00:00 : Updated ev_id=20231031193330 Aircraft_Key=1 Occurrence_No=3.
Progress update 2025-02-03 01:13:32.377920+00:00 : Updated ev_id=20240620194502 Aircraft_Key=1 Occurrence_No=5.
Progress update 2025-02-03 01:13:32.428110+00:00 : Updated ev_id=20250101199498 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-03 01:13:32.794217+00:00 : Updated ev_id=20240729194783 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-03 01:13:32.819744+00:00 : Updated ev_id=20240816194941 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-03 01:13:32.852084+00:00 : Updated ev_id=20241112195476 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-03 01:13:32.878082+00:00 : Updated ev_id=20241112195476 Aircraft_Key=1 Occurrence_No=2.
Progress update 2025-02-03 01:13:32.902082+00:00 : Updated ev_id=20241113195481 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-03 01:13:32.927605+00:00 : Updated ev_id=20241113195481 Aircraft_Key=1 Occurrence_No=2.
Progress update 2025-02-03 01:13:33.602888+00:00 : Updated ev_id=20241231199497 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-03 01:13:33.869252+00:00 : Updated ev_id=20221115106296 Aircraft_Key=1 Occurrence_No=2.
Progress update 2025-02-03 01:13:33.893941+00:00 : Updated ev_id=20221223106489 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-03 01:13:33.918777+00:00 : Updated ev_id=20221223106489 Aircraft_Key=1 Occurrence_No=2.
Progress update 2025-02-03 01:13:33.943783+00:00 : Updated ev_id=20221223106489 Aircraft_Key=1 Occurrence_No=3.
Progress update 2025-02-03 01:13:34.027508+00:00 : Updated ev_id=20230326106956 Aircraft_Key=1 Occurrence_No=2.
Progress update 2025-02-03 01:13:34.052509+00:00 : Updated ev_id=20230326106956 Aircraft_Key=1 Occurrence_No=3.
Progress update 2025-02-03 01:13:34.077509+00:00 : Updated ev_id=20230326106956 Aircraft_Key=1 Occurrence_No=4.
Progress update 2025-02-03 01:13:34.102517+00:00 : Updated ev_id=20230326106956 Aircraft_Key=1 Occurrence_No=5.
Progress update 2025-02-03 01:13:34.127540+00:00 : Updated ev_id=20230326106956 Aircraft_Key=1 Occurrence_No=6.
Progress update 2025-02-03 01:13:34.152542+00:00 : Updated ev_id=20230406107019 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-03 01:13:34.193790+00:00 : Updated ev_id=20230406107019 Aircraft_Key=1 Occurrence_No=2.
Progress update 2025-02-03 01:13:34.218798+00:00 : Updated ev_id=20230630192493 Aircraft_Key=1 Occurrence_No=2.
Progress update 2025-02-03 01:13:34.243915+00:00 : Updated ev_id=20230703192503 Aircraft_Key=1 Occurrence_No=6.
Progress update 2025-02-03 01:13:34.303457+00:00 : Updated ev_id=20230703192503 Aircraft_Key=1 Occurrence_No=4.
Progress update 2025-02-03 01:13:34.369537+00:00 : Updated ev_id=20230712192609 Aircraft_Key=1 Occurrence_No=2.
Progress update 2025-02-03 01:13:34.401776+00:00 : Updated ev_id=20230712192609 Aircraft_Key=1 Occurrence_No=3.
Progress update 2025-02-03 01:13:34.427938+00:00 : Updated ev_id=20240722194742 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-03 01:13:34.728326+00:00 : Updated ev_id=20241231199496 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-03 01:13:34.893334+00:00 : Updated ev_id=20241112195479 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-03 01:13:35.068455+00:00 : Updated ev_id=20241016195324 Aircraft_Key=1 Occurrence_No=1.
Progress update 2025-02-03 01:13:35.093457+00:00 : Updated ev_id=20241016195324 Aircraft_Key=1 Occurrence_No=2.
Progress update 2025-02-03 01:13:35.193019+00:00 : Number rows selected : 113.
Progress update 2025-02-03 01:13:35.194020+00:00 : Number rows inserted : 77.
Progress update 2025-02-03 01:13:35.194020+00:00 : Number rows updated : 36.
Progress update 2025-02-03 01:13:35.194020+00:00 :
Progress update 2025-02-03 01:13:35.194020+00:00 : Database table : findings <-----------------------------------.
Progress update 2025-02-03 01:13:36.827021+00:00 : Number rows selected : 55.
Progress update 2025-02-03 01:13:36.827021+00:00 : Number rows inserted : 55.
Progress update 2025-02-03 01:13:36.827021+00:00 :
Progress update 2025-02-03 01:13:36.827021+00:00 : Database table : flight_crew <-----------------------------------.
Progress update 2025-02-03 01:13:37.559767+00:00 : Updated ev_id=20071115X01799 aircraft_key=1 crew_no=1.
Progress update 2025-02-03 01:13:37.593227+00:00 : Updated ev_id=20070508X00530 aircraft_key=1 crew_no=1.
Progress update 2025-02-03 01:13:37.627240+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1.
Progress update 2025-02-03 01:13:37.717755+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1.
Progress update 2025-02-03 01:13:37.717755+00:00 : Number rows selected : 30.
Progress update 2025-02-03 01:13:37.718756+00:00 : Number rows inserted : 26.
Progress update 2025-02-03 01:13:37.718756+00:00 : Number rows updated : 4.
Progress update 2025-02-03 01:13:37.718756+00:00 :
Progress update 2025-02-03 01:13:37.718756+00:00 : Database table : injury <-----------------------------------.
Progress update 2025-02-03 01:13:37.819828+00:00 : Updated ev_id=20221115106294 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-03 01:13:37.868342+00:00 : Updated ev_id=20221115106294 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-03 01:13:38.051142+00:00 : Updated ev_id=20231031193330 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-02-03 01:13:38.109568+00:00 : Updated ev_id=20231031193330 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-03 01:13:38.143217+00:00 : Updated ev_id=20231031193330 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-02-03 01:13:38.167732+00:00 : Updated ev_id=20231031193330 aircraft_key=1 inj_person_category=Pass injury_level=SERS.
Progress update 2025-02-03 01:13:38.201588+00:00 : Updated ev_id=20231031193330 aircraft_key=1 inj_person_category=Pass injury_level=MINR.
Progress update 2025-02-03 01:13:38.234453+00:00 : Updated ev_id=20231031193330 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-03 01:13:38.268005+00:00 : Updated ev_id=20231031193330 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-03 01:13:38.301104+00:00 : Updated ev_id=20240620194502 aircraft_key=1 inj_person_category=Cabi injury_level=FATL.
Progress update 2025-02-03 01:13:38.325922+00:00 : Updated ev_id=20240620194502 aircraft_key=1 inj_person_category=Cabi injury_level=SERS.
Progress update 2025-02-03 01:13:38.351927+00:00 : Updated ev_id=20240620194502 aircraft_key=1 inj_person_category=Cabi injury_level=MINR.
Progress update 2025-02-03 01:13:38.383996+00:00 : Updated ev_id=20240620194502 aircraft_key=1 inj_person_category=Cabi injury_level=NONE.
Progress update 2025-02-03 01:13:38.438484+00:00 : Updated ev_id=20240620194502 aircraft_key=1 inj_person_category=Cabi injury_level=TOTL.
Progress update 2025-02-03 01:13:38.475927+00:00 : Updated ev_id=20240620194502 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-02-03 01:13:38.509934+00:00 : Updated ev_id=20240620194502 aircraft_key=1 inj_person_category=Flig injury_level=SERS.
Progress update 2025-02-03 01:13:38.542729+00:00 : Updated ev_id=20240620194502 aircraft_key=1 inj_person_category=Flig injury_level=MINR.
Progress update 2025-02-03 01:13:38.567882+00:00 : Updated ev_id=20240620194502 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-03 01:13:38.592538+00:00 : Updated ev_id=20240620194502 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-03 01:13:38.618094+00:00 : Updated ev_id=20240620194502 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-02-03 01:13:38.651243+00:00 : Updated ev_id=20240620194502 aircraft_key=1 inj_person_category=Pass injury_level=SERS.
Progress update 2025-02-03 01:13:38.693371+00:00 : Updated ev_id=20240620194502 aircraft_key=1 inj_person_category=Pass injury_level=MINR.
Progress update 2025-02-03 01:13:38.734372+00:00 : Updated ev_id=20240620194502 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-03 01:13:38.767668+00:00 : Updated ev_id=20240620194502 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-03 01:13:39.308808+00:00 : Updated ev_id=20250101199498 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-03 01:13:39.334810+00:00 : Updated ev_id=20250101199498 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-03 01:13:40.859067+00:00 : Updated ev_id=20240729194783 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-03 01:13:40.892609+00:00 : Updated ev_id=20240729194783 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-03 01:13:40.975844+00:00 : Updated ev_id=20240816194941 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-03 01:13:41.000826+00:00 : Updated ev_id=20240816194941 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-03 01:13:41.075191+00:00 : Updated ev_id=20241112195476 aircraft_key=1 inj_person_category=Cabi injury_level=FATL.
Progress update 2025-02-03 01:13:41.100191+00:00 : Updated ev_id=20241112195476 aircraft_key=1 inj_person_category=Cabi injury_level=SERS.
Progress update 2025-02-03 01:13:41.125706+00:00 : Updated ev_id=20241112195476 aircraft_key=1 inj_person_category=Cabi injury_level=MINR.
Progress update 2025-02-03 01:13:41.150712+00:00 : Updated ev_id=20241112195476 aircraft_key=1 inj_person_category=Cabi injury_level=NONE.
Progress update 2025-02-03 01:13:41.175228+00:00 : Updated ev_id=20241112195476 aircraft_key=1 inj_person_category=Cabi injury_level=TOTL.
Progress update 2025-02-03 01:13:41.225234+00:00 : Updated ev_id=20241112195476 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-02-03 01:13:41.250398+00:00 : Updated ev_id=20241112195476 aircraft_key=1 inj_person_category=Flig injury_level=SERS.
Progress update 2025-02-03 01:13:41.274911+00:00 : Updated ev_id=20241112195476 aircraft_key=1 inj_person_category=Flig injury_level=MINR.
Progress update 2025-02-03 01:13:41.300422+00:00 : Updated ev_id=20241112195476 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-03 01:13:41.325424+00:00 : Updated ev_id=20241112195476 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-03 01:13:41.358428+00:00 : Updated ev_id=20241112195476 aircraft_key=1 inj_person_category=LapC injury_level=FATL.
Progress update 2025-02-03 01:13:41.411943+00:00 : Updated ev_id=20241112195476 aircraft_key=1 inj_person_category=LapC injury_level=SERS.
Progress update 2025-02-03 01:13:41.433458+00:00 : Updated ev_id=20241112195476 aircraft_key=1 inj_person_category=LapC injury_level=MINR.
Progress update 2025-02-03 01:13:41.459151+00:00 : Updated ev_id=20241112195476 aircraft_key=1 inj_person_category=LapC injury_level=NONE.
Progress update 2025-02-03 01:13:41.483580+00:00 : Updated ev_id=20241112195476 aircraft_key=1 inj_person_category=LapC injury_level=TOTL.
Progress update 2025-02-03 01:13:41.508576+00:00 : Updated ev_id=20241112195476 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-02-03 01:13:41.533577+00:00 : Updated ev_id=20241112195476 aircraft_key=1 inj_person_category=Pass injury_level=SERS.
Progress update 2025-02-03 01:13:41.558581+00:00 : Updated ev_id=20241112195476 aircraft_key=1 inj_person_category=Pass injury_level=MINR.
Progress update 2025-02-03 01:13:41.592094+00:00 : Updated ev_id=20241112195476 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-03 01:13:41.617095+00:00 : Updated ev_id=20241112195476 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-03 01:13:41.642118+00:00 : Updated ev_id=20241113195481 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-03 01:13:41.667277+00:00 : Updated ev_id=20241113195481 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-03 01:13:41.692279+00:00 : Updated ev_id=20241113195481 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-03 01:13:41.717277+00:00 : Updated ev_id=20241113195481 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-03 01:13:46.232021+00:00 : Updated ev_id=20221115106296 aircraft_key=1 inj_person_category=Flig injury_level=MINR.
Progress update 2025-02-03 01:13:46.257193+00:00 : Updated ev_id=20221115106296 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-03 01:13:46.282198+00:00 : Updated ev_id=20221115106296 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-03 01:13:46.307387+00:00 : Updated ev_id=20221115106296 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-03 01:13:46.332391+00:00 : Updated ev_id=20221223106489 aircraft_key=1 inj_person_category=Flig injury_level=MINR.
Progress update 2025-02-03 01:13:46.357314+00:00 : Updated ev_id=20221223106489 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-03 01:13:46.382320+00:00 : Updated ev_id=20221223106489 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-02-03 01:13:46.407703+00:00 : Updated ev_id=20221223106489 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-03 01:13:46.582902+00:00 : Updated ev_id=20230110106561 aircraft_key=1 inj_person_category=Flig injury_level=SERS.
Progress update 2025-02-03 01:13:46.607420+00:00 : Updated ev_id=20230110106561 aircraft_key=1 inj_person_category=Flig injury_level=MINR.
Progress update 2025-02-03 01:13:46.682095+00:00 : Updated ev_id=20230110106561 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-03 01:13:46.831942+00:00 : Updated ev_id=20230326106956 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-02-03 01:13:46.907441+00:00 : Updated ev_id=20230326106956 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-03 01:13:47.057291+00:00 : Updated ev_id=20230406107019 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-02-03 01:13:47.082292+00:00 : Updated ev_id=20230406107019 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-03 01:13:47.157295+00:00 : Updated ev_id=20230630192493 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-03 01:13:47.181810+00:00 : Updated ev_id=20230630192493 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-03 01:13:47.207323+00:00 : Updated ev_id=20230630192493 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-03 01:13:47.232328+00:00 : Updated ev_id=20230630192493 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-03 01:13:47.257455+00:00 : Updated ev_id=20230703192503 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-03 01:13:47.282453+00:00 : Updated ev_id=20230703192503 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-03 01:13:47.307973+00:00 : Updated ev_id=20230703192503 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-03 01:13:47.331971+00:00 : Updated ev_id=20230703192503 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-03 01:13:47.415996+00:00 : Updated ev_id=20230712192609 aircraft_key=1 inj_person_category=Flig injury_level=SERS.
Progress update 2025-02-03 01:13:47.440338+00:00 : Updated ev_id=20230712192609 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-03 01:13:47.464995+00:00 : Updated ev_id=20230712192609 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-03 01:13:47.501517+00:00 : Updated ev_id=20230712192609 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-03 01:13:47.532521+00:00 : Updated ev_id=20240722194742 aircraft_key=1 inj_person_category=Flig injury_level=MINR.
Progress update 2025-02-03 01:13:47.557108+00:00 : Updated ev_id=20240722194742 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-03 01:13:47.582108+00:00 : Updated ev_id=20240722194742 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-02-03 01:13:47.606622+00:00 : Updated ev_id=20240722194742 aircraft_key=1 inj_person_category=Pass injury_level=SERS.
Progress update 2025-02-03 01:13:47.631557+00:00 : Updated ev_id=20240722194742 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-03 01:13:48.489812+00:00 : Updated ev_id=20071115X01799 aircraft_key=1 inj_person_category=Pass injury_level=MINR.
Progress update 2025-02-03 01:13:48.520320+00:00 : Updated ev_id=20071115X01799 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-03 01:13:48.915678+00:00 : Updated ev_id=20241230199488 aircraft_key=1 inj_person_category=Flig injury_level=MINR.
Progress update 2025-02-03 01:13:48.939677+00:00 : Updated ev_id=20241230199488 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-03 01:13:48.989683+00:00 : Updated ev_id=20241230199488 aircraft_key=1 inj_person_category=Pass injury_level=MINR.
Progress update 2025-02-03 01:13:49.015195+00:00 : Updated ev_id=20241230199488 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-03 01:13:49.872377+00:00 : Updated ev_id=20241112195479 aircraft_key=1 inj_person_category=Cabi injury_level=FATL.
Progress update 2025-02-03 01:13:49.898019+00:00 : Updated ev_id=20241112195479 aircraft_key=1 inj_person_category=Cabi injury_level=SERS.
Progress update 2025-02-03 01:13:49.923539+00:00 : Updated ev_id=20241112195479 aircraft_key=1 inj_person_category=Cabi injury_level=MINR.
Progress update 2025-02-03 01:13:49.947672+00:00 : Updated ev_id=20241112195479 aircraft_key=1 inj_person_category=Cabi injury_level=NONE.
Progress update 2025-02-03 01:13:49.985008+00:00 : Updated ev_id=20241112195479 aircraft_key=1 inj_person_category=Cabi injury_level=TOTL.
Progress update 2025-02-03 01:13:50.014900+00:00 : Updated ev_id=20241112195479 aircraft_key=1 inj_person_category=Flig injury_level=FATL.
Progress update 2025-02-03 01:13:50.039431+00:00 : Updated ev_id=20241112195479 aircraft_key=1 inj_person_category=Flig injury_level=SERS.
Progress update 2025-02-03 01:13:50.064591+00:00 : Updated ev_id=20241112195479 aircraft_key=1 inj_person_category=Flig injury_level=MINR.
Progress update 2025-02-03 01:13:50.090167+00:00 : Updated ev_id=20241112195479 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-03 01:13:50.114405+00:00 : Updated ev_id=20241112195479 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-03 01:13:50.139913+00:00 : Updated ev_id=20241112195479 aircraft_key=1 inj_person_category=LapC injury_level=FATL.
Progress update 2025-02-03 01:13:50.163964+00:00 : Updated ev_id=20241112195479 aircraft_key=1 inj_person_category=LapC injury_level=SERS.
Progress update 2025-02-03 01:13:50.189573+00:00 : Updated ev_id=20241112195479 aircraft_key=1 inj_person_category=LapC injury_level=MINR.
Progress update 2025-02-03 01:13:50.214450+00:00 : Updated ev_id=20241112195479 aircraft_key=1 inj_person_category=LapC injury_level=NONE.
Progress update 2025-02-03 01:13:50.239107+00:00 : Updated ev_id=20241112195479 aircraft_key=1 inj_person_category=LapC injury_level=TOTL.
Progress update 2025-02-03 01:13:50.264236+00:00 : Updated ev_id=20241112195479 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-02-03 01:13:50.290242+00:00 : Updated ev_id=20241112195479 aircraft_key=1 inj_person_category=Pass injury_level=SERS.
Progress update 2025-02-03 01:13:50.314622+00:00 : Updated ev_id=20241112195479 aircraft_key=1 inj_person_category=Pass injury_level=MINR.
Progress update 2025-02-03 01:13:50.339589+00:00 : Updated ev_id=20241112195479 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-03 01:13:50.364589+00:00 : Updated ev_id=20241112195479 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-03 01:13:50.739719+00:00 : Updated ev_id=20241016195324 aircraft_key=1 inj_person_category=Flig injury_level=NONE.
Progress update 2025-02-03 01:13:50.764514+00:00 : Updated ev_id=20241016195324 aircraft_key=1 inj_person_category=Flig injury_level=TOTL.
Progress update 2025-02-03 01:13:50.789518+00:00 : Updated ev_id=20241016195324 aircraft_key=1 inj_person_category=Pass injury_level=FATL.
Progress update 2025-02-03 01:13:50.839812+00:00 : Updated ev_id=20241016195324 aircraft_key=1 inj_person_category=Pass injury_level=SERS.
Progress update 2025-02-03 01:13:50.864354+00:00 : Updated ev_id=20241016195324 aircraft_key=1 inj_person_category=Pass injury_level=MINR.
Progress update 2025-02-03 01:13:50.889358+00:00 : Updated ev_id=20241016195324 aircraft_key=1 inj_person_category=Pass injury_level=NONE.
Progress update 2025-02-03 01:13:50.916617+00:00 : Updated ev_id=20241016195324 aircraft_key=1 inj_person_category=Pass injury_level=TOTL.
Progress update 2025-02-03 01:13:51.556458+00:00 : Number rows selected : 505.
Progress update 2025-02-03 01:13:51.556458+00:00 : Number rows inserted : 386.
Progress update 2025-02-03 01:13:51.556458+00:00 : Number rows updated : 119.
Progress update 2025-02-03 01:13:51.556458+00:00 :
Progress update 2025-02-03 01:13:51.556458+00:00 : Database table : narratives <-----------------------------------.
Progress update 2025-02-03 01:13:51.688490+00:00 : Updated ev_id=20221115106294 aircraft_key=1.
Progress update 2025-02-03 01:13:51.822518+00:00 : Updated ev_id=20231031193330 aircraft_key=1.
Progress update 2025-02-03 01:13:51.897076+00:00 : Updated ev_id=20240620194502 aircraft_key=1.
Progress update 2025-02-03 01:13:52.345256+00:00 : Updated ev_id=20221115106296 aircraft_key=1.
Progress update 2025-02-03 01:13:52.405851+00:00 : Updated ev_id=20221223106489 aircraft_key=1.
Progress update 2025-02-03 01:13:52.522297+00:00 : Updated ev_id=20230110106561 aircraft_key=1.
Progress update 2025-02-03 01:13:52.672639+00:00 : Updated ev_id=20230326106956 aircraft_key=1.
Progress update 2025-02-03 01:13:52.747324+00:00 : Updated ev_id=20230406107019 aircraft_key=1.
Progress update 2025-02-03 01:13:52.863842+00:00 : Updated ev_id=20230630192493 aircraft_key=1.
Progress update 2025-02-03 01:13:52.980445+00:00 : Updated ev_id=20230703192503 aircraft_key=1.
Progress update 2025-02-03 01:13:53.114094+00:00 : Updated ev_id=20230712192609 aircraft_key=1.
Progress update 2025-02-03 01:13:53.164115+00:00 : Updated ev_id=20240722194742 aircraft_key=1.
Progress update 2025-02-03 01:13:53.296744+00:00 : Updated ev_id=20071115X01799 aircraft_key=1.
Progress update 2025-02-03 01:13:53.378774+00:00 : Updated ev_id=20070508X00530 aircraft_key=1.
Progress update 2025-02-03 01:13:53.421831+00:00 : Updated ev_id=20070530X00665 aircraft_key=1.
Progress update 2025-02-03 01:13:53.505064+00:00 : Updated ev_id=20070228X00236 aircraft_key=1.
Progress update 2025-02-03 01:13:53.655355+00:00 : Number rows selected : 35.
Progress update 2025-02-03 01:13:53.655355+00:00 : Number rows inserted : 19.
Progress update 2025-02-03 01:13:53.655355+00:00 : Number rows updated : 16.
Progress update 2025-02-03 01:13:53.656357+00:00 :
Progress update 2025-02-03 01:13:53.656357+00:00 : Database table : occurrences <-----------------------------------.
Progress update 2025-02-03 01:13:53.656357+00:00 : Number rows selected : 0.
Progress update 2025-02-03 01:13:53.656357+00:00 :
Progress update 2025-02-03 01:13:53.656357+00:00 : Database table : dt_flight_crew <-----------------------------------.
Progress update 2025-02-03 01:13:57.417235+00:00 : Updated ev_id=20071115X01799 Aircraft_Key=1 crew_no=1 col_name=crew_cert_code code=CFI.
Progress update 2025-02-03 01:13:57.454719+00:00 : Updated ev_id=20071115X01799 Aircraft_Key=1 crew_no=1 col_name=crew_cert_code code=COMM.
Progress update 2025-02-03 01:13:57.479391+00:00 : Updated ev_id=20071115X01799 Aircraft_Key=1 crew_no=1 col_name=crew_rat_airpln code=MEL.
Progress update 2025-02-03 01:13:57.504122+00:00 : Updated ev_id=20071115X01799 Aircraft_Key=1 crew_no=1 col_name=crew_rat_airpln code=SEL.
Progress update 2025-02-03 01:13:57.529126+00:00 : Updated ev_id=20071115X01799 Aircraft_Key=1 crew_no=1 col_name=crew_rat_instruct code=AME.
Progress update 2025-02-03 01:13:57.553925+00:00 : Updated ev_id=20071115X01799 Aircraft_Key=1 crew_no=1 col_name=crew_rat_instruct code=ASE.
Progress update 2025-02-03 01:13:57.578927+00:00 : Updated ev_id=20071115X01799 Aircraft_Key=1 crew_no=1 col_name=crew_rat_instruct code=HELI.
Progress update 2025-02-03 01:13:57.604926+00:00 : Updated ev_id=20071115X01799 Aircraft_Key=1 crew_no=1 col_name=crew_rat_instrum code=APLN.
Progress update 2025-02-03 01:13:57.628933+00:00 : Updated ev_id=20071115X01799 Aircraft_Key=1 crew_no=1 col_name=crew_rat_roto code=HELI.
Progress update 2025-02-03 01:13:57.687735+00:00 : Updated ev_id=20070508X00530 Aircraft_Key=1 crew_no=1 col_name=crew_cert_code code=STU.
Progress update 2025-02-03 01:13:57.713139+00:00 : Updated ev_id=20070508X00530 Aircraft_Key=1 crew_no=1 col_name=crew_rat_airpln code=NONE.
Progress update 2025-02-03 01:13:57.754341+00:00 : Updated ev_id=20070508X00530 Aircraft_Key=1 crew_no=1 col_name=crew_rat_instruct0 code=NONE.
Progress update 2025-02-03 01:13:57.788550+00:00 : Updated ev_id=20070508X00530 Aircraft_Key=1 crew_no=1 col_name=crew_rat_instrum0 code=NONE.
Progress update 2025-02-03 01:13:57.815359+00:00 : Updated ev_id=20070508X00530 Aircraft_Key=1 crew_no=1 col_name=crew_rat_roto0 code=NONE.
Progress update 2025-02-03 01:13:57.848906+00:00 : Updated ev_id=20070530X00665 Aircraft_Key=1 crew_no=1 col_name=crew_cert_code code=CFI.
Progress update 2025-02-03 01:13:57.881917+00:00 : Updated ev_id=20070530X00665 Aircraft_Key=1 crew_no=1 col_name=crew_cert_code code=COMM.
Progress update 2025-02-03 01:13:57.924244+00:00 : Updated ev_id=20070530X00665 Aircraft_Key=1 crew_no=1 col_name=crew_rat_airpln code=SEL.
Progress update 2025-02-03 01:13:57.945247+00:00 : Updated ev_id=20070530X00665 Aircraft_Key=1 crew_no=1 col_name=crew_rat_instruct0 code=NONE.
Progress update 2025-02-03 01:13:57.970911+00:00 : Updated ev_id=20070530X00665 Aircraft_Key=1 crew_no=1 col_name=crew_rat_instrum0 code=NONE.
Progress update 2025-02-03 01:13:57.999637+00:00 : Updated ev_id=20070530X00665 Aircraft_Key=1 crew_no=1 col_name=crew_rat_roto0 code=NONE.
Progress update 2025-02-03 01:13:58.395627+00:00 : Updated ev_id=20070228X00236 Aircraft_Key=1 crew_no=1 col_name=crew_cert_code code=ATP.
Progress update 2025-02-03 01:13:58.478143+00:00 : Updated ev_id=20070228X00236 Aircraft_Key=1 crew_no=1 col_name=crew_rat_airpln code=MEL.
Progress update 2025-02-03 01:13:58.503661+00:00 : Updated ev_id=20070228X00236 Aircraft_Key=1 crew_no=1 col_name=crew_rat_airpln code=SEL.
Progress update 2025-02-03 01:13:58.529227+00:00 : Updated ev_id=20070228X00236 Aircraft_Key=1 crew_no=1 col_name=crew_rat_instruct0 code=NONE.
Progress update 2025-02-03 01:13:58.570406+00:00 : Updated ev_id=20070228X00236 Aircraft_Key=1 crew_no=1 col_name=crew_rat_instrum code=APLN.
Progress update 2025-02-03 01:13:58.628407+00:00 : Updated ev_id=20070228X00236 Aircraft_Key=1 crew_no=1 col_name=crew_rat_roto0 code=NONE.
Progress update 2025-02-03 01:13:58.628407+00:00 : Number rows selected : 173.
Progress update 2025-02-03 01:13:58.628407+00:00 : Number rows inserted : 147.
Progress update 2025-02-03 01:13:58.628407+00:00 : Number rows updated : 26.
Progress update 2025-02-03 01:13:58.629406+00:00 :
Progress update 2025-02-03 01:13:58.629406+00:00 : Database table : flight_time <-----------------------------------.
Progress update 2025-02-03 01:14:09.750799+00:00 : Updated ev_id=20071115X01799 aircraft_key=1 crew_no=1 flight_type=L24H flight_craft=ALL.
Progress update 2025-02-03 01:14:09.775474+00:00 : Updated ev_id=20071115X01799 aircraft_key=1 crew_no=1 flight_type=L30D flight_craft=ALL.
Progress update 2025-02-03 01:14:09.801429+00:00 : Updated ev_id=20071115X01799 aircraft_key=1 crew_no=1 flight_type=L90D flight_craft=ALL.
Progress update 2025-02-03 01:14:09.825428+00:00 : Updated ev_id=20071115X01799 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=ALL.
Progress update 2025-02-03 01:14:09.850942+00:00 : Updated ev_id=20071115X01799 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=MAKE.
Progress update 2025-02-03 01:14:09.883030+00:00 : Updated ev_id=20071115X01799 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=MENG.
Progress update 2025-02-03 01:14:09.909541+00:00 : Updated ev_id=20071115X01799 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=NGHT.
Progress update 2025-02-03 01:14:09.934546+00:00 : Updated ev_id=20071115X01799 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=ROTO.
Progress update 2025-02-03 01:14:09.959158+00:00 : Updated ev_id=20071115X01799 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=SENG.
Progress update 2025-02-03 01:14:09.984170+00:00 : Updated ev_id=20071115X01799 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=SIMU.
Progress update 2025-02-03 01:14:10.026030+00:00 : Updated ev_id=20070508X00530 aircraft_key=1 crew_no=1 flight_type=L90D flight_craft=ALL.
Progress update 2025-02-03 01:14:10.042705+00:00 : Updated ev_id=20070508X00530 aircraft_key=1 crew_no=1 flight_type=L90D flight_craft=MAKE.
Progress update 2025-02-03 01:14:10.067546+00:00 : Updated ev_id=20070508X00530 aircraft_key=1 crew_no=1 flight_type=L90D flight_craft=SENG.
Progress update 2025-02-03 01:14:10.092894+00:00 : Updated ev_id=20070508X00530 aircraft_key=1 crew_no=1 flight_type=PIC flight_craft=ALL.
Progress update 2025-02-03 01:14:10.118047+00:00 : Updated ev_id=20070508X00530 aircraft_key=1 crew_no=1 flight_type=PIC flight_craft=MAKE.
Progress update 2025-02-03 01:14:10.141627+00:00 : Updated ev_id=20070508X00530 aircraft_key=1 crew_no=1 flight_type=PIC flight_craft=SENG.
Progress update 2025-02-03 01:14:10.167757+00:00 : Updated ev_id=20070508X00530 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=ALL.
Progress update 2025-02-03 01:14:10.192271+00:00 : Updated ev_id=20070508X00530 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=MAKE.
Progress update 2025-02-03 01:14:10.217388+00:00 : Updated ev_id=20070508X00530 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=NGHT.
Progress update 2025-02-03 01:14:10.242177+00:00 : Updated ev_id=20070508X00530 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=SENG.
Progress update 2025-02-03 01:14:10.267386+00:00 : Updated ev_id=20070508X00530 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=SIMU.
Progress update 2025-02-03 01:14:10.292514+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1 flight_type=INST flight_craft=ALL.
Progress update 2025-02-03 01:14:10.317061+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1 flight_type=INST flight_craft=MAKE.
Progress update 2025-02-03 01:14:10.342581+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1 flight_type=INST flight_craft=NGHT.
Progress update 2025-02-03 01:14:10.367361+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1 flight_type=INST flight_craft=SENG.
Progress update 2025-02-03 01:14:10.392020+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1 flight_type=INST flight_craft=SIMU.
Progress update 2025-02-03 01:14:10.408975+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1 flight_type=L24H flight_craft=ALL.
Progress update 2025-02-03 01:14:10.433857+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1 flight_type=L24H flight_craft=MAKE.
Progress update 2025-02-03 01:14:10.458860+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1 flight_type=L24H flight_craft=SENG.
Progress update 2025-02-03 01:14:10.485864+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1 flight_type=L30D flight_craft=ALL.
Progress update 2025-02-03 01:14:10.509376+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1 flight_type=L30D flight_craft=MAKE.
Progress update 2025-02-03 01:14:10.536380+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1 flight_type=L30D flight_craft=SENG.
Progress update 2025-02-03 01:14:10.558507+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1 flight_type=L90D flight_craft=ALL.
Progress update 2025-02-03 01:14:10.583511+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1 flight_type=L90D flight_craft=MAKE.
Progress update 2025-02-03 01:14:10.608483+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1 flight_type=L90D flight_craft=SENG.
Progress update 2025-02-03 01:14:10.642486+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1 flight_type=PIC flight_craft=ALL.
Progress update 2025-02-03 01:14:10.667483+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1 flight_type=PIC flight_craft=MAKE.
Progress update 2025-02-03 01:14:10.700997+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1 flight_type=PIC flight_craft=MENG.
Progress update 2025-02-03 01:14:10.726256+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1 flight_type=PIC flight_craft=NGHT.
Progress update 2025-02-03 01:14:10.759040+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1 flight_type=PIC flight_craft=SENG.
Progress update 2025-02-03 01:14:10.784043+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=ALL.
Progress update 2025-02-03 01:14:10.808565+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=MAKE.
Progress update 2025-02-03 01:14:10.833563+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=MENG.
Progress update 2025-02-03 01:14:10.859163+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=NGHT.
Progress update 2025-02-03 01:14:10.883645+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=SENG.
Progress update 2025-02-03 01:14:10.916503+00:00 : Updated ev_id=20070530X00665 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=SIMU.
Progress update 2025-02-03 01:14:11.560088+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=L24H flight_craft=ACTU.
Progress update 2025-02-03 01:14:11.575092+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=L24H flight_craft=ALL.
Progress update 2025-02-03 01:14:11.600602+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=L24H flight_craft=MAKE.
Progress update 2025-02-03 01:14:11.625604+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=L24H flight_craft=MENG.
Progress update 2025-02-03 01:14:11.650602+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=L24H flight_craft=NGHT.
Progress update 2025-02-03 01:14:11.687605+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=L24H flight_craft=SENG.
Progress update 2025-02-03 01:14:11.709114+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=L24H flight_craft=SIMU.
Progress update 2025-02-03 01:14:11.734118+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=L30D flight_craft=ACTU.
Progress update 2025-02-03 01:14:11.758477+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=L30D flight_craft=ALL.
Progress update 2025-02-03 01:14:11.783483+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=L30D flight_craft=MAKE.
Progress update 2025-02-03 01:14:11.808995+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=L30D flight_craft=MENG.
Progress update 2025-02-03 01:14:11.841994+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=L30D flight_craft=NGHT.
Progress update 2025-02-03 01:14:11.866995+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=L30D flight_craft=SENG.
Progress update 2025-02-03 01:14:11.892112+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=L30D flight_craft=SIMU.
Progress update 2025-02-03 01:14:11.917114+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=L90D flight_craft=ACTU.
Progress update 2025-02-03 01:14:11.942118+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=L90D flight_craft=ALL.
Progress update 2025-02-03 01:14:11.967208+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=L90D flight_craft=MAKE.
Progress update 2025-02-03 01:14:11.991723+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=L90D flight_craft=MENG.
Progress update 2025-02-03 01:14:12.017724+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=L90D flight_craft=NGHT.
Progress update 2025-02-03 01:14:12.041725+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=L90D flight_craft=SENG.
Progress update 2025-02-03 01:14:12.066725+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=L90D flight_craft=SIMU.
Progress update 2025-02-03 01:14:12.092240+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=PIC flight_craft=ACTU.
Progress update 2025-02-03 01:14:12.117239+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=PIC flight_craft=ALL.
Progress update 2025-02-03 01:14:12.141753+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=PIC flight_craft=MAKE.
Progress update 2025-02-03 01:14:12.166868+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=PIC flight_craft=MENG.
Progress update 2025-02-03 01:14:12.191380+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=PIC flight_craft=NGHT.
Progress update 2025-02-03 01:14:12.208383+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=PIC flight_craft=SENG.
Progress update 2025-02-03 01:14:12.233381+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=PIC flight_craft=SIMU.
Progress update 2025-02-03 01:14:12.263382+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=ACTU.
Progress update 2025-02-03 01:14:12.283387+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=ALL.
Progress update 2025-02-03 01:14:12.308899+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=GLDR.
Progress update 2025-02-03 01:14:12.332900+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=LTA.
Progress update 2025-02-03 01:14:12.358413+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=MAKE.
Progress update 2025-02-03 01:14:12.391497+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=MENG.
Progress update 2025-02-03 01:14:12.416496+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=NGHT.
Progress update 2025-02-03 01:14:12.441497+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=ROTO.
Progress update 2025-02-03 01:14:12.467497+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=SENG.
Progress update 2025-02-03 01:14:12.492009+00:00 : Updated ev_id=20070228X00236 aircraft_key=1 crew_no=1 flight_type=TOTL flight_craft=SIMU.
Progress update 2025-02-03 01:14:12.492009+00:00 : Number rows selected : 556.
Progress update 2025-02-03 01:14:12.492009+00:00 : Number rows inserted : 472.
Progress update 2025-02-03 01:14:12.492009+00:00 : Number rows updated : 84.
Progress update 2025-02-03 01:14:12.492009+00:00 :
Progress update 2025-02-03 01:14:12.493009+00:00 : Database table : seq_of_events <-----------------------------------.
Progress update 2025-02-03 01:14:12.493009+00:00 : Number rows selected : 0.
Progress update 2025-02-03 01:14:12.673452+00:00 : INFO.00.065 Cleansing PostgreSQL data.
Progress update 2025-02-03 01:14:12.674448+00:00 : --------------------------------------------------------------------------------
2025-02-03 02:14:12,674 [root] [db_utils.py ] INFO INFO.00.080 Admin connect request host=localhost port=5432 dbname=io_aero_db user=io_aero
Progress update 2025-02-03 01:14:12.728962+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'acft_category'.
Progress update 2025-02-03 01:14:13.804097+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-03 01:14:13.804097+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'dest_country'.
Progress update 2025-02-03 01:14:14.858719+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-03 01:14:14.858719+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'dprt_country'.
Progress update 2025-02-03 01:14:15.957360+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-03 01:14:15.957360+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'far_part'.
Progress update 2025-02-03 01:14:16.955786+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-03 01:14:16.955786+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'oper_country'.
Progress update 2025-02-03 01:14:17.955316+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-03 01:14:17.956317+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'owner_country'.
Progress update 2025-02-03 01:14:18.923871+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-03 01:14:18.923871+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'regis_no'.
Progress update 2025-02-03 01:14:19.431588+00:00 : Number cols trimmed : 1.
Progress update 2025-02-03 01:14:19.884710+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-03 01:14:19.885711+00:00 : INFO.00.066 Cleansing table 'events' column 'ev_city'.
Progress update 2025-02-03 01:14:19.947155+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-03 01:14:19.947155+00:00 : INFO.00.066 Cleansing table 'events' column 'ev_site_zipcode'.
Progress update 2025-02-03 01:14:20.004329+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-03 01:14:20.004830+00:00 : INFO.00.066 Cleansing table 'events' column 'latitude'.
Progress update 2025-02-03 01:14:20.053411+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-03 01:14:20.053411+00:00 : INFO.00.066 Cleansing table 'events' column 'longitude'.
Progress update 2025-02-03 01:14:20.098136+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-03 01:14:20.098136+00:00 : INFO.00.066 Cleansing table 'events_sequence' column 'occurrence_code'.
Progress update 2025-02-03 01:14:20.127819+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-03 01:14:20.127819+00:00 : 78 s - Total time launcher.
Progress update 2025-02-03 01:14:20.127819+00:00 : INFO.00.006 End Launcher.
Progress update 2025-02-03 01:14:20.127819+00:00 : ===============================================================================.
2025-02-03 02:14:21,846 [root] [io_logger.py ] INFO You are using io-aero's iocommon version 1.2.63 logger (Copyright (c) 2022-2024 IO-Aero)
2025-02-03 02:14:21,846 [root] [io_settings.py ] INFO Starting the configuration management system.
2025-02-03 02:14:21,846 [root] [io_settings.py ] INFO Running in a source (non-compiled) environment. Configuration loading from: D:\SoftDevelopment\Projects\IO-Aero\io-avstats
2025-02-03 02:14:21,846 [root] [io_settings.py ] INFO Dynaconf settings loaded successfully.
Progress update 2025-02-03 01:14:23.481960+00:00 : ===============================================================================.
Progress update 2025-02-03 01:14:23.481960+00:00 : INFO.00.004 Start Launcher.
2025-02-03 02:14:23,481 [root] [launcher.py ] INFO param argv=['scripts\\launcher.py', '-t', 'c_l_l']
2025-02-03 02:14:23,481 [root] [launcher.py ] INFO Start launcher.py
2025-02-03 02:14:23,492 [root] [launcher.py ] INFO locale=('en_US', 'UTF-8')
Progress update 2025-02-03 01:14:23.493962+00:00 : INFO.00.005 Argument task='c_l_l'.
Progress update 2025-02-03 01:14:23.493962+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-03 01:14:23.493962+00:00 : INFO.00.040 Correct decimal US latitudes and longitudes.
Progress update 2025-02-03 01:14:23.493962+00:00 : --------------------------------------------------------------------------------
2025-02-03 02:14:23,494 [root] [db_utils.py ] INFO INFO.00.080 Admin connect request host=localhost port=5432 dbname=io_aero_db user=io_aero
2025-02-03 02:14:23,623 [root] [db_utils.py ] INFO INFO.00.080 Admin connect request host=localhost port=5432 dbname=io_aero_db user=io_aero
Progress update 2025-02-03 01:14:35.660172+00:00 : Number of rows so far read : 10000.
Progress update 2025-02-03 01:14:45.529605+00:00 : Number of rows so far read : 20000.
Progress update 2025-02-03 01:14:55.188711+00:00 : Number of rows so far read : 30000.
Progress update 2025-02-03 01:15:04.944470+00:00 : Number of rows so far read : 40000.
Progress update 2025-02-03 01:15:11.892181+00:00 : Number of rows so far read : 50000.
Progress update 2025-02-03 01:15:17.949267+00:00 : Number of rows so far read : 60000.
Progress update 2025-02-03 01:15:23.906230+00:00 : Number of rows so far read : 70000.
Progress update 2025-02-03 01:15:29.837796+00:00 : Number of rows so far read : 80000.
Progress update 2025-02-03 01:15:35.710934+00:00 : Number of rows so far read : 90000.
Progress update 2025-02-03 01:15:42.284743+00:00 : Number of rows so far read : 100000.
Progress update 2025-02-03 01:15:50.236276+00:00 : Number of rows so far read : 110000.
Progress update 2025-02-03 01:15:58.912837+00:00 : Number of rows so far read : 120000.
Progress update 2025-02-03 01:16:05.470149+00:00 : Number of rows so far read : 130000.
Progress update 2025-02-03 01:16:11.584673+00:00 : Number of rows so far read : 140000.
Progress update 2025-02-03 01:16:13.509086+00:00 : Number rows selected : 142858.
Progress update 2025-02-03 01:16:13.510087+00:00 : Number rows updated : 142858.
Progress update 2025-02-03 01:16:13.538609+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-03 01:16:13.538609+00:00 : 110 s - Total time launcher.
Progress update 2025-02-03 01:16:13.538609+00:00 : INFO.00.006 End Launcher.
Progress update 2025-02-03 01:16:13.539608+00:00 : ===============================================================================.
2025-02-03 02:16:15,359 [root] [io_logger.py ] INFO You are using io-aero's iocommon version 1.2.63 logger (Copyright (c) 2022-2024 IO-Aero)
2025-02-03 02:16:15,360 [root] [io_settings.py ] INFO Starting the configuration management system.
2025-02-03 02:16:15,360 [root] [io_settings.py ] INFO Running in a source (non-compiled) environment. Configuration loading from: D:\SoftDevelopment\Projects\IO-Aero\io-avstats
2025-02-03 02:16:15,361 [root] [io_settings.py ] INFO Dynaconf settings loaded successfully.
Progress update 2025-02-03 01:16:17.112754+00:00 : ===============================================================================.
Progress update 2025-02-03 01:16:17.112754+00:00 : INFO.00.004 Start Launcher.
2025-02-03 02:16:17,112 [root] [launcher.py ] INFO param argv=['scripts\\launcher.py', '-t', 'f_n_a']
2025-02-03 02:16:17,113 [root] [launcher.py ] INFO Start launcher.py
2025-02-03 02:16:17,125 [root] [launcher.py ] INFO locale=('en_US', 'UTF-8')
Progress update 2025-02-03 01:16:17.126273+00:00 : INFO.00.005 Argument task='f_n_a'.
Progress update 2025-02-03 01:16:17.126273+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-03 01:16:17.127269+00:00 : INFO.00.086 Find the nearest airports.
Progress update 2025-02-03 01:16:17.127269+00:00 : --------------------------------------------------------------------------------
2025-02-03 02:16:17,127 [root] [db_utils.py ] INFO INFO.00.080 Admin connect request host=localhost port=5432 dbname=io_aero_db user=io_aero
2025-02-03 02:16:17,236 [root] [db_utils.py ] INFO INFO.00.080 Admin connect request host=localhost port=5432 dbname=io_aero_db user=io_aero
Progress update 2025-02-03 01:16:46.216835+00:00 : Number of rows so far read : 10000.
Progress update 2025-02-03 01:17:13.726194+00:00 : Number of rows so far read : 20000.
Progress update 2025-02-03 01:17:40.485865+00:00 : Number of rows so far read : 30000.
Progress update 2025-02-03 01:18:09.137016+00:00 : Number of rows so far read : 40000.
Progress update 2025-02-03 01:18:35.004681+00:00 : Number of rows so far read : 50000.
Progress update 2025-02-03 01:18:35.086910+00:00 : ERROR.00.942 Event '20220711105442': issue with the Haversine algorithm: 'Longitude -894627.0 is out of range [-180, 180]'.
Progress update 2025-02-03 01:19:02.155418+00:00 : Number of rows so far read : 60000.
Progress update 2025-02-03 01:19:29.081326+00:00 : Number of rows so far read : 70000.
Progress update 2025-02-03 01:19:31.442543+00:00 : ERROR.00.942 Event '20210419102938': issue with the Haversine algorithm: 'Latitude 4603.0 is out of range [-90, 90]'.
Progress update 2025-02-03 01:19:31.442543+00:00 : ERROR.00.942 Event '20221027106211': issue with the Haversine algorithm: 'Latitude 36940.21 is out of range [-90, 90]'.
Progress update 2025-02-03 01:19:31.442543+00:00 : ERROR.00.942 Event '20221108106263': issue with the Haversine algorithm: 'Latitude 390408.0 is out of range [-90, 90]'.
Progress update 2025-02-03 01:19:31.442543+00:00 : ERROR.00.942 Event '20220803105651': issue with the Haversine algorithm: 'Latitude 41370104.0 is out of range [-90, 90]'.
Progress update 2025-02-03 01:19:31.442543+00:00 : ERROR.00.942 Event '20221108106264': issue with the Haversine algorithm: 'Latitude 43511185.0 is out of range [-90, 90]'.
Progress update 2025-02-03 01:19:31.464560+00:00 : Number rows selected : 70926.
Progress update 2025-02-03 01:19:31.465560+00:00 : Number rows updated : 70920.
Progress update 2025-02-03 01:19:31.467560+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-03 01:19:31.467560+00:00 : 194 s - Total time launcher.
Progress update 2025-02-03 01:19:31.467560+00:00 : INFO.00.006 End Launcher.
Progress update 2025-02-03 01:19:31.467560+00:00 : ===============================================================================.
2025-02-03 02:19:33,380 [root] [io_logger.py ] INFO You are using io-aero's iocommon version 1.2.63 logger (Copyright (c) 2022-2024 IO-Aero)
2025-02-03 02:19:33,381 [root] [io_settings.py ] INFO Starting the configuration management system.
2025-02-03 02:19:33,381 [root] [io_settings.py ] INFO Running in a source (non-compiled) environment. Configuration loading from: D:\SoftDevelopment\Projects\IO-Aero\io-avstats
2025-02-03 02:19:33,381 [root] [io_settings.py ] INFO Dynaconf settings loaded successfully.
Progress update 2025-02-03 01:19:35.327591+00:00 : ===============================================================================.
Progress update 2025-02-03 01:19:35.327591+00:00 : INFO.00.004 Start Launcher.
2025-02-03 02:19:35,327 [root] [launcher.py ] INFO param argv=['scripts\\launcher.py', '-t', 'v_n_d']
2025-02-03 02:19:35,327 [root] [launcher.py ] INFO Start launcher.py
2025-02-03 02:19:35,339 [root] [launcher.py ] INFO locale=('en_US', 'UTF-8')
Progress update 2025-02-03 01:19:35.340591+00:00 : INFO.00.005 Argument task='v_n_d'.
Progress update 2025-02-03 01:19:35.340591+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-03 01:19:35.340591+00:00 : INFO.00.043 Verify selected NTSB data.
Progress update 2025-02-03 01:19:35.340591+00:00 : --------------------------------------------------------------------------------
2025-02-03 02:19:35,341 [root] [db_utils.py ] INFO INFO.00.080 Admin connect request host=localhost port=5432 dbname=io_aero_db user=io_aero
Progress update 2025-02-03 01:19:37.813423+00:00 : INFO.00.063 Processed data source 'events'.
Progress update 2025-02-03 01:19:37.813423+00:00 : Number cols deleted : 91388.
Progress update 2025-02-03 01:19:37.813423+00:00 : --------------------------------------------------------------------------------
2025-02-03 02:19:37,814 [root] [db_utils.py ] INFO INFO.00.080 Admin connect request host=localhost port=5432 dbname=io_aero_db user=io_aero
Progress update 2025-02-03 01:19:37.896939+00:00 : INFO.00.064 Verification of table 'events' column(s) 'latitude & longitude'.
Progress update 2025-02-03 01:19:37.896939+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-03 01:19:40.270744+00:00 : Number of rows so far read : 10000.
Progress update 2025-02-03 01:19:42.120595+00:00 : Number of rows so far read : 20000.
Progress update 2025-02-03 01:19:43.919569+00:00 : Number of rows so far read : 30000.
Progress update 2025-02-03 01:19:45.852882+00:00 : Number of rows so far read : 40000.
Progress update 2025-02-03 01:19:48.168061+00:00 : Number of rows so far read : 50000.
Progress update 2025-02-03 01:19:52.149966+00:00 : Number of rows so far read : 60000.
Progress update 2025-02-03 01:19:56.108168+00:00 : Number of rows so far read : 70000.
Progress update 2025-02-03 01:19:59.423735+00:00 : Number rows errors : 27962.
Progress update 2025-02-03 01:19:59.423735+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-03 01:19:59.424737+00:00 : INFO.00.064 Verification of table 'events' column(s) 'ev_city'.
Progress update 2025-02-03 01:19:59.891566+00:00 : Number rows errors : 6253.
Progress update 2025-02-03 01:19:59.892567+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-03 01:19:59.892567+00:00 : INFO.00.064 Verification of table 'events' column(s) 'ev_city & ev_site_zipcode'.
Progress update 2025-02-03 01:20:00.703606+00:00 : Number rows errors : 16960.
Progress update 2025-02-03 01:20:00.703606+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-03 01:20:00.703606+00:00 : INFO.00.064 Verification of table 'events' column(s) 'ev_state'.
Progress update 2025-02-03 01:20:00.739628+00:00 : Number rows errors : 176.
Progress update 2025-02-03 01:20:00.739628+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-03 01:20:00.739628+00:00 : INFO.00.064 Verification of table 'events' column(s) 'ev_site_zipcode'.
Progress update 2025-02-03 01:20:01.000756+00:00 : Number rows errors : 5139.
Progress update 2025-02-03 01:20:01.000756+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-03 01:20:01.000756+00:00 : Number rows selected : 76772.
Progress update 2025-02-03 01:20:01.000756+00:00 : Number rows updated : 56490.
Progress update 2025-02-03 01:20:01.001757+00:00 : Number rows errors : 56490.
Progress update 2025-02-03 01:20:01.003757+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-03 01:20:01.003757+00:00 : 25 s - Total time launcher.
Progress update 2025-02-03 01:20:01.004757+00:00 : INFO.00.006 End Launcher.
Progress update 2025-02-03 01:20:01.004757+00:00 : ===============================================================================.
2025-02-03 02:20:02,761 [root] [io_logger.py ] INFO You are using io-aero's iocommon version 1.2.63 logger (Copyright (c) 2022-2024 IO-Aero)
2025-02-03 02:20:02,762 [root] [io_settings.py ] INFO Starting the configuration management system.
2025-02-03 02:20:02,762 [root] [io_settings.py ] INFO Running in a source (non-compiled) environment. Configuration loading from: D:\SoftDevelopment\Projects\IO-Aero\io-avstats
2025-02-03 02:20:02,762 [root] [io_settings.py ] INFO Dynaconf settings loaded successfully.
Progress update 2025-02-03 01:20:04.662147+00:00 : ===============================================================================.
Progress update 2025-02-03 01:20:04.662147+00:00 : INFO.00.004 Start Launcher.
2025-02-03 02:20:04,662 [root] [launcher.py ] INFO param argv=['scripts\\launcher.py', '-t', 'r_d_s']
2025-02-03 02:20:04,663 [root] [launcher.py ] INFO Start launcher.py
2025-02-03 02:20:04,674 [root] [launcher.py ] INFO locale=('en_US', 'UTF-8')
Progress update 2025-02-03 01:20:04.675154+00:00 : INFO.00.005 Argument task='r_d_s'.
Progress update 2025-02-03 01:20:04.675154+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-03 01:20:04.676159+00:00 : INFO.00.071 Refreshing the database schema.
Progress update 2025-02-03 01:20:04.676159+00:00 : --------------------------------------------------------------------------------
2025-02-03 02:20:04,676 [root] [db_utils.py ] INFO INFO.00.080 Admin connect request host=localhost port=5432 dbname=io_aero_db user=io_aero
Progress update 2025-02-03 01:20:04.737890+00:00 :
Progress update 2025-02-03 01:20:04.738414+00:00 : Database table : io_md_codes_eventsoe <-----------------------------------.
Progress update 2025-02-03 01:20:04.788888+00:00 : Number rows deleted : 13.
Progress update 2025-02-03 01:20:04.850309+00:00 : Number rows selected : 1558.
Progress update 2025-02-03 01:20:07.379590+00:00 : Number rows inserted : 96.
Progress update 2025-02-03 01:20:07.380592+00:00 :
Progress update 2025-02-03 01:20:07.380592+00:00 : Database table : io_md_codes_phase <-----------------------------------.
Progress update 2025-02-03 01:20:07.422230+00:00 : Number rows deleted : 12.
Progress update 2025-02-03 01:20:07.477124+00:00 : Number rows selected : 1558.
Progress update 2025-02-03 01:20:08.845131+00:00 : Number rows inserted : 48.
Progress update 2025-02-03 01:20:08.846131+00:00 :
Progress update 2025-02-03 01:20:08.846131+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-03 01:20:08.846131+00:00 : INFO.00.084 Database table io_md_codes_phase: Load description_main_phase from file 'data/Main_Phases_of_Flight/main_phases_of_flight.xlsx'.
Progress update 2025-02-03 01:20:08.846131+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-03 01:20:10.154008+00:00 : Number rows selected : 48.
Progress update 2025-02-03 01:20:10.154008+00:00 : Number rows updated : 48.
Progress update 2025-02-03 01:20:10.155010+00:00 :
Progress update 2025-02-03 01:20:10.155010+00:00 : Database table : io_md_codes_category <-----------------------------------.
Progress update 2025-02-03 01:20:10.207013+00:00 : Number rows deleted : 4.
Progress update 2025-02-03 01:20:10.743694+00:00 : Number rows selected : 7610.
Progress update 2025-02-03 01:20:10.897799+00:00 : Number rows inserted : 5.
Progress update 2025-02-03 01:20:10.903804+00:00 :
Progress update 2025-02-03 01:20:10.903804+00:00 : Database table : io_md_codes_subcategory <-----------------------------------.
Progress update 2025-02-03 01:20:11.244883+00:00 : Number rows selected : 7610.
Progress update 2025-02-03 01:20:12.423927+00:00 : Number rows inserted : 21.
Progress update 2025-02-03 01:20:12.424925+00:00 :
Progress update 2025-02-03 01:20:12.424925+00:00 : Database table : io_md_codes_section <-----------------------------------.
Progress update 2025-02-03 01:20:12.682682+00:00 : Number rows selected : 7610.
Progress update 2025-02-03 01:20:19.918894+00:00 : Number rows inserted : 129.
Progress update 2025-02-03 01:20:19.919895+00:00 :
Progress update 2025-02-03 01:20:19.919895+00:00 : Database table : io_md_codes_subsection <-----------------------------------.
Progress update 2025-02-03 01:20:20.177811+00:00 : Number rows selected : 7610.
Progress update 2025-02-03 01:20:39.654978+00:00 : Number rows inserted : 776.
Progress update 2025-02-03 01:20:39.655978+00:00 :
Progress update 2025-02-03 01:20:39.655978+00:00 : Database table : io_md_codes_modifier <-----------------------------------.
Progress update 2025-02-03 01:20:39.696689+00:00 : Number rows deleted : 8.
Progress update 2025-02-03 01:20:39.934035+00:00 : Number rows selected : 7610.
Progress update 2025-02-03 01:20:41.604303+00:00 : Number rows inserted : 74.
Progress update 2025-02-03 01:24:02.899845+00:00 : INFO.00.069 Materialized database view is refreshed: io_app_ae1982.
Progress update 2025-02-03 01:24:02.899845+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-03 01:24:02.899845+00:00 : 238 s - Total time launcher.
Progress update 2025-02-03 01:24:02.899845+00:00 : INFO.00.006 End Launcher.
Progress update 2025-02-03 01:24:02.900846+00:00 : ===============================================================================.
---------------------------------------------------------------------------
The current time is: 2:24:03.53
Enter the new time:
---------------------------------------------------------------------------
End run_io_avstats_dev
===========================================================================