Skip to main content
Solved

SDE Writer - How to set up Oracle metadata correct for SDO Geometry?

  • August 12, 2016
  • 3 replies
  • 91 views
M
Forum|alt.badge.img

We're trying to write data via "ArcSDE Geodb" writer in SDO_GEOMETRY format and make it readable for non-ESRI software. We're using ArcGIS for Desktop 10.3.1 on an ArcSDE 10.2.2 on Oracle 11g with FME Desktop 2015.1 (but the same problem apperas in different combinations of software versions as well).

Our main problem is that in the oracle geometry metadata entries the axis-definition can't be set correctly no matter how we're trying it. 

SQL:
select DIMINFO from user_sdo_geom_metadata WHERE TABLE_NAME = 'SDOTEST_FME_WRITERCRS';

RESULT:
MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT(NULL,3447000,3467000,0.001),MDSYS.SDO_DIM_ELEMENT(NULL,5422000,5440000,0.001))

As you can see, both axis are defined as "NULL" instead of "X" and "Y". Is there any way to tell the writer how to set this up correct?

Best answer by mariuskolleck

We figured it out ourselves - maybe the answer is usefull to others:

Add following lines to the conf-keyword in the dbtune:

SDO_DIMNAME_1 "X"
SDO_DIMNAME_2 "Y"

Now the metadata entry looks like this:

MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',3505441.75,3521229.808,0.001),MDSYS.SDO_DIM_ELEMENT('Y',5395498.508,5412904.8494,0.001))
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

M
Forum|alt.badge.img
  • mariuskolleck
  • Author
  • Best Answer
  • August 12, 2016

We figured it out ourselves - maybe the answer is usefull to others:

Add following lines to the conf-keyword in the dbtune:

SDO_DIMNAME_1 "X"
SDO_DIMNAME_2 "Y"

Now the metadata entry looks like this:

MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',3505441.75,3521229.808,0.001),MDSYS.SDO_DIM_ELEMENT('Y',5395498.508,5412904.8494,0.001))
steveatsafe
Safer
Forum|alt.badge.img+13
  • steveatsafeSafer
  • Safer
  • August 13, 2016

Just to be clear - this is related to the "Configuration Keyword" on the GEODATABASE_SDE Writer. So the settings you are are managing are found in the DBTUNE table of the targeted database. I presume you've either tweak "DEFAULTS" or created a new keyword configuration set to use when creating tables with geometry type of SDO_GEOMETRY.

 

 

Thanks for the share of your solution! I'm sure it will help someone else.
SteveatSafe
M
Forum|alt.badge.img

Just to be clear - this is related to the "Configuration Keyword" on the GEODATABASE_SDE Writer. So the settings you are are managing are found in the DBTUNE table of the targeted database. I presume you've either tweak "DEFAULTS" or created a new keyword configuration set to use when creating tables with geometry type of SDO_GEOMETRY.

 

 

Thanks for the share of your solution! I'm sure it will help someone else.
Exactly - thank you for setting this clear. We edited the configuration keyword we used for this specific purpose by export and reimport via ESRI's sde command line tools. Another way is - like you said - edit the table DBTUNE directly.

 

 

Community Stats

32,154
Posts
122,047
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.