[mapguide-users] Draw Polyline using MySQL Databse

[peter56]

Hi Dhirendra Kumar,

you can find a lot about MySQL Spatial in the documentation. In case of
V.5.0 look here:

http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html

and for V5.1:

http://dev.mysql.com/doc/refman/5.1/en/spatial-extensions.html

For creating layers, I'm using standard MG Studio functions. Here my
workflow:

1. create a connection to the database, using FDO provider for mysql
2. create a new layer based on (1)
3. select a table with spatial data for the new layer
4. select the database row for geometry
5. create a filter to select only a data subset for this layer. Here you can
for example use another row

And now the layer is redy.

I hope it helps? Sorry, I'm only a beginner with MapGuide and (My)SQL.

Regards - Peter



Dhirendra Kumar wrote:
> 
> Hi peter56,
> 
> Thankyou for your quick replay, I have MySQL 5.0 and Autodesk MapGuide
> studio 2007. Is it possible to make polyline Layers using Autodesk
> MapGuide Strudio 2007 ? peter56, I have not detail idea about MySQL
> geometry,Pls Explain this command, insert into
> tra_strasse_text(stratext_geo) Values (geomfromtext('linestring(x1 1y1,x2
> 1y2,x3 y3)'));, So, can you send me your table schema and Detail of how to
> make layers using Autodesk MapGuide studio 2007 ?. From where you get idea
> about this, if possible then send me Resource links also. I am waiting for
> your valuable suggestion. Thnakyou in Advance.
> 
> Regards,
> 
> Dhirendra Kumar
> 
> 
> 
> peter56 wrote:
>> 
>> 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#a11004395
Sent from the MapGuide Users mailing list archive at Nabble.com.