]> gitweb.michael.orlitzky.com - dead/census-tools.git/commit
Added a unique index on the tiger_lines "tlid" column.
authorMichael Orlitzky <michael@orlitzky.com>
Mon, 19 Oct 2009 11:51:40 +0000 (07:51 -0400)
committerMichael Orlitzky <michael@orlitzky.com>
Mon, 19 Oct 2009 11:51:40 +0000 (07:51 -0400)
commit456160ca20e132877327d2a0bf556449a8f84a3a
treee34d6ba0405c6a66942c68174a02138b6c19c7bc
parent730af6c2b7cc3b82a45fe8cdff720c13892316cb
Added a unique index on the tiger_lines "tlid" column.
Created a quick sed script to filter "BEGIN;" and "END;" from the shp2pgsql output.
Updated the makefile to import the tiger_lines data one row at a time, outside of a transaction.
bin/filter-transactions [new file with mode: 0755]
makefile
sql/create_tlid_unique_index.sql [new file with mode: 0644]