This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?

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 Board.

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.gov. This data is supplied here for demonstration purposes only and neither intended nor warranted to be accurate.
Courtesy: National Transportation Safety Board

Property Inventory

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(), InjuriesTotalFatalDisplayToLogical(), InjuriesTotalFatalGet(), InjuriesTotalFatalGetStored(), InjuriesTotalFatalIsValid(), InjuriesTotalFatalLogicalToDisplay(), InjuriesTotalFatalNormalize(), InjuriesTotalFatalSet(), InjuriesTotalGet(), InjuriesTotalGetStored(), InjuriesTotalIsValid(), InjuriesTotalLogicalToDisplay(), InjuriesTotalMinorDisplayToLogical(), InjuriesTotalMinorGet(), InjuriesTotalMinorGetStored(), InjuriesTotalMinorIsValid(), InjuriesTotalMinorLogicalToDisplay(), InjuriesTotalMinorNormalize(), InjuriesTotalMinorSet(), InjuriesTotalNoneDisplayToLogical(), InjuriesTotalNoneGet(), InjuriesTotalNoneGetStored(), InjuriesTotalNoneIsValid(), InjuriesTotalNoneLogicalToDisplay(), InjuriesTotalNoneNormalize(), InjuriesTotalNoneSet(), InjuriesTotalNormalize(), InjuriesTotalSeriousDisplayToLogical(), InjuriesTotalSeriousGet(), InjuriesTotalSeriousGetStored(), InjuriesTotalSeriousIsValid(), InjuriesTotalSeriousLogicalToDisplay(), InjuriesTotalSeriousNormalize(), InjuriesTotalSeriousSet(), 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(), SkyConditionCeilingHeightDisplayToLogical(), SkyConditionCeilingHeightGet(), SkyConditionCeilingHeightGetStored(), SkyConditionCeilingHeightIsValid(), SkyConditionCeilingHeightLogicalToDisplay(), SkyConditionCeilingHeightNormalize(), SkyConditionCeilingHeightSet(), 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(), SkyConditionNonCeilingHeightDisplayToLogical(), SkyConditionNonCeilingHeightGet(), SkyConditionNonCeilingHeightGetStored(), SkyConditionNonCeilingHeightIsValid(), SkyConditionNonCeilingHeightLogicalToDisplay(), SkyConditionNonCeilingHeightNormalize(), SkyConditionNonCeilingHeightSet(), 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(), WindDirectionIndicatorDisplayToLogical(), WindDirectionIndicatorGet(), WindDirectionIndicatorGetStored(), WindDirectionIndicatorIsValid(), WindDirectionIndicatorLogicalToDisplay(), WindDirectionIndicatorLogicalToOdbc(), WindDirectionIndicatorNormalize(), WindDirectionIndicatorSet(), 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(), WindGustIndicatorDisplayToLogical(), WindGustIndicatorGet(), WindGustIndicatorGetStored(), WindGustIndicatorIsValid(), WindGustIndicatorLogicalToDisplay(), WindGustIndicatorLogicalToOdbc(), WindGustIndicatorNormalize(), WindGustIndicatorSet(), 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(), WindVelocityIndicatorDisplayToLogical(), WindVelocityIndicatorGet(), WindVelocityIndicatorGetStored(), WindVelocityIndicatorIsValid(), WindVelocityIndicatorLogicalToDisplay(), WindVelocityIndicatorLogicalToOdbc(), WindVelocityIndicatorNormalize(), WindVelocityIndicatorSet(), 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()

Inherited Members

Inherited Methods

Storage

Storage Model: CacheStorage (Aviation.Event)

^Aviation.EventD(ID)
=
%%CLASSNAME
EventId
NTSBId
Type
EventDate
EventTime
TimeZone
LocationCountry
LocationState
LocationCity
LocationCountryCode
LocationSiteZipCode
LocationCoordsLatitude
LocationCoordsLongitude
MidAir
OnGroundCollision
AirportName
AirportLocation
AirportDistance
AirportDirection
AirportElevation
LightConditions
SkyConditionNonCeiling
SkyConditionNonCeilingHeight
SkyConditionCeilingHeight
SkyConditionCeiling
Visibility
WeatherAirTemperature
WindDirection
WindDirectionIndicator
WindVelocity
WindVelocityIndicator
WindGustIndicator
WindGust
Altimeter
WeatherPrecipitation
InjuriesHighest
InjuriesGroundFatal
InjuriesGroundMinor
InjuriesGroundSerious
InjuriesTotalFatal
InjuriesTotalMinor
InjuriesTotalNone
InjuriesTotalSerious
InjuriesTotal
InvestigatingAgency
FAADistrictOffice
NarrativeFull
NarrativeSummary
NarrativeCause
Feedback