census-postgres

census-postgres copied to clipboard

License

2

Hello! I'm wondering what kind of license are this data/product attached to? Thank you :)

ethervoid

acs2009_5yr view_stored_by_tables.sql missing JOINS, duplicate views

1

Several census tables (B24121 to B24126) span multiple sequences and the corresponding views created in view_stored_by_tables are missing the relevant JOINs. There are also several hundred views which are duplicated...

potash

acs2009_5yr/insert_into_tables.sql missing alias for temp_seq tables and is creating conflict with the geoheader table

thisisbinod

acs2009_5yr/store_by_tables.sql is missing GeoID for all the tables except for the first one.

thisisbinod

Please add the missing schema.

thisisbinod

WITH ENCODING 'latin1'; missing while improting 2009_5yr geoheader text files.

thisisbinod

The script tries to import the same geoheaders from both group1 and group2 directories and thus creates duplicate records. This is only for 2009_5yr datasets.

thisisbinod

For each of the releases I've had to clean up the `census_table_metadata` with these `UPDATE`s: - `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,...

iandees