[postgis-users] ESRI Geodatabases, relationship classes and PostGIS

[Paragon Corporation]

Juan,
 
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?
 
If they are standard Access attribute tables, then you could import them
using the ODBC driver of OGR.
 
To do so you would do the following
1) Create a system DSN on windows that points to your access database file.
2) Do something like

ogr2ogr -append -f "PostgreSQL" PG:"host=pghost user=pgloginname
dbname=pgdbname password=pgpassword port=5432" 
ODBC:"someaccessdsn" table1 table2 table3
 
Where table1 table2 table3 are the names of the access tables you want to
export to PostgreSQL.
 
I think it creates an annoying empty geometry field regardless, but then I
just drop the column.
 
 
Hope that helps,
Regina
 

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Juan
Declet
Sent: Monday, July 28, 2008 6:36 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] ESRI Geodatabases,relationship classes and
PostGIS


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. 

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.

-Juan #1 (pardon the pun)


On Sat, Jul 26, 2008 at 7:41 AM, jcvlz <jcvlz at jcvlz.com> wrote:


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:

http://www.osgeo.org/

-Juan #2 [  not the OP :)  ]


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080729/d2b4d0fd/attachment.html>