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

[Mr. Puneet Kishor]

Karsten,

On Aug 10, 2011, at 11:12 PM, karsten vennemann wrote:

> 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
> 

Perhaps other will respond with something helpful, but the above is way too generic. You might have to narrow down the specific issues in order to get more useful responses.

Puneet.