[gdal-dev] drawing line using OGR and mysql in mapserver
Chaitanya kumar CH
chaitanya.ch at gmail.com
Fri Mar 2 10:49:29 EST 2012
Modify the table to store the line as a wkt geometry in string format.
On Fri, Mar 2, 2012 at 9:12 PM, Murat Beyhan <beyhan at deprem.gov.tr> wrote:
> 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.
>
>
--
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/5493e5ec/attachment-0001.html
More information about the gdal-dev
mailing list