<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7652.24">
<TITLE>RE: [postgis-users] How do PostGIS&SQL Server 2008 with geospatialsupport compare ?</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>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.<BR>
<BR>
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.<BR>
<BR>
HTH, and please forgive any misleading info -- I am mere psychology major who strayed far afield!<BR>
<BR>
Greg Williamson<BR>
Senior DBA<BR>
GlobeXplorer LLC, a DigitalGlobe company<BR>
<BR>
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.<BR>
<BR>
(My corporate masters made me say this.)<BR>
<BR>
<BR>
<BR>
-----Original Message-----<BR>
From: postgis-users-bounces@postgis.refractions.net on behalf of Guido Lemoine<BR>
Sent: Tue 11/20/2007 1:03 AM<BR>
To: PostGIS Users Discussion<BR>
Subject: Re: [postgis-users] How do PostGIS&SQL Server 2008 with geospatialsupport compare ?<BR>
<BR>
Plus Postgis available also on other than the SQL Server-specific OS<BR>
and at (near) zero cost. What is big about geodetic support, by the<BR>
way?<BR>
<BR>
GL<BR>
<BR>
Paul Ramsey wrote:<BR>
> Too soon. Probably comparable, with PostGIS having a smattering of<BR>
> features that SQL Server does not, and SQL Server having one big<BR>
> feature (geodetic support) that PostGIS does not.<BR>
><BR>
> Steven De Vriendt wrote:<BR>
>> Hi list,<BR>
>><BR>
>> Maybe my question comes a bit soon, still I wonder how the two<BR>
>> compare. For now we use PostGIS and SQL Server 2005 next<BR>
>> to each other in our organization.Spatial support looks promising<BR>
>> but I don't know if it's worth to take the SQL 2008-spatial support<BR>
>> in account.<BR>
>> (read: if the price tag will justify SQL server above PostGIS).<BR>
>><BR>
>> Cheers<BR>
>> Steven<BR>
><BR>
><BR>
<BR>
--<BR>
----------------------------------------------------------------<BR>
Guido Lemoine<BR>
Joint Research Centre, European Commission<BR>
Institute for the Protection and Security of the Citizen (IPSC)<BR>
Support to External Security<BR>
Via E. Fermi, 2749 TP 267 Ispra 21027 (VA), Italy<BR>
Tel. +39 0332 786239 (direct line) Fax. +39 0332 785154<BR>
WWW: <A HREF="http://ses.jrc.it">http://ses.jrc.it</A><BR>
----------------------------------------------------------------<BR>
Disclaimer:<BR>
Views expressed are those of the individual and do not represent<BR>
the views of the European Commission<BR>
<BR>
<BR>
_______________________________________________<BR>
postgis-users mailing list<BR>
postgis-users@postgis.refractions.net<BR>
<A HREF="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>