<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=utf-8" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.19019"></HEAD>
<BODY>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN class=383552817-10082011>Hi
all,</SPAN></FONT></DIV>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN
class=383552817-10082011></SPAN></FONT> </DIV>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN class=383552817-10082011>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)
.</SPAN></FONT></DIV>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN
class=383552817-10082011></SPAN></FONT> </DIV>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN class=383552817-10082011>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 ;)</SPAN></FONT></DIV>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN
class=383552817-10082011></SPAN></FONT> </DIV>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN class=383552817-10082011>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.</SPAN></FONT></DIV>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN
class=383552817-10082011>Looking forward to hear what other have come up
with.</SPAN></FONT></DIV>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN class=383552817-10082011>Thanks
a lot</SPAN></FONT></DIV>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN
class=383552817-10082011></SPAN></FONT> </DIV>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN
class=383552817-10082011>Cheers</SPAN></FONT></DIV>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN
class=383552817-10082011>Karsten</SPAN></FONT></DIV>
<P class=MsoNormal align=left><FONT size=2><SPAN
style="FONT-FAMILY: Verdana; FONT-SIZE: 11pt">Karsten
Vennemann<BR></SPAN></FONT><FONT size=1><SPAN
style="FONT-FAMILY: Verdana; FONT-SIZE: 9pt">Principal<BR><BR></SPAN></FONT><FONT
color=#003264><FONT size=1><SPAN
style="FONT-FAMILY: Verdana; FONT-SIZE: 9pt">Terra GIS
LTD<BR></SPAN></FONT></FONT><?xml:namespace prefix = st1 ns =
"urn:schemas-microsoft-com:office:smarttags" /><st1:country-region
w:st="on"><st1:place w:st="on"><FONT color=#003264 size=1><SPAN
style="FONT-FAMILY: Verdana; FONT-SIZE: 9pt">USA</SPAN></FONT></st1:place></st1:country-region><FONT
color=#003264 size=1><SPAN
style="FONT-FAMILY: Verdana; FONT-SIZE: 9pt"> <BR><A
href="http://www.terragis.net">www.terragis.net</A></SPAN></FONT></P></BODY></HTML>