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

Noli Sicad nsicad at gmail.com
Wed Aug 10 21:54:31 EDT 2011

These 2 softwares will help connect / move your ArcGIS project to FOSS.

Connect: ArcGIS to PostGIS

 PgMap - for Postgresql / PostGIS - Free

This is the ArcMap Extension for connectinng to PostGIS (PostgreSQL)
spatial database.


Move:  ArcGIS to QGIS - (Free ArcGIS extension)
One needs to export layers in an opened Arcmap document into a QGIS project file

Mxd2Qgs Tool


On 8/11/11, Arnie Shore <shoreas at gmail.com> wrote:
> All, esp Karsten, I wonder if you've given consideration to the feasibility
> of a solution based on web services;
> If feasible, this could bypass the issue you correctly raise re "what data
> storage solution you would recommend ", since the function of the service wd
> be to return data in one of the standard/common formats regardless of the
> origin.
> It's a non-trivial effort to design a suitable API,  but such an
> implementation cd provide the data to suitably-connected desktop
> applications, as well as to conventional browsers, of course
> AS
> On Wed, Aug 10, 2011 at 2:19 PM, Mr. Puneet Kishor
> <punk.kish at gmail.com>wrote:
>> 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
>> >
>> _______________________________________________
>> Discuss mailing list
>> Discuss at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/discuss

More information about the Discuss mailing list