Export (0) Print
Expand All
Expand Minimize

sys.spatial_index_tessellations (Transact-SQL)

Represents the information about the tessellation scheme and parameters of each of the spatial indexes.

NoteNote

For information about tessellation, see Spatial Indexing 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)

X-coordinate of the lower-left 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 x-min coordinate value

NoteNote
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)

Y-coordinate of the lower-left 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 y-min coordinate value

bounding_box_xmax

float(53)

X-coordinate of the upper-right 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 x-max coordinate value

bounding_box_ymax

float(53)

Y-coordinate of upper-right 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 y-max coordinate value

level_1_grid

smallint

Grid density for the top-level 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)

level_1_grid_desc

nvarchar(60)

Grid density for the top-level grid, one of:

LOW

MEDIUM

HIGH

level_2_grid

smallint

Grid density for the 2nd-level 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

level_2_grid_desc

nvarchar(60)

Grid density for the 2nd-level grid, one of:

LOW

MEDIUM

HIGH

level_3_grid

smallint

Grid density for the 3rd-level 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

level_3_grid_desc

nvarchar(60)

Grid density for the 3rd-level grid, one of:

LOW

MEDIUM

HIGH

level_4_grid

smallint

Grid density for the 4th-level 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

level_4_grid_desc

nvarchar(60)

Grid density for the 4th-level grid, one of:

LOW

MEDIUM

HIGH

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

In SQL Server 2005 and later versions, 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. For more information, see Metadata Visibility Configuration.

Community Additions

ADD
Show:
© 2014 Microsoft