Touchstone 4.0 Database Documentation
tECARingOption Table
Description
Stores information about the ring options selected for the Geospatial analysis.
Properties
Creation Date5/31/2016 9:45 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key AnalysisSID

Unique system-generated sequential identifier for the analysis  record.

For a complete list of records, see tAnalysis Table.

Integer4   
 RingCriteriaCode

Code that represents the ring criteria type.

For a complete list of codes, see tRingCriteria Table

VarChar10   
 RingCriteriaCountCount of the ring criteria used to filter the exposure data. For example, top 10,000 total replacement value.Double9  
 RemoveDuplicate

Indicates whether duplicate rings, having the same latitude and longitude, should be removed or retained to produce overlapping exposure data.

  • 1 = Yes (remove duplicate rings)
  • 0 = No (retain duplicate rings)
Boolean1 
((1))
 
 IsUniqueRingDefinition

Indicates whether a ring definition is unique. This flag is used by the User Interface when consolidated rings.

  • 1 = Yes (unique)
  • 0 = No (not unique)
Boolean1 
((1))
 
 RiskMeasureCode

Code that represents how the risk measure is calculated. 

For a complete list of codes, see tRiskMeasure Table.

VarChar10   
Objects that depend on tECARingOption
 Database ObjectObject TypeDescriptionDep Level
tECARingDefinition tabletECARingDefinitionTableStores information regarded the rings used during a Geospatial analysis.4
tECARingGeoMatchLevelOption tabletECARingGeoMatchLevelOptionTableStores information about the geocode match level achieved during the Geospatial \analysis.4
tECARingLandmarkOption tabletECARingLandmarkOptionTableStores information about the landmarks used during a Geospatial analysis.4
tECARingLocationList tabletECARingLocationListTableStores information about the locations included in the Geospatial analysis.4
Objects that tECARingOption depends on
 Database ObjectObject TypeDescriptionDep Level
tAnalysis tabletAnalysisTableStores information about each sub-section of the activity output. Each activity task creates and writes to this table as the task is performed.1
tDataServer tabletDataServerTableStores information about each data server used in the project, including its sequential identifier (SID), name, description, connection information, and default MDF and LDF paths.3
tDataSource tabletDataSourceTableStores information about the data source used for the Touchstone project. A data source is a database that is registered with the Touchstone application.2
tExposureConcentrationAnalysisOption tabletExposureConcentrationAnalysisOptionTableStores the options used during a Geospatial analysis.2
tProject tabletProjectTableStores information regarding the project, such as project name and status code.1
See Also

Related Objects

AIRProject Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.