X-Git-Url: http://gitweb.michael.orlitzky.com/?a=blobdiff_plain;f=bin%2Fpg2kml;h=68d5e6fafb27c9a008a26e65dd88089510906fd4;hb=0e8428f00f565a3e1791e19098ab59442972fa09;hp=1fddabec07811fc147d8a160db4a9654730f97f5;hpb=d6aa9f176f67ee918f854c1df3ec5b072a502288;p=dead%2Fcensus-tools.git

diff --git a/bin/pg2kml b/bin/pg2kml
index 1fddabe..68d5e6f 100755
--- a/bin/pg2kml
+++ b/bin/pg2kml
@@ -128,9 +128,9 @@ for style in red_styles:
 
 
 query = """
-SELECT tiger.blkidfp00, population_density, AsKML(the_geom) as geom
-       FROM (sf1_blocks INNER JOIN tiger
-             ON sf1_blocks.tiger_blkidfp00=tiger.blkidfp00);
+SELECT tiger_blocks.blkidfp00, population_density, AsKML(the_geom) as geom
+       FROM (sf1_blocks INNER JOIN tiger_blocks
+             ON sf1_blocks.blkidfp00 = tiger_blocks.blkidfp00);
 """
 
 cursor.execute(query)