Skip to content

Instantly share code, notes, and snippets.

@lukerosiak

lukerosiak/gist:5328017

Created April 6, 2013 22:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save lukerosiak/5328017 to your computer and use it in GitHub Desktop.
Save lukerosiak/5328017 to your computer and use it in GitHub Desktop.
Download ZIP
census.ire.org to PostgreSQL
Raw
gistfile1.py
#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