1

I'm using ArcGIS Desktop 10.6.1 with PostgreSQL 10.3/PostGIS 2.4 and would like to edit PostgreSQL polygon features regardless of client (QGIS/ArcGIS desktop) without having to create an ArcGIS Enterprise Geodatabase.

How can I create a PostGIS database where edits are possible in ArcGIS Desktop?

Note as a test with a different method - I've created a Postgres database (with PostGIS extension enabled), then created an ESRI Enterprise geodatabase on top of this, created a "data_manager" user/schema and proceeded to import a layer (with pg geometry keyword) where I can edit in ArcGIS and QGIS. However if a QGIS user creates a spatially enabled table in the data_manager schema, it's not registered with the geodatabase in ArcGIS.

Old/related posts (no longer relevant) due to changes of read/write at ESRI Desktop 10.4 then again at 10.6:

marked as duplicate by PolyGeo arcgis-desktop Sep 28 '18 at 0:49

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1

Linked are three files that explain various aspects of using PostGIS tables with QGIS (referred to as 'OpenGIS' in the documents):

The Register Layer with ArcGIS is a custom Python module incorporated in the Q startup.py file. You cannot reconcile versioned edits unless they are committed to the default base table(s) upon editing exit.

  • This is excellent. Let me give this a shot and see if this answers the question. I've already done quite a bit of testing, and (almost) come to the conclusion this won't be possible (or if it is, changes to delta tables from different clients will cause additional problems). Thanks! – rustyfisher Sep 28 '18 at 12:41
  • The 3rd pdf, step 3 has a very interesting functionality: "Right-click on the testpoint layer in the Layers Panel and select the Register Layer with ArcGIS option" which I can't find any in QGIS. – rustyfisher Sep 28 '18 at 15:49
  • See edits to original post. – Rudy Stricklan Sep 29 '18 at 1:34
  • Thanks Rudy - was able to get this implemented without too much effort. The one thing I realized mid way through, is this is registering a layer with QGIS, not registering a layer with ArcGIS. I'm not quite sure how this would be better than simply changing the configuration keyword from default to "PG geometry". I guess maybe it works if the ArcGIS user forgets to do so? More so - I'm after if an QGIS user creates a table within the Postgres geodatabase, the ArcGIS user needs to be able register and write to that table. – rustyfisher Oct 1 '18 at 19:23
  • Yes, the ArcGIS layer/feature class has to be created in ArcGIS first. That was the client's specification. – Rudy Stricklan Oct 2 '18 at 21:49

Not the answer you're looking for? Browse other questions tagged or ask your own question.