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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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 [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
