census-postgres-scripts
census-postgres-scripts copied to clipboard
censusreporter
Scripts used to set up census-postgres on an Amazon EC2 instance.
the data from census are actually in 4269 I think you could reproject and make valid in one step: psql -d census -U census -v ON_ERROR_STOP=1 -q -c "ALTER TABLE...
Is this incorrect / not updated? I'm assuming this may throw an error if 2016 ACS is not downloaded. https://github.com/censusreporter/census-postgres-scripts/blob/6f64337261e82e941a2713ea5b1aa87c184a033f/13_index_tiger_2017.sql#L63
This is also somewhat crossposted from the following: https://github.com/aria2/aria2/issues/973. It seems as if wget, curl, and aria2 are forbidden. The .gz extension is also now missing. Any known workarounds to...
there seems to be some path issue, when I run I get: ``` unzip: cannot find or open All_Geographies_Not_Tracts_Block_Groups.zip, All_Geographies_Not_Tracts_Block_Groups.zip.zip or All_Geographies_Not_Tracts_Block_Groups.zip.ZIP. unzip: cannot find or open *_All_Geographies_Not_Tracts_Block_Groups.zip, *_All_Geographies_Not_Tracts_Block_Groups.zip.zip or...
After unzipping the 2009_5yr manually, it turns out a file in the geoheader has an incorrect encoding: (I also removed the -q flag to see where it failed for importing...
The census website does not seem to have the all_ACSSF.zip file for 2008 1 yr. http://www2.census.gov/acs2008_1yr/summaryfile/ ``` 11/14 18:39:34 [ERROR] CUID#6 - Download aborted. URI=http://www2.census.gov/acs2008_1yr/summaryfile/all_ACSSF.zip Exception: [AbstractCommand.cc:312] errorCode=22 URI=http://www2.census.gov/acs2008_1yr/summaryfile/all_ACSSF.zip ->...
Something about the load process led to the `acs2017_1yr.census_table_metadata` being off in a few cases. Specifically, the value for `denominator_column_id` was incorrectly set. This column is used to indicate when...
I added a chunk of script at the bottom of the two table-based downloader files to strip out the specified "jam values" from data files, so that we don't inadvertently...
Metadata
Owner
Metadata
Scripts used to set up census-postgres on an Amazon EC2 instance.