<div dir="ltr">The tables must be standard Access tables, since a Personal Geodatabase .MDB file can be opened in Access and the tables (spatial and nonspatial) read and edited within.<br><br>I wonder about the relationship classes, though. These were not recognized by the OGRINFO tool (only feature classes showed up). I suppose that the OGR ODBC driver will recognize non-spatial data tables, but not the relationship classes defined in ArcCatalog, since these seem to be in a ESRI propietary format. Actually, I have not been able to identify where the ArcCatalog-created relationship classes reside when opening a Personal Geodatabase in Access. <br>
<br><div class="gmail_quote">On Tue, Jul 29, 2008 at 1:09 AM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">Juan,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">Does Arc Catalog create standard Access database attribute
tables (e.g. the kind you would create just using Access) or does it make it in
some sort of proprietary format similar to the way it does feature
classes?</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">If they are standard Access attribute tables, then you
could import them using the ODBC driver of OGR.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">To do so you would do the following</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">1) Create a system DSN on windows that points to your
access database file.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">2) Do something like</font></span></div><span><code>
</code><div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"></font><br>ogr2ogr
-append -f "PostgreSQL" PG:"host=<i>pghost</i> user=<i>pgloginname</i>
dbname=<i>pgdbname</i> password=<i>pgpassword</i> port=5432"
<br>ODBC:"someaccessdsn" table1 table2 table3</div>
<div dir="ltr" align="left"> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">Where table1 table2 table3 are the names of the access
tables you want to export to PostgreSQL.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">I think it creates an annoying empty geometry field
regardless, but then I just drop the column.</font></span></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"></font></div> </span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">Hope that helps,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">Regina</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div><br>
<div dir="ltr" align="left" lang="en-us">
<hr>
<font size="2" face="Tahoma"><div class="Ih2E3d"><b>From:</b>
<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>] <b>On Behalf Of </b>Juan
Declet<br></div><b>Sent:</b> Monday, July 28, 2008 6:36 PM<br><b>To:</b> PostGIS Users
Discussion<br><b>Subject:</b> Re: [postgis-users] ESRI Geodatabases,relationship
classes and PostGIS<br></font><br></div><div><div></div><div class="Wj3C7c">
<div></div>
<div dir="ltr"><font size="2">Well, so far I have been able load the 'Parcels'
sample database included with PostGIS into a remote ArcMap session using a demo
version of zigGIS. This required editing the PostGIS configuration files to
allow remote access. <br><br>Now I am attempting to convert an ESRI Personal
Geodatabase to PostGIS using OGR2OGR. However, OGRINFO displays only the feature
classes, but not the nonspatial data tables or relationship classes created in
ArcCatalog. Does anyone know where to find extensive documentation for OGR2OGR?
The command line help is minimal.<br><br>-Juan #1 (pardon the
pun)<br></font><br>
<div class="gmail_quote">On Sat, Jul 26, 2008 at 7:41 AM, jcvlz <span dir="ltr"><<a href="mailto:jcvlz@jcvlz.com" target="_blank">jcvlz@jcvlz.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div dir="ltr">For what it's worth, I believe there should be some way to
accomplish this with one of the OSGeo FOSS projects - although I'm not not
familiar with the services/protocols that ESRI programs use:<br><br><a href="http://www.osgeo.org/" target="_blank">http://www.osgeo.org/</a><br><br>-Juan #2 [ not the OP
:)
]<br></div><br>_______________________________________________<br>postgis-users
mailing list<br><a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br></div>