Aviation.Event

persistent class Aviation.Event extends %Library.Persistent

SQL Table Name: Aviation.Event

This class represents events involving aircraft as registered by the National Transportation Safety BoardOpens in a new tab.

Note on the data: The dataset provided in this sample demo is only a lightweight subset of the full NTSB dataset, which is available from http://www.ntsb.govOpens in a new tab. This data is supplied here for demonstration purposes only and neither intended nor warranted to be accurate.
Courtesy: National Transportation Safety Board

Property Inventory

• Aircraft
• AirportDirection
• AirportDistance
• AirportElevation
• AirportLocation
• AirportName
• Altimeter
• EventDate
• EventId
• EventTime
• FAADistrictOffice
• InjuriesGroundFatal
• InjuriesGroundMinor
• InjuriesGroundSerious
• InjuriesHighest
• InjuriesTotal
• InjuriesTotalFatal
• InjuriesTotalMinor
• InjuriesTotalNone
• InjuriesTotalSerious
• InvestigatingAgency
• LightConditions
• LocationCity
• LocationCoordsLatitude
• LocationCoordsLongitude
• LocationCountry
• LocationSiteZipCode
• LocationState
• MidAir
• NTSBId
• NarrativeCause
• NarrativeFull
• NarrativeSummary
• OnGroundCollision
• SkyConditionCeiling
• SkyConditionCeilingHeight
• SkyConditionNonCeiling
• SkyConditionNonCeilingHeight
• TimeZone
• Type
• Visibility
• WeatherAirTemperature
• WeatherPrecipitation
• WindDirection
• WindDirectionIndicator
• WindGust
• WindGustIndicator
• WindVelocity
• WindVelocityIndicator

Properties

relationship Aircraft as array of Aviation.Aircraft [ InitialExpression = $listbuild("Aviation.Aircraft","Event",+$this,"children",1,1) , Transient , Inverse = Event , Cardinality = children ];

Property methods: AircraftGet(), AircraftGetObject(), AircraftGetObjectId(), AircraftGetSwizzled(), AircraftIsEmpty(), AircraftIsValid(), AircraftNewObject(), AircraftRClose(), AircraftRExec(), AircraftRFetch(), AircraftRelate(), AircraftSQLCompute(), AircraftSet(), AircraftUnRelate()

property AirportDirection as %Integer;

Property methods: AirportDirectionDisplayToLogical(), AirportDirectionGet(), AirportDirectionGetStored(), AirportDirectionIsValid(), AirportDirectionLogicalToDisplay(), AirportDirectionNormalize(), AirportDirectionSet()

property AirportDistance as %Library.String (MAXLEN = 50);

Property methods: AirportDistanceDisplayToLogical(), AirportDistanceGet(), AirportDistanceGetStored(), AirportDistanceIsValid(), AirportDistanceLogicalToDisplay(), AirportDistanceLogicalToOdbc(), AirportDistanceNormalize(), AirportDistanceSet()

property AirportElevation as %Integer;

Property methods: AirportElevationDisplayToLogical(), AirportElevationGet(), AirportElevationGetStored(), AirportElevationIsValid(), AirportElevationLogicalToDisplay(), AirportElevationNormalize(), AirportElevationSet()

property AirportLocation as %Library.String (MAXLEN = 25);

Property methods: AirportLocationDisplayToLogical(), AirportLocationGet(), AirportLocationGetStored(), AirportLocationIsValid(), AirportLocationLogicalToDisplay(), AirportLocationLogicalToOdbc(), AirportLocationNormalize(), AirportLocationSet()

property AirportName as %Library.String (MAXLEN = 30);

Property methods: AirportNameDisplayToLogical(), AirportNameGet(), AirportNameGetStored(), AirportNameIsValid(), AirportNameLogicalToDisplay(), AirportNameLogicalToOdbc(), AirportNameNormalize(), AirportNameSet()

property Altimeter as %Library.String (MAXLEN = 50);

Property methods: AltimeterDisplayToLogical(), AltimeterGet(), AltimeterGetStored(), AltimeterIsValid(), AltimeterLogicalToDisplay(), AltimeterLogicalToOdbc(), AltimeterNormalize(), AltimeterSet()

property EventDate as %TimeStamp;

Property methods: EventDateDisplayToLogical(), EventDateGet(), EventDateGetStored(), EventDateIsValid(), EventDateLogicalToDisplay(), EventDateNormalize(), EventDateOdbcToLogical(), EventDateSet()

property EventId as %Library.String [ Required ];

Property methods: EventIdDisplayToLogical(), EventIdGet(), EventIdGetStored(), EventIdIsValid(), EventIdLogicalToDisplay(), EventIdLogicalToOdbc(), EventIdNormalize(), EventIdSet()

property EventTime as %Integer;

Property methods: EventTimeDisplayToLogical(), EventTimeGet(), EventTimeGetStored(), EventTimeIsValid(), EventTimeLogicalToDisplay(), EventTimeNormalize(), EventTimeSet()

property FAADistrictOffice as %Library.String (MAXLEN = 50);

Property methods: FAADistrictOfficeDisplayToLogical(), FAADistrictOfficeGet(), FAADistrictOfficeGetStored(), FAADistrictOfficeIsValid(), FAADistrictOfficeLogicalToDisplay(), FAADistrictOfficeLogicalToOdbc(), FAADistrictOfficeNormalize(), FAADistrictOfficeSet()

property InjuriesGroundFatal as %Integer;

Property methods: InjuriesGroundFatalDisplayToLogical(), InjuriesGroundFatalGet(), InjuriesGroundFatalGetStored(), InjuriesGroundFatalIsValid(), InjuriesGroundFatalLogicalToDisplay(), InjuriesGroundFatalNormalize(), InjuriesGroundFatalSet()

property InjuriesGroundMinor as %Integer;

Property methods: InjuriesGroundMinorDisplayToLogical(), InjuriesGroundMinorGet(), InjuriesGroundMinorGetStored(), InjuriesGroundMinorIsValid(), InjuriesGroundMinorLogicalToDisplay(), InjuriesGroundMinorNormalize(), InjuriesGroundMinorSet()

property InjuriesGroundSerious as %Integer;

Property methods: InjuriesGroundSeriousDisplayToLogical(), InjuriesGroundSeriousGet(), InjuriesGroundSeriousGetStored(), InjuriesGroundSeriousIsValid(), InjuriesGroundSeriousLogicalToDisplay(), InjuriesGroundSeriousNormalize(), InjuriesGroundSeriousSet()

property InjuriesHighest as %Library.String (MAXLEN = 10);

Property methods: InjuriesHighestDisplayToLogical(), InjuriesHighestGet(), InjuriesHighestGetStored(), InjuriesHighestIsValid(), InjuriesHighestLogicalToDisplay(), InjuriesHighestLogicalToOdbc(), InjuriesHighestNormalize(), InjuriesHighestSet()

property InjuriesTotal as %Integer;

Property methods: InjuriesTotalDisplayToLogical(), InjuriesTotalGet(), InjuriesTotalGetStored(), InjuriesTotalIsValid(), InjuriesTotalLogicalToDisplay(), InjuriesTotalNormalize(), InjuriesTotalSet()

property InjuriesTotalFatal as %Integer;

Property methods: InjuriesTotalFatalDisplayToLogical(), InjuriesTotalFatalGet(), InjuriesTotalFatalGetStored(), InjuriesTotalFatalIsValid(), InjuriesTotalFatalLogicalToDisplay(), InjuriesTotalFatalNormalize(), InjuriesTotalFatalSet()

property InjuriesTotalMinor as %Integer;

Property methods: InjuriesTotalMinorDisplayToLogical(), InjuriesTotalMinorGet(), InjuriesTotalMinorGetStored(), InjuriesTotalMinorIsValid(), InjuriesTotalMinorLogicalToDisplay(), InjuriesTotalMinorNormalize(), InjuriesTotalMinorSet()

property InjuriesTotalNone as %Integer;

Property methods: InjuriesTotalNoneDisplayToLogical(), InjuriesTotalNoneGet(), InjuriesTotalNoneGetStored(), InjuriesTotalNoneIsValid(), InjuriesTotalNoneLogicalToDisplay(), InjuriesTotalNoneNormalize(), InjuriesTotalNoneSet()

property InjuriesTotalSerious as %Integer;

Property methods: InjuriesTotalSeriousDisplayToLogical(), InjuriesTotalSeriousGet(), InjuriesTotalSeriousGetStored(), InjuriesTotalSeriousIsValid(), InjuriesTotalSeriousLogicalToDisplay(), InjuriesTotalSeriousNormalize(), InjuriesTotalSeriousSet()

property InvestigatingAgency as %Library.String (MAXLEN = 1);

Property methods: InvestigatingAgencyDisplayToLogical(), InvestigatingAgencyGet(), InvestigatingAgencyGetStored(), InvestigatingAgencyIsValid(), InvestigatingAgencyLogicalToDisplay(), InvestigatingAgencyLogicalToOdbc(), InvestigatingAgencyNormalize(), InvestigatingAgencySet()

property LightConditions as %Library.String (MAXLEN = 20);

Property methods: LightConditionsDisplayToLogical(), LightConditionsGet(), LightConditionsGetStored(), LightConditionsIsValid(), LightConditionsLogicalToDisplay(), LightConditionsLogicalToOdbc(), LightConditionsNormalize(), LightConditionsSet()

property LocationCity as %Library.String (MAXLEN = 50);

Property methods: LocationCityDisplayToLogical(), LocationCityGet(), LocationCityGetStored(), LocationCityIsValid(), LocationCityLogicalToDisplay(), LocationCityLogicalToOdbc(), LocationCityNormalize(), LocationCitySet()

property LocationCoordsLatitude as %Double;

Property methods: LocationCoordsLatitudeDisplayToLogical(), LocationCoordsLatitudeGet(), LocationCoordsLatitudeGetStored(), LocationCoordsLatitudeIsValid(), LocationCoordsLatitudeLogicalToDisplay(), LocationCoordsLatitudeNormalize(), LocationCoordsLatitudeOdbcToLogical(), LocationCoordsLatitudeSet()

property LocationCoordsLongitude as %Double;

Property methods: LocationCoordsLongitudeDisplayToLogical(), LocationCoordsLongitudeGet(), LocationCoordsLongitudeGetStored(), LocationCoordsLongitudeIsValid(), LocationCoordsLongitudeLogicalToDisplay(), LocationCoordsLongitudeNormalize(), LocationCoordsLongitudeOdbcToLogical(), LocationCoordsLongitudeSet()

property LocationCountry as %Library.String (MAXLEN = 100);

Property methods: LocationCountryDisplayToLogical(), LocationCountryGet(), LocationCountryGetStored(), LocationCountryIsValid(), LocationCountryLogicalToDisplay(), LocationCountryLogicalToOdbc(), LocationCountryNormalize(), LocationCountrySet()

property LocationSiteZipCode as %Library.String (MAXLEN = 10);

Property methods: LocationSiteZipCodeDisplayToLogical(), LocationSiteZipCodeGet(), LocationSiteZipCodeGetStored(), LocationSiteZipCodeIsValid(), LocationSiteZipCodeLogicalToDisplay(), LocationSiteZipCodeLogicalToOdbc(), LocationSiteZipCodeNormalize(), LocationSiteZipCodeSet()

property LocationState as %Library.String (MAXLEN = 100);

Property methods: LocationStateDisplayToLogical(), LocationStateGet(), LocationStateGetStored(), LocationStateIsValid(), LocationStateLogicalToDisplay(), LocationStateLogicalToOdbc(), LocationStateNormalize(), LocationStateSet()

property MidAir as %Library.String (MAXLEN = 1);

Property methods: MidAirDisplayToLogical(), MidAirGet(), MidAirGetStored(), MidAirIsValid(), MidAirLogicalToDisplay(), MidAirLogicalToOdbc(), MidAirNormalize(), MidAirSet()

property NTSBId as %Library.String (MAXLEN = 10);

Property methods: NTSBIdDisplayToLogical(), NTSBIdGet(), NTSBIdGetStored(), NTSBIdIsValid(), NTSBIdLogicalToDisplay(), NTSBIdLogicalToOdbc(), NTSBIdNormalize(), NTSBIdSet()

property NarrativeCause as %String (MAXLEN = 30000);

Property methods: NarrativeCauseDisplayToLogical(), NarrativeCauseGet(), NarrativeCauseGetStored(), NarrativeCauseIsValid(), NarrativeCauseLogicalToDisplay(), NarrativeCauseLogicalToOdbc(), NarrativeCauseNormalize(), NarrativeCauseSet()

property NarrativeFull as %String (MAXLEN = 100000);

For simplicity, using the narratives for the first aircraft involved in this event, as in most cases subsequent narratives just refer to the initial one.

Property methods: NarrativeFullDisplayToLogical(), NarrativeFullGet(), NarrativeFullGetStored(), NarrativeFullIsValid(), NarrativeFullLogicalToDisplay(), NarrativeFullLogicalToOdbc(), NarrativeFullNormalize(), NarrativeFullSet()

property NarrativeSummary as %String (MAXLEN = 30000);

Property methods: NarrativeSummaryDisplayToLogical(), NarrativeSummaryGet(), NarrativeSummaryGetStored(), NarrativeSummaryIsValid(), NarrativeSummaryLogicalToDisplay(), NarrativeSummaryLogicalToOdbc(), NarrativeSummaryNormalize(), NarrativeSummarySet()

property OnGroundCollision as %Library.String (MAXLEN = 1);

Property methods: OnGroundCollisionDisplayToLogical(), OnGroundCollisionGet(), OnGroundCollisionGetStored(), OnGroundCollisionIsValid(), OnGroundCollisionLogicalToDisplay(), OnGroundCollisionLogicalToOdbc(), OnGroundCollisionNormalize(), OnGroundCollisionSet()

property SkyConditionCeiling as %Library.String (MAXLEN = 20);

Property methods: SkyConditionCeilingDisplayToLogical(), SkyConditionCeilingGet(), SkyConditionCeilingGetStored(), SkyConditionCeilingIsValid(), SkyConditionCeilingLogicalToDisplay(), SkyConditionCeilingLogicalToOdbc(), SkyConditionCeilingNormalize(), SkyConditionCeilingSet()

property SkyConditionCeilingHeight as %Library.Integer;

Property methods: SkyConditionCeilingHeightDisplayToLogical(), SkyConditionCeilingHeightGet(), SkyConditionCeilingHeightGetStored(), SkyConditionCeilingHeightIsValid(), SkyConditionCeilingHeightLogicalToDisplay(), SkyConditionCeilingHeightNormalize(), SkyConditionCeilingHeightSet()

property SkyConditionNonCeiling as %Library.String (MAXLEN = 20);

Property methods: SkyConditionNonCeilingDisplayToLogical(), SkyConditionNonCeilingGet(), SkyConditionNonCeilingGetStored(), SkyConditionNonCeilingIsValid(), SkyConditionNonCeilingLogicalToDisplay(), SkyConditionNonCeilingLogicalToOdbc(), SkyConditionNonCeilingNormalize(), SkyConditionNonCeilingSet()

property SkyConditionNonCeilingHeight as %Library.Integer;

Property methods: SkyConditionNonCeilingHeightDisplayToLogical(), SkyConditionNonCeilingHeightGet(), SkyConditionNonCeilingHeightGetStored(), SkyConditionNonCeilingHeightIsValid(), SkyConditionNonCeilingHeightLogicalToDisplay(), SkyConditionNonCeilingHeightNormalize(), SkyConditionNonCeilingHeightSet()

property TimeZone as %Library.String (MAXLEN = 3);

Property methods: TimeZoneDisplayToLogical(), TimeZoneGet(), TimeZoneGetStored(), TimeZoneIsValid(), TimeZoneLogicalToDisplay(), TimeZoneLogicalToOdbc(), TimeZoneNormalize(), TimeZoneSet()

property Type as %Library.String (MAXLEN = 10);

Property methods: TypeDisplayToLogical(), TypeGet(), TypeGetStored(), TypeIsValid(), TypeLogicalToDisplay(), TypeLogicalToOdbc(), TypeNormalize(), TypeSet()

property Visibility as %Library.String (MAXLEN = 50);

Property methods: VisibilityDisplayToLogical(), VisibilityGet(), VisibilityGetStored(), VisibilityIsValid(), VisibilityLogicalToDisplay(), VisibilityLogicalToOdbc(), VisibilityNormalize(), VisibilitySet()

property WeatherAirTemperature as %Integer;

Property methods: WeatherAirTemperatureDisplayToLogical(), WeatherAirTemperatureGet(), WeatherAirTemperatureGetStored(), WeatherAirTemperatureIsValid(), WeatherAirTemperatureLogicalToDisplay(), WeatherAirTemperatureNormalize(), WeatherAirTemperatureSet()

property WeatherPrecipitation as %Library.String (MAXLEN = 3);

Property methods: WeatherPrecipitationDisplayToLogical(), WeatherPrecipitationGet(), WeatherPrecipitationGetStored(), WeatherPrecipitationIsValid(), WeatherPrecipitationLogicalToDisplay(), WeatherPrecipitationLogicalToOdbc(), WeatherPrecipitationNormalize(), WeatherPrecipitationSet()

property WindDirection as %Integer;

Property methods: WindDirectionDisplayToLogical(), WindDirectionGet(), WindDirectionGetStored(), WindDirectionIsValid(), WindDirectionLogicalToDisplay(), WindDirectionNormalize(), WindDirectionSet()

property WindDirectionIndicator as %Library.String (MAXLEN = 20);

Property methods: WindDirectionIndicatorDisplayToLogical(), WindDirectionIndicatorGet(), WindDirectionIndicatorGetStored(), WindDirectionIndicatorIsValid(), WindDirectionIndicatorLogicalToDisplay(), WindDirectionIndicatorLogicalToOdbc(), WindDirectionIndicatorNormalize(), WindDirectionIndicatorSet()

property WindGust as %Integer;

Property methods: WindGustDisplayToLogical(), WindGustGet(), WindGustGetStored(), WindGustIsValid(), WindGustLogicalToDisplay(), WindGustNormalize(), WindGustSet()

property WindGustIndicator as %Library.String (MAXLEN = 20);

Property methods: WindGustIndicatorDisplayToLogical(), WindGustIndicatorGet(), WindGustIndicatorGetStored(), WindGustIndicatorIsValid(), WindGustIndicatorLogicalToDisplay(), WindGustIndicatorLogicalToOdbc(), WindGustIndicatorNormalize(), WindGustIndicatorSet()

property WindVelocity as %Integer;

Property methods: WindVelocityDisplayToLogical(), WindVelocityGet(), WindVelocityGetStored(), WindVelocityIsValid(), WindVelocityLogicalToDisplay(), WindVelocityNormalize(), WindVelocitySet()

property WindVelocityIndicator as %Library.String (MAXLEN = 20);

Property methods: WindVelocityIndicatorDisplayToLogical(), WindVelocityIndicatorGet(), WindVelocityIndicatorGetStored(), WindVelocityIndicatorIsValid(), WindVelocityIndicatorLogicalToDisplay(), WindVelocityIndicatorLogicalToOdbc(), WindVelocityIndicatorNormalize(), WindVelocityIndicatorSet()

Indexes

index (IDKEY on ) [IdKey, Type = key];

Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()

index (PKINDEX on EventId) [PrimaryKey, Unique];

Index methods: PKINDEXCheck(), PKINDEXCheckUnique(), PKINDEXDelete(), PKINDEXExists(), PKINDEXOpen(), PKINDEXSQLCheckUnique(), PKINDEXSQLExists(), PKINDEXSQLFindPKeyByConstraint(), PKINDEXSQLFindRowIDByConstraint()