How to replicate state tree from GDBTools?

[ChrisMathers1]

 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?

[DerekLaw]

All,

Just FYI, you may also want to vote for this enhancement request on the ArcGIS Ideas site,

State Tree Diagram for 10.1 and above

https://community.esri.com/ideas/7322?commentID=33437#comment-33437 

Hope this helps,