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
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Martin Davis
Senior Technical Architect
Refractions Research, Inc.
(250) 383-3022
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
