This seems like the basis for another good wiki article... 8^)
Paragon Corporation wrote:
Juan,
Can't say I'm even a mildly competent user of ArcGIS products, but
hopefully the little I know about the topic will be of help to you.
For GeoDatabase -> PostGIS - OGR2OGR has worked well for me, its
free, and also can deal with other formats as well.
We have some of the more commonly used cases we use documented on our
site. We recently added a Personal Geodatabase example which is
further to the end of the document
http://www.bostongis.com/PrinterFriendly.aspx?content_name=ogr_cheatsheet
For editing data in ArcMap
ArcGIS 9.3 has built in support, but I think you may need to purchase
the PostgreSQL SDE license to use it. Check out Bill Dollins -
http://geobabble.wordpress.com he has a number of articles on using
both builtin support and using ZigGIS
Paolo Corti -
http://www.paolocorti.net/2008/06/06/spatial-database-for-postgres-and-arcgis-users-how-to-choose/
Dave Bowman for some more examples of using ArcGIS 9.3 with PostGIS -
http://blog.davebouwman.net/2008/05/12/PostGISRound2ReadingTheManual.aspx
If you are using ArcGIS 9.2 and below or you just need desktop editing
support (and are using ArcGIS 9.3) and don't want to pay for an SDE
license, check out ZigGIS plugin for ArcDesktop -
http://www.obtusesoft.com/pr.html
Hope that helps,
Regina
------------------------------------------------------------------------
*From:* [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] *On Behalf Of
*Juan Declet
*Sent:* Thursday, July 24, 2008 4:59 PM
*To:* postgis-users@postgis.refractions.net
*Subject:* [postgis-users] ESRI Geodatabases, relationship classes and
PostGIS
Hi, all. I am evaluating PostGIS to determine if it can suit our needs.
What I currently have is a personal geodatabase (.MDB) file, created
in ArcCatalog.
This geodatabase has a number of relationship classes created in
ArcCatalog that are
used in ArcMap to facilitate editing and addition of new features.
What I am looking for is a spatial data server where I can publish
this geodatabase and make it available for ArcMap users to connect to
this data source and edit the dataset. In other words, I need an Open
Source equivalent to ArcGIS Server or Arc Spatial Data Server (ArcSDE).
The questions are:
1. Will PostGIS recognize relationship classes created in ArcCatalog,
being that these are not exactly like those created in Access or in an
Access-like environment (i.e., relationship classes don't show up in
the Relationships window in MS Access)?
2. Can a client such as ArcMap connect to a PostGIS data source?
I appreciate the input of seasoned PostGIS users in this matter.
Regards,
Juan Declet
------------------------------------------------------------------------
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Martin Davis
Senior Technical Architect
Refractions Research, Inc.
(250) 383-3022
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
