Table of Contents
A tbox
is composed of a numeric value and/or time dimensions. For each dimension, minimum and maximum values are given. Examples of input of tbox
values are as follows:
-- Both value and time dimensions SELECT tbox 'TBOX((1.0, 2000-01-01), (2.0, 2000-01-02))'; -- Only value dimension SELECT tbox 'TBOX((1.0,), (2.0,))'; -- Only time dimension SELECT tbox 'TBOX((, 2000-01-01), (, 2000-01-02))';
An stbox
is composed of a spatial value and/or time dimensions, where the coordinates of the spatial value dimension may be 2D or 3D. For each dimension, minimum and maximum values are given. The coordinates may be Cartesian (planar) or geodetic (spherical). The SRID of the coordinates may be specified; if it is not the case, a value of 0 (unknown) and 4326 (corresponding to WGS84) is assumed, respectively, for planar and geodetic boxes. Examples of input of stbox
values are as follows:
-- Only value dimension with X and Y coordinates SELECT stbox 'STBOX((1.0, 2.0), (1.0, 2.0))'; -- Only value dimension with X, Y, and Z coordinates SELECT stbox 'STBOX Z((1.0, 2.0, 3.0), (1.0, 2.0, 3.0))'; -- Both value (with X and Y coordinates) and time dimensions SELECT stbox 'STBOX T((1.0, 2.0, 2001-01-03), (1.0, 2.0, 2001-01-03))'; -- Both value (with X, Y, and Z coordinates) and time dimensions SELECT stbox 'STBOX ZT((1.0, 2.0, 3.0, 2001-01-04), (1.0, 2.0, 3.0, 2001-01-04))'; -- Only time dimension SELECT stbox 'STBOX T(( , , 2001-01-03), ( , , 2001-01-03))'; -- Only value dimension with X, Y, and Z geodetic coordinates SELECT stbox 'GEODSTBOX((1.0, 2.0, 3.0), (1.0, 2.0, 3.0))'; -- Both value (with X, Y and Z geodetic coordinates) and time dimension SELECT stbox 'GEODSTBOX T((1.0, 2.0, 3.0, 2001-01-04), (1.0, 2.0, 3.0, 2001-01-04))'; -- Only time dimension for geodetic box SELECT stbox 'GEODSTBOX T(( , , 2001-01-03), ( , , 2001-01-03))'; -- SRID is given SELECT stbox 'SRID=5676;STBOX T((1.0, 2.0, 2001-01-04), (1.0, 2.0, 2001-01-04))'; SELECT stbox 'SRID=4326;GEODSTBOX((1.0, 2.0, 3.0), (1.0, 2.0, 3.0))';