X-Git-Url: http://gitweb.michael.orlitzky.com/?a=blobdiff_plain;f=bin%2Fpg2kml;h=81afecaa63bc98a7fbed36739360dfd86b7f4628;hb=a288d4500730745bdd483c33c02411b9237b4a9f;hp=084abccd993624941aeb73cbe0c7a8195bc90577;hpb=68801d56ace446b73e8a382ef122afcf98333003;p=dead%2Fcensus-tools.git

diff --git a/bin/pg2kml b/bin/pg2kml
index 084abcc..81afeca 100755
--- a/bin/pg2kml
+++ b/bin/pg2kml
@@ -33,7 +33,7 @@ to stdout.
 parser = OptionParser(add_help_option = False)
 
 # Use this module's docstring as the description.
-parser.description = __doc__
+parser.description = __doc__.strip()
 
 parser.add_option('-h',
                   '--host',
@@ -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()