[GIS] What are benefits of using ArcGIS with PostgreSQL over simply ArcSDE

arcgis-10.1enterprise-geodatabasepostgispostgresqlsql

I understand that in order to benefit from ArcGIS spatial datatypes (ST_GEOMETRY, versioned geodatabases etc.) ArcSDE needs to be installed – and with the 10.1 client it is automatically installed (two-tier client>>DBMS, see here.

However, I'm still trying to figure out the benefits of connecting an Esri front end to PostgreSQL (or Oracle). Is it purely back-end benefits, such as scalability /performance / redundancy / DBAability, or are there any extra front-end features offered by a PostgreSQL / PostGIS setup? The Esri help does not seem to elaborate

FYI, I'm pretty much a database newbie who is designing a GIS dissertation aimed at illustrating why Postgresql / PostGIS / QGIS is more scalable / flexible (and cheaper) than ArcGIS / any database, so must also consider above scenario, which I can't afford to implement. Any links on this last point, especially regarding workflow (e.g. not having loads of shapefiles cluttering everything up) most welcome. d.

Best Answer

Storing your data in a Spatial Database has several benefits over storing it in ArcSDE Geodatabase with a RDBMS Backend.
These include:

  • Your data can be accessed by other third party products freely.
  • Your DBA is happier with it being a Pure Database storage, since they can apply all their normal DBA best practices on the database.
  • You can apply Spatial SQL queries on the data from whichever client you wish. This can often be much more powerful than the Analysis that can be done in ArcGIS Desktop.

By doing things this way, you will not have access to many of ArcGIS Geodatabase functionality, like versioning, datasets, Network datasets, Geometric networks and so on.

A compromise, might be to have a ArcSDE geodatabase, and store spatial data in the native geometry/Geography type of the database. This can be done by using the appropriate config keyword while creating and loading data.

Related Question