[OSGeo-Discuss] designing databases, organizing data formats to work with open source and proprietary GIS

Duarte Carreira DCarreira at edia.pt
Thu Aug 11 01:45:21 PDT 2011

Hi there.

Im my view, there are 2 levels of integration: with and without ArcSDE.

If you have ArcSDE then you should follow Simon’s tips. It’s a tougher challenge to try getting all ArcGIS functionality and at the same time sharing the database with other tiers of software.
If you don’t then it’s simpler but it’s very likely that you will have to settle with some limitations in ArcGIS, mainly read-only access to the database, and not having the geodb design’s perks, like subtypes, domains, topology, etc. Since 10 you can already load data from a variety of spatial rdbms including pgsql. But not editing. I’m not sure what will change in 10.1.

For the Open Source side of things, going the way of pgsql is all you need! All tribes show their love for pgsql so it’s very powerfull in all aspects, desktop and server, C and Java, etc. Also you will be well served in other arenas besides GIS.

Just my 2 cents.

De: karsten vennemann [mailto:karsten at terragis.net]
Enviada: quarta-feira, 10 de Agosto de 2011 18:43
Para: discuss at lists.osgeo.org
Assunto: [OSGeo-Discuss] designing databases, organizing data formats to work with open source and proprietary GIS

Hi all,

in the near future I will have the opportunity to help design databases, decide on data formats (files data) for an international organization that wishes to be able to use both proprietary and open source based systems, mostly in web mapping solution but also possibly on the desktop. The task will be to design and organize the data stores in a way that both types of systems - open source (e.g. MapServer, OpenLayers) and proprietary systems (ESRI Arc Server) can use them well, and along the way to try to avoid too much data duplication (having to store data in multiple formats just to make them accessible) .

This sounds to like a exiting & useful, fun task, but given the limitations of both systems (regarding input data that might not work out of the box- namely file Geodatabases in open source solutions, and PostGIS data in ESRI products) might be not totally trivial ;)

I was wondering if anybody has done work on this, has implemented systems facing the same issues or knows of projects or reports that have been dealing with similar issues. Also I anybody has comments about what data storage solution you would recommend and comments about the pro and cons of certain storage designs please send it to the list.
Looking forward to hear what other have come up with.
Thanks a lot

Karsten Vennemann

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/discuss/attachments/20110811/8ba90f1a/attachment-0002.html>

More information about the Discuss mailing list