[postgis-users] PostgreSQL/PostGIS and ArcGIS Server 9.3

[Martin Davis]

Oracle Spatial and SDE had the same problem, of different geometry 
models.  (This shows up most obviously in the polygon model, where SDE 
handles some kinds of holes differently to OGC & Oracle).

This seemed to cause problems when accessing Oracle data through SDE a 
while back (2-3 yrs ago), but I think the issue has now been solved.  I 
presume that SDE rebuilds the polygon topology to turn it into the SDE 
flavour.  (Although this would be quite slow for large geometries, I 
think).  Presumably they could do the same for PostGIS.

If anyone else has more info on this I'd be interested to hear it.

Chris Hermansen wrote:
> What I find immediately puzzling about this whole SDE - PostGIS thing 
> is a comment that Someone Knowledgeable (Paul?  Martin?) made a few 
> weeks ago about an incompatibility between SDE's geometry and OGC or 
> at least PostGIS's implementation of OGC.
>
> Sorry I can't provide more details, but does anyone recall this, and 
> have a comment on the matter?
>
> Tim Bowden wrote:
>> On Fri, 2008-05-23 at 09:29 -0500, Stephen Woodbridge wrote:
>>  
>>> Tim Bowden wrote:
>>>    
>>>> Hi all,
>>>>
>>>> I've read bits and pieces about PostgreSQL/PostGIS and ArcGIS 
>>>> Server 9.3
>>>> and how they (might) inter-operate.  Can anybody point me to a concise
>>>> summation of what's happening there?  I understand ArcGIS Server 
>>>> will be
>>>> able to use PostGIS geometries, but at what cost (performance and
>>>> functionality)? Does this mean we can have ArcGIS and open source
>>>> clients editing the same geometries?
>>>>
>>>> ArcGIS Server 9.3 beta is in the wild, and I've read that the final
>>>> release is due "soon".  Anyone have any idea if soon is measured in
>>>> weeks or months?
>>>>       
>>> Tim,
>>>
>>> You might be interested in this link:
>>> http://blog.davebouwman.net/2008/05/12/PostGISRound2ReadingTheManual.aspx 
>>>
>>>
>>> -Stephen Woodbridge
>>>   http://imaptools.com/
>>>     
>>
>> Hot stuff, thanks Stephen.  Looks very promising.  With a bit of luck it
>> will ease the transition to PostgreSQL/PostGIS for those wanting to go
>> down that route.  I can think of a few who will be looking at this over
>> the next few years.
>>
>> Regards,
>> Tim Bowden
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>   
>
>

-- 
Martin Davis
Senior Technical Architect
Refractions Research, Inc.
(250) 383-3022