]> gitweb.michael.orlitzky.com - dead/census-tools.git/blobdiff - sql/combine-block-tables.sql
Add a GiST index on blocks.the_geom after we combine the TIGER/SF1 tables.
[dead/census-tools.git] / sql / combine-block-tables.sql
index 3f492068379d93ae855b83da44af53cef3692e9a..a9dccd98dfbfe6156a9db98852ba2df8050f03b7 100644 (file)
@@ -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);