Add additional "attributes" to ST_GEOMETRY object column

Bud — Tue, 12 Jul 2022 21:30:10 GMT

Oracle 18c SDE.ST_GEOMETRY EGDB:

Has anyone ever tried adding additional "attributes" to an ST_GEOMETRY object column?

Such as adding an SDO_GEOMETRY attribute to the object column:

ENTITY	NUMBER(38)
NUMPTS	NUMBER(38)
MINX	FLOAT(64)
MINY	FLOAT(64)
MAXX	FLOAT(64)
MAXY	FLOAT(64)
MINZ	FLOAT(64)
MAXZ	FLOAT(64)
MINM	FLOAT(64)
MAXM	FLOAT(64)
AREA	FLOAT(64)
LEN	FLOAT(64)
SRID	NUMBER(38)
POINTS	BLOB
SDO_GEOM	SDO_GEOMETRY

Source: ST_Geometry in Oracle

Or, alternatively, add an additional "subtype" to the object supertype.

Sure, it wouldn't be supported. But that's not what I'm asking about. I'm asking if anyone has tried it.

Reason: I want to use Oracle Spatial linear referencing functionality, but can't switch my FCs from ST_GEOMETRY over to SDO_GOMETRY. We can't add additional geometry columns to a FC (causes errors). And I want to avoid creating dozens of helper SDO_GEOMETRY FCs if I can help it.

Thanks.

topic Add additional "attributes" to ST_GEOMETRY *object* column in Geodatabase Questions

Add additional "attributes" to ST_GEOMETRY *object* column

topic Add additional "attributes" to ST_GEOMETRY object column in Geodatabase Questions

Add additional "attributes" to ST_GEOMETRY object column