[mapguide-users] RE: RE: About FDO

Fri May 25 09:05:10 EDT 2007

Hi Andy Morsell,

I could not create layer using  MySQL Database, because i not get sufficent
material from your given link to create Layer. So, after testing Connection
with MySQL what should i do ?. In MySQL Connection window all options for
only Making Connection and Joining feature sources But not any option for
Making Layer using this connection. If any other method for Layer creation
then please Help me. Thankyou in Advance.

Thankyou in Advance,

Regards,
Dhirendra Kumar

Andy Morsell wrote:
> 
> Dave,
> One thing to note is that the coordinate system overrides are not working
> in
> Beta 2 for both MySQL ODBC point X,Y geometry or native MySQL spatial.  I
> know that at least the ODBC scenario was working fine in Beta 1.  I logged
> a
> ticket with trac late yesterday about this issue:
> http://trac.osgeo.org/mapguide/ticket/159
> 
> 
> Andy 
> 
> -----Original Message-----
> From: mapguide-users-bounces at lists.osgeo.org
> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Dave Wilson
> Sent: Thursday, May 24, 2007 9:24 AM
> To: MapGuide Users Mail List
> Subject: RE: [mapguide-users] RE: About FDO
> 
> I think there may be some misunderstanding here. From the sounds of things
> it seems to me you are talking about native MySQL spatial data vs FDO
> Datastored based data, correct?
> 
> Prior to the current beta of open source with overrides it is not possible
> to specify a coordinate system for a native MySQL Spatial table. (ie you
> load the data using SHP2MySQL or something similar).
> There is an SRID column in the MySQL schema, but it is not implemented in
> MySQL or currently used by FDO that I am aware of. In other words SRID's
> aren't implemented as they are in Oracle.
> 
> It should be possible in current MapGuide and in the Beta to create a map
> and specify the coordinate system that the data is measured in and the map
> should preview. However if the layers are to be used in a map with a
> different coordinate system they will not transform unless you have the
> override option in the Beta. If you have Map and can create an FDO
> Datastore
> there is a coordinate system defined with the data and this should work
> fine.
> 
> Another issue with using MySQL that is important to note is that it
> currently only supports Envelope based spatial operations. So when a user
> attempts to select a polygon in a map there are cases where the adjacent
> polygon is selected because MySQL executes an EnvelopeIntersects rather
> than
> an Intersects operation. If you can imagine drawing an envelope rectangle
> around to adjacent polygons and note where you clicked to select that if
> the
> rectangles overlap the selection will choose the one with the lowest id.
> This is a flaw, but only because MySQL isn't fully spatial capable. The
> results are that selection can be somewhat inconsistent on polygon layers.
> This may also apply to polylines, but I have yet to determine if this is
> the
> case.
> 
> Regards,
> Dave
> 
> 
> -----Original Message-----
> From: mapguide-users-bounces at lists.osgeo.org
> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Andy Morsell
> Sent: Thursday, May 24, 2007 10:02 AM
> To: 'MapGuide Users Mail List'
> Subject: RE: [mapguide-users] RE: About FDO
> 
> To create data, data connections, layers, maps and so on it is easiest to
> use one of the GUI's available.  MapGuide Open Source comes with Web
> Studio.
> Or, you can use  the fully featured Autodesk MapGuide Studio.  You can
> download and use a preview version from here:
> http://usa.autodesk.com/adsk/servlet/index?id=7176611&siteID=123112
> 
> 
> Andy 
> 
> -----Original Message-----
> From: mapguide-users-bounces at lists.osgeo.org
> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Dhirendra
> Kumar
> Sent: Thursday, May 24, 2007 5:17 AM
> To: mapguide-users at lists.osgeo.org
> Subject: [mapguide-users] RE: About FDO
> 
> 
> Hi Andy Morsell,
> 
> Thankyou for your replay, I have succesfully establish mapguide connection
> with MySQL 5.0. But i have not idea how to make layer using this
> connection
> and define Cordinate system, So please guide me, how to make layers ? I am
> waiting for your valuable replay.
> 
> Regards,
> Dhirendra Kumar
> 
> Andy Morsell wrote:
>> 
>> What you describe is not really a function of FDO but rather of the 
>> MapGuide API.  If you just need to update layer properties and refresh
> 
>> the layer and map, then it doesn't matter what your feature source 
>> type is.  Any database (that supports your geometry types) will work 
>> fine for this type of application.
>> 
>> 
>> Andy Morsell, P.E.
>> Spatial Integrators, Inc.
>> http://www.SpatialGIS.com
>> 
>> -----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 21, 2007 10:45 PM
>> To: mapguide-users at lists.osgeo.org
>> Subject: [mapguide-users] About FDO
>> 
>> 
>> Hi All,
>> 
>> I want to use FDO connectivity with MySQL or Oracle. So, first i want
> to
>> know some information about FDO when i shall use Oracle with FDO then 
>> during run time FDO direct Connect Oracle Database ? I am asking this 
>> Qustion because my client requirments is to change layers property 
>> during run time, Co'uz they want to update Database time to time and 
>> as per updation
> they
>> want to show features on map. Is it possible with FDO ? if yes then
> tell
>> me
>> which database is more sutable with MGOS ? and posible then send me
> some
>> Examples of FDO Connectvity with some Quieries Example.
>> 
>> Thankyou in Advance,
>> 
>> Regards,Dhirendra Kumar
>> --
>> View this message in context:
>> http://www.nabble.com/About-FDO-tf3794354s16610.html#a10731856
>> 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
>> 
>> 
> 
> --
> View this message in context:
> http://www.nabble.com/About-FDO-tf3794354s16610.html#a10782569
> 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
> 
> 

-- 
View this message in context: http://www.nabble.com/About-FDO-tf3794354s16610.html#a10802586
Sent from the MapGuide Users mailing list archive at Nabble.com.