Hello Joshua,
Sorry to bring up an old thread but I was wondering what the SQL query of the states or state lineages table you ran against the GDB was to generate the WIL_sde_states.txt parse file? Thanks!
-Rex
We use Oracle user-schema geodatabases, so you have to define the schema geodatabase of interest. My SQL file I use contains the following:
SET ECHO OFF
SET FEEDBACK OFF
SET LINESIZE 240
SET PAGESIZE 1500
SET TRIMSPOOL ON
COLUMN state FORMAT a10 HEADING 'STATE'
COLUMN parent FORMAT a10 HEADING 'PARENT'
COLUMN version FORMAT a50 HEADING 'VERSION'
COLUMN lineage FORMAT a10 HEADING 'LINEAGE'
DEFINE SDE = (name of user-schema geodatabase)
SELECT TO_CHAR(st.state_id) AS state
,TO_CHAR(st.parent_state_id) AS parent
,vr.name AS version
,TO_CHAR(st.lineage_name) AS lineage
from &SDE..states st
LEFT JOIN &SDE..versions vr
ON st.state_id = vr.state_id
ORDER BY st.state_id;
For all those looking to use the GDBT with the recent releases of ArcGIS Desktop:
Using our favourite GDBT toolset with Desktop 10.1 or later release