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',
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)
doc.children.append(placemark)
-print doc.to_kml()
+doc.print_kml()
conn.close()