statefp = "'%s'" % options.state
lines_query = """
-SELECT gid, tlid, fullname, the_geom
+SELECT gid, tlid, fullname, ST_AsKml(the_geom)
FROM tiger_lines
WHERE statefp=%s
""" % statefp
# Some streets don't have a fullname.
fullname = 'Unknown'
- name = KML.Name(fullname + '(' + str(row[1]) + ')')
+ name = KML.Name(fullname + ' (' + str(row[1]) + ')')
placemark.children.append(name)
geometry = KML.RawText(row[3])