<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16674" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=406010901-25072008><FONT face=Arial
color=#0000ff size=2>Juan,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=406010901-25072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=406010901-25072008><FONT face=Arial
color=#0000ff size=2>Can't say I'm even a mildly competent user of ArcGIS
products, but hopefully the little I know about the topic will be of help to
you.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=406010901-25072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=406010901-25072008><FONT face=Arial
color=#0000ff size=2>For GeoDatabase -> PostGIS - OGR2OGR has
worked well for me, its free, and also can deal with other formats as
well. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=406010901-25072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=406010901-25072008><FONT face=Arial
color=#0000ff size=2>We have some of the more commonly used cases we use
documented on our site. We recently added a Personal Geodatabase example
which is further to the end of the document</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=406010901-25072008><FONT face=Arial
color=#800000 size=2><A
href="http://www.bostongis.com/PrinterFriendly.aspx?content_name=ogr_cheatsheet">http://www.bostongis.com/PrinterFriendly.aspx?content_name=ogr_cheatsheet</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=406010901-25072008><FONT face=Arial
color=#800000 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=406010901-25072008><FONT face=Arial
color=#800000 size=2>For editing data in ArcMap</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=406010901-25072008><FONT face=Arial
color=#800000 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=406010901-25072008><FONT face=Arial
color=#800000 size=2>ArcGIS 9.3 has built in support, but I think you may need
to purchase the PostgreSQL SDE license to use it. Check out Bill Dollins -
<A
href="http://geobabble.wordpress.com">http://geobabble.wordpress.com</A>
he has a number of articles on using both builtin support and using
ZigGIS</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=406010901-25072008><FONT face=Arial
color=#800000 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=406010901-25072008><FONT face=Arial
color=#800000 size=2>Paolo Corti - <A
href="http://www.paolocorti.net/2008/06/06/spatial-database-for-postgres-and-arcgis-users-how-to-choose/">http://www.paolocorti.net/2008/06/06/spatial-database-for-postgres-and-arcgis-users-how-to-choose/</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=406010901-25072008><FONT face=Arial
color=#800000 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=406010901-25072008><FONT face=Arial
color=#800000 size=2>Dave Bowman for some more examples of using ArcGIS 9.3 with
PostGIS - <A
href="http://blog.davebouwman.net/2008/05/12/PostGISRound2ReadingTheManual.aspx">http://blog.davebouwman.net/2008/05/12/PostGISRound2ReadingTheManual.aspx</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=406010901-25072008><FONT face=Arial
color=#800000 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=406010901-25072008><FONT face=Arial
color=#800000 size=2>If you are using ArcGIS 9.2 and below or you just need
desktop editing support (and are using ArcGIS 9.3) and don't want to pay for an
SDE license, check out ZigGIS plugin for ArcDesktop - <A
href="http://www.obtusesoft.com/pr.html">http://www.obtusesoft.com/pr.html</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=406010901-25072008><FONT face=Arial
color=#800000 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=406010901-25072008><FONT face=Arial
color=#800000 size=2>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=406010901-25072008><FONT face=Arial
color=#800000 size=2>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=406010901-25072008><FONT face=Arial
color=#800000 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=406010901-25072008><FONT face=Arial
color=#800000 size=2></FONT></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Juan
Declet<BR><B>Sent:</B> Thursday, July 24, 2008 4:59 PM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users] ESRI
Geodatabases, relationship classes and PostGIS<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr><FONT size=2>Hi, all. I am evaluating PostGIS to determine if it
can suit our needs.<BR><BR>What I currently have is a personal geodatabase
(.MDB) file, created in ArcCatalog.<BR>This geodatabase has a number of
relationship classes created in ArcCatalog that are<BR>used in ArcMap to
facilitate editing and addition of new features.<BR><BR>What I am looking for is
a spatial data server where I can publish this geodatabase and make it available
for ArcMap users to connect to this data source and edit the dataset. In other
words, I need an Open Source equivalent to ArcGIS Server or Arc Spatial Data
Server (ArcSDE).<BR><BR>The questions are:<BR><BR>1. Will PostGIS recognize
relationship classes created in ArcCatalog, being that these are not exactly
like those created in Access or in an Access-like environment (i.e.,
relationship classes don't show up in the Relationships window in MS
Access)?<BR><BR>2. Can a client such as ArcMap connect to a PostGIS data
source?<BR><BR>I appreciate the input of seasoned PostGIS users in this
matter.<BR><BR>Regards,<BR><BR>Juan Declet</FONT></DIV></BODY></HTML>