github.com/censusreporter/census-postgres commits

Fix the _moe view to include the _moe columns.

a64da362476ab1f8c47b381ebb636658564e4eda authored over 11 years ago by Ian Dees <[email protected]>

Use the correct sqn column name and write out at the correct time.

122a99424f6d7c51fe7a12024d9fa8c1dba9d35c authored over 11 years ago by Ian Dees <[email protected]>

Import the fixed-width .txt g* files instead of .csv.

1ec5d25302f31b82f0543ae2093b4e44aaf431f3 authored over 11 years ago by Ian Dees <[email protected]>

Initial try at the 2010 1-yr ACS.

923fdab943ac972063a67c07c69325ac5dcf46b0 authored over 11 years ago by Ian Dees <[email protected]>

Oops, flipped these two dirs around.

328de98dc5bda1ad8cd3cbd96591dd38f5305dad authored over 11 years ago by Ian Dees <[email protected]>

Push the config stuff into each module.

66e4424912ef3568bddcfe26df16ddb3a47dca5a authored over 11 years ago by Ian Dees <[email protected]>

Forgot to modularize the tmp_sequence COPY builder.

2695f04321f35c1b6e2fded62c4b98ebd7128525 authored over 11 years ago by Ian Dees <[email protected]>

Try to handle metadata column names changing between ACS releases.

739d2f611f6bcf933427a378ff14d0f9640b930a authored over 11 years ago by Ian Dees <[email protected]>

Fix acs_dir example.

c2f9ed074f128e9df02550371add81e133fc3fe7 authored over 11 years ago by Ian Dees <[email protected]>

Refactor the scripts a bit so they can be run all at once.

f4d0bdee1af726d643cb1dbb1e1afc9cc2daf4a1 authored over 11 years ago by Ian Dees <[email protected]>

Use itertools across the board.

8c00038d968d46870bea4e3133cf0542ac1fbac3 authored over 11 years ago by Ian Dees <[email protected]>

Try to use itertools to make the code a bit easier to read.

82c7ea0baf94c1a5ca1395629f02fe0c884dd197 authored over 11 years ago by Ian Dees <[email protected]>

Fix the name of the output file.

7f92f7dc36841bfb4119f70215396f83ed680e02 authored over 11 years ago by Ian Dees <[email protected]>

Add a views SQL builder script.

036f1cb7d820c6b9efc441455ea7a3c665df3c08 authored over 11 years ago by Ian Dees <[email protected]>

Add a script that generates the create table for the real data.

67bd971ffd5f73edd17140cf3b8688857c608c67 authored over 11 years ago by Ian Dees <[email protected]>

Add build_sequence_import script.

75a3b75a2bc10e7e0e7ebbd23ba922fe991e8d08 authored over 11 years ago by Ian Dees <[email protected]>

Remove unused imports.

602ef431ccf294c4406127bb440faab38ae3298f authored over 11 years ago by Ian Dees <[email protected]>

Use the correct index for the sequence number in the file name.

9570733a62fa2061cd7dcb4974bd088ba62d284b authored over 11 years ago by Ian Dees <[email protected]>

Sort the files before writing them out.

350ef1a6268335d1df73eb4cae11b4f363ebb5c8 authored over 11 years ago by Ian Dees <[email protected]>

Those .txt files are actually CSVs. Tricky.

bb51259f2aa496496473f7456d22e2f32cbf5bec authored over 11 years ago by Ian Dees <[email protected]>

First pass at a import tmp_seq generator.

6c065a99ed5b7781e6ba5e61adc74cd258f8d1e9 authored over 11 years ago by Ian Dees <[email protected]>

My quick hack didn't do what I wanted it to do.

f55da7ce902f45e4f0d22a20c2d14adb7b68fc6c authored over 11 years ago by Ian Dees <[email protected]>

Include the _moe tmp tables.

2b1cb4aabad4d6c02081165fd4cb30aba50f7156 authored over 11 years ago by Ian Dees <[email protected]>

Clean up and DRY-ify the tmp_seq python script.

e437b2ab37b196b83ff0d842f0133db24109f554 authored over 11 years ago by Ian Dees <[email protected]>

Update and rename build_ to build_tmp_sequence_sql.py

11dc421fcede59a994fb37d10c82f050409d5b1c authored over 11 years ago by Ian Dees <[email protected]>

Create build_

1570d05728af02b8780a6f9dfe48662ad49887e0 authored over 11 years ago by Ian Dees <[email protected]>

Initial geoheader import script.

6f3da94493cbaad76f4adcf5dca03ac650cb4498 authored over 11 years ago by Ian Dees <[email protected]>

Replaced idiosyncratic filepath with <census_upload_root> placeholder for ACS 2011; added README.md to ACS 2011 folder

25440faadaf6f5c2332286f6e645516f0ad8f115 authored almost 12 years ago by Lee Hachadoorian <[email protected]>

Added import scripts for ACS 2011 5-year data product

efe2d66f248aedb42f8e77f6058ea1b0136aeeb5 authored almost 12 years ago by Lee Hachadoorian <[email protected]>

Simplified main README, moved instructions on use of meta-scripts to the meta-scripts folder

8ec34ea38803a2bf9e7d9920a290115c060ff106 authored almost 12 years ago by Lee Hachadoorian <[email protected]>

Adding ACS 2011 support files, change to meta-script to support ACS 2011

bb9067be3ecba1064315e6c2d9bdd4f7d8eff516 authored almost 12 years ago by Lee Hachadoorian <[email protected]>

Added state-specific import scripts to acs2010_5yr; Cleanup of deleted files

4dacdb63e8a3ba905f7a57a8f5fdf0f5e84f1429 authored over 12 years ago by unknown <[email protected]>

Added scripts for ACS 2010 Selected Population Tables

9a0712009ebe07a72de16fd785506529b17b600d authored over 12 years ago by unknown <[email protected]>

Replaced overloaded functions with functions using DEFAULT values for input parameters.

4b4e6db51e9b22c763e4b63dba8e21aa6de67c2e authored over 12 years ago by Lee Hachadoorian <[email protected]>

Added data functions (meta-scripts), significantly modifed README

9a1906e40fe0b2659a998cc112a94cff6cc5bc9c authored over 12 years ago by Lee Hachadoorian <[email protected]>

Added .md to README filename

0d7557614f51bd4cbe195e4a71ef43231366ad16 authored over 12 years ago by Lee Hachadoorian <[email protected]>

Updated README

4cc6633c19126ce2a11e09bb4aaf3a3a0f77ae78 authored over 12 years ago by Lee Hachadoorian <[email protected]>

Initial commit

fb0fb9dcf01fa1de8583cae4c1ee6c7749def3ab authored over 12 years ago by Lee Hachadoorian <[email protected]>

Ecosyste.ms: OpenCollective

github.com/censusreporter/census-postgres