topic Re: Get ST_GEOMETRY object's attribute in ArcGIS Enterprise Questions

Get ST_GEOMETRY object's attribute

Bud — Mon, 16 May 2022 19:13:55 GMT

I have an SDE.ST_GEOMETRY value (Oracle 18c):

select
    sde.st_geometry('LINESTRING EMPTY', 26917) as shape
from
    dual

I want to select one of the ST_GEOMETRY object's attributes:

How can I do that with Oracle SQL?

Bud — Sat, 11 Jun 2022 20:10:27 GMT

1. Use dot notation:

select
    sde.st_geometry('LINESTRING EMPTY', 26917).len as shape
from
    dual

If the shape column wasn't already wrapped in brackets via a function, then we would need to add the brackets:

select
    (shape).len
from
    my_fc

2. Or, use a table alias:

select
    a.shape.len
from
    my_fc a

3. Or, use the TREAT() function:

select
    treat(shape as sde.st_geometry).len
from
    my_fc

Although that might be misguided/unnecessary, since wrapping the column in brackets achieves the same thing (brackets is my preferred technique).

Bud — Thu, 09 Jun 2022 14:42:13 GMT

If I understand correctly, SDO_GEOMETRY has similar attributes. Additionally, SDO_GEOMETRY has methods (aka member functions):

Bud — Tue, 28 Nov 2023 23:09:24 GMT

For my notes, the result from an object's attribute can be different than the result from the corresponding ST_GEOMETRY function: