X-Git-Url: http://gitweb.michael.orlitzky.com/?a=blobdiff_plain;f=bin%2Flines2kml;h=bba63b2f59df68e25e71826b502a29fd900bab50;hb=a288d4500730745bdd483c33c02411b9237b4a9f;hp=9a4b6d384264886186cd559a08b8dfda6b535264;hpb=717a5d47751909c5b2e0d9e984c340cb2e50be82;p=dead%2Fcensus-tools.git

diff --git a/bin/lines2kml b/bin/lines2kml
index 9a4b6d3..bba63b2 100755
--- a/bin/lines2kml
+++ b/bin/lines2kml
@@ -72,7 +72,7 @@ if (options.state != None):
     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
@@ -91,7 +91,7 @@ for row in rows:
         # 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])