sys.spatial_index_tessellations (TransactSQL)
Represents the information about the tessellation scheme and parameters of each of the spatial indexes.
Note 

For information about tessellation, see Spatial Indexes Overview. 
Applies to: SQL Server (SQL Server 2008 through current version). 
Column name 
Data type 
Description 


object_id 
int 
ID of the object on which the index is defined. Each (object_id, index_id) pair has a corresponding entry in sys.spatial_indexes. 

index_id 
int 
ID of the spatial index in which the indexed column is defined 

tessellation_scheme 
sysname 
Name of the tessellation scheme, one of: GEOMETRY_GRID GEOGRAPHY_GRID 

bounding_box_xmin 
float(53) 
Xcoordinate of the lowerleft corner of the bounding box, one of: NULL = Not applicable for a given tessellation scheme (such as GEOGRAPHY_GRID) n = If tessellation_scheme is GEOMETRY_GRID, the xmin coordinate value


bounding_box_ymin 
float(53) 
Ycoordinate of the lowerleft corner of the bounding box, one of: NULL = Not applicable for a given tessellation scheme (such as GEOGRAPHY_GRID) n = If tessellation_scheme is GEOMETRY_GRID, the ymin coordinate value 

bounding_box_xmax 
float(53) 
Xcoordinate of the upperright corner of the bounding box, one of: NULL = Not applicable for a given tessellation scheme (such as GEOGRAPHY_GRID) n = If tessellation_scheme is GEOMETRY_GRID, the xmax coordinate value 

bounding_box_ymax 
float(53) 
Ycoordinate of upperright corner of the bounding box, one of: NULL = Not applicable for a given tessellation scheme (such as GEOGRAPHY_GRID) n = If tessellation_scheme is GEOMETRY_GRID, the ymax coordinate value 

level_1_grid 
smallint 
Grid density for the toplevel grid. If tessellation_scheme is GEOMETRY_GRID or GEOGRAPHY_GRID, one of: 16 = 4 by 4 grid (LOW) 64 = 8 by 8 grid (MEDIUM) 256 = 16 by 16 grid (HIGH) NULL = Not applicable for given spatial index type or tessellation scheme. NULL is returned when new SQL Server 11 tessellation is used. 

level_1_grid_desc 
nvarchar(60) 
Grid density for the toplevel grid, one of: LOW MEDIUM HIGH NULL = Not applicable for given spatial index type or tessellation scheme. NULL is returned when new SQL Server 11 tessellation is used. 

level_2_grid 
smallint 
Grid density for the 2ndlevel grid. If tessellation_scheme is GEOMETRY_GRID or GEOGRAPHY_GRID, one of: 16 = 4 by 4 grid (LOW) 64 = 8 by 8 grid (MEDIUM) 256 = 16 by 16 grid (HIGH) NULL = Not applicable for given spatial index type or tessellation scheme. NULL is returned when new SQL Server 11 tessellation is used. 

level_2_grid_desc 
nvarchar(60) 
Grid density for the 2ndlevel grid, one of: LOW MEDIUM HIGH NULL = Not applicable for given spatial index type or tessellation scheme. NULL is returned when new SQL Server 11 tessellation is used. 

level_3_grid 
smallint 
Grid density for the 3rdlevel grid. If tessellation_scheme is GEOMETRY_GRID or GEOGRAPHY_GRID, one of: 16 = 4 by 4 grid (LOW) 64 = 8 by 8 grid (MEDIUM) 256 = 16 by 16 grid (HIGH) NULL = Not applicable for given spatial index type or tessellation scheme. NULL is returned when new SQL Server 11 tessellation is used. 

level_3_grid_desc 
nvarchar(60) 
Grid density for the 3rdlevel grid, one of: LOW MEDIUM HIGH NULL = Not applicable for given spatial index type or tessellation scheme. NULL is returned when new SQL Server 11 tessellation is used. 

level_4_grid 
smallint 
Grid density for the 4thlevel grid. If tessellation_scheme is GEOMETRY_GRID or GEOGRAPHY_GRID, one of: 16 = 4 by 4 grid (LOW) 64 = 8 by 8 grid (MEDIUM) 256 = 16 by 16 grid (HIGH) NULL = Not applicable for given spatial index type or tessellation scheme. NULL is returned when new SQL Server 11 tessellation is used. 

level_4_grid_desc 
nvarchar(60) 
Grid density for the 4thlevel grid, one of: LOW MEDIUM HIGH NULL = Not applicable for given spatial index type or tessellation scheme. NULL is returned when new SQL Server 11 tessellation is used. 

cells_per_object 
int 
Number of cells per spatial object, one of: If tessellation_scheme is GEOMETRY_GRID or GEOGRAPHY_GRID, n = number of cells per object NULL = Not applicable for given spatial index type or tessellation scheme 