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

Murat Beyhan beyhan at deprem.gov.tr
Fri Mar 2 10:42:15 EST 2012


Chaitanya,

I mean What should I do,
Still could not draw a simple line on the map,
Please how can I overcome this issue. How can I change VRT file.
in order to read data from such table storing data as linestring

regards

murat
On Fri, 2012-03-02 at 21:08 +0530, Chaitanya kumar CH wrote:
> 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
> 
> -- 
> This message has been scanned for viruses and 
> dangerous content by MailScanner, and is 
> believed to be clean.

-- 
Murat BEYHAN
Geophysical Engineer, M.Sc.
Prime Ministry
Disaster and Emergency Management Presidency
Earthquake Department
Address: Eskisehir 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.



More information about the gdal-dev mailing list