Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 2 down vote favorite
1

Is there a way to see the possible values of a specific coded value domain in arcmap 9.3.1 (I have no access to the SDE which holds all the data in arcCatalog)?

share|improve this question

3 Answers

up vote 2 down vote accepted

Are you asking about outside of an edit session?
If you have access to the data in arcmap you have access to the data in arccatalog.
In arcmap there is a small button at the top with a "yellow file cabinet" catalog.
If you access the data in arcmap, ArcCatalog is how that connection is created.
Does IT have that locked down?
a. If you have the data in arcmap and you go to the layer properties> symbology dialog.
Select the domain field on categories, and add all values.
coded value

b. If you can edit when you are in an edit session and select the field (in the attribute table) it should be a pulldown with all the possible values.

Hope I'm not stepping on any IT toes here, but...
NOT
when you open arcmap if you don't have to type a password then you have a connection to sde with the password in it.
They may have it hidden in a secured location but the normal place for those *.sde files is in the... C:\Documents and Settings\myusername\Application Data\ESRI\Desktop10.0\ArcCatalog\Connection to mysde.sde.
If you open arccatalog and go to the sde connection and right click> select properties "not connection properties"
connection
That dialog has two valuable pieces of information.
one the location of the sde (connection) file.
two the name and values of the domains. Note the domains tab (v10 may not be true for 9.3.1)
connection

Once you have acces to that connection you could do the following.
OR request your admin do it for you.
Just create a one time table for you to use as reference. go to arctoolbox...
arctoolbox
use the domain to table tool to create a txt, dbf, gdb table, or info file (gdb table shown)you can use in arcmap, or excel.
domain2table

share|improve this answer
I can enter ArcCatalog but to access the SDE database I needa password which I'm refused to get. A. in the layer properties I cannot see the values B. in the edit I can see all values in the pulldown (thanks!) but I can only see the aliases, not the codes which is the more essential thing. – jonatr Dec 15 '11 at 14:51
if none of this works your admin has created an application to push a password into the connection when you start arcmap. in which case you are probably out of luck (except the choice in b.). You should request an excel file from the domain to table tool. – Brad Nesom Dec 15 '11 at 15:52
up vote 2 down vote

Have you tried running the Domain to Table tool? This will give you a listing of all domains and associated code values. And it is available at all license levels.

share|improve this answer
up vote 0 down vote

Export the feature class to a shapefile. Instead of aliases you should have the actual value.

Or you could do a summarize for the domain field. the result will give you the values, if i'm not mistaken.

share|improve this answer
it's possible (theoretically) - but it's loads of work, as I'd have to record the actual values and then go back to the original to record the aliases which match. – jonatr Dec 18 '11 at 6:25

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.