[mapguide-users] Draw Polyline using MySQL Databse

[Dhirendra Kumar]

Hi peter56,

Thankyou for your Quick replay, You are right, I already done layer creation
of points using X, Y cordinate and connection using ODBC, But i have some
problem in Layer creation of Polyline. For this i have to make Table those
support spatial data,  for that you sent some insert command insert into
tra_strasse_text(stratext_geo) Values (geomfromtext('linestring(x1 1y1,x2
1y2,x3 y3)')); so, pls You Explain only Two part of this Query 
(FIRST) tra_strasse_text(stratext_geo) and 
(SECOND) Values (geomfromtext('linestring(x1 1y1,x2 1y2,x3 y3)').I want to
know from where you are inserting x1 1y1,x2 1y2,x3 y3 Values from any table
or any file ? After inserting data into table you are selecting which field
for make cordinate ? and you are making connection using ODBC? pls send your
table schema.


Regards,
Dhirendra Kumar


peter56 wrote:
> 
> 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#a11005474
Sent from the MapGuide Users mailing list archive at Nabble.com.