Touchstone 4.0 Database Documentation
AIRSpatial Database
Description

The AIRSpatial database stores information used for Touchstone's spatial calculations. 

Schema Diagram

To view the database schema diagrams for the AIRSpatial database, see Schema Diagrams.

Tables
TableDescription
tblSpatialDataSetErrorsStores the spatial dataset error information that is used internally by Touchstone.
tDBVersionDefines the version of the database.
tSIDControlContains 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.
tSpatialDataColumnStores information used in Touchstone's spatial calculations.
tSpatialDatasetStores information used in Touchstone's spatial calculations.
tSpatialDatasetAnalysisReserved for overriding a default distance of 100 miles if it is not precise enough for a particular spatial dataset’s processing.
tSpatialDatasetAnalysisPerilStores the valid PerilSet combinations (PerilSetCodes) for spatial datasets.
tSpatialDataSetErrors

Reserved for temporary storage of errors that might occur during an import of spatial data.

tSpatialDatasetEventReserved for future use.
tSpatialDatasetGridHeaderContains metadata for grid datasets and indexes. Primarily used to translate latitude and longitudes into grid coordinates.
tSpatialDatasetGroupContains the dataset group definitions used to group related datasets together (i.e. the hurricane track and wind speed footprint for Hurricane Rita).
tSpatialDatasetGroupDefinitionA cross reference table that links datasets to their dataset groups.
tSpatialDatasetHazardAttributeXrefSystem reference table used to identify the hazard attribute associated with a spatial dataset.
xtSpatialDataSet_000003

Stores any number of columns relevant to a spatial dataset.  Currently only one column can be chosen to be used as a value in map layer viewing and geospatial analyses.

Note that the "_00003" in the table name identifies a specific spatial dataset; The columns within this table are used for all spatial datasets.
xtSpatialDataset_000003Grid

 Stores grid information relevant to a spatial dataset.

Note that the "_00003" in the table name identifies a specific spatial dataset; The columns within this table are used for all spatial datasets.
xtSpatialDataset_000003Index

Contains a pre-calculated index to improve geospatial analysis performance for line and point data.

Note that the "_00003" in the table name identifies a specific spatial dataset; The columns within this table are used for all spatial datasets.

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.