Describe the bug
The employment module fails when run for years 2010-2012 failing the output check in _validate_jobs_outputs().
To Reproduce
Run the program for 2010-2012. Also, see the sql/employment/get_B24080.sql query for years 2010-2012.
Expected behavior
There is a missing industry code in the final output. All industry codes should be represented. Specifically, the "SE" industry is missing. This is due to no block group level data being present in the [acs] database. See https://github.com/SANDAG/ACS/issues/24.
Potential resolution
We could resolve https://github.com/SANDAG/ACS/issues/24, or just use 2013 in place of 2010-2012, or pivot to the census tract level for 2010-2012. It would probably be best to resolve the issue in the [acs] database since the data does exist just not within the Census API.
Describe the bug
The employment module fails when run for years 2010-2012 failing the output check in
_validate_jobs_outputs().To Reproduce
Run the program for 2010-2012. Also, see the
sql/employment/get_B24080.sqlquery for years 2010-2012.Expected behavior
There is a missing industry code in the final output. All industry codes should be represented. Specifically, the "SE" industry is missing. This is due to no block group level data being present in the
[acs]database. See https://github.com/SANDAG/ACS/issues/24.Potential resolution
We could resolve https://github.com/SANDAG/ACS/issues/24, or just use 2013 in place of 2010-2012, or pivot to the census tract level for 2010-2012. It would probably be best to resolve the issue in the
[acs]database since the data does exist just not within the Census API.