System reference table that stores information regarding the attributes that are available for browsing or required for Geospatial analytics.
Touchstone 2022 Database Reference
tSpatialAnalysisField Table
System reference table that stores information regarding the attributes that are available for browsing or required for Geospatial analytics.
| Creation Date | 2/7/2012 12:20 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 149 |
| Data Space Used | 24.00 KB |
| Index Space Used | 16.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | SpatialAnalysisFieldType | Categorization for the Geospatial analysis field type. | varchar | 40 | |||
| | SpatialAnalysisField | Name of the Geospatial analysis field type. | varchar | 255 | |||
| Description | Description of the Geospatial analysis field type. | varchar | 1024 | ||||
| IsActive | Indicates whether the Geospatial analysis field type is available for use.
| bit | 1 | dbo.D_1 | |||
| ColumnOrder | Order in which the table columns are organized. | real | 4 | ||||
| ColumnRank | Ranking for the table columns. | int | 4 | ||||
| IsVisible | Indicates whether the Geospatial analysis field type is visible on the user interface.
| bit | 1 | dbo.D_1 | |||
| IsIncludedInCube | Indicates whether the Geospatial analysis field type is included in the cube building process, but is not be visible on the user interface.
| bit | 1 | dbo.D_1 | |||
| IsWorkersComp | Indicates whether the Geospatial analysis field type is available for Workers' compensation risks.
| bit | 1 | ((0)) | |||
| IsProperty | Indicates whether the Geospatial analysis field type is available for Property risks.
| bit | 1 | ((0)) |