Touchstone 4.0 Database Documentation
tECASpatialDataSetBucketDetail Table
Description
Stores 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.
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 BucketDetailSIDUnique system-generated sequential identifier for the bucket record.Integer4   
 BucketDefinitionSID

Unique system-generated sequential identifier for the bucket definition record.

For a complete list of records, see tECASpatialDataSetBucketDefinition Table.

Integer4   
 BucketLabelAttribute of the bucket. For example, wind speed, soil type, elevation.VarChar255  
 BucketMinUsed for wind speed tracking, it is the minimum value of the bucket range. Numeric9 (19,6)  
 BucketMaxUsed for wind speed tracking, it is the maximum value of the bucket range. Numeric9 (19,6)  
 BucketValueWhen the bucket value is not min/max, a discrete bucket value is provided.VarChar50  
 BucketColorColor used to display the bucket on a map.VarChar15  
 MinConversionUnitCode

Code for the unit of measure used to express the minimum bucket value.

For a complete list of codes, see tUnit Table.

VarChar10  
 MaxConversionUnitCode

Code for the unit of measure used to express the maximum bucket value.

For a complete list of codes, see tUnit Table.

VarChar10  
 DamageRatioRatio of the cost to repairing a building vs. the cost of rebuilding it. Multiply the value by 100 to express it as a percentageSingle4  
 BucketSourceMinCalculated values based on BucketMin.Numeric9 (19,6) 
([dbo].[fBucketValueComputeSource]([BucketMin],[MinConversionUnitCode],[BucketDefinitionSID]))
 BucketSourceMaxCalculated values based on BucketMax.Numeric9 (19,6) 
([dbo].[fBucketValueComputeSource]([BucketMax],[MaxConversionUnitCode],[BucketDefinitionSID]))
Objects that tECASpatialDataSetBucketDetail 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
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
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
tECASpatialDataSetOption tabletECASpatialDataSetOptionTableStores information regarding the spatial data set options used during the Geospatial analysis.3
tExposureConcentrationAnalysisOption tabletExposureConcentrationAnalysisOptionTableStores the options used during a Geospatial analysis.2
tProject tabletProjectTableStores information regarding the project, such as project name and status code.1
tUnitConversion tabletUnitConversionTable

Stores the ratio needed to convert from one distance measurement unit type to another, such as feet to meters.

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.