geography data type for attributes

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

geography data type for attributes

lhughes
I'm in the early stages of developing a SQL Server data warehouse that will maintain geographic/spatial data. I'm new to anchor modeling and wondering if the online tools support the SQL Server geographic data type. Any experience or ideas?

Thanks-

Lee
Reply | Threaded
Open this post in threaded view
|

Re: geography data type for attributes

roenbaeck
Administrator
It does support the geography type, but you will need to check the "Checkum" box in attributes or knots using the type. This is because of the fact that equality (and other comparison operators) cannot be used directly with the type.