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

Lee Hachadoorian lee.hachadoorian at gmail.com
Tue Jul 29 09:34:37 PDT 2008

Yes, ArcCatalog creates a standard Access database table, but enforces
the creation of a unique index called OBJECTID (which is not, however,
actually a primary key).  So what Regina describes should work.

There's an ogr2ogr cheatsheet at BostonGIS

I'm not sure about the relationship classes question, although my
suspicion is that the conversion works table-by-table on data (spatial
and non-spatial) only.  Since the relationship classes are not stored
in the feature class or non-spatial table itself (they are stored in a
table called GDB_RelClasses), I suspect that ogr2ogr will not do
anything to convert them.  Can someone confirm?

Lee Hachadoorian
PhD Student, Geography
Program in Earth & Environmental Sciences
CUNY Graduate Center

More information about the postgis-users mailing list