topic Re: Export Domains to spreadsheet in Data Management Questions

Export Domains to spreadsheet

Anonymous User — Wed, 24 Nov 2010 16:29:45 GMT

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

Re: Export Domains to spreadsheet

anthonysanchez — Tue, 30 Nov 2010 13:52:00 GMT

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

Re: Export Domains to spreadsheet

BruceHarold — Wed, 01 Dec 2010 19:26:56 GMT

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