Touchstone 2022 Database Reference
tSpatialRounding Table
AIRReference Database : tSpatialRounding Table
Description

Stores information regarding latitude/longitude rounding, which is calculated for map cluster display during a Geospatial analysis.

Properties
Creation Date11/20/2012 12:06 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows7
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key SpatialRoundingCode

Code that represents the spatial rounding.

  • 1 = 0 (1.000000
  • 2 = 1 (0.100000) 
  • 3 = 2 (0.010000)                  
  • 4 = 3 (0.001000)        
  • 5 = 4 (0.000100)        
  • 6 = 5 (0.000010)
  • 7 = 6 (0.000001)        
tinyint1   
 SpatialRoundingDigit

Decimal digit to which the latitude and longitude coordinates are rounded.

Corresponds to the code in SpatialRoundingCode.

tinyint1   
 SpatialRoundingClusterSize

Size of the spatial rounding cluster.

Corresponds to the code in SpatialRoundingCode.

numeric9 (38,6) 
(power(CONVERT([numeric](9,6),(10),(0)), -[SpatialRoundingDigit]))
 Description

Description of the spatial rounding type.

varchar1024  
See Also

Related Objects

AIRReference Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.