At this point I could only advice you to refer to MySQL documentation. http://dev.mysql.com/doc/ http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
On Mon, Mar 5, 2012 at 7:00 PM, Murat Beyhan <bey...@deprem.gov.tr> wrote: > Chaitanya, > I could not succeeded What I have tried. > the problem is I'm not good at mysql. > I think I could not do this job. > I'm really upset. > Are there a different way or easy way to draw line using mysql table > data.. > Regards > > > On Mon, 2012-03-05 at 10:44 +0200, Murat Beyhan wrote: > > Chaitanya, > > > > I was forget to convert lat lon to string as you said before than I was > > use BINARY to convert it but I could not converted ı think because still > > same problem continuing. > > > > as follows > > > > > > CREATE OR REPLACE > > ALGORITHM = UNDEFINED > > VIEW `lineview3` ( > > eq_id, > > geom > > ) AS > > SELECT eq_id, > > BINARY CONCAT( 'LINESTRING(', lon1, ' ', lat1, ',', lon2, ' ', lat2, > > ')' ) AS geom > > FROM sfault > > > > > > Ok, I will tyr cast. By the way I learn more about mysql, too.. > > thanks > > Murat > > > > > > On Mon, 2012-03-05 at 14:07 +0530, Chaitanya kumar CH wrote: > > > Murat, > > > > > > Perhaps you can use the CAST operator to convert the data type to > > > varchar. > > > > > > On Monday, March 5, 2012, Murat Beyhan <bey...@deprem.gov.tr> wrote: > > > > Chaitanya, > > > > > > > > Thanks for your help, I try to use concat to create view from > > > database > > > > which is storing start and end of the point of the line > > > > as follows. > > > > > > > > > > > > create view lineview6 as select eq_id, > > > > CONCAT('LINESTRING(',lon1,'',lat1,',',lon2,'',lat2,')') as geom from > > > > sfault > > > > > > > > > > > > > > > > but at the previous problem still could not solve > > > > as you said geom field should be string but view automatically > > > decided > > > > the format of the geom column randomly (now is var). then the select > > > sql > > > > result of the view as follows and mapserver does not draw line. > > > > > > > > > > > > SQL result > > > > Host: localhost > > > > Database: dynamic > > > > Generation Time: Mar 05, 2012 at 09:52 AM > > > > Generated by: phpMyAdmin 3.3.10 / MySQL 5.1.55 > > > > SQL query: SELECT * FROM `lineview6` LIMIT 0, 30 ;Rows: 1 > > > > > > > > eq_id > > > > geom > > > > 20100308023229 > > > > LINESTRING(38.7901 40.0811,38.7428 > > > > 40.0311) > > > > > > > > > > > > and structure of the lineview6 is as follows > > > > > > > > eq_id varchar(14) > > > > geom var(51) > > > > > > > > please excuse me for this > > > > > > > > murat > > > > > > > > > > > > > > > > On Fri, 2012-03-02 at 21:38 +0530, Chaitanya kumar CH wrote: > > > >> Please refer to my previous posts. > > > >> Modify the SQL select command. Use the CONCAT function instead of > > > the > > > >> + operator to create the wkt. > > > >> > > > >> It should be something like this: CONCAT('LINESTRING(', x1, ' ', > > > y1, > > > >> ',', x2, ' ', y2, ')') > > > >> You may have to change the order of the points. > > > >> > > > >> On Fri, Mar 2, 2012 at 9:24 PM, Murat Beyhan <bey...@deprem.gov.tr> > > > >> wrote: > > > >> Chaitanya, > > > >> > > > >> I store data in table not view as I told you before becasue > > > I > > > >> could not > > > >> declare column as string, then I create a new table and > > > select > > > >> fault(line) column as linestring. in mysql WKT support > > > these > > > >> format > > > >> > > > >> > > > >> * A LineString with four points: > > > >> > > > >> LINESTRING(0 0, 10 10, 20 25, 50 60) > > > >> > > > >> Note that point coordinate pairs are separated by > > > >> commas. > > > >> > > > >> * A Polygon with one exterior ring and one interior > > > ring: > > > >> > > > >> POLYGON((0 0,10 0,10 10,0 10,0 0),(5 5,7 5,7 7,5 7, > > > 5 > > > >> 5)) > > > >> * A MultiPoint with three Point values: > > > >> > > > >> MULTIPOINT(0 0, 20 20, 60 60) > > > >> * A MultiLineString with two LineString values: > > > >> > > > >> MULTILINESTRING((10 10, 20 20), (15 15, 30 15)) > > > >> * A MultiPolygon with two Polygon values: > > > >> > > > >> MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0)),((5 5,7 5,7 > > > >> 7,5 7, 5 5))) > > > >> * A GeometryCollection consisting of two Point values > > > and > > > >> one > > > >> LineString: > > > >> > > > >> GEOMETRYCOLLECTION(POINT(10 10), POINT(30 30), > > > >> LINESTRING(15 15, 20 20)) > > > >> > > > >> > > > >> How to modify wkt geometry in string format > > > >> in map file it is already defined as > > > >> <GeometryType>wkbLineString</GeometryType> > > > >> like this. > > > >> > > > >> I really sorry for giving trouble to you. Thanks > > > >> > > > >> murat > > > >> > > > >> On Fri, 2012-03-02 at 21:19 +0530, Chaitanya kumar CH > > > wrote: > > > >> > Modify the table to store the line as a wkt geometry in > > > >> string format. > > > >> > > > > >> > On Fri, Mar 2, 2012 at 9:12 PM, Murat Beyhan > > > >> <bey...@deprem.gov.tr> > > > >> > wrote: > > > >> > Chaitanya, > > > >> > > > > >> > I mean What should I do, > > > >> > Still could not draw a simple line on the map, > > > >> > Please how can I overcome this issue. How can I > > > >> change VRT > > > >> > file. > > > >> > in order to read data from such table storing > > > data > > > >> as > > > >> > linestring > > > >> > > > > >> > regards > > > >> > > > > >> > murat > > > > > > > > > > -- > > > Best regards, > > > Chaitanya kumar CH. > > > > > > +91-9494447584 > > > 17.2416N 80.1426E > > > > > > -- > > > This message has been scanned for viruses and > > > dangerous content by MailScanner, and is > > > believed to be clean. > > > > > > > > Murat BEYHAN > > > > Jeofizik Y.Müh. > > T.C. Başbakanlık > > Afet ve Acil Durum Yönetimi Başkanlığı > > Deprem Dairesi Başkanlığı > > Eskişehir Yolu 12. Km. > > Lodumlu/ANKARA > > Tel: 312 2872680-1556 > > email:bey...@deprem.gov.tr > > > > > > > > > > > > Murat BEYHAN > > Jeofizik Y.Müh. > T.C. Başbakanlık > Afet ve Acil Durum Yönetimi Başkanlığı > Deprem Dairesi Başkanlığı > Eskişehir Yolu 12. Km. > Lodumlu/ANKARA > Tel: 312 2872680-1556 > email:bey...@deprem.gov.tr > > > > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > > -- Best regards, Chaitanya kumar CH. +91-9494447584 17.2416N 80.1426E
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev