update_notes/20220219_add_2020_acs_5year.md

In GL-Li/rawcensus2010: Extract Decennial Census and American Community Survey Data

Add 2020 ACS 5-year data to totalcensus

The 2020 ACS 5-year data was released on 3/17/2022.

Download data

Download Sequence Number/Table Number Lookup file in text format

• Download from here
• Save the file to totalcensus/data_raw/acs/ and rename it as ACS_5yr_Seq_Table_Number_Lookup_2020.txt.

Download Appendices file in xls format

• Same download website.
• Save the file to the same directory as ACS_2020_SF_5YR_Appendices.xlsx. The Census Bureau changed the format from xls to xlsx in 2019. In case having trouble reading the file using readxl::read_excel, delete the second sheet.

Create datasets

Try to finish all sections in one R session. If have to restart a R session, rebuild the package to make use of the new dataset.

Create acs file table lookup dataset

• In the block ACS 5 year === in data_raw/acs/create_acs_file_table_lookup.R, add a line of code lookup_acs5year_2020 <- make_acs_lookup(5, 2020) and and run the line of code. A .RData file will be added into totalcensus/data/. After this step, the new data will be usable. You can rebuild the package and use the data.
• Update generate_acs5_tablecontents_() function in R/search_census_and_acs.R and rebuild the package.
• In totalcensus/R/data_acs.R, add documentation for the new dataset lookup_acs5year_2020 following the format in the file.

Create acs table dictionary dataset

• In totalcensus/data_raw/acs/create_acs_table_dictionary.R find the block # acs5 === , change the latest_year to 2020 and run the code of this block.
• Update the documentation for dict_acs5_table in totalcensus/R/data.acs.R by adding one line \item{acs5_2019}{whether the table is available in 2020}.

Create_acs geocomponent dictionary dataset

• In totalcensus/data_raw/acs/create_acs_geocomponent_dictionary.R find the block # acs5year geocomponent ====== and add a line S2020 <- generate_geocomponent("acs5", 2020). Run this line (will take time to download ACS data) and compare S2020 to S2019. As they are the same, no further action is needed for this dataset.
• No documentation update needed.

Create acs summary level dictionary dataset

• In totalcensus/data_raw/acs/create_acs_summary_level_dictionary.R do the same thing as above. The result is the same so no further action needed.

Create acs geoheader dictionary dataset

• The file is totalcensus/data_raw/acs/create_acs_geoheader_dictionary.R. However, first check if the 2020 geoheaders are the same as the 2019 ones. The 2019 geoheaders can be found in the technical documentation (table 2.4 here). Do nothing as they are the same since 2011.

Check the update

Rebuild the package

• Update the DESCRIPTION file:
• Version: 0.6.6
• Date: 2022-03-19
• Restart R and rebuild the package
• Create document
• Check package for cran, fix notes
  • update quiet_gobal_variables_in_cran_check.R
  • note to be solved: installed size is 5.0Mb, sub-directories of 1Mb or more: data 4.6Mb

Run test files under directory 'test/'

• Run "# compare acs5year over years =======" section of test_data_consistency_over_years.R to make sure 2020 data is consistent with other years
• Run test_new_data_on_Rhode_Island.R to make sure no error.

Submit to CRAN

• update README.md
• create source package and submit

GL-Li/rawcensus2010 documentation built on Jan. 19, 2024, 7:11 p.m.