I was talking about the geometry format of the line. You have to decide for yourselves about the efficiency.<br><br><div class="gmail_quote">On Fri, Mar 2, 2012 at 8:57 PM, Murat Beyhan <span dir="ltr"><<a href="mailto:beyhan@deprem.gov.tr">beyhan@deprem.gov.tr</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Chaitanya,<br>
<br>
What do you prefer and which way more fast to draw line and point<br>
because I also draw point about 160000 and I use wkbpoint.<br>
<br>
Any way how to change and What I will change in the vrt.<br>
<br>
could you tell something about it<br>
thanks<br>
<div class="HOEnZb"><div class="h5"><br>
<br>
On Fri, 2012-03-02 at 20:23 +0530, Chaitanya kumar CH wrote:<br>
> Murat,<br>
><br>
> You specified the encoding for GeometryField in the VRT as WKT. OGR<br>
> expects a WKT if you do that. Either change the data or the VRT.<br>
><br>
> On Fri, Mar 2, 2012 at 6:42 PM, Murat Beyhan <<a href="mailto:beyhan@deprem.gov.tr">beyhan@deprem.gov.tr</a>><br>
> wrote:<br>
> I have to say this is not view<br>
> this is a table created.<br>
><br>
> Because I could not declare type of geom field as a string<br>
> than I create<br>
> geometry field column in spatial mysql database..<br>
><br>
><br>
> On Fri, 2012-03-02 at 18:39 +0530, Chaitanya kumar CH wrote:<br>
> > Murat,<br>
> ><br>
> > Can you show a sample output of your view?<br>
> > SELECT * FROM geom;<br>
> ><br>
> > On Fri, Mar 2, 2012 at 6:12 PM, Murat Beyhan<br>
> <<a href="mailto:beyhan@deprem.gov.tr">beyhan@deprem.gov.tr</a>><br>
> > wrote:<br>
> ><br>
> ><br>
> ><br>
> ><br>
> > Dear Chaitanya,<br>
> ><br>
> > I see what you explain first I convert lat lon data<br>
> to string<br>
> > then I<br>
> > concatenate them to string again. But I would like<br>
> to ask<br>
> > I have already add data to mysql table as follows is<br>
> this also<br>
> > correct<br>
> > because when I browse table it seems it store data<br>
> in geometry<br>
> > field<br>
> > but mapserver gives error<br>
> > Unable to identify source field 'fault' for<br>
> geometry.<br>
> > any way<br>
> > I will try to convert data first then I can return<br>
> back you.<br>
> > Regards...<br>
> ><br>
> > ps.<br>
> ><br>
> > ogrinfo<br>
> ><br>
> MYSQL:dynamic,user=root,password=mysql_123,host=localhost,port=3306,tables=geom<br>
> > INFO: Open of<br>
> ><br>
> `MYSQL:dynamic,user=root,password=mysql_123,host=localhost,port=3306,tables=geom'<br>
> > using driver `MySQL' successful.<br>
> > 1: geom (None)<br>
> ><br>
> ><br>
> ><br>
> ><br>
> > it say none in geom<br>
> > may be first I have to do what you say<br>
> > thanks<br>
> > Murat<br>
> ><br>
> ><br>
> ><br>
> > --<br>
> > Best regards,<br>
> > Chaitanya kumar CH.<br>
> ><br>
> > <a href="tel:%2B91-9494447584" value="+919494447584">+91-9494447584</a><br>
> > 17.2416N 80.1426E<br>
> ><br>
><br>
> > --<br>
> > This message has been scanned for viruses and<br>
> > dangerous content by MailScanner, and is<br>
> > believed to be clean.<br>
><br>
><br>
><br>
> Murat BEYHAN<br>
><br>
> Jeofizik Y.Müh.<br>
> T.C. Başbakanlık<br>
> Afet ve Acil Durum Yönetimi Başkanlığı<br>
> Deprem Dairesi Başkanlığı<br>
> Eskişehir Yolu 12. Km.<br>
> Lodumlu/ANKARA<br>
> Tel: 312 2872680-1556<br>
> <a href="mailto:email%3Abeyhan@deprem.gov.tr">email:beyhan@deprem.gov.tr</a><br>
><br>
><br>
><br>
><br>
> --<br>
> This message has been scanned for viruses and<br>
> dangerous content by MailScanner, and is<br>
> believed to be clean.<br>
><br>
><br>
><br>
><br>
><br>
> --<br>
> Best regards,<br>
> Chaitanya kumar CH.<br>
><br>
> <a href="tel:%2B91-9494447584" value="+919494447584">+91-9494447584</a><br>
> 17.2416N 80.1426E<br>
><br>
> --<br>
> This message has been scanned for viruses and<br>
> dangerous content by MailScanner, and is<br>
> believed to be clean.<br>
<br>
<br>
<br>
Murat BEYHAN<br>
<br>
Jeofizik Y.Müh.<br>
T.C. Başbakanlık<br>
Afet ve Acil Durum Yönetimi Başkanlığı<br>
Deprem Dairesi Başkanlığı<br>
Eskişehir Yolu 12. Km.<br>
Lodumlu/ANKARA<br>
Tel: 312 2872680-1556<br>
<a href="mailto:email%3Abeyhan@deprem.gov.tr">email:beyhan@deprem.gov.tr</a><br>
<br>
<br>
<br>
<br>
--<br>
This message has been scanned for viruses and<br>
dangerous content by MailScanner, and is<br>
believed to be clean.<br>
<br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Best regards,<br>Chaitanya kumar CH.<br><br>+91-9494447584<br>17.2416N 80.1426E<br>