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
select sde.sde_states.state_id, parent_state_id, lineage_name, name
left join sde.SDE_versions
order by state_id;
but I'm having trouble sorting the states into their branches however. Anyone at esri have some advice?