[gdal-dev] drawing line using OGR and mysql in mapserver
Chaitanya kumar CH
chaitanya.ch at gmail.com
Fri Mar 2 11:08:14 EST 2012
Please refer to my previous posts.
Modify the SQL select command. Use the CONCAT function instead of the +
operator to create the wkt.
It should be something like this: CONCAT('LINESTRING(', x1, ' ', y1, ',',
x2, ' ', y2, ')')
You may have to change the order of the points.
On Fri, Mar 2, 2012 at 9:24 PM, Murat Beyhan <beyhan at deprem.gov.tr> wrote:
> Chaitanya,
>
> I store data in table not view as I told you before becasue I could not
> declare column as string, then I create a new table and select
> fault(line) column as linestring. in mysql WKT support these format
>
>
> * A LineString with four points:
>
> LINESTRING(0 0, 10 10, 20 25, 50 60)
>
> Note that point coordinate pairs are separated by commas.
>
> * A Polygon with one exterior ring and one interior ring:
>
> POLYGON((0 0,10 0,10 10,0 10,0 0),(5 5,7 5,7 7,5 7, 5 5))
> * A MultiPoint with three Point values:
>
> MULTIPOINT(0 0, 20 20, 60 60)
> * A MultiLineString with two LineString values:
>
> MULTILINESTRING((10 10, 20 20), (15 15, 30 15))
> * A MultiPolygon with two Polygon values:
>
> MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0)),((5 5,7 5,7 7,5 7, 5 5)))
> * A GeometryCollection consisting of two Point values and one
> LineString:
>
> GEOMETRYCOLLECTION(POINT(10 10), POINT(30 30), LINESTRING(15 15, 20
> 20))
>
>
> How to modify wkt geometry in string format
> in map file it is already defined as
> <GeometryType>wkbLineString</GeometryType>
> like this.
>
> I really sorry for giving trouble to you. Thanks
>
> murat
>
> On Fri, 2012-03-02 at 21:19 +0530, Chaitanya kumar CH wrote:
> > 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
> >
> > --
> > 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/22a23691/attachment-0001.html
More information about the gdal-dev
mailing list