X-Git-Url: http://gitweb.michael.orlitzky.com/?a=blobdiff_plain;f=bin%2Fpg2kml;h=81afecaa63bc98a7fbed36739360dfd86b7f4628;hb=7b8cd40d5f84e25422f34e23ed3734053298b5b9;hp=1fddabec07811fc147d8a160db4a9654730f97f5;hpb=63612d67421c5bd193e6b97f4d777742e07fbbba;p=dead%2Fcensus-tools.git

diff --git a/bin/pg2kml b/bin/pg2kml
index 1fddabe..81afeca 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)
@@ -170,6 +170,6 @@ for row in rows:
     
     doc.children.append(placemark)
 
-print doc.to_kml()
+doc.print_kml()
 
 conn.close()