[gdal-dev] drawing line using OGR and mysql in mapserver
Murat Beyhan
beyhan at deprem.gov.tr
Fri Mar 2 10:54:34 EST 2012
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.
More information about the gdal-dev
mailing list