Changes between Version 5 and Version 6 of UsersWikiPostgisarcgis


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

Legend:

Unmodified
Added
Removed
Modified
  • UsersWikiPostgisarcgis

    v5 v6  
    1010Details: [http://wikis.esri.com/wiki/display/ag93bsr/ArcSDE+PostgreSQL+Database+Requirements ArcSDE 9.3 PostgreSQL/PostGIS Database Requirements]
    1111
    12 Second issue:
    13 There 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.
     12Second issue - really confusing so pay careful attention:
     13There is PostGIS and there is [http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002p0000006s000000.htm ESRI ST_Geometry] which is ESRI's specific flavor of OGC geometry they install in PostgreSQL and make the default. 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. they call their data type st_geometry and PostGIS type is just called geometry.
    1414
    1515They also have a raster type they call ST_Raster not to be confused with PostGIS 2.0 raster type.
    16 Again different types.  More about ArcGIS ST_Raster type is discussed [http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//006z000000p8000000.htm ArcGIS 10: Installing the ST_Raster type in a local PostgreSQL database]
     16Again different types.  More about ArcGIS ST_Raster type is discussed [http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//006z000000p8000000.htm ArcGIS 10: Installing the ST_Raster type in a local PostgreSQL database]. PostGIS 2.0 raster type is just called raster.
     17
    1718== Case Studies ==
    1819These are Case Studies of using ArcSDE with PostGIS or moving away from ArcSDE: