idea Enable Editing of native PostGIS geometry without enterprise geodatabase (and license) in ArcGIS Pro Ideas

Enable Editing of native PostGIS geometry without enterprise geodatabase (and license)

MikeDolbow — Fri, 15 Dec 2023 15:34:26 GMT

Under current capabilities (as of 2023-12-15), it is not possible to edit spatial tables in a PostgreSQL database with native PostGIS geometry unless you first undertake the "Create Enterprise Geodatabase" process. (And that process requires an expensive enterprise license.)

This is true despite the fact that Esri expresses "support" for "using" native PostGIS geometry in this help section. It is true you can read such spatial tables (via query layer), and you can even load them in (via geoprocessing), but you cannot edit them. So that "support" is fairly limited when it comes to a core capability.

True, there are many cases when an "Enterprise Geodatabase" is advantageous. But there are other cases where it is not required and introduces unnecessary overhead. For very basic spatial data management, true support for PostgreSQL and PostGIS geometry would include editing from Pro.

Re: Enable Editing of native PostGIS geometry without enterprise geodatabase (and license)

rhys-kdrm — Sat, 03 May 2025 00:58:58 GMT

@MikeDolbow - there is a workaround to edit Postgres data that I use without having ArcGIS Enterprise. I use Python and FastAPI to create an editable feature service. Then I add the feature service to ArcGIS Pro, and the data is editable, even though it is in Postgres. These posts I wrote may help: https://www.linkedin.com/pulse/web-mapping-apps-postgres-arcgis-without-enterprise-rhys-donoghue and https://www.linkedin.com/pulse/how-load-geojson-from-postgres-using-bounding-box-arcgis-donoghue. At some stage I am planning on making my code open source. I am bit too busy for that at the moment though.

Re: Enable Editing of native PostGIS geometry without enterprise geodatabase (and license)

MikeDolbow — Tue, 06 May 2025 15:36:16 GMT

Thanks @rhys-kdrm - I've heard about similar workarounds and I might pursue them. For now, I'm pretty comfortable either doing all my editing in QGIS or "offline" in Pro (then loading the data into the database with ArcPy).

Nevertheless, I'd still like to see this implemented.

Re: Enable Editing of native PostGIS geometry without enterprise geodatabase (and license)

PatricePineaultWSP — Thu, 16 Oct 2025 13:18:30 GMT

I have used GISquirrel successfully in the past.