Ecosyste.ms: OpenCollective

An open API service for software projects hosted on Open Collective.

github.com/censusreporter/census-postgres-scripts

Scripts used to set up census-postgres on an Amazon EC2 instance.
https://github.com/censusreporter/census-postgres-scripts

Add status comments

c050731283cd729b02357f24ed4061d6b444581f authored over 11 years ago by Ian Dees <[email protected]>
Add psql result checks before continuing on.

0314e6de298b5614c0b02341655cabaab0306401 authored over 11 years ago by Ian Dees <[email protected]>
Try to error out of the build process sooner.

c51d01475b0dbbca34325cfa667d6276f98818b3 authored over 11 years ago by Ian Dees <[email protected]>
Cascade the schema drop.

b75e14a2816c9ee1302bf5ce590a55de804e4256 authored over 11 years ago by Ian Dees <[email protected]>
Cleanup after making the prebuilt postgres SQL more specific.

d242c4c15ca446148758dbbc1a64601e77018d5b authored over 11 years ago by Ian Dees <[email protected]>
Download the lookup tables for 5 year releases.

0de685d292e281761190539371ee63f5884f6e50 authored over 11 years ago by Ian Dees <[email protected]>
Adding the 2011 1yr sqn lookup txt

fb1c007d6742f15fc419023c11e004524225ad3e authored over 11 years ago by Ian Dees <[email protected]>
Fix the URL to 2009 3yr's sqn lookup

2329c64c94da03c6a957a2ab24e35f040b0e65aa authored over 11 years ago by Ian Dees <[email protected]>
Ignore the 'island' states in the census_names view.

3ba05666aa8acdc77672e330c33057954166e38f authored over 11 years ago by Ian Dees <[email protected]>
Hard-code a nation-wide sumlevel for the tiger autocomplete view.

39b0294c9adca3d42ce3a6ef7ee3125832fcbc39 authored over 11 years ago by Ian Dees <[email protected]>
Add geoid indexes to tiger tables.

9685652f602d36e5ffae9336af02827b7c5578c2 authored over 11 years ago by Ian Dees <[email protected]>
Add intpt to the TIGER views.

cc7898d43f507c7456f6cab066523809dde64fe4 authored over 11 years ago by Ian Dees <[email protected]>
Add postgis to the PostgreSQL setup script.

8cb367f31f26278493fb8935b461d9cdd99c0575 authored over 11 years ago by Ian Dees <[email protected]>
Create a census role in pg and another view for simple tiger names.

2a2e9650256a5a05a9fff96db6bbe1ebeb9f9ca1 authored over 11 years ago by Ian Dees <[email protected]>
Make sure we download the geoheader stuff for 2007 ACSs.

2f984feb5b8c21769fac9c4444f7b409275d0228 authored over 11 years ago by Ian Dees <[email protected]>
Don't try to use my drop scripts because they're already there.

17e6cf580d8771cade4449b0fdce0644d0a10997 authored over 11 years ago by Ian Dees <[email protected]>
Add name indexes for prefix searching. Also a view for all of TIGER shapes.

ddd9adc31f974391c1e318b599ef6b235f36884b authored over 11 years ago by Ian Dees <[email protected]>
Swap the -n unzip argument.

8017d209bbce08321c955e93f12dc0597e8864d9 authored over 11 years ago by Ian Dees <[email protected]>
Always overwrite during unzip and don't rm source files.

fb90fc376ecac6980cdbaf585f3aabf03d9fe10e authored over 11 years ago by Ian Dees <[email protected]>
Modify the scripts to import more TIGER data.

9ed2794ca5d049f5cce7093efc1a5cc6e983f66c authored over 11 years ago by Ian Dees <[email protected]>
Change owner on the tiger2012 schema.

bf95f35bf8488aed3a6898b44152b7904a228987 authored over 11 years ago by Ian Dees <[email protected]>
Don't add the spatial index for every shapefile.

b9e24cac5ad7d413477a4b64272ca9cd75bc894d authored over 11 years ago by Ian Dees <[email protected]>
Use separate for loop for the append operation.

16a7c5a6e748c790bacd6a412dc818e35abb8fee authored over 11 years ago by Ian Dees <[email protected]>
Try to pull apart the shapefile prepare.

878c892233ddc0b7faff99cc6f180af50411d270 authored over 11 years ago by Ian Dees <[email protected]>
Quiet down the psql output.

fe3897eb2437186437353046b51e9f7f461cddd8 authored over 11 years ago by Ian Dees <[email protected]>
Die if the import was unsuccessful.

7116b48f88489dd72200db676ed12556672592fc authored over 11 years ago by Ian Dees <[email protected]>
Delete the sql along the way.

3cdc560ec61a13471efd75f4d601aefe0b46f456 authored over 11 years ago by Ian Dees <[email protected]>
Pick the right directory for tiger2012 stuff.

5c3476b85b2d621623a9b39692ded93d7c3b0935 authored over 11 years ago by Ian Dees <[email protected]>
Mark the postgis stuff +x.

78effc5164a55fb7fbd6b31733f0fa773e54fa54 authored over 11 years ago by Ian Dees <[email protected]>
Create 13_import_tiger_2012.sh

b1f64accf8d1a952ff4f5653529808a659404125 authored over 11 years ago by Ian Dees <[email protected]>
Script PostGIS setup.

8158b856d06f75ab63e80439abfab29a540735a3 authored over 11 years ago by Ian Dees <[email protected]>
Rename to be consistent.

4d81e76d4dc72dac7fae1098ea445c2c9dbbc831 authored over 11 years ago by Ian Dees <[email protected]>
Forgot to include county shapefiles.

36b9932b5bd857b1d24dff8a46089abbad77916d authored over 11 years ago by Ian Dees <[email protected]>
Create 10_download_tiger_2012.sh

11312422984932944314981a85f9d947a3bf9640 authored over 11 years ago by Ian Dees <[email protected]>
Use the drop import tables script instead of some shell script.

78e5598e1916bd35e20b90b225492e56b09caf63 authored over 11 years ago by Ian Dees <[email protected]>
The 2007 3yr zipfiles unpack in a weird directory.

c86b5dc079d0c9576fb88e279bf65cb6e6faddc7 authored over 11 years ago by Ian Dees <[email protected]>
Fix unpacking of the 2007 download scripts.

3cda21327e3faa1e40d486d0d84a4446485bb5b1 authored over 11 years ago by Ian Dees <[email protected]>
Add 2008 1 and 3 year import scripts.

0d9d81a4b5edfc5cf6288f8cb8a938c584253ed5 authored over 11 years ago by Ian Dees <[email protected]>
Add 2007 1 and 3 year scripts.

4e6001b6a5904e5cfc6ae32af82f98ae1a4ded84 authored over 11 years ago by Ian Dees <[email protected]>
Typo in the path of the 2008 3yr.

ffbddd1706f19c2780b85e246b3af99476aa2f9c authored over 11 years ago by Ian Dees <[email protected]>
Unzip the downloaded 2008 files correctly.

3f32c774ce004e71363679ec39c6022749a67938 authored over 11 years ago by Ian Dees <[email protected]>
Add download scripts for 2008 one and three years.

382265aa2f489e3206d605151ecb417cfdb6e4ef authored over 11 years ago by Ian Dees <[email protected]>
Use drop sql instead of a shell script.

559a6eca8839a7b6062b603e7a067f16eafcd0cd authored over 11 years ago by Ian Dees <[email protected]>
Add ACS 2009 import scripts.

2fb5d35911ef63569cd04cfbba91230a8c65bb06 authored over 11 years ago by Ian Dees <[email protected]>
Fix the 2009 1 and 3 year download scripts.

efbdad64cd067e7a6f3f0816dd1d0e671ddb60a3 authored over 11 years ago by Ian Dees <[email protected]>
Fix unzipping for the 2009 5yr.

2c05f1cae2334c48ab4e44e9fa1a596f675cb01d authored over 11 years ago by Ian Dees <[email protected]>
Add 2009 download scripts.

ad4163357a715f398f771eec33435451df5d25a5 authored over 11 years ago by Ian Dees <[email protected]>
Add 3yr import scripts.

e1c6e2835834e4b2b850346c919e636ae7742cee authored over 11 years ago by Ian Dees <[email protected]>
Add 3yr download scripts.

ce688a642684887cdf234b8b741212c9b11bdc8a authored over 11 years ago by Ian Dees <[email protected]>
Add 2011 1yr import script and fix drops for 2010.

ba8ebead2ae0bdb5722d594259a8cb9294df4edf authored over 11 years ago by Ian Dees <[email protected]>
Removing some files that aren't created anymore.

8d8eb2b7b7e92bbc146618a5c061dd3d170c241a authored over 11 years ago by Ian Dees <[email protected]>
Create 03_import_acs_2010_1yr.sh

57488d53a68afa19e85a13d2a371e6476b64abc8 authored over 11 years ago by Ian Dees <[email protected]>
Add download steps for 1 and 3yr ACS.

8c88477d5c74be4b4a63b5d14cde3a04c3ce4892 authored over 11 years ago by Ian Dees <[email protected]>
Return to the correct dir to complete tmp cleanup.

3ef325c3abb79d299413a5c48743d813829ce8a7 authored over 11 years ago by Ian Dees <[email protected]>
Missing some tmp tables for the 2010 5yr cleanup.

720df05828deb5f39ca82ab7475c7fb19a114e7b authored over 11 years ago by Ian Dees <[email protected]>
Need to store MOE tables too.

746ef224c997074d46b6c243b55f63c2748321f0 authored over 11 years ago by Ian Dees <[email protected]>
Run some 2010 sql.

9c376e248cd6c57b6def59c3d6c03cc43dcf61b3 authored over 11 years ago by Ian Dees <[email protected]>
Pull the group* dirs back up where they should be.

394ea3ca0a7d134c230eab262f681f7b263046cb authored over 11 years ago by Ian Dees <[email protected]>
Unzipping 2010 puts the files inside a deep dir structure.

8cf5df1d4af455c823a0386baf6a1d449aedebf0 authored over 11 years ago by Ian Dees <[email protected]>
Just kidding. The file extension on Census' site is wrong.

ce080e09d53bb5b075eee2b5adab82f11dc12950 authored over 11 years ago by Ian Dees <[email protected]>
All 3 2010 5yrs are .zip, not .tgz

ea812076df06c72a90bfe2888eeeaaeb11691718 authored over 11 years ago by Ian Dees <[email protected]>
Check if the script is root before running.

593375a242818574d9c2825e0a1ededa6b37e1e0 authored over 11 years ago by Ian Dees <[email protected]>
Fixes for download URLs.

88c7496596f61432303af48f3c16ddaf509e8cc2 authored over 11 years ago by Ian Dees <[email protected]>
Same for the data-specific years.

d48f0da07a46ea817e25b61307b57b5e81689071 authored over 11 years ago by Ian Dees <[email protected]>
Optionally create the tmp dir in case it's already there.

2e4e56ea2af4f1f3aaaec53143b449c5a81587e7 authored over 11 years ago by Ian Dees <[email protected]>
Read from dataset-specific directories.

9e2c7fb1d48c7be05034586c08eb3a8a086d1122 authored over 11 years ago by Ian Dees <[email protected]>
Add ACS 2010 5yr version of the steps.

77a7eb3e4d09d17c52871b2e9a0f1aefbf04c2f7 authored over 11 years ago by Ian Dees <[email protected]>
Add a readme.

2abb850ac24ec5645905c5b9e672262fedfff2fa authored over 11 years ago by Ian Dees <[email protected]>
Make all the scripts +x.

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

e82a4e44aa103ae257f9391bf67cef8ba37708de authored almost 12 years ago by Ian Dees <[email protected]>

538bbfc024aaa1615a19075bc46600c5159f5ba9 authored almost 12 years ago by Ian Dees <[email protected]>

56575286390813e6a382619efa363ac0d50b823f authored almost 12 years ago by Ian Dees <[email protected]>

c1ff681a70035ff7f66654fa49afa106ceac0674 authored almost 12 years ago by Ian Dees <[email protected]>

4a742429820298cb0dec0e1a49934244c3633567 authored almost 12 years ago by Ian Dees <[email protected]>