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:

2

1 Answer 1

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.

8
  • 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! Sep 28, 2018 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. Sep 28, 2018 at 15:49
  • See edits to original post. Sep 29, 2018 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. Oct 1, 2018 at 19:23
  • Yes, the ArcGIS layer/feature class has to be created in ArcGIS first. That was the client's specification. Oct 2, 2018 at 21:49

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