Method CreateSpatialIndex

Namespace

YndigoBlue.Velocity.Model

Assembly

YndigoBlue.Velocity.dll

CreateSpatialIndex(string, string, double, double, double, double, double, double, double)

Creates a spatial index on a geometry or geography column with an explicit bounding box and multi-level grid sizes.

public SpatialIndex CreateSpatialIndex(string name, string column, double xmin, double ymin, double xmax, double ymax, double smallGridSize, double mediumGridSize, double largeGridSize)

Parameters

name string

The index name.

column string

The name of the Geometry or Geography column to index.

xmin double

The minimum X coordinate (longitude) of the bounding box.

ymin double

The minimum Y coordinate (latitude) of the bounding box.

xmax double

The maximum X coordinate (longitude) of the bounding box.

ymax double

The maximum Y coordinate (latitude) of the bounding box.

smallGridSize double

The size of the finest grid cells; smaller values give higher spatial resolution but increase index size.

mediumGridSize double

The size of the medium-level grid cells.

largeGridSize double

The size of the coarsest grid cells.

Returns

SpatialIndex

The newly created SpatialIndex.

CreateSpatialIndex(string, string)

Creates a spatial index on a geometry or geography column with zeroed bounding box and grid sizes, suitable for databases that auto-compute the extent.

public SpatialIndex CreateSpatialIndex(string name, string column)

Parameters

name string

The index name.

column string

The name of the Geometry or Geography column to index.

Returns

SpatialIndex

The newly created SpatialIndex.