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. 
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 