[mapguide-users] RE: MySQL Database Feature Source Cordiante
System
Dhirendra Kumar
dhirendra.mgos at gmail.com
Wed May 30 05:48:11 EDT 2007
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#a10870520
Sent from the MapGuide Users mailing list archive at Nabble.com.
More information about the mapguide-users
mailing list