Added the Delaware lines to the download_data script.

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

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