AnsweredAssumed Answered

How to replicate state tree from GDBTools?

Question asked by cmathers on Sep 27, 2016
Latest reply on Oct 12, 2016 by cmathers

 I got a new computer which means a completely fresh install of Desktop at 10.4.1 which means no more rolling GDBTools forward. I really liked being able to visualize the state tree and want to try to replicate it using python. I'm grabbing the state list using

use sde
select sde.sde_states.state_id, parent_state_id, lineage_name, name
from sde.SDE_states
left join sde.SDE_versions
on sde.sde_states.state_id
= sde.sde_versions.state_id
order by state_id;

but I'm having trouble sorting the states into their branches however. Anyone at esri have some advice?