The AIRSpatial database stores information that Touchstone uses to perform spatial calculations.
You can view a diagram of the AIRExposure database in Schema Diagrams.
| Table | Description |
|---|---|
| tDbHistory | Stores information about any packages applied to the database. |
| tDBVersion | Defines the version of the database. |
| tSIDControl | Contains a list of all SID tables and the last SID value in use for each table. After each insert operation, the SID value will update. |
| tSpatialDataColumn | Stores information used in Touchstone's spatial calculations. |
| tSpatialDataset | Stores information used in Touchstone's spatial calculations. |
| tSpatialDatasetAnalysis | Reserved for overriding a default distance of 100 miles if it is not precise enough for a particular spatial dataset’s processing. |
| tSpatialDatasetAnalysisPeril | Stores the valid PerilSet combinations (PerilSetCodes) for spatial datasets. |
| tSpatialDatasetGridHeader | Contains metadata for grid datasets and indexes. Primarily used to translate latitude and longitudes into grid coordinates. |
| tSpatialDatasetGroup | Contains the dataset group definitions used to group related datasets together (i.e. the hurricane track and wind speed footprint for Hurricane Rita). |
| tSpatialDatasetGroupDefinition | A cross reference table that links datasets to their dataset groups. |
| tSpatialDatasetHazardAttributeXref | System reference table used to identify the hazard attribute associated with a spatial dataset. |
| tSpatialDatasetSources | 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. |
| tUpgradeLog | Stores information about upgrade scripts. |
| tWebLayer | Stores information about user-specified web layers. A web layer is a collection of geospatial data made available on the web. For example, the United States Geological Survey maintains a web layer that shows current fire locations in the Unites States. The USGS supplies a URL that users can specify in Touchstone to view the layer in the application. |