I just want to note that I am using SQL 2008 to display geometry without any issues...
Martin -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Rodolfo Moreno Sent: Friday, March 13, 2009 10:55 AM To: [email protected] Subject: RE: [mapguide-users] SQL 2008 Geographic data type can't be selected Hi all, I was reviewing others theards with relation to it. http://n2.nabble.com/Layer%27s-selection-Problem-td2352146.html It seems to be an issue with geography data type in sql 2008. I would like to post a ticket but I don't know exactly in where is the error in mapguide or FDO. Any opinion? Regards Rodolfo Moreno wrote: > > Yes, my table has primary key (as integer) and spatial index with > geographic grid. > > Regards, > > > Dave Wilson wrote: >> >> Can you ensure your table has a primary key? I'm pretty sure it's >> required. >> >> Dave >> >> -----Original Message----- >> From: [email protected] >> [mailto:[email protected]] On Behalf Of Rodolfo >> Moreno >> Sent: Friday, March 06, 2009 4:01 PM >> To: [email protected] >> Subject: RE: [mapguide-users] SQL 2008 Geographic data type can't be >> selected >> >> >> Hi Andrei, >> sorry for my delay. >> I have created a new sql table with geography sql type and I added two >> simple polygons. >> here is my sql script: >> >> insert into test1 >> VALUES (1,geography::STGeomFromText('POLYGON ((0 0 ,1 0,1 1 , 0 1, 0 0 >> ))', >> 4326) ) >> >> insert into test1 >> VALUES (2,geography::STGeomFromText('POLYGON ((1 1 ,3 1,2 3 , 1 1 ))', >> 4326) >> ) >> >> Next I have displayed the features with the ajax viewer of the MGOS (I am >> using 2.0.1 version) and the result is the same. >> It means that the features are shown but these can't be selected. >> >> I guess that it is an issue of MGOS. have you ever had success with it? >> >> Regards, >> >> >> Rodolfo Moreno wrote: >>> >>> Thanks Andrei, I am goin to try your suggestion. >>> >>> >>> miansi wrote: >>>> >>>> Hello Rodolfo, >>>> >>>> Make sure you set SRID while populating SQL: >>>> >>>> ... >>>> , [Geo] = GEOMETRY::STGeomFromText([import].[Geo], @SRID) >>>> ... >>>> >>>> Base on your map (WGS 84) your SRID should be something like 4326 >>>> >>>> >>>> Regards, >>>> >>>> Andrei >>>> >>>> >>>> -----Original Message----- >>>> From: [email protected] >>>> [mailto:[email protected]] On Behalf Of Rodolfo >>>> Moreno >>>> Sent: Monday, March 02, 2009 9:15 AM >>>> To: [email protected] >>>> Subject: [mapguide-users] SQL 2008 Geographic data type can't be >>>> selected >>>> >>>> >>>> I have could select features from geometric data type (sql 2008 as data >>>> source) however, for the case of geographic data type the selection of >>>> the >>>> features is not possible. >>>> The error shown in the log is: "sys.geometry is incompatible with >>>> sys.geography" >>>> The map that contains this layer is set as WGS 84. >>>> >>>> any help will be appreciated, thanks >>>> >>>> ----- >>>> Rodolfo Moreno >>>> CivilEng >>>> >>>> -- >>>> View this message in context: >>>> http://n2.nabble.com/SQL-2008-Geographic-data-type-can%27t-be-selected-t >>>> p2410036p2410036.html >>>> Sent from the MapGuide Users mailing list archive at Nabble.com. >>>> >>>> _______________________________________________ >>>> mapguide-users mailing list >>>> [email protected] >>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users >>>> >>>> >>>> ----Notice Regarding Confidentiality---- >>>> This email, including any and all attachments, (this "Email") is >>>> intended >>>> only for the party to whom it is addressed and may contain information >>>> that is confidential or privileged. Sierra Systems Group Inc. and its >>>> affiliates accept no responsibility for any loss or damage suffered by >>>> any person resulting from any unauthorized use of or reliance upon this >>>> Email. If you are not the intended recipient, you are hereby notified >>>> that any dissemination, copying or other use of this Email is >>>> prohibited. >>>> Please notify us of the error in communication by return email and >>>> destroy all copies of this Email. Thank you. >>>> _______________________________________________ >>>> mapguide-users mailing list >>>> [email protected] >>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users >>>> >>>> >>> >>> >> >> >> ----- >> Rodolfo Moreno >> CivilEng >> >> -- >> View this message in context: >> http://n2.nabble.com/SQL-2008-Geographic-data-type-can%27t-be-selected-tp2410036p2438599.html >> Sent from the MapGuide Users mailing list archive at Nabble.com. >> >> _______________________________________________ >> mapguide-users mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/mapguide-users >> _______________________________________________ >> mapguide-users mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/mapguide-users >> >> > > ----- Rodolfo Moreno CivilEng -- View this message in context: http://n2.nabble.com/SQL-2008-Geographic-data-type-can%27t-be-selected-tp2410036p2473836.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
