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

[Chaitanya kumar CH]

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 <beyhan at 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 <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
> >
> > --
> > 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/ce933eff/attachment-0001.html