Export Domains to spreadsheet

Question

Does anyone know a tool that will help me export all tools to a table/spreadsheet? (for Arc10)

I used to use Geodatabase Reporter, but there is not a version for Arc10.  The domain-to-table works well enough for a single table, but not really for a gdb w/ 250 domains in it...

bharold · Answer

Does anyone know a tool that will help me export all tools to a table/spreadsheet? (for Arc10)

I used to use Geodatabase Reporter, but there is not a version for Arc10.  The domain-to-table works well enough for a single table, but not really for a gdb w/ 250 domains in it...

Hi

ArcPy Describe properties include a Python list of domains for any workspace which you could loop through the Domain to Table GP tool and make your tables.

Regards

anthonysanchez · Answer

Hello,
I'm not aware of any tools but I do know that they are now stored in xml for you to grab and parse yourself.

for oracle:
range domains:
SELECT name,definition FROM SDE.GDB_ITEMS_VW
where type='{C29DA988-8C3E-45F7-8B5C-18E51EE7BEB4}';

coded value domains:
SELECT NAME,DEFINITION FROM SDE.GDB_ITEMS_VW
where type='{8C368B12-A12E-4C7E-9638-C9C64E69E98F}';

You may need to use sqldeveloper or some other tool that can display the xml for you.

-Anthony