From: Michael Orlitzky <michael@orlitzky.com>
Date: Thu, 15 Apr 2010 01:27:20 +0000 (-0400)
Subject: Add a GiST index on blocks.the_geom after we combine the TIGER/SF1 tables.
X-Git-Url: http://gitweb.michael.orlitzky.com/?p=dead%2Fcensus-tools.git;a=commitdiff_plain;h=4ab0591f5fd8019a0e847a11d1d87b5481f5d28a

Add a GiST index on blocks.the_geom after we combine the TIGER/SF1 tables.
---

diff --git a/sql/combine-block-tables.sql b/sql/combine-block-tables.sql
index 3f49206..a9dccd9 100644
--- a/sql/combine-block-tables.sql
+++ b/sql/combine-block-tables.sql
@@ -19,3 +19,6 @@ INSERT INTO blocks
 
 DROP TABLE sf1_blocks;
 DROP TABLE tiger_blocks;
+
+/* We have to re-create the GiST index on the new table as well. */
+CREATE INDEX idx_geometry_gist ON blocks USING gist(the_geom);