Renamed the "tiger" table to "tiger_blocks" in preparation for the addition of the...

[dead/census-tools.git] / bin / pg2kml

diff --git a/bin/pg2kml b/bin/pg2kml
index 1fddabec07811fc147d8a160db4a9654730f97f5..68d5e6fafb27c9a008a26e65dd88089510906fd4 100755 (executable)
--- 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)