sys.spatial_index_tessellations (TransactSQL)
Updated: June 10, 2016
Represents the information about the tessellation scheme and parameters of each of the spatial indexes.



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. Note: The coordinates defined by the bounding box parameters are interpreted for each object according to its Spatial Reference Identifier (SRID). 
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 
The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission.
Object Catalog Views (TransactSQL)
Spatial Indexes Overview
sys.objects (TransactSQL)
sys.spatial_indexes (TransactSQL)
sys.indexes (TransactSQL)
sys.index_columns (TransactSQL)
Community Additions
ADD
Show: