census-postgres icon indicating copy to clipboard operation
census-postgres copied to clipboard

Add docs/code for extra cleanup commands that happen after import

Open iandees opened this issue 12 years ago • 0 comments

For each of the releases I've had to clean up the census_table_metadata with these UPDATEs:

  • update acs2011_5yr.census_table_metadata set table_title=initcap(table_title);
  • update acs2011_5yr.census_table_metadata set table_title=replace(table_title, 'Ct, Me, Ma, Mi, Mn, Nh, Nj, Ny, Pa, Ri, Vt, Wi', 'CT, ME, MA, MI, MN, NH, NJ, NY, PA, RI, VT, WI') WHERE table_id='B08009';
  • update acs2011_5yr.census_table_metadata set table_title=replace(table_title, 'Ssi', 'SSI') WHERE table_title LIKE '%Ssi%';

iandees avatar Jul 31 '13 20:07 iandees