[mapserver-users] Using the SQL Server 2008 Plugin with a Geography column

[Andrew Williams]

Joncoign,

Just looking for some clarification to your question.

I'm no expert but this stuck out when I was looking into SQL 2008.

There are two ways to define an object spatially in 2008 one as type geometry and one as geography.

Is it possible your calling geometry type instead of a geography type?

http://www.microsoft.com/sqlserver/2008/en/us/spatial-data.aspx

Might be of interest

-----Original Message-----
From: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of joncoign
Sent: Wednesday, 1 April 2009 9:35 AM
To: mapserver-users at lists.osgeo.org
Subject: [mapserver-users] Using the SQL Server 2008 Plugin with a Geography column


Has anyone been able to get the SQL Server 2008 plugin to work against a geography column.

I have been using the following DATA Statement

DATA "the_geom FROM Types USING UNIQUE ID USING SRID=4326"

and get the response, "sys.geometry is incompatible with sys.geography" due to the spatial filter being written by the plugin using geometry.

Is there an option to change this? I have been unable to locate any detailed documetation on SQL Server 2008 plugin so if this exists that might help.

--
View this message in context: http://n2.nabble.com/Using-the-SQL-Server-2008-Plugin-with-a-Geography-column-tp2565867p2565867.html
Sent from the Mapserver - User mailing list archive at Nabble.com.

_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users