Question

Convert SDO_GEOMETRY to ST_GEOMETRY

  • 13 March 2015
  • 1 reply
  • 12 views
J
Badge +1
I have an ESRI file geodatabase and would like to insert it into an Oracle table in ST_GEOMETRY format. The Oracle Spatial writer, however, seems to write only SDO_GEOMETRY. Is there a way to get it to write ST_GEOMETRY?

 

 

Thanks

1 reply

G
Badge +3
afiak, you cannot store SDE.ST_GEOMETRY in Oralce SDO.

 

You need to convert it.

 

Theoreticcaly something like this should work in oracle, so maybe if u use a SQLExecutor  or a SQLCreator with a selection like this might work:

 

 

SELECT MDSYS.SDO_GEOMETRY(SDE.ST_AsText(a.shape),SDO_SRID) FROM my_ESRI_ST_GEOMETRY_table a;

 

 

(have not tried this myself btw. The example is quoted from the Oracle community.)

Reply


Community Stats

28,650
Posts
109,267
Replies
36,523
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.