[postgis-users] How do PostGIS&SQL Server 2008 with geospatialsupport compare ?

Gregory Williamson Gregory.Williamson at digitalglobe.com
Tue Nov 20 02:47:15 PST 2007


Geodetic stuff is of interest to those of us who care about, for instance, the track that satellites follow around the earth. Geodetic is relentlessly ellipsoidal, I think and helps in calculations relating to that sort of time and space calculation. I mucked with it some in Informix's Geodetic blade -- if you search IBM's web site they have decent documentation on the difference between spatial and geodetic blades and why one might be preferred. The Internation Date line, for instance, is one area that is handled differently.

For most of the calculations I am currently involved in the spatial-blade (postGIS-like) accuracy is good enough. But there are those in my parent company who care very much about the distortions involved in a projection.

HTH, and please forgive any misleading info -- I am mere psychology major who strayed far afield!

Greg Williamson
Senior DBA
GlobeXplorer LLC, a DigitalGlobe company

Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information and must be protected in accordance with those provisions. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

(My corporate masters made me say this.)



-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net on behalf of Guido Lemoine
Sent: Tue 11/20/2007 1:03 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] How do PostGIS&SQL Server 2008 with geospatialsupport compare ?
 
Plus Postgis available also on other than the SQL Server-specific OS
and at (near) zero cost. What is big about geodetic support, by the
way?

GL

Paul Ramsey wrote:
> Too soon. Probably comparable, with PostGIS having a smattering of 
> features that SQL Server does not, and SQL Server having one big 
> feature (geodetic support) that PostGIS does not.
>
> Steven De Vriendt wrote:
>> Hi list,
>>
>> Maybe my question comes a bit soon, still I wonder how the two
>> compare. For now we use PostGIS and SQL Server 2005 next
>> to each other in our organization.Spatial support looks promising
>> but I don't know if it's worth to take the SQL 2008-spatial support 
>> in account.
>> (read: if the price tag will justify SQL server above PostGIS).
>>
>> Cheers
>> Steven
>
>

-- 
----------------------------------------------------------------
Guido Lemoine
Joint Research Centre, European Commission
Institute for the Protection and Security of the Citizen (IPSC)
Support to External Security
Via E. Fermi, 2749 TP 267 Ispra 21027 (VA), Italy
Tel. +39 0332 786239 (direct line) Fax. +39 0332 785154
WWW: http://ses.jrc.it
----------------------------------------------------------------
Disclaimer:
Views expressed are those of the individual and do not represent 
the views of the European Commission


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071120/b3412acd/attachment.html>


More information about the postgis-users mailing list