SPAM-LOW: Re: [mapguide-users] Draw Polyline using MySQL Databse

[Andy Morsell]

They are saying that they have a number of records with X and Y points and
they need to connect them to form polylines to display in the map.  They are
expecting this to be a functionality of MapGuide.  I don't think they are
using MySQL geometry types like you are, but they probably should be.  In my
opinion they should run some scripts to create a new table or possibly write
a view to create MySQL linestrings from this data and then use the MySQL FDO
provider to render it.


Andy 

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of peter56
Sent: Saturday, June 02, 2007 1:06 PM
To: mapguide-users at lists.osgeo.org
Subject: SPAM-LOW: Re: [mapguide-users] Draw Polyline using MySQL Databse


Hi,

what do you mean with "draw polyline"? I have stored polylines in MySQL as
linestrings. 

Here an example in MySQL:

insert into tra_strasse_text(stratext_geo) Values
(geomfromtext('linestring(x1 1y1,x2 1y2,x3 y3)'));

Using the MySQL FDO, all polylines are shown correct. Is this, what you
mean?

Regards - Peter



Dhirendra Kumar wrote:
> 
> Hi All,
> 
> I establish connection with MySQL for layer creation,  Now i can view 
> all Ponts Successfully on new Layers, But one problem here to draw 
> polyline, because for draw any polyline we need six points  X1, X2, Y1,
Y2, Xn, Yn.
> But during feature source creation time in Autodesk mapguide studio 
> 2007, I can see only three fields  X Column, Y Column and Z column for 
> selection of table Attribute, so how can i draw polyline ?, Please 
> anyone help me, and give me once agian your valuable suggestion. I am 
> waiting for your replay. Thankyou in Advance.
> 
> Regards,
> 
> Dhirendra Kumar
> 

--
View this message in context:
http://www.nabble.com/Draw-Polyline-using-MySQL-Databse-tf3852037s16610.html
#a10930782
Sent from the MapGuide Users mailing list archive at Nabble.com.

_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users