Stores information used in Touchstone's spatial calculations.
Touchstone 2022 Database Reference
tSpatialDataColumn Table
| Creation Date | 3/4/2013 12:29 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 5799 |
| Data Space Used | 1,096.00 KB |
| Index Space Used | 608.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | SpatialDataColumnSID | Unique system-generated sequential identifier for the spatial data column record. | int | 4 | |||
| SpatialDatasetSID | Unique system-generated sequential identifier for the spatial dataset record. For a complete set of records, see tSpatialDataset Table. | int | 4 |  | |||
| DatabaseName | Name of the spatial database. | nvarchar | 128 | ||||
| TableName | Spatial dataset table name. | nvarchar | 128 | ||||
| ColumnName | Spatial dataset table column name. | nvarchar | 128 | ||||
| TableNamePrefix | Spatial dataset table name prefix. | nvarchar | 8 | | |||
| DesignatedColumn | Internal information used for Touchstone's spatial calculations. | bit | 1 | ||||
| ColumnCalculation | Internal information used for Touchstone's spatial calculations. | nvarchar | 1024 | | |||
| ColumnOrder | Spatial dataset table column order. | smallint | 2 | ||||
| AnalysisVersion | Internal information used for Touchstone's spatial calculations. | int | 4 | ||||
| CreatedOn | Date and time the record was created. | datetime2 | 4 |