Construct ST_GEOMETRY rectangle from two vertices

Bud — Wed, 08 Jun 2022 14:35:16 GMT

SDE.ST_GEOMETRY in Oracle:

I have two vertices of a rectangle:

Lower-left: 10,10
Upper-right: 100,100

I want to construct a rectangle polygon from those two vertices using ST_GEOMETRY functions.

Currently, there doesn't seem to be a a way to construct that rectangle using only the two vertices. It seems like the only way to construct the rectangle is to determine what all four (or five?) vertices are — and construct the rectangle that way.

It would help if functionality could be added so that we could construct an ST_GEOMETRY rectangle from just the lower-left and upper-right vertices.

Similar to what we can do with SDO_GEOMETRY's rectangle functionality:

select
    sdo_geometry(2003, 26917, null, sdo_elem_info_array(1, 1003, 3), 
        sdo_ordinate_array(665287.423,4857578.086,     676832.320,4878119.585))
        -- only two vertices         🡅                          🡅
from
    dual

Result:
[MDSYS.SDO_GEOMETRY]

idea Construct ST_GEOMETRY rectangle from two vertices in ArcGIS Enterprise Ideas

Construct ST_GEOMETRY rectangle from two vertices