Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

sys.spatial_index_tessellations (Transact-SQL)

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

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

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

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

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)

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 top-level 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 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. NULL is returned when new SQL Server 11 tessellation is used.

level_2_grid_desc

nvarchar(60)

Grid density for the 2nd-level 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 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. NULL is returned when new SQL Server 11 tessellation is used.

level_3_grid_desc

nvarchar(60)

Grid density for the 3rd-level 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 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. NULL is returned when new SQL Server 11 tessellation is used.

level_4_grid_desc

nvarchar(60)

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.