Startup

Inputs

The Startup module has no inputs

Outputs

MGRA XREF ([inputs].[mgra])

Create the MGRA cross-reference which will be used for every year of data in the Estimates run. Since the MGRA is the smallest geography we have, it nicely nests up to every larger geography, which are currently limited to the 2010 Census Tracts, 2020 Census Tracts, and 2020 Cities.

All XREFs are pulled from the [GeoAnalyst] database, rather than [demographic_warehouse], due to the better documentation of XREF source and methodology. As we are currently on MGRA15, the 2020 Census Tract and 2020 Cities xref are simple many-to-one relationships. However, the MGRA15 to 2010 Census Tract is actually a many-to-many relationship, which the Estimates Program is not currently equipped to deal with. Instead, special work was done to create a many-to-one relationship between MGRA15 and 2010 Census Tracts, all of which is documented in the [GeoAnalyst] project (link: TODO as there is currently no GitHub repo for this).

Special MGRAs ([inputs].[special_mgras])

Certain MGRAs contain special kinds of population or housing and so thus must be treated differently. There are three different situations which are labeled by this output table:

1. MGRAs with prison population, aka Group Quarters - Institutional Correctional Facilities
2. MGRAs with only active duty military population, aka TODO
3. MGRAs with senior only population, aka TODO. Note that most senior communities are age restricted to 55+, with a few exceptions for 45+ communities.

Each row of this table contains the following information (table metadata columns not included)

Column	Description
[mgra15]	The MGRA15 number that these age/sex restrictions are applied to
[start_year]	The year inclusive that these restrictions start applying in
[end_year]	The year inclusive that these restrictions stop applying in
[pop_type]	The type of population the restrctions apply to
[sex]	(Optional) The sex the population must be
[min_age]	(Optional) The minimum age inclusive the population can be
[max_age]	(Optional) The maximum age inclusive the population can be