Has X dimension?
hasX({tbox, stbox}): bool
SELECT hasX(tbox 'TBOX((, 2000-01-01), (, 2000-01-03))'); -- false SELECT hasX(stbox 'STBOX((1.0, 2.0), (3.0, 4.0))'); -- true
Has Z dimension?
hasZ(stbox): bool
SELECT hasZ(stbox 'STBOX((1.0, 2.0), (3.0, 4.0))'); -- false
Has T dimension?
hasT({tbox, stbox}): bool
SELECT hasT(tbox 'TBOX((1.0, 2000-01-01), (3.0, 2000-01-03))'); -- true SELECT hasT(stbox 'STBOX((1.0, 2.0), (3.0, 4.0))'); -- false
Get the minimum X value
Xmin({tbox, stbox}): float
SELECT Xmin(tbox 'TBOX((1.0, 2000-01-01), (3.0, 2000-01-03))'); -- 1 SELECT Xmin(stbox 'STBOX((1.0, 2.0), (3.0, 4.0))'); -- 1
Get the maximum X value
Xmax({tbox, stbox}): float
SELECT Xmax(tbox 'TBOX((1.0, 2000-01-01), (3.0, 2000-01-03))'); -- 3 SELECT Xmax(stbox 'STBOX((1.0, 2.0), (3.0, 4.0))'); -- 3
Get the minimum Y value
Ymin(stbox): float
SELECT Ymin(stbox 'STBOX((1.0, 2.0), (3.0, 4.0))'); -- 2
Get the maximum Y value
Ymax(stbox): float
SELECT Ymax(stbox 'STBOX((1.0, 2.0), (3.0, 4.0))'); -- 4
Get the minimum Z value
Zmin(stbox): float
SELECT Zmin(stbox 'STBOX Z((1.0, 2.0, 3.0), (4.0, 5.0, 6.0))'); -- 3
Get the maximum Z value
Zmax(stbox): float
SELECT Zmax(stbox 'STBOX Z((1.0, 2.0, 3.0), (4.0, 5.0, 6.0))'); -- 6
Get the minimum timestamp
Tmin({tbox, stbox}): timestamptz
SELECT Tmin(stbox 'GEODSTBOX T(( , , 2001-01-01), ( , , 2001-01-03))'); -- "2001-01-01"
Get the maximum timestamp
Tmax({tbox, stbox}): timestamptz
SELECT Tmax(stbox 'GEODSTBOX T(( , , 2001-01-01), ( , , 2001-01-03))'); -- "2001-01-03"