Chaitanya,
I was forget to convert lat lon to string as you said before than I was
use BINARY to convert it but I could not converted ı think because still
same problem continuing.
as follows
CREATE OR REPLACE
ALGORITHM = UNDEFINED
VIEW `lineview3` (
eq_id,
geom
) AS
SELECT eq_id,
BINARY CONCAT( 'LINESTRING(', lon1, ' ', lat1, ',', lon2, ' ', lat2,
')' ) AS geom
FROM sfault
Ok, I will tyr cast. By the way I learn more about mysql, too..
thanks
Murat
On Mon, 2012-03-05 at 14:07 +0530, Chaitanya kumar CH wrote:
> Murat,
>
> Perhaps you can use the CAST operator to convert the data type to
> varchar.
>
> On Monday, March 5, 2012, Murat Beyhan <bey...@deprem.gov.tr> wrote:
> > Chaitanya,
> >
> > Thanks for your help, I try to use concat to create view from
> database
> > which is storing start and end of the point of the line
> > as follows.
> >
> >
> > create view lineview6 as select eq_id,
> > CONCAT('LINESTRING(',lon1,'',lat1,',',lon2,'',lat2,')') as geom from
> > sfault
> >
> >
> >
> > but at the previous problem still could not solve
> > as you said geom field should be string but view automatically
> decided
> > the format of the geom column randomly (now is var). then the select
> sql
> > result of the view as follows and mapserver does not draw line.
> >
> >
> > SQL result
> > Host: localhost
> > Database: dynamic
> > Generation Time: Mar 05, 2012 at 09:52 AM
> > Generated by: phpMyAdmin 3.3.10 / MySQL 5.1.55
> > SQL query: SELECT * FROM `lineview6` LIMIT 0, 30 ;Rows: 1
> >
> > eq_id
> > geom
> > 20100308023229
> > LINESTRING(38.7901 40.0811,38.7428
> > 40.0311)
> >
> >
> > and structure of the lineview6 is as follows
> >
> > eq_id varchar(14)
> > geom var(51)
> >
> > please excuse me for this
> >
> > murat
> >
> >
> >
> > On Fri, 2012-03-02 at 21:38 +0530, Chaitanya kumar CH wrote:
> >> 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 <bey...@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
> >> <bey...@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
> >
>
> --
> 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:bey...@deprem.gov.tr
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev
