From 5a969daed7f14f10a3a80b823be5a108696399b7 Mon Sep 17 00:00:00 2001 From: Michael Orlitzky Date: Wed, 21 Oct 2009 01:42:16 -0400 Subject: [PATCH] Added a space between the road name and its tlid. Fixed the query to actually return KML. --- bin/lines2kml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) 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]) -- 2.43.2