Touchstone 4.0 Database Documentation
tECASpatialDataSetBucketDefinition Table
Description
Stores 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.
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 BucketDefinitionSIDUnique system-generated sequential identifier for the bucket definition record.Integer4   
 AnalysisSID

Unique system-generated sequential identifier for the analysis  record.

For a complete list of records, see tAnalysis Table.

Integer4   
 SpatialDataSetIDSystem-generated identifier of the spatial data set.Integer4   
 SpatialDataSetBucketTypeCode

Code that represents the type of spatial data set bucket.

For a complete list of codes, see tSpatialDataSetBucketType Table.

VarChar10   
 SpatialFieldNameName of the Concentration analysis field.VarChar255   
 BucketDefinitionNameUser-supplied name of the bucket.VarChar255   
 BucketSourceUnitCode

Code for the unit of measure used to express the bucket size.

For a complete list of codes, see tUnit Table.

VarChar10  
Objects that depend on tECASpatialDataSetBucketDefinition
 Database ObjectObject TypeDescriptionDep Level
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 tECASpatialDataSetBucketDefinition 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
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
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.