Stores information about the ring options selected for the Geospatial analysis.
Touchstone 2022 Database Reference
tECARingOption Table
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 2 |
| Data Space Used | 8.00 KB |
| Index Space Used | 8.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 | |||
| RingCriteriaCode | Code that represents the ring criteria type. For a complete list of codes, see tRingCriteria Table. | varchar | 10 | ||||
| RingCriteriaCount | Count of the ring criteria used to filter the exposure data. For example, top 10,000 total replacement value. | float | 9 |  | |||
| RemoveDuplicate | Indicates whether duplicate rings, having the same latitude and longitude, should be removed or retained to produce overlapping exposure data.
| bit | 1 | ((1)) | |||
| IsUniqueRingDefinition | Indicates whether a ring definition is unique. This flag is used by the User Interface when consolidated rings.
| bit | 1 | ((1)) | |||
| RiskMeasureCode | Code that represents how the risk measure is calculated. For a complete list of codes, see tRiskMeasure Table. | varchar | 10 | ||||
| MinLatitude | Represents the minimum latitude value of the overlapping ring exposure. | numeric | 9 (9,6) | | |||
| MinLongitude | Represents the minimum longitude value of the overlapping ring exposure. | numeric | 9 (9,6) | | |||
| MaxLatitude | Represents the maximum latitude value of the overlapping ring exposure. | numeric | 9 (9,6) | | |||
| MaxLongitude | Represents the maximum longitude value of the overlapping ring exposure. | numeric | 9 (9,6) | | |||
| RemoveOverlap | Indicates whether overlapping rings, having the same latitude and longitude, should be removed or retained to produce overlapping exposure data.
| bit | 1 | ((0)) | |||
| FinancialPerspectiveFindHighestLossRing | Stores the highest loss accumulation of ring exposure in geospatial analysis. | varchar | 10 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tECARingDefinition | Table | Stores information regarded the rings used during a Geospatial analysis. | 1 |
| tECARingGeoMatchLevelOption | Table | Stores information about the geocode match level achieved during the Geospatial \analysis. | 1 |
| tECARingLandmarkOption | Table | Stores information about the landmarks used during a Geospatial analysis. | 1 |
| tECARingLocationList | Table | Stores information about the locations included in the Geospatial analysis. | 1 |
| 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 |