[postgis-users] OT: SQLServer2008 Geography type

Paul Ramsey pramsey at cleverelephant.ca
Thu Feb 28 16:09:47 PST 2008

They aren't saying they can't cross the dateline, they are saying you
can't have objects that cover more than half the sphere (any half).
It's a restriction, but not a particularly onerous one.

On 2/26/08, Robert Coup <robert.coup at onetrackmind.co.nz> wrote:
> Noticed this today...
>  http://stevekass.com/2007/11/21/the-hemisphere-requirement/
>  Basically, in SQL Server 2008 Geography values (geography is the
>  ellipsoidal "first-class citizen" type) are limited to a single
>  hemisphere (<180 width and <90 height).
>  Odd. Because I would think it'd be relatively easy to implement
>  something with those same restrictions on top of postgis' geometry
>  data type via some adding and subtracting past +/- 180 & +/-90.
>  (IMHO a single-hemisphere limit is dumb, from my point of view the
>  whole purpose of "geography" is to be able to represent
>  large/interesting areas of the world)
>  Rob :)
>  _______________________________________________
>  postgis-users mailing list
>  postgis-users at postgis.refractions.net
>  http://postgis.refractions.net/mailman/listinfo/postgis-users

More information about the postgis-users mailing list