I have a SDE.ST_GEOMETRY polyline FC in an Oracle 18c/10.7.1 geodatabase.
I want to convert the SDE.ST_GEOMETRY shape column to SDO_GEOMETRY using SQL.
Reason: So that I can do linear referencing operations using Oracle Spatial's linear referencing package.
Such a conversion can be done by:
Converting the SDE.ST_GEOMETRY shape column to well-known text using ST_AsText.
to_char(sde.st_astext(shape))
LINESTRING ( 675939.0727821561 4861635.038876267, 675881.8875467349 4861589.914457718, 675879.1765119368 4861586.041565847, 675877.9556495566 4861580.512319708, 675879.8962382395 4861575.485510156, 675976.9673410757 4861477.697030321, 675982.1957818093 4861474.598758776, 675988.0051615685 4861472.468589587, 675994.20185149 4861471.306795442, 676000.9793965323 4861470.919485278, 676006.788765802 4861471.306795442, 676011.6298439335 4861472.275034143, 676150.6204311419 4861517.834283836)
From there, I can convert the well-known text to SDO_GEOMETRY using SDO_UTIL.FROM_WKTGEOMETRY:
sdo_util.from_wktgeometry(sde.st_astext(shape))
MDSYS.SDO_GEOMETRY(2002,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),MDSYS.SDO_ORDINATE_ARRAY(675939.072782156,4861635.03887627,675881.887546735,4861589.91445772,675879.176511937,4861586.04156585,675877.955649557,4861580.51231971,675879.89623824,4861575.48551016,675976.967341076,4861477.69703032,675982.195781809,4861474.59875878,675988.005161569,4861472.46858959,675994.20185149,4861471.30679544,676000.979396532,4861470.91948528,676006.788765802,4861471.30679544,676011.629843934,4861472.27503414,676150.620431142,4861517.83428384,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL))
Question:
What's with all the nulls in the SDO_GEOMETRY result? Can they be avoided?
For what it's worth, I'm using Toad for Oracle (version 12.12.0.39).
ST_GEOMETRY
parameter list. – geozelot Jan 12 '20 at 9:57