Changes between Version 3 and Version 4 of UsersWikiPostgisarcgis


Ignore:
Timestamp:
Dec 16, 2010, 8:39:36 AM (13 years ago)
Author:
robe
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • UsersWikiPostgisarcgis

    v3 v4  
    11= PostGIS and ArcSDE/ArcGIS  Articles =
    2 == Issues Gotchas ==
     2== Issues / Gotchas / Confusions ==
    33The biggest problem with using PostGIS in ArcSDE is that you are forced to use older versions of PostGIS and PostgreSQL.
    4  * If you are running ArcGIS 10.0 then only PostGIS 1.4 and PostgreSQL 8.3/8.4 are supported. Details: [http://resources.arcgis.com/content/arcsde/10.0/postgresql-system-requirements ArcSDE 10 PostgreSQL/PostGIS system requirements] 
     4 * If you are running ArcGIS 10.0 then only PostGIS 1.4 and PostgreSQL 8.3/8.4 are supported.
     5
     6Details: [http://resources.arcgis.com/content/arcsde/10.0/postgresql-system-requirements ArcSDE 10 PostgreSQL/PostGIS system requirements] 
    57
    68 * If you are running ArcGIS 9.3 then only PostGIS 1.3 and PostgreSQL 8.3 are supported.
     9
    710Details: [http://wikis.esri.com/wiki/display/ag93bsr/ArcSDE+PostgreSQL+Database+Requirements ArcSDE 9.3 PostgreSQL/PostGIS Database Requirements]
     11
     12Second issue:
     13There is PostGIS and there is ESRI ST_Geometry which is ESRI's specific flavor of OGC geometry they install in PostgreSQL. These are not the same thing.  Of course we would prefer you to use PostGIS, and PostGIS gives you more options with working with other software (particularly Open Source). The ST_Geometry and related functions are stored in the sde schema.
    814== Case Studies ==
    915These are Case Studies of using ArcSDE with PostGIS or moving away from ArcSDE: