GDBT to ArcGIS 10.1?

7053
23
04-26-2013 12:32 PM
ChrisQuick
New Contributor II
Will there be a new version of this for ArcGIS 10.1?  If not, does anyone know if the 10.0 version still works with 10.1?

Thanks,

CSQ
Reply
0 Kudos
23 Replies
RexRobichaux3
New Contributor III

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 

Reply
0 Kudos
JoshuaBixby
MVP Esteemed Contributor

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;
ShaunConway
Occasional Contributor II
Anybody want to give me direction of viewing the current state of the database in 10.2?

Thanks,
Shaun
AsrujitSengupta
Regular Contributor III

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