Touchstone 4.0 Database Documentation
tECASpatialDataSetOption Table
Description
Stores information regarding the spatial data set options used during the Geospatial analysis.
Properties
Creation Date5/31/2016 9:45 AM
File GroupPRIMARY
Text File GroupPRIMARY
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   
Primary Key SpatialDataSetIDUnique system-generated identifier for the spatial data set.Integer4   
 SpatialDataSetSourceCode

Code that represents the source of the spatial data set.

For a complete list of codes, see tSpatialDataSetSource Table.

VarChar10   
 SpatialDataSetTypeCode

Code that represents the type of spatial data set.

For a complete list of codes, see tSpatialDataSetType Table.

VarChar10   
 SpatialDataSetSID

Unique system-generated sequential identifier for the spatial dataset record.

For a complete set of records, see tSpatialDataset Table.

Integer4   
 PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4  
 ApplyCustomDamageRatio

Indicates whether a custom damage ratio is applied, as opposed to the damage ratio that is saved in the spatial data set.

  • 1 = Yes (applied)
  • 0 = No (not applied)
Boolean1 
((1))
 
 AvailableForAnalysisTypeCode

Code that represents the analysis types to which the spatial data set can be applied.

For a complete list of codes, see tAnalysisType Table.

VarChar10  
 SpatialFieldsXML expression containing the dynamic column names created within the spatial detail table. Used internally by Touchstone.Xml16  
Objects that depend on tECASpatialDataSetOption
 Database ObjectObject TypeDescriptionDep Level
tECASpatialDataSetBucketDefinition tabletECASpatialDataSetBucketDefinitionTableStores information that defines the buckets used in a Geospatial analysis. A bucket is a range of attribute values that is analyzed as a single entity with a single damage ratio; For example, a bucket of wind speed could be 60 – 70 miles per hour.4
tECASpatialDataSetBucketDetail tabletECASpatialDataSetBucketDetailTableStores information regarding the data set bucket used during the Geospatial analysis. A bucket is a range that is analyzed as a single entity with a single damage ratio; For example, a bucket of wind speed could be 60 – 70 miles per hour.5
Objects that tECASpatialDataSetOption 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.