[mapguide-users] RE: RE: MySQL Database Feature
SourceCordianteSystem
Dave Wilson
dave.wilson at autodesk.com
Fri Jun 1 11:19:28 EDT 2007
You Dhirendra you currently can't do polylines via ODBC. You would have
to use MySQL geometry in a table to do that. Then you would need to use
the MySQL Provider. You will have to read MySQL documentation for
examples on creating your table and data inserts.
Regards,
Dave
-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Dhirendra
Kumar
Sent: Friday, June 01, 2007 6:02 AM
To: mapguide-users at lists.osgeo.org
Subject: [mapguide-users] RE: RE: MySQL Database Feature
SourceCordianteSystem
Hi Dave,
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
help
me, and give me once agian your valuable suggestion. I am waiting for
your
replay. Thankyou in Advance.
Regards,
Dhirendra Kumar
Dhirendra Kumar wrote:
>
> Hi Dave,
>
> Thankyou for your quick replay and valuable suggestion. Now i can Make
> layers and view also. Thankyou once again.
>
> Regards,
>
> Dhirendra Kumar
>
>
> Dave Wilson-3 wrote:
>>
>> I reread the email chain and noticed you talked about Points and
>> Longitude and Latitude columns. If that is the case you shouldn't use
>> the MySQL provider, but instead use an ODBC connection. You will need
to
>> install the MySQL ODBC Connector on your server system (it's the ODBC
>> driver for MySQL).
>>
>>
>>
>> You likely don't have any geometry because there are no geometry type
>> columns in your data.
>>
>>
>>
>> Regards,
>>
>> Dave
>>
>>
>>
>> From: mapguide-users-bounces at lists.osgeo.org
>> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Kenneth,
>> GEOGRAF A/S
>> Sent: Wednesday, May 30, 2007 8:11 AM
>> To: MapGuide Users Mail List
>> Subject: Re: [mapguide-users] RE: MySQL Database Feature Source
>> CordianteSystem
>>
>>
>>
>> I think you have a problem with the database schema then.
>>
>> I don't think there is any live support, as this is an open source
>> project.
>>
>> If you want real support, consider purchasing MapGuide Enterprise
from
>> Autodesk.
>> Its basically the same product, but you get access to Autodesk
support.
>>
>>
>>
>>
>>
>> Regards, Kenneth, GEOGRAF A/S
>>
>>
>>
>>
>> Dhirendra Kumar wrote:
>>
>> Hi Kenneth,
>>
>> I am waiting for your replay. Please read my previous message for
>> detail.
>>
>> Regards,
>> Dhirendra Kumar
>>
>>
>> Dhirendra Kumar wrote:
>>
>>
>>
>> Hi Kenneth,
>>
>> As per your suggestion i can view all tables during layer
>> creation but
>> after selection of table lower Geometry combo box is empty not
>> any data in
>> this combo box. Then how will i select "Geometry".In my process
>> any thing
>> wrong ?. Kenneth i want to live chat with any MGOS Expert, Is it
>> possible
>> ?
>>
>> Regards,
>>
>> Dhirendra Kumar
>>
>>
>> Kenneth, GEOGRAF A/S wrote:
>>
>>
>> Oh, my fault. It takes the two coorner coordinates, not
>> a center
>> coordinate.
>>
>> You must enter correct coordinates in the "lower left"
>> and "upper right"
>> boxes.
>> You must also select the correct coordinate system.
>>
>> When you create a new layer, you must select a
>> datasource.
>> After selecting the data source, the names of the tables
>> in the
>> datasource should display in the combo box "Feature
>> class".
>> You can select the desired table here.
>> You can select the column containing the geometry in the
>> combobox
>> "Geometry".
>>
>> Regards, Kenneth, GEOGRAF A/S
>>
>>
>>
>> Dhirendra Kumar wrote:
>>
>>
>> Hi Kenneth,
>>
>> First i want to give you thankyou for your quick
>> replay. Acording to you
>> when i go to create Layer then i can view only
>> Data resource used in
>> this
>> layer field and select saved Datasource name
>> and i save this layer as a
>> same name of Datasource But i am not getting
>> tables name individually
>> and
>> after that i make map using this layer then i
>> can view only Coordinate
>> system option and initial view option for
>> initial Zoom setting option
>> But i
>> am not getting any option for center coordinate.
>> For Information i am
>> using
>> MGOS 1.1.0, MySQL 5.0 and Autodesk mapguide
>> studio 2007.So please help
>> me.
>>
>> Regards,
>> Dhirendra Kumar
>>
>>
>> Kenneth, GEOGRAF A/S wrote:
>>
>>
>>
>> You cannot see the tables on the
>> datasource. That is by design. The
>> tables are considered schema's within
>> the datasource.
>>
>> You should be able to see all the
>> tables, when you are creating the
>> layer.
>>
>> When working with databases, I would
>> recommend not using any
>> non-english
>> charaters, even though the database
>> supports it. Many third-party
>> applications break when they encounter
>> such characters.
>>
>> Did you enter the center coordinate on
>> the map?
>>
>> Try looking at the MapGuide log files.
>> They should be in
>> C:\Program
>> Files\MapGuideOpenSource\Server\Logs
>>
>> There might be a message if something
>> went wrong.
>>
>> Regards, Kenneth, GEOGRAF A/S
>>
>>
>>
>> Dhirendra Kumar wrote:
>>
>>
>>
>> Hi Kenneth,
>>
>> As per your suggestion first i create
>> one datasource (Connection was
>> succesfull) and after that create layer
>> with existing datasource, and
>> also
>> create map and mention cordinate system.
>> But my problem is still same.
>> In
>> MySQL Database one table with 15 fields
>> and i want to create Points on
>> field
>> Longitude and Latitude. Any problem in
>> this field name ? During
>> creation
>> of
>> datasource, not getting any option to
>> select any specific table but
>> when
>> i
>> use join feature then i can view all
>> tables name for join purpose.
>> Help
>> me......
>>
>> Regards,
>> Dhirendra Kumar
>>
>>
>>
>> Kenneth, GEOGRAF A/S wrote:
>>
>>
>>
>>
>> As Dave wrote, you must zoom in to the
>> data.
>> Since you cannot enter coordinates on
>> the layer preview, it will not
>> show.
>>
>> To view data you must:
>>
>> Create a datasource.
>> Create a layer with the datasource.
>> Create a map.
>> Select the coordinate system.
>> Specify the center coordinate manually.
>> Add the layer.
>> Press refresh.
>>
>> If it still won't show, doublecheck the
>> connection on the datasource,
>> and press the "Test connection" button.
>>
>> Regards, Kenneth, GEOGRAF A/S
>>
>>
>>
>> Dhirendra Kumar wrote:
>>
>>
>>
>>
>> Hi Dave,
>>
>> You are right, not any fied in autodesk
>> studio 2007 for mention
>> cordinate
>> system but when i am creating layer
>> using data source, then why
>> Layer
>> is
>> not
>> showing in map preview window of
>> Autodesk studio 2007. Please help
>> me
>> ....... Thankyou in Advance.
>>
>> Regards,
>> Dhirendra Kumar
>>
>>
>> Dave Wilson-3 wrote:
>>
>>
>>
>>
>>
>> As per my previous email unless you have
>> the new MGOS beta there is
>> no
>> field to specify a coordinate system
>> override since currently MySQL
>> doesn't support coordinate systems in
>> the native schema. You can
>> specify
>> the correct coordinate system in your
>> map but you will have to zoom
>> and
>> find the data to set the extent
>> yourself.
>>
>> Regards,
>> Dave
>>
>> -----Original Message-----
>> From:
>> mapguide-users-bounces at lists.osgeo.org
>>
>> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of
>> Dhirendra
>> Kumar
>> Sent: Monday, May 28, 2007 5:07 AM
>> To: mapguide-users at lists.osgeo.org
>> Subject: [mapguide-users] MySQL Database
>> Feature Source Cordiante
>> System
>>
>>
>> Hi All,
>>
>> I have successfully established
>> connection of MySQL 5.0 Database
>> and
>> mapguide 1.1.0 with the help of Autodesk
>> MapGuide Studio 2007 but
>> when
>> creating Layer using this data source
>> then layer is not showing in
>> autodesk
>> Layer Preview window, I think this is
>> happning due to cordinate
>> system,
>> If i
>> am right then where is option of
>> providing cordinate system of
>> MySQL
>> data
>> source ? If i am wrong then please give
>> me idea, How to solve this
>> problem ?
>>
>> Regards,
>> Dhirendra Kumar
>> --
>> View this message in context:
>>
>>
http://www.nabble.com/MySQL-Database-Feature-Source-Cordiante-System-tf3
>> 827380s16610.html#a10834515
>> 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
>>
>>
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>>
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>>
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>>
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>
>
--
View this message in context:
http://www.nabble.com/MySQL-Database-Feature-Source-Cordiante-System-tf3
827380s16610.html#a10911536
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
More information about the mapguide-users
mailing list