census-postgres
census-postgres copied to clipboard
Add docs/code for extra cleanup commands that happen after import
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%';