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. _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev