v019 no AI

October 13, 20241 yr

Author

31 minutes ago, nunomigpe said:

Hello

i was able to have traffic, no interations or warning but appear on map, now i cann t be able even to show dont know why

Best Regards

i restart v3 insert rlyplan again, and now it seems to appear AI, but last 2 flyghts nothing....

log 7

log8 with CTD

CREATE TABLE [CycleInfo] (
   [Manufacturer]   nvarchar(50) COLLATE NOCASE,
   [Provider]   nvarchar(50) COLLATE NOCASE,
   [AIRAC_Cycle]   nvarchar(4) COLLATE NOCASE,
   [Version]   nvarchar(2) COLLATE NOCASE,
   [Start_Date]   nvarchar(10) COLLATE NOCASE,
   [End_Date]   nvarchar(10) COLLATE NOCASE,
   [Parsed_At]   char(25) COLLATE NOCASE

);

2024-10-12 21:08:24.9733|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [TERP_Legs] (
   [Id]   integer PRIMARY KEY AUTOINCREMENT NOT NULL,
   [Type]   integer,
   [Identifier]   nvarchar COLLATE NOCASE,
   [Latitude]   float,
   [Longitude]   float,
   [NavaidIdentifier]   nvarchar COLLATE NOCASE,
   [WPtBearing]   float,
   [WPDistance]   float,
   [AltitudeConstraint]   integer,
   [FirstAltitude]   integer,
   [SecondAltitude]   integer,
   [SpeedConstraint]   integer,
   [FirstSpeed]   integer,
   [SecondSpeed]   integer,
   [SpecialWaypoint]   integer,
   [OverFlyWaypoint]   bit,
   [MissedApprFix]   bit,
   [TurnDirection]   integer,
   [MagCourse]   float,
   [DistanceNM]   float,
   [SweepAngle]   float,
   [DMEDistanceNM]   float,
   [StartRadial]   integer,
   [ArcCenterFix_Id]   integer,
   [Radius]   float,
   [LegDistanceType]   integer,
   [APPRTransition_Id]   integer,
   [STAR_Id]   integer,
   [FINALApproach_Id]   integer,
   [SID_Id]   integer,
   [NavaidNavFix_Id]   integer,
   [NavaidType]   integer,
   [NavFix_Id]   integer
,
FOREIGN KEY ([APPRTransition_Id])
REFERENCES [APPRTransitions]([Id]),
FOREIGN KEY ([STAR_Id])
REFERENCES [STARs]([Id]),
FOREIGN KEY ([FINALApproach_Id])
REFERENCES [FINALApproaches]([Id]),
FOREIGN KEY ([SID_Id])
REFERENCES [SIDs]([Id])
);

2024-10-12 21:08:24.9942|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [Helipads] (
   [Id]   integer PRIMARY KEY AUTOINCREMENT NOT NULL,
   [SurfaceType]   integer,
   [Position_Latitude]   real,
   [Position_Longitude]   real,
   [Elevation]   real,
   [Length]   real,
   [WIdth]   real,
   [Heading]   real,
   [UserModified]   bit,
   [Airport_Id]   integer NOT NULL
,
FOREIGN KEY ([Airport_Id])
REFERENCES [Airports]([Id])
);
CREATE INDEX [Helipads_IX_FK_AirportHelipad]
ON [Helipads]
([Airport_Id] DESC);

2024-10-12 21:08:25.0082|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [FuelPoints] (
   [Id]   integer PRIMARY KEY AUTOINCREMENT NOT NULL,
   [Position_Latitude]   real,
   [Position_Longitude]   real,
   [UserModified]   bit,
   [Airport_Id]   integer NOT NULL
,
FOREIGN KEY ([Airport_Id])
REFERENCES [Airports]([Id])
);
CREATE INDEX [FuelPoints_IX_FK_AirportFuelPoint]
ON [FuelPoints]
([Airport_Id] DESC);

2024-10-12 21:08:25.0232|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [Fuels] (
   [Id]   integer PRIMARY KEY AUTOINCREMENT NOT NULL,
   [Type]   integer,
   [Availability]   integer,
   [FuelPoint_Id]   integer NOT NULL
,
FOREIGN KEY ([FuelPoint_Id])
REFERENCES [FuelPoints]([Id])
);
CREATE INDEX [Fuels_IX_FK_FuelPointFuel]
ON [Fuels]
([FuelPoint_Id] DESC);

2024-10-12 21:08:25.0371|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [TaxiPoints] (
   [Id]   integer PRIMARY KEY AUTOINCREMENT NOT NULL,
   [Type]   integer,
   [Position_Latitude]   real,
   [Position_Longitude]   real,
   [Reverse]   bit,
   [Name]   nvarchar COLLATE NOCASE,
   [Radius]   real,
   [Heading]   real,
   [PushbackType]   integer,
   [ParkType]   integer,
   [UserModified]   bit,
   [Airport_Id]   integer NOT NULL
,
FOREIGN KEY ([Airport_Id])
REFERENCES [Airports]([Id])
);
CREATE INDEX [TaxiPoints_IX_FK_AirportTaxiPoint]
ON [TaxiPoints]
([Airport_Id] DESC);

2024-10-12 21:08:25.0511|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [TaxiPaths] (
   [Id]   integer PRIMARY KEY AUTOINCREMENT NOT NULL,
   [Type]   integer,
   [SurfaceType]   integer,
   [Width]   real,
   [WeightLimit]   real,
   [Name]   nvarchar COLLATE NOCASE,
   [NameIndex]   smallint,
   [UserModified]   bit,
   [Airport_Id]   integer NOT NULL
,
FOREIGN KEY ([Airport_Id])
REFERENCES [Airports]([Id])
);
CREATE INDEX [TaxiPaths_IX_FK_AirportTaxiPath]
ON [TaxiPaths]
([Airport_Id] DESC);

2024-10-12 21:08:25.0511|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [SIDs] (
   [Id]   integer PRIMARY KEY AUTOINCREMENT NOT NULL,
   [Name]   nvarchar COLLATE NOCASE,
   [UserModified]   bit,
   [TransitionName]   nvarchar COLLATE NOCASE,
   [SIDSegmentType]   integer,
   [Airport_Id]   integer NOT NULL
,
FOREIGN KEY ([Airport_Id])
REFERENCES [Airports]([Id])
);
CREATE INDEX [SIDs_IX_FK_AirportSID]
ON [SIDs]
([Airport_Id] DESC);

2024-10-12 21:08:25.0800|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [STARs] (
   [Id]   integer PRIMARY KEY AUTOINCREMENT NOT NULL,
   [Name]   nvarchar COLLATE NOCASE,
   [UserModified]   bit,
   [TransitionName]   nvarchar COLLATE NOCASE,
   [STARSegmentType]   integer,
   [Airport_Id]   integer NOT NULL
,
FOREIGN KEY ([Airport_Id])
REFERENCES [Airports]([Id])
);
CREATE INDEX [STARs_IX_FK_AirportSTAR]
ON [STARs]
([Airport_Id] DESC);

2024-10-12 21:08:25.0950|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [APPRTransitions] (
   [Id]   integer PRIMARY KEY AUTOINCREMENT NOT NULL,
   [Name]   nvarchar COLLATE NOCASE,
   [TransitionFixICAO]   nvarchar COLLATE NOCASE,
   [RunwayName]   nvarchar COLLATE NOCASE,
   [FINALApproach_Id]   integer NOT NULL,
   [Airport_Id]   integer NOT NULL
,
FOREIGN KEY ([FINALApproach_Id])
REFERENCES [FINALApproaches]([Id]),
FOREIGN KEY ([Airport_Id])
REFERENCES [Airports]([Id])
);
CREATE INDEX [APPRTransitions_IX_FK_APPRTransitionFINALApproach]
ON [APPRTransitions]
([FINALApproach_Id] DESC);

2024-10-12 21:08:25.1102|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [FINALApproaches] (
   [Id]   integer PRIMARY KEY AUTOINCREMENT NOT NULL,
   [ApprName]   nvarchar COLLATE NOCASE,
   [RunwayName]   nvarchar COLLATE NOCASE,
   [ApprType]   integer,
   [Runway_Id]   integer NOT NULL,
   [Airport_Id]   integer NOT NULL,
   [MissedApproachStartIndex]   integer
,
FOREIGN KEY ([Runway_Id])
REFERENCES [Runways]([Id]),
FOREIGN KEY ([Airport_Id])
REFERENCES [Airports]([Id])
);
CREATE INDEX [FINALApproaches_IX_FK_FINALApproachAirport]
ON [FINALApproaches]
([Airport_Id] DESC);
CREATE INDEX [FINALApproaches_IX_FK_FINALApproachRunway]
ON [FINALApproaches]
([Runway_Id] DESC);

2024-10-12 21:08:25.1338|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [Runways] (
   [Id]   integer PRIMARY KEY AUTOINCREMENT NOT NULL,
   [Name]   nvarchar COLLATE NOCASE,
   [Elevation]   real,
   [Length]   real,
   [Width]   real,
   [SurfaceType]   integer,
   [Heading]   real,
   [PatternAltitude]   real,
   [Takeoff]   bit,
   [Landing]   bit,
   [Position_Latitude]   real,
   [Position_Longitude]   real,
   [PatternDirection]   nvarchar COLLATE NOCASE,
   [MidPosition_Latitude]   real,
   [MidPosition_Longitude]   real,
   [Type]   integer,
   [UserModified]   bit,
   [Airport_Id]   integer NOT NULL
,
FOREIGN KEY ([Airport_Id])
REFERENCES [Airports]([Id])
);
CREATE INDEX [Runways_IX_FK_AirportRunway]
ON [Runways]
([Airport_Id] DESC);

2024-10-12 21:08:25.1477|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [GlideSlopes] (
   [Id]   integer PRIMARY KEY AUTOINCREMENT NOT NULL,
   [Position_Latitude]   real,
   [Position_Longitude]   real,
   [Elevation]   real,
   [Range]   real,
   [Pitch]   real,
   [UserModified]   bit,
   [ILS_Id]   integer
,
FOREIGN KEY ([ILS_Id])
REFERENCES [ILSs]([Id])
);
CREATE INDEX [GlideSlopes_IX_FK_ILSGlideSlope]
ON [GlideSlopes]
([ILS_Id] DESC);

2024-10-12 21:08:25.1627|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [DMEs] (
   [Id]   integer PRIMARY KEY AUTOINCREMENT NOT NULL,
   [Elevation]   real,
   [Range]   real,
   [Position_Latitude]   real,
   [Position_Longitude]   real,
   [UserModified]   bit,
   [ILS_Id]   integer,
   [VOR_Id]   integer,
   [Frequency]   real
,
FOREIGN KEY ([ILS_Id])
REFERENCES [ILSs]([Id]),
FOREIGN KEY ([VOR_Id])
REFERENCES [VORs]([Id])
);
CREATE INDEX [DMEs_IX_FK_ILSDME]
ON [DMEs]
([ILS_Id] DESC);
CREATE INDEX [DMEs_IX_FK_VORDME]
ON [DMEs]
([VOR_Id] DESC);

2024-10-12 21:08:25.1846|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [Airways] (
   [Id]   integer PRIMARY KEY AUTOINCREMENT NOT NULL,
   [Identifier]   nvarchar COLLATE NOCASE,
   [UserModified]   bit

);

2024-10-12 21:08:25.1926|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [AirwaySegments] (
   [Id]   integer PRIMARY KEY AUTOINCREMENT NOT NULL,
   [TopAltitudeFt]   integer,
   [BottomAltitudeFt]   integer,
   [Type]   integer,
   [UserModified]   bit,
   [Fix1Identifier]   nvarchar COLLATE NOCASE,
   [Fix2Identifier]   nvarchar COLLATE NOCASE,
   [Airway_Id]   integer,
   [NavFix1_Id]   integer,
   [NavFix2_Id]   integer,
   [Fix1_Latitude]   real,
   [Fix1_Longitude]   real,
   [Fix2_Latitude]   real,
   [Fix2_Longitude]   real,
   [Direction]   integer
,
FOREIGN KEY ([Airway_Id])
REFERENCES [Airways]([Id]),
FOREIGN KEY ([NavFix1_Id])
REFERENCES [NavFixes]([Id]),
FOREIGN KEY ([NavFix2_Id])
REFERENCES [NavFixes]([Id])
);
CREATE INDEX [AirwaySegments_IX_FK_AirwayAirwaySegment]
ON [AirwaySegments]
([Airway_Id] DESC);
CREATE INDEX [AirwaySegments_IX_FK_AirwaySegmentNavFix]
ON [AirwaySegments]
([NavFix2_Id] DESC);
CREATE INDEX [AirwaySegments_IX_FK_AirwaySegmentNavFix1]
ON [AirwaySegments]
([NavFix1_Id] DESC);

2024-10-12 21:08:25.2205|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [TaxiPathTaxiPoint] (
[TaxiPaths_Id] integer NOT NULL,
[TaxiPoints_Id] integer NOT NULL,
PRIMARY KEY ([TaxiPaths_Id], [TaxiPoints_Id])
,
FOREIGN KEY ([TaxiPaths_Id])
REFERENCES [TaxiPaths]([Id]),
FOREIGN KEY ([TaxiPoints_Id])
REFERENCES [TaxiPoints]([Id])
);
CREATE INDEX [TaxiPathTaxiPoint_IX_FK_TaxiPathTaxiPoint_TaxiPoint]
ON [TaxiPathTaxiPoint]
([TaxiPoints_Id] DESC);

2024-10-12 21:08:25.2357|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [Gates] (
   [Id]   integer PRIMARY KEY AUTOINCREMENT NOT NULL,
   [Name]   nvarchar(50) COLLATE NOCASE,
   [Position_Latitude]   real,
   [Position_Longitude]   real,
   [Airport_Id]   integer,
   [Type]   integer
,
FOREIGN KEY ([Airport_Id])
REFERENCES [Airports]([Id])
);

2024-10-12 21:08:25.2436|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [AirspaceATCController] (
[Airspace_Id] integer NOT NULL,
[ATCController_Id] integer NOT NULL,
PRIMARY KEY ([ATCController_Id], [Airspace_Id])

);

2024-10-12 21:08:25.2436|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [Airspaces] (
   [Id]   integer PRIMARY KEY AUTOINCREMENT NOT NULL,
   [Radius]   real,
   [Type]   integer,
   [TopAltitude]   real,
   [TopAltitudeType]   integer,
   [BaseAltitude]   real,
   [BaseAltitudeType]   integer,
   [Name]   nvarchar COLLATE NOCASE,
   [TopLeftPosition_Latitude]   real,
   [TopLeftPosition_Longitude]   real,
   [BotRightPosition_Latitude]   real,
   [BotRightPosition_Longitude]   real,
   [UserModified]   bit,
   [Airport_Id]   integer

);

2024-10-12 21:08:25.2586|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [BoundaryPoints] (
   [Id]   integer PRIMARY KEY AUTOINCREMENT NOT NULL,
   [Position_Latitude]   real,
   [Position_Longitude]   real,
   [BoundaryVia]   integer,
   [CenterPosition_Latitude]   real,
   [CenterPosition_Longitude]   real,
   [ArcDistance]   real,
   [ArcBearing]   real,
   [AirspaceId]   integer,
   [UserModified]   bit
,
FOREIGN KEY ([AirspaceId])
REFERENCES [Airspaces]([Id])
);

2024-10-12 21:08:25.2586|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [Airports] (
   [Id]   integer PRIMARY KEY AUTOINCREMENT NOT NULL,
   [Name]   nvarchar COLLATE NOCASE,
   [ICAO_Code]   nvarchar COLLATE NOCASE,
   [Elevation]   real,
   [MagVar]   real,
   [Position_Latitude]   real,
   [Position_Longitude]   real,
   [CountryCode]   char(2) COLLATE NOCASE,
   [Country]   nvarchar COLLATE NOCASE,
   [City]   nvarchar COLLATE NOCASE,
   [State]   nvarchar COLLATE NOCASE,
   [UserModified]   bit,
   [TransitionAltitude]   integer

);

2024-10-12 21:08:25.2736|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [ATCControllers] (
   [Id]   integer PRIMARY KEY AUTOINCREMENT NOT NULL,
   [Name]   nvarchar COLLATE NOCASE,
   [Type]   integer,
   [Frequency]   real,
   [FrequencyUnit]   integer,
   [Position_Latitude]   real,
   [Position_Longitude]   real,
   [UserModified]   bit,
   [Airport_Id]   integer
,
FOREIGN KEY ([Airport_Id])
REFERENCES [Airports]([Id])
);

2024-10-12 21:08:25.2736|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [ILSs] (
   [Id]   integer PRIMARY KEY AUTOINCREMENT NOT NULL,
   [Name]   nvarchar COLLATE NOCASE,
   [Frequency]   real,
   [Range]   real,
   [Bearing]   real,
   [Position_Latitude]   real,
   [Position_Longitude]   real,
   [Elevation]   real,
   [Identifier]   nvarchar COLLATE NOCASE,
   [LocalizerOnly]   bit,
   [MagVar]   real,
   [Backcourse]   bit,
   [Width]   real,
   [CountryCode]   char(2) COLLATE NOCASE,
   [Airport_ICAO]   nvarchar COLLATE NOCASE,
   [UserModified]   bit,
   [Runway_Id]   integer
,
FOREIGN KEY ([Runway_Id])
REFERENCES [Runways]([Id])
);
CREATE INDEX [ILSs_IX_FK_RunwayILS]
ON [ILSs]
([Runway_Id] DESC);

2024-10-12 21:08:25.2969|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [NavFixes] (
   [Id]   integer PRIMARY KEY AUTOINCREMENT NOT NULL,
   [Identifier]   nvarchar COLLATE NOCASE,
   [Position_Latitude]   real,
   [Position_Longitude]   real,
   [MagVar]   real,
   [CountryCode]   char(2) COLLATE NOCASE,
   [Type]   integer,
   [UserModified]   bit

);

2024-10-12 21:08:25.3055|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [NDBs] (
   [Id]   integer PRIMARY KEY AUTOINCREMENT NOT NULL,
   [Name]   nvarchar COLLATE NOCASE,
   [Position_Latitude]   real,
   [Position_Longitude]   real,
   [MagVar]   real,
   [Identifier]   nvarchar COLLATE NOCASE,
   [CountryCode]   char(2) COLLATE NOCASE,
   [Elevation]   real,
   [Range]   real,
   [Frequency]   real,
   [Airport_ICAO]   nvarchar COLLATE NOCASE,
   [UserModified]   bit

);

2024-10-12 21:08:25.3055|INFO|DbAccess.SqlServerToSQLite|

CREATE TABLE [VORs] (
   [Id]   integer PRIMARY KEY AUTOINCREMENT NOT NULL,
   [Name]   nvarchar COLLATE NOCASE,
   [Position_Latitude]   real,
   [Position_Longitude]   real,
   [MagVar]   real,
   [Identifier]   nvarchar COLLATE NOCASE,
   [CountryCode]   char(2) COLLATE NOCASE,
   [Type]   integer,
   [Elevation]   real,
   [Range]   real,
   [Frequency]   real,
   [DMEOnly]   bit,
   [DMEPresent]   bit,
   [Airport_ICAO]   nvarchar COLLATE NOCASE,
   [UserModified]   bit

);

log 9

v019 no AI

Featured Replies

Create an account or sign in to comment

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)

Chrome (Desktop)

Safari (iOS 16.4+)

Safari (macOS)

Edge (Android)

Edge (Desktop)

Firefox (Android)

Firefox (Desktop)