ST_SpatialGridIndex

Create a grid table.

Syntax

ST_SpatialGridIndex(gridsize [, debug[, srid]])

gridsize

The grid size in degrees. Possible values:

1
0.1
0.01

Type: DOUBLE

debug

Whether to enable debug messages and preserve all intermediate tables.

Type: BOOLEAN

Default: FALSE

srid

The SRID used to initialize the grid.

Type: INTEGER

Returns

This function returns two outputs:

A value of type INTEGER that is 0 if the function was successful or 1 if an error occurred.
A grid table with one row for ...? Each row of the output table has the following columns:

???

???

Examples

set PATH=inza.inza;
 
call inza..ST_SPATIALGRIDINDEX(1,'FALSE',4326); select count(*) from
            grid_one_geometries; drop table grid_one_geometries;

call inza..ST_SPATIALGRIDINDEX(0.1,'FALSE',4326); select count(*) from
            grid_point1_geometries; drop table grid_point1_geometries;


 
ST_SPATIALGRIDINDEX
---------------------
0
(1 row)

COUNT
-------
64800
(1 row)

ST_SPATIALGRIDINDEX
---------------------
0
(1 row)

COUNT
---------
6480000
(1 row)