Suborganization / grouping hierarchy

[epicfaace]

1. Create the database structure for handling suborganizations
2. Create a frontend functionality for doing this (editing / viewing this data), then manually tag a few orgs
3. Ue a service like Nominatum to automatically do it

[Matthew-Grayson]

Government hierarchies becomes FOUO at a certain level of detail, so I suggest they aren't navigable by unregistered or non-federal users.

[mbachtell-nais]

The attached spreadsheet is assembled from usa.gov's list of federal agencies, states, and Federally recognized American Indian tribes and Alaska Native entities.

us_govt_agencies.xlsx

This should be the foundation of the organizations. It does not have the relationships established and those will need to be done now.

@epicfaace, do we want to have these prepopulated in the database and flagged as disabled until an "organization" requests activation?

[mbachtell-nais]

• https://github.com/cisagov/dotgov-data/blob/main/current-full.csv
• https://github.com/cisagov/dotgov-data/blob/main/current-federal.csv

These will be used as the base for the federal, state, and some local organizations. These will be supplemented by the content in the previously linked spreadsheet.

The script in https://github.com/cisagov/crossfeed/blob/master/backend/src/tasks/dotgov.ts has foundational elements for the ETL processing of the bulleted links above.

[mbachtell-nais]

Comparison of Tribal groups from current-federal.csv and those listed on usa.gov. The delta will need to mined and added. Marked as "Missing" in the spreadsheet.

Tribal_combined.csv

[mbachtell-nais]

The scripts to pull the respective websites for counties and all of the towns and cities listed within Wikipedia is complete but I'm not sure where this fits in to the larger Crossfeed project. The scripts and content are available at https://github.com/mbachtell-nais/US-County-and-City-URLs .