Describe the bug
The 5-year ACS PUMS for 2010 and 2011 have no [DIS] field to identify disabled persons. This makes the "Group Quarters - Institutional Correctional Facilities" type contain a large segment of elderly persons.
To Reproduce
See attached Excel workbook populated by adjusting the sql/ase/get_region_gq_ase_dist.sql query.
GQ ASE Distributions.xlsx
Expected behavior
The resulting distributions for 2010 and 2011 should be more in-line with 2012+. Specifically, having over 13% of the "Group Quarters - Institutional Correctional Facilities" type be 85+ is unacceptable.
Potential resolution
Alter the SQL query to use 2012 distributions for regional group quarters. Some thought is given to only using 2012 for the two types effected by this issue, "Group Quarters - Institutional Correctional Facilities" and "Group Quarters - Other", although that would require a slightly more complex implementation.
Describe the bug
The 5-year ACS PUMS for 2010 and 2011 have no
[DIS]field to identify disabled persons. This makes the "Group Quarters - Institutional Correctional Facilities" type contain a large segment of elderly persons.To Reproduce
See attached Excel workbook populated by adjusting the
sql/ase/get_region_gq_ase_dist.sqlquery.GQ ASE Distributions.xlsx
Expected behavior
The resulting distributions for 2010 and 2011 should be more in-line with 2012+. Specifically, having over 13% of the "Group Quarters - Institutional Correctional Facilities" type be 85+ is unacceptable.
Potential resolution
Alter the SQL query to use 2012 distributions for regional group quarters. Some thought is given to only using 2012 for the two types effected by this issue, "Group Quarters - Institutional Correctional Facilities" and "Group Quarters - Other", although that would require a slightly more complex implementation.