How to model government organization hierarchies so that the list can expand and compress

[Alex Glaros]

Frank, thanks for describing the terminology of what I'm trying to do.

1. Do the recursive join Postgres examples you linked to, use a data structure where the child has the adjoining parent-ID? Examples look great.

2. Not 100% sure that hierarchical is the perfect solution but will go with that now. Of course some agencies will be at equal levels; will ignore for now.

3. Could not find Laura's response. Was it deleted?

4. Solution will expressed in the DB, not Python.

Much appreciated!

Alex