In sql 2008 there are two types of spatial data: Geometry (flat Earth model) and Geography (ellipsoidal model). The issue is with geography data type. The features are displayed but these can't be selected. Regards,
Martin Morrison wrote: > > Maybe I am misunderstanding what the issue is. Early on you stated: > > " for the case of geographic data type the > selection of the features is not possible." > > So what exactly is the issue that you are having? > > Martin > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Rodolfo > Moreno > Sent: Friday, March 13, 2009 11:18 AM > To: [email protected] > Subject: RE: [mapguide-users] SQL 2008 Geographic data type can't be > selected > > > 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 > > _______________________________________________ > 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-tp2410036p2475222.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
