Table of Contents

Class SpatialDataSchema.SpatialIndexTessellation

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.spatial_index_tessellations (Transact-SQL)

Applies to: √ SQL Server

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

note


For information about tessellation, see Spatial Indexes Overview.


See sys.spatial_index_tessellations.

[Table(Schema = "sys", Name = "spatial_index_tessellations", IsView = true)]
public class SpatialDataSchema.SpatialIndexTessellation
Inheritance
SpatialDataSchema.SpatialIndexTessellation
Inherited Members
Extension Methods

Properties

BoundingBoxXmax

bounding_box_xmax NULL 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 
[Column("bounding_box_xmax")]
[Nullable]
public double? BoundingBoxXmax { get; set; }

Property Value

double?

BoundingBoxXmin

bounding_box_xmin NULL 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: The coordinates defined by the bounding box parameters are interpreted for each object according to its Spatial Reference Identifier (SRID). 
[Column("bounding_box_xmin")]
[Nullable]
public double? BoundingBoxXmin { get; set; }

Property Value

double?

BoundingBoxYmax

bounding_box_ymax NULL 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 
[Column("bounding_box_ymax")]
[Nullable]
public double? BoundingBoxYmax { get; set; }

Property Value

double?

BoundingBoxYmin

bounding_box_ymin NULL 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 
[Column("bounding_box_ymin")]
[Nullable]
public double? BoundingBoxYmin { get; set; }

Property Value

double?

CellsPerObject

cells_per_object NULL 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 
[Column("cells_per_object")]
[Nullable]
public int? CellsPerObject { get; set; }

Property Value

int?

IndexID

index_id NOT NULL int

ID of the spatial index in which the indexed column is defined 
[Column("index_id")]
[NotNull]
public int IndexID { get; set; }

Property Value

int

Level1Grid

level_1_grid NULL 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. 
[Column("level_1_grid")]
[Nullable]
public short? Level1Grid { get; set; }

Property Value

short?

Level1GridDesc

level_1_grid_desc NULL 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. 
[Column("level_1_grid_desc")]
[Nullable]
public string? Level1GridDesc { get; set; }

Property Value

string

Level2Grid

level_2_grid NULL 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. 
[Column("level_2_grid")]
[Nullable]
public short? Level2Grid { get; set; }

Property Value

short?

Level2GridDesc

level_2_grid_desc NULL 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. 
[Column("level_2_grid_desc")]
[Nullable]
public string? Level2GridDesc { get; set; }

Property Value

string

Level3Grid

level_3_grid NULL 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. 
[Column("level_3_grid")]
[Nullable]
public short? Level3Grid { get; set; }

Property Value

short?

Level3GridDesc

level_3_grid_desc NULL 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. 
[Column("level_3_grid_desc")]
[Nullable]
public string? Level3GridDesc { get; set; }

Property Value

string

Level4Grid

level_4_grid NULL 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. 
[Column("level_4_grid")]
[Nullable]
public short? Level4Grid { get; set; }

Property Value

short?

Level4GridDesc

level_4_grid_desc NULL 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. 
[Column("level_4_grid_desc")]
[Nullable]
public string? Level4GridDesc { get; set; }

Property Value

string

Object

objects (sys.objects)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = false)]
public ObjectSchema.Object Object { get; set; }

Property Value

ObjectSchema.Object

ObjectID

object_id NOT NULL 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. 
[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int

TessellationScheme

tessellation_scheme NULL sysname

Name of the tessellation scheme, one of: GEOMETRY_GRID, GEOGRAPHY_GRID 
[Column("tessellation_scheme")]
[Nullable]
public string? TessellationScheme { get; set; }

Property Value

string