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 > On Fri, 2012-03-02 at 21:08 +0530, Chaitanya kumar CH wrote: > > I was talking about the geometry format of the line. You have to > > decide for yourselves about the efficiency. > > > > On Fri, Mar 2, 2012 at 8:57 PM, Murat Beyhan <bey...@deprem.gov.tr> > > wrote: > > Chaitanya, > > > > What do you prefer and which way more fast to draw line and > > point > > because I also draw point about 160000 and I use wkbpoint. > > > > Any way how to change and What I will change in the vrt. > > > > could you tell something about it > > thanks > > > > > > On Fri, 2012-03-02 at 20:23 +0530, Chaitanya kumar CH wrote: > > > Murat, > > > > > > You specified the encoding for GeometryField in the VRT as > > WKT. OGR > > > expects a WKT if you do that. Either change the data or the > > VRT. > > > > > > On Fri, Mar 2, 2012 at 6:42 PM, Murat Beyhan > > <bey...@deprem.gov.tr> > > > wrote: > > > I have to say this is not view > > > this is a table created. > > > > > > Because I could not declare type of geom field as a > > string > > > than I create > > > geometry field column in spatial mysql database.. > > > > > > > > > On Fri, 2012-03-02 at 18:39 +0530, Chaitanya kumar > > CH wrote: > > > > Murat, > > > > > > > > Can you show a sample output of your view? > > > > SELECT * FROM geom; > > > > > > > > On Fri, Mar 2, 2012 at 6:12 PM, Murat Beyhan > > > <bey...@deprem.gov.tr> > > > > wrote: > > > > > > > > > > > > > > > > > > > > Dear Chaitanya, > > > > > > > > I see what you explain first I convert lat > > lon data > > > to string > > > > then I > > > > concatenate them to string again. But I > > would like > > > to ask > > > > I have already add data to mysql table as > > follows is > > > this also > > > > correct > > > > because when I browse table it seems it > > store data > > > in geometry > > > > field > > > > but mapserver gives error > > > > Unable to identify source field 'fault' > > for > > > geometry. > > > > any way > > > > I will try to convert data first then I > > can return > > > back you. > > > > Regards... > > > > > > > > ps. > > > > > > > > ogrinfo > > > > > > > > > > MYSQL:dynamic,user=root,password=mysql_123,host=localhost,port=3306,tables=geom > > > > INFO: Open of > > > > > > > > > > `MYSQL:dynamic,user=root,password=mysql_123,host=localhost,port=3306,tables=geom' > > > > using driver `MySQL' successful. > > > > 1: geom (None) > > > > > > > > > > > > > > > > > > > > it say none in geom > > > > may be first I have to do what you say > > > > thanks > > > > 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 > > > > > > > > > > > > > > > -- > > > 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 > > > > > > -- > > > 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 > > > > > > > > > > -- > > 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 > > > > -- > > This message has been scanned for viruses and > > dangerous content by MailScanner, and is > > believed to be clean. > > -- > Murat BEYHAN > Geophysical Engineer, M.Sc. > Prime Ministry > Disaster and Emergency Management Presidency > Earthquake Department > Address: Eskisehir 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