[mapguide-users] SQL 2008 Geographic data type can't be selected

[Martin Morrison]

I just want to note that I am using SQL 2008 to display geometry without any issues...

Martin



-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Rodolfo Moreno
Sent: Friday, March 13, 2009 10:55 AM
To: mapguide-users at lists.osgeo.org
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: mapguide-users-bounces at lists.osgeo.org
>> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Rodolfo
>> Moreno
>> Sent: Friday, March 06, 2009 4:01 PM
>> To: mapguide-users at lists.osgeo.org
>> 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: mapguide-users-bounces at lists.osgeo.org
>>>> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Rodolfo
>>>> Moreno
>>>> Sent: Monday, March 02, 2009 9:15 AM
>>>> To: mapguide-users at lists.osgeo.org
>>>> 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
>>>> mapguide-users at lists.osgeo.org
>>>> 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
>>>> mapguide-users at lists.osgeo.org
>>>> 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
>> 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
>> 
>> 
> 
> 


-----
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
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users