X-Git-Url: http://gitweb.michael.orlitzky.com/?a=blobdiff_plain;f=sql%2Fcombine-block-tables.sql;fp=sql%2Fcombine-block-tables.sql;h=3f492068379d93ae855b83da44af53cef3692e9a;hb=348d73e051e750a1d750388aeba681074c1cc5e6;hp=0000000000000000000000000000000000000000;hpb=eb51c39a919ac83319a6ced262051e6f8b0f00c4;p=dead%2Fcensus-tools.git

diff --git a/sql/combine-block-tables.sql b/sql/combine-block-tables.sql
new file mode 100644
index 0000000..3f49206
--- /dev/null
+++ b/sql/combine-block-tables.sql
@@ -0,0 +1,21 @@
+/*
+  Combine the sf1_blocks and tiger_blocks tables into one
+  comprehensive "blocks" table. Once we're done, we drop
+  sf1_blocks and tiger_blocks.
+*/
+INSERT INTO blocks
+       (SELECT sf1_blocks.id,
+	       sf1_blocks.state,
+       	       sf1_blocks.county,
+	       sf1_blocks.tract,
+	       sf1_blocks.block,
+	       sf1_blocks.blkidfp00,
+	       sf1_blocks.pop100,
+	       sf1_blocks.total_area,
+	       sf1_blocks.population_density,
+	       tiger_blocks.the_geom
+	FROM sf1_blocks INNER JOIN tiger_blocks
+	     		ON sf1_blocks.blkidfp00 = tiger_blocks.blkidfp00);
+
+DROP TABLE sf1_blocks;
+DROP TABLE tiger_blocks;