Stores information used in Touchstone's spatial calculations.
Touchstone 2022 Database Reference
tSpatialDataset Table
| Creation Date | 10/18/2012 10:51 AM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| System Object |  |
| Published for Replication | |
| Rows | 478 |
| Data Space Used | 368.00 KB |
| Index Space Used | 16.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | SpatialDatasetSID | Unique system-generated sequential identifier for the spatial dataset record. | int | 4 | |||
| SpatialDataset | Name of the spatial dataset. | varchar | 50 | ||||
| SpatialQueryType | Code that represents the spatial query type. For a complete list of codes, see tSpatialQueryType Table. | varchar | 10 | ||||
| SpatialDatasetType | Code that represents the spatial data set type. For a complete list of datasets types, see tSpatialDataSetType Table. | varchar | 10 | ||||
| SpatialDatasetCategory | Catastrophe type to which the dataset applies. | varchar | 255 |  | |||
| SpatialDefaultValue | Reserved for future use. | varchar | 20 | | |||
| XMin | The smallest longitude values in the spatial dataset. | numeric | 9 (9,6) | | |||
| YMin | The smallest latitude values in the spatial dataset. | numeric | 9 (9,6) | | |||
| XMax | The largest longitude values in the spatial dataset. | numeric | 9 (9,6) | | |||
| YMax | The largest latitude values in the spatial dataset. | numeric | 9 (9,6) | | |||
| SpatialDatasetRegion | Geographic region to which the dataset applies. Note that, in this situation, this field may contain both region (i.e. Europe, North America) as well as area (U.S. State) information. | varchar | 50 | | |||
| SpatialDatasetOriginalSource | Reserved for future use. | varchar | 100 | | |||
| SpatialDatasetIsAvailableForAnalysis | Indicates whether the dataset is available for use during a Geospatial analysis.
| bit | 1 | ||||
| SpatialDatasetCachePriority | A seldom used value corresponding to Microsoft’s System.Web.Caching.CacheItemPriority values. | int | 4 | | |||
| CreateDate | Date and time the spatial dataset was created | datetime | 4 | | (getdate()) | ||
| UploadDate | Date the spatial dataset was created. | datetime | 4 | | (getdate()) | ||
| Description | Description of the spatial dataset. | varchar | 4000 | | |||
| EventScale | Storm category value for tropical cyclone. Magnitude value for earthquake. | varchar | 4000 | | |||
| InsurableLoss | Insured loss amount for historical events. | varchar | 4000 | | |||
| Notes | Notes about the dataset. | varchar | 4000 | | |||
| EventYear | Year in which historical event occurred. | int | 4 | | |||
| SpatialFields | The most important field(s) for understanding the particular spatial dataset. For example, using tropical cyclone Dolly, the SpatialFields include the MaxWindSpeed for the GRID type spatial dataset and Distance for the PATH type spatial dataset. | xml | 0 | | |||
| AvailableForAnalysisTypeCode | Code that represents the analysis types for which the spatial dataset can be used. For a complete list of codes, see tAnalysisType Table. | varchar | 10 | | |||
| LicenseRegionCode | Code that represents the geographic region. For a complete list of codes, see tLicenseRegion Table. | smallint | 2 | | |||
| BusinessUnitSID | Unique system-generated sequential identifier for the business unit record. | int | 4 | ((0)) | |||
| LayerGroup | Name of the map layer group to which the spatial dataset is applied. Reserved for future use. | varchar | 100 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tSpatialDatasetAnalysis | Table | Reserved for overriding a default distance of 100 miles if it is not precise enough for a particular spatial dataset’s processing. | 1 |
| tSpatialDatasetGroupDefinition | Table | A cross reference table that links datasets to their dataset groups. | 1 |
| tSpatialDatasetHazardAttributeXref | Table | System reference table used to identify the hazard attribute associated with a spatial dataset. | 1 |
| tSpatialDatasetSources | Table | Stores the data needed by the Geospatial Data Abstraction Library (GDAL) to locate and interact with the spatial datasets stored in the application file system. In Touchstone 6.0, AIR moved most of the spatial data used by Touchstone out of the Touchstone databases and into the Touchstone file system. Touchstone uses GDAL to interact with the spatial data in the file system. | 1 |