O'Reilly logo

Applying and Extending Oracle Spatial by Siva Ravada, Simon Gerard Greener

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Tiling a vector geometry – ST_Tile

A common requirement for processing vector data is to tile (or tesselate) a vector object into a series of regular, non-overlapping squares or rectangles so that the entire object is covered. A function to do this is described as follows:

Create Or Replace T_Geometry As Object(
[…]
  Member Function ST_Tile(p_Tile_X    In Number,
                          p_Tile_Y    In Number,
                          p_grid_type In varchar2 Default 'TILE',
                          p_touch     In Integer default 0,
                          p_clip      In Integer default 0)
         Return T_Grids Pipelined,

This function requires the width of the tile in X and Y dimensions to be provided. They do not have to be the same. They, however, have to be expressed in the default units of the geometry's SRID. In addition, the p_grid_type parameter allows the user ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required