[gdal-dev] drawing line using OGR and mysql in mapserver

[Chaitanya kumar CH]

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 <beyhan at 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 <beyhan at 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:beyhan at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20120302/55caaa15/attachment.html