That's right. geometry type in sql 2008 is working correctly. It means you can display and select the features.
Martin Morrison wrote: > > 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 > > ----- Rodolfo Moreno CivilEng -- View this message in context: http://n2.nabble.com/SQL-2008-Geographic-data-type-can%27t-be-selected-tp2410036p2473971.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
