Class SpatialDataSchema.SpatialIndexTessellation
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
sys.spatial_index_tessellations (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Represents the information about the tessellation scheme and parameters of each of the spatial indexes.
note
For information about tessellation, see Spatial Indexes Overview.
[Table(Schema = "sys", Name = "spatial_index_tessellations", IsView = true)]
public class SpatialDataSchema.SpatialIndexTessellation- Inheritance
-
SpatialDataSchema.SpatialIndexTessellation
- Extension Methods
Properties
BoundingBoxXmax
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
BoundingBoxXmin
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
BoundingBoxYmax
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
BoundingBoxYmin
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
CellsPerObject
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
ID of the spatial index in which the indexed column is defined
[Column("index_id")]
[NotNull]
public int IndexID { get; set; }Property Value
Level1Grid
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
Level1GridDesc
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
Level2Grid
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
Level2GridDesc
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
Level3Grid
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
Level3GridDesc
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
Level4Grid
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
Level4GridDesc
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
Object
objects (sys.objects)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = false)]
public ObjectSchema.Object Object { get; set; }Property Value
ObjectID
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
TessellationScheme
Name of the tessellation scheme, one of: GEOMETRY_GRID, GEOGRAPHY_GRID
[Column("tessellation_scheme")]
[Nullable]
public string? TessellationScheme { get; set; }