![]() |
MobilityDB 1.3
|
◆ stbox_in()
Return a spatiotemporal box from its Well-Known Text (WKT) representation. Examples of input are as follows STBOX X((1.0, 2.0), (3.0, 4.0)) -> only spatial 2D
STBOX Z((1.0, 2.0, 3.0), (4.0, 5.0, 6.0)) -> only spatial 3D
STBOX XT(((1.0, 2.0), (3.0, 4.0)),[2001-01-01, 2001-01-02]) -> spatiotemporal 2D+T
STBOX ZT(((1.0, 2.0, 3.0), (4.0, 5.0, 6.0)),[2001-01-01, 2001-01-02]) -> spatiotemporal 3D+T
STBOX T([2001-01-01, 2001-01-02]) -> only temporal
SRID=xxxx;STBOX... -> Any of the above with SRID
GEODSTBOX Z((1.0, 2.0, 3.0), (4.0, 5.0, 6.0)) -> only spatial
GEODSTBOX T([2001-01-01, 2001-01-02]) -> only temporal
GEODSTBOX ZT(((1.0, 2.0, 3.0),(4.0, 5.0, 6.0)),[2001-01-01, 2001-01-02]) -> spatiotemporal
SRID=xxxx;GEODSTBOX... -> Any of the above with SRID
where the commas are optional and the SRID is optional. If the SRID is not stated it is by default 0 for non geodetic boxes and 4326 for geodetic boxes
|