PostGIS PG_Geometry support in 10.3

Question

Hi,

We have a PostgreSQL 9.3.6 (x64) and PostGIS 2.1.5 extension installed. We have several spatial tables in it. We want to connect this DB to our ArcMap 10.3, but we can't have any success. I got DBMS error and can't figure our how to fix it. Is there any tutorial or documentation that shows clearly how to connect current PostGIS database without installing SDE?

Also I still have questions about editing PostGIS without using ST_Geometry (SDE format) because we have some geometry services written in .NET which accesses PostGIS directly. We don't want to break this link, is this possible with ESRI tech? I don't want to create two databases and sync them together to achieve this process.

Any help or suggestion will be appreciated

Best regards.

Alper.

Duarte_Carreira · Answer

Answer to your question: * Is it possible to use native PostGIS functions and geometry type in ArcMap without installing SDE stuff?

It is possible to read, impossible to write/edit.

Elaborating:

You can create data in PostGIS using non-esri software like QGIS, and read it in ArcMap.

You can add it to the map using menu File->Add Data->Add Query Layer. You can filter, symbolize, label, etc. You cannot edit.

Option 2: you can only create PostGIS data using ArcMap if you install sde, then you can read it in QGIS. You cannot edit in QGIS. (you can but that's a bit more complicated because of ObjectID maintenance/creation)

Option 3: you can create PostGIS data using ArcMap (with sde), publish a T-WFS service with ArcGIS Server, and edit the data in QGIS by using the t-WFS service.

Option 4: buy an add-in for ArcMap that edits "pure" PostGIS data.

JoshuaBixby · Answer

Have you read PostgreSQL data types supported in ArcGIS?  It contains lots of good information about PostGIS and ArcGIS, including requirements for using PostGIS data types in ArcGIS, with or without SDE involved.

DSICBS · Answer

Hi,

I'm connecting to PostGIS both from PGAdmin and QGIS from my desktop. The real problem is I cannot edit layer from QGIS even I can add and see layer in QGIS.

I want to create a central spatial database that works both ESRI tools and Open Sources tools. Users must read, insert, update and delete all layers from all clients like ArcMap, ArcGIS Server, QGIS or GeoServer.

I tried to change the default storage from ST_GEOMETRY to PG_GEOMETRY, but there is no success to read from all clients.

I really need an answer from ESRI Staff that:

* Is it possible to use native PostGIS functions and geometry type in ArcMap without installing SDE stuff?

Best regards.

Alper.