Touchstone 4.0 Database Documentation
tSpatialDataset Table
Description
Stores information used in Touchstone's spatial calculations.
Properties
Creation Date10/18/2012 10:51 AM
File GroupPRIMARY
Text File GroupPRIMARY
System Object
Published for Replication
Rows536
Data Space Used200.00 KB
Index Space Used16.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key SpatialDatasetSID

Unique system-generated sequential identifier for the spatial dataset record.

Integer4   
 SpatialDatasetName of the spatial dataset.VarChar50   
 SpatialQueryType

Code that represents the spatial query type.

For a complete list of codes, see tSpatialQueryType Table.

VarChar10   
 SpatialDatasetType

Code that represents the spatial  data set type.

For a complete list of datasets types, see tSpatialDataSetType Table.

VarChar10   
 SpatialDatasetCategoryCatastrophe type to which the dataset applies. VarChar255  
 SpatialDefaultValueReserved for future use.VarChar20  
 XMinThe smallest longitude values in the spatial dataset.Numeric9 (9,6)  
 YMinThe smallest latitude values in the spatial dataset.Numeric9 (9,6)  
 XMaxThe largest longitude values in the spatial dataset.Numeric9 (9,6)  
 YMaxThe largest latitude values in the spatial dataset.Numeric9 (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.

VarChar50  
 SpatialDatasetOriginalSourceReserved for future use.VarChar100  
 SpatialDatasetIsAvailableForAnalysis

Indicates whether the dataset is available for use during a Geospatial analysis.

  • 1 = Yes (available)
  • 0 = No (unavailable)
Boolean1   
 SpatialDatasetCachePriorityA seldom used value corresponding to Microsoft’s System.Web.Caching.CacheItemPriority values. Integer4  
 CreateDateDate and time the spatial dataset was createdDBTimeStamp4
(getdate())
 
 UploadDateDate the spatial dataset was created.DBTimeStamp4
(getdate())
 
 DescriptionDescription of the spatial dataset.VarChar4000  
 EventScaleStorm category value for tropical cyclone.  Magnitude value for earthquake.VarChar4000  
 InsurableLossInsured loss amount for historical events.VarChar4000  
 NotesNotes about the dataset.VarChar4000  
 EventYearYear in which historical event occurred.Integer4  
 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.

Xml16  
 AvailableForAnalysisTypeCode

Code that represents the analysis types for which the spatial dataset can be used.

For a complete list of codes, see tAnalysisType Table.
VarChar10  
 LicenseRegionCode

Code that represents the geographic region.

For a complete list of codes, see tLicenseRegion Table.

SmallInt2  
 BusinessUnitSID

Unique system-generated sequential identifier for the business unit record.

Integer4 
((0))
 
 LayerGroupName of the map layer group to which the spatial dataset is applied. Reserved for future use.VarChar100  
Objects that depend on tSpatialDataset
 Database ObjectObject TypeDescriptionDep Level
tSpatialDatasetAnalysis tabletSpatialDatasetAnalysisTableReserved for overriding a default distance of 100 miles if it is not precise enough for a particular spatial dataset’s processing.1
tSpatialDatasetEvent tabletSpatialDatasetEventTableReserved for future use.1
tSpatialDatasetGroupDefinition tabletSpatialDatasetGroupDefinitionTableA cross reference table that links datasets to their dataset groups.1
tSpatialDatasetHazardAttributeXref tabletSpatialDatasetHazardAttributeXrefTableSystem reference table used to identify the hazard attribute associated with a spatial dataset.1
See Also

Related Objects

AIRSpatial Database

 

 


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.