Skip to main content
Solved

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

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))
View original
Did this help you find an answer to your question?

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+12
  • 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
steveatsafe wrote:

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.

 

 

Reply


Helpful Members This Week

Community Stats

31,191
Posts
118,246
Replies
38,801
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.