1

Is it possible to create additional 'fields' in the geodatabase domain system table (GDB_items) in SDE 10.3/Oracle?

It would be handy to store additional information in domains. For example:

  • CODE [domain coded value]
  • NAME [domain description]
  • Additional fields: DETAILS, COMMENTS, RELATED_DOCUMENT, etc.

I know it wouldn't be accessible in ArcGIS desktop's out-of-box functionality, but maybe it would be possible to query it with SQL?

The SQL used to access the domain would look like this, but include additional 'fields':

select 
 extractvalue(codedvalues.column_value, 'CodedValue/Code') as domain_code, 
 extractvalue(codedvalues.column_value, 'CodedValue/Name') as domain_description
from 
 sde.gdb_items_vw
cross join
 xmlsequence(xmltype(definition).extract('/GPCodedValueDomain2/CodedValues/CodedValue')) codedvalues 
where 
 sde.gdb_items_vw.name = 'STRATEGY'

Or, as an alternative, would it be an acceptable practice to create a separate table that is related to the domain by the CODE value? And then join to it using the query mentioned above?

asked May 10, 2016 at 20:02
3
  • 4
    If you don't mind using a completely unsupported geodatabase, with the possibilty of corruption at the next upgrade... All-in-all, I'd recommend a parallel table (owned by a different user). Commented May 10, 2016 at 20:10
  • @Vince: Why owned by a different user? Commented May 10, 2016 at 21:17
  • 1
    To prevent namespace pollution. Commented May 10, 2016 at 21:53

1 Answer 1

0

Vince's comment as the answer:

...I'd recommend a parallel table.

answered Sep 2, 2016 at 13:33

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.