[mapguide-users] RE: MySQL Database Feature Source Cordiante
System
Dhirendra Kumar
dhirendra.mgos at gmail.com
Wed May 30 08:19:23 EDT 2007
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
>>
>>
>
>
--
View this message in context: http://www.nabble.com/MySQL-Database-Feature-Source-Cordiante-System-tf3827380s16610.html#a10872539
Sent from the MapGuide Users mailing list archive at Nabble.com.
More information about the mapguide-users
mailing list