I am running a query, in which I was hoping to convert ESRI ST_GEOMETY's into SDO_GEOMETRY's
SELECT OBJECTID, ROUTE_NAME, ...
, sde.st_srid(shape) srid
, sde.st_astext(shape)
, sdo_geometry(sde.st_astext(shape), 8307) ora_shape
FROM LRSN_StateLog where objectid=188;
FYI - The ESRI SRID = 300002 (which is probably not related/important)
The sde.st_astext(shape) returns a 3D multilinestrings with measure
Here is an example of the ST_ASTEXT returned:
multilinestring zm((10.05 10.28 3.4 8.4, 20.95 20.89 4.5 9.5), (20.95 20.89 4.5 9.5, 31.92 21.45 3.6 8.6))
I know I can create an oracle SDO_GEOMETRY from a 2D linestring and multilinestring such as this:
select sdo_geometry('MULTILINESTRING (
( 430807.37500000 4218293.00010000, 430770.97000000 4224400.50010000),
( 431599.32500000 4225124.47500000, 439409.06510000 4236267.50010000)
)',8307) from dual;
However, is it possible for ORACLE to accept a 3D (or 3D with measure) WKT?
if so, what would the syntax be? (aka: the WKT formatting)
ps: I have tried a few variations of syntax, and have also tried various 3D Oracle SRID's ...with no luck
pss: I did not see a way to convert the 3D to 2D via any ESRI PL/SQL package either.