Created
April 6, 2013 22:59
-
-
Save lukerosiak/5328017 to your computer and use it in GitHub Desktop.
census.ire.org to PostgreSQL
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#import all Census 2010 tables into PostgreSQL. Then use BoundaryService to import TIGER shapefiles into PostGIS and join them. | |
import os | |
s = """ire_H1.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H10.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H11.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H11A.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H11B.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H11C.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H11D.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H11E.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H11F.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H11G.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H11H.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H11I.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H12.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H12A.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H12B.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H12C.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H12D.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H12E.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H12F.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H12G.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H12H.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H12I.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H13.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H14.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H15.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H16.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H16A.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H16B.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H16C.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H16D.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H16E.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H16F.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H16G.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H16H.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H16I.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H17.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H17A.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H17B.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H17C.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H17D.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H17E.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H17F.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H17G.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H17H.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H17I.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H18.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H19.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H2.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H20.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H21.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H22.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H3.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H4.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H5.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H6.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H7.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H8.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_H9.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_HCT1.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_HCT2.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_HCT3.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_HCT4.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P1.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P10.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P11.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P12.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P12A.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P12B.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P12C.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P12D.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P12E.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P12F.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P12G.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P12H.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P12I.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P13.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P13A.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P13B.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P13C.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P13D.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P13E.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P13F.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P13G.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P13H.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P13I.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P14.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P15.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P16.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P16A.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P16B.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P16C.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P16D.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P16E.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P16F.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P16G.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P16H.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P16I.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P17.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P17A.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P17B.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P17C.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P17D.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P17E.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P17F.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P17G.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P17H.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P17I.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P18.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P18A.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P18B.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P18C.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P18D.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P18E.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P18F.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P18G.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P18H.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P18I.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P19.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P2.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P20.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P21.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P22.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P23.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P24.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P25.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P26.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P27.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P28.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P28A.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P28B.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P28C.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P28D.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P28E.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P28F.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P28G.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P28H.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P28I.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P29.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P29A.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P29B.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P29C.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P29D.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P29E.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P29F.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P29G.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P29H.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P29I.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P3.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P30.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P31.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P31A.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P31B.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P31C.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P31D.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P31E.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P31F.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P31G.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P31H.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P31I.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P32.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P33.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P34.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P34A.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P34B.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P34C.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P34D.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P34E.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P34F.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P34G.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P34H.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P34I.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P35.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P35A.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P35B.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P35C.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P35D.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P35E.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P35F.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P35G.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P35H.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P35I.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P36.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P36A.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P36B.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P36C.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P36D.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P36E.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P36F.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P36G.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P36H.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P36I.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P37.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P37A.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P37B.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P37C.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P37D.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P37E.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P37F.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P37G.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P37H.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P37I.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P38.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P38A.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P38B.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P38C.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P38D.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P38E.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P38F.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P38G.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P38H.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P38I.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P39.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P39A.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P39B.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P39C.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P39D.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P39E.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P39F.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P39G.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P39H.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P39I.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P4.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P40.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P41.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P42.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P43.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P44.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P45.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P46.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P47.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P48.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P49.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P5.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P50.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P51.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P6.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P7.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P8.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_P9.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCO1.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCO10.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCO2.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCO3.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCO4.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCO5.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCO6.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCO7.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCO8.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCO9.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT1.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT10.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT11.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT12.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT12A.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT12B.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT12C.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT12D.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT12E.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT12F.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT12G.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT12H.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT12I.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT12J.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT12K.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT12L.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT12M.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT12N.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT12O.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT13.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT13A.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT13B.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT13C.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT13D.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT13E.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT13F.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT13G.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT13H.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT13I.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT14.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT14A.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT14B.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT14C.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT14D.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT14E.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT14F.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT14G.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT14H.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT14I.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT15.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT16.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT17.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT18.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT19.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT19A.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT19B.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT19C.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT19D.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT19E.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT19F.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT19G.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT19H.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT19I.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT2.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT20.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT20A.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT20B.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT20C.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT20D.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT20E.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT20F.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT20G.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT20H.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT20I.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT21.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT22.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT22A.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT22B.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT22C.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT22D.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT22E.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT22F.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT22G.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT22H.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT22I.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT3.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT4.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT5.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT6.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT7.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT8.sql a year ago create table DDL for bulkdata export format [JoeGermuska] | |
ire_PCT9.sql a year ago create table DDL for bulkdata export format [JoeGermuska]""" | |
# change this to your default database, or tweak the script to make it a parameter | |
#create this before running: psql create database censusweb | |
database='censusweb' | |
# 040 State | |
# 050 County | |
# 060 County Subdivision | |
# 140 Census Tract | |
# 160 Place | |
#modify sumlev list with these | |
# see also http://census.ire.org/data/bulkdata.html | |
# list of FIPS state codes at http://en.wikipedia.org/wiki/Federal_Information_Processing_Standard_state_code#FIPS_state_codes | |
#modify 'state' list if you don't want all states | |
for line in s.splitlines(): | |
table = line.split('\t')[0][4:-4] | |
os.system('psql -c "drop table if exists ire_%s" %s' % (table.lower(),database)) | |
os.system("curl https://raw.github.com/ireapps/census/master/tools/sql/ire_export/ire_%s.sql | psql %s" % (table,database)) | |
for state in range(1,57): | |
state = "%02d" % state | |
for sumlev in ['140',]: #'040','050','160']: | |
print "%s %s %s" % (table,state,sumlev) | |
os.system("wget -O - http://censusdata.ire.org/%s/all_%s_in_%s.%s.csv | gunzip > /census/ire-sql/bulk/all_%s_in_%s.%s.csv" % (state,sumlev,state,table,sumlev,state,table)) | |
os.system('psql -c "copy ire_%s from \'/census/ire-sql/bulk/all_%s_in_%s.%s.csv\' csv header" %s' % (table.lower(),sumlev,state,table,database)) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment