Skip to content

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

@iandees

Description

@iandees

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%';

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions