<!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=531200308-29072008><FONT face=Arial
color=#0000ff size=2>Juan,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=531200308-29072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=531200308-29072008><FONT face=Arial
color=#0000ff size=2>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 class=531200308-29072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=531200308-29072008><FONT face=Arial
color=#0000ff size=2>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 class=531200308-29072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=531200308-29072008><FONT face=Arial
color=#0000ff size=2>To do so you would do the following</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=531200308-29072008><FONT face=Arial
color=#0000ff size=2>1) Create a system DSN on windows that points to your
access database file.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=531200308-29072008><FONT face=Arial
color=#0000ff size=2>2) Do something like</FONT></SPAN></DIV><SPAN
class=531200308-29072008><CODE>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2></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 class=531200308-29072008><FONT face=Arial
color=#0000ff size=2>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 class=531200308-29072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=531200308-29072008><FONT face=Arial
color=#0000ff size=2>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 face=Arial color=#0000ff
size=2></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT></CODE> </DIV></SPAN>
<DIV dir=ltr align=left><SPAN class=531200308-29072008><FONT face=Arial
color=#0000ff size=2>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=531200308-29072008><FONT face=Arial
color=#0000ff size=2>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=531200308-29072008><FONT face=Arial
color=#0000ff 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> 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 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">jcvlz@jcvlz.com</A>></SPAN>
wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<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">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></BODY></HTML>