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

[Murat Beyhan]

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.