| 6/9/2009 2:27:44 PM | Ruchika | --Select AddGeometryColumn ('schema','bus_stop','the_geom',4326,'LINESTRING',2);
update "schema".bus_stop
set the_geom = GeomFromText('LINESTRING(' ||"Stop_Lon" || ' ' || "Stop_Lat" || ' ' || "Stop_Id" || '' || "Zone_Id" || ')',4326)
it gives me error geometry requires more point.I have a table bus_stop( "Stop_Id" integer NOT NULL,
"Stop_Name" character varying(50),
"Stop_Desc" character varying(50),
"Stop_Lat" double precision,
"Stop_Lon" double precision,
"Zone_Id" integer,
the_geom geometry) what can be the solution for this prob?I want the geom in linestring to draw the curves. |
