Stores information regarding the spatial data set options used during the Geospatial analysis.
Touchstone 2022 Database Reference
tECASpatialDataSetOption Table
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | AnalysisSID | Unique system-generated sequential identifier for the analysis record. For a complete list of records, see tAnalysis Table. | int | 4 | |||
| | SpatialDataSetID | Unique system-generated identifier for the spatial data set. | int | 4 | |||
| SpatialDataSetSourceCode | Code that represents the source of the spatial data set. For a complete list of codes, see tSpatialDataSetSource Table. | varchar | 10 | ||||
| SpatialDataSetTypeCode | Code that represents the type of spatial data set. For a complete list of codes, see tSpatialDataSetType Table. | varchar | 10 | ||||
| SpatialDataSetSID | Unique system-generated sequential identifier for the spatial dataset record. For a complete set of records, see tSpatialDataset Table. | int | 4 | ||||
| PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | int | 4 |  | |||
| ApplyCustomDamageRatio | Indicates whether a custom damage ratio is applied, as opposed to the damage ratio that is saved in the spatial data set.
| bit | 1 | ((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. | varchar | 10 | | |||
| SpatialFields | XML expression containing the dynamic column names created within the spatial detail table. Used internally by Touchstone. | xml | 0 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tECASpatialDataSetBucketDefinition | Table | 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. | 1 |
| tECASpatialDataSetBucketDetail | Table | 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. | 2 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
| tAnalysis | Table | Stores information about each analysis. | 2 |
| tDataServer | Table | Stores information about each data server associated with the project, including the sequential identifier (SID), name, description, connection information, and default MDF and LDF paths for the server. | 4 |
| tDataSource | Table | Stores information about the databases registered with the application, for example, the exposure and results databases. | 3 |
| tExposureConcentrationAnalysisOption | Table | Stores the options used during a Geospatial analysis. | 1 |
| tExposureSet | Table | Stores exposure set information from each exposure database on the server. | 4 |
| tProject | Table | Stores information about each project, for example, the project name and status code. | 3 |