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-tp2410036p2450086.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
