Editing PostGIS spatial data using ArcGIS

[Joel Masselink]

Hi CUGOS,

I'm looking at ways to directly edit PostGIS spatial data in an Esri ecosystem. Out of the box, ArcGIS Desktop can only read PostGIS spatial data. 

1) Does anyone have experience in working around this issue and directly editing PostGIS? Are there solutions from within Desktop? 

(For example, perhaps two-way replication is the answer - FileGDB (local) edits pushed to the server (PostGIS) and so forth? Though this may require ArcGIS Server...?)

2) If not, are there specialized tools or extensions which allow this? I've come across GISquirrel but thought to ask the community before going down a rabbit hole. 

Thanks in advance!

Cheers,

Joel

[Webb Sprague]

I know you said ESRI ecosystem, but ... QGIS edits postgis layers beautifully.

--
You received this message because you are subscribed to the Google Groups "Cascadia Users of Geospatial Open Source" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cugos+un...@googlegroups.com.
To post to this group, send email to cu...@googlegroups.com.
Visit this group at http://groups.google.com/group/cugos.
For more options, visit https://groups.google.com/d/optout.

[Joel]

​Right, I'm looking for an Esri-based solution...​

[Chris Barker - NOAA Federal]

On Nov 20, 2015, at 7:29 AM, Joel <jmass...@gmail.com> wrote:

​Right, I'm looking for an Esri-based solution...​

Could you run some Python scripts from within arc -- you should be able to do whatever you want from Python.

CHB

[Nick Peihl]

Hi Joel,

You can view data from PostGIS in ArcMap using Query Layers (http://resources.arcgis.com/en/help/main/10.2/index.html#//00s50000000n000000), but you cannot edit it. Editing PostGIS in ArcMap requires you to register the PostGIS database as an enterprise geodatabase (http://resources.arcgis.com/en/help/main/10.2/index.html#/A_quick_tour_of_geodatabases_in_PostgreSQL/002p000000pt000000/). But you may need an Advanced ArcMap license to do so.

In my experience there are no other options for editing PostGIS in ArcGIS.

Nick Peihl

[Ryan Dalton]

Take a look on http://gis.stackexchange.com/questions/tagged/arcgis-desktop+postgis, as there are a number of discussions about using PostGIS with ArcMap.

Two that stuck out were:

http://gis.stackexchange.com/questions/140978/how-to-edit-a-postgis-database-using-arcgis-for-desktop-add-in-extension-no-ar

http://gis.stackexchange.com/questions/55094/arcgis-10-1-edit-postgresql-layer

One product you should check out is "ST-Links SpatialKit".  I have never used it, but I have heard about it numerous times, and it is also mentioned in above links.

http://www.st-links.com/Pages/default.aspx

Ryan

[Jesse Langdon]

Hi Joel,

ZigGIS use to be the go-to solution for directly editing PostGIS data in ArcGIS, but it's sadly defunct now.  Probably one of the better solutions I've run across is called GISquirrel (https://www.gisquirrel.com).  It's an extension that allows direct editing of PostGIS tables in ArcMap.  A single license is relatively inexpensive ( £150.00, ~$230), and it looks very promising.  The name is quite unfortunate though, in my opinion.   I've never had the guts to go to my boss and say "Let's buy some GISquirrel licenses!"

 While it's not FOSS, it's a hell of lot less money than ESRI's ridiculously priced Data Interoperability extension ($2k?)  Full disclosure, I have not actually used it.  As was mentioned by Webb, if I need to do manual data editing with PostGIS, I just use QGIS.

Good luck!
Jesse

[Jesse Langdon]

Oops, just realized you already mentioned GISquirrel in your original post.  My apologies for being redundant!

Jesse


On Thursday, November 19, 2015 at 1:14:23 PM UTC-8, Joel Masselink wrote:

[Joel]

​​

Thanks all for your responses. I really appreciate it. Here are compiled responses:

----------------------------------------------------------------------------------------

Problem (similar to this from GIS StackExchange):

I'm looking at ways to directly edit PostGIS spatial data in an Esri ecosystem. Out of the box, ArcGIS Desktop can only read PostGIS spatial data. You can view data from PostGIS in ArcMap using Query Layers (http://resources.arcgis.com/en/help/main/10.2/index.html#//00s50000000n000000), but you cannot edit it.

Solutions:

Editing PostGIS in ArcMap requires you to register the PostGIS database as an enterprise geodatabase (http://resources.arcgis.com/en/help/main/10.2/index.html#/A_quick_tour_of_geodatabases_in_PostgreSQL/002p000000pt000000/).

ArcGIS Server, ArcSDE, or Data Interoperability extensions licenses (all very costly) may be required for editing PostGIS spatial data. If you have an Enterprise install of ArcServer, then you can install SDE for Postgres, which 'Esri-enables' Postgres and you can read/write. ArcServer seems to be required, or alternatively the following third-party products claim to permit read/write functionality:

Third-party products:

GISquirrel £150.00 = $228

GISquirrel allows you to view, edit and manage spatial data from Microsoft SQL Server or PostGIS in ArcGIS Desktop, without SDE, Server, ArcEditor or ArcInfo licences.

ST-Links SpatialKit $288 CAN = $216

ArcMap Extension for directly connecting to spatial databases.

SpatialKit 4.0 for ArcMap 10.0 / 10.1 / 10.2 is available for download.

No ArcSDE, No ArcInfo, No ArcGIS Server.

Work with Postgresql / PostGIS, SQL Server 2008 / 2008 R2 spatial databases

• Seamlessly integrates with ArcMap

• Use spatial tables and / or views as ArcMap Feature layers

• Edit database spatial tables / views within ArcMap Editing Session

• Support multi-connections, multi-databases, and various database systems

----------------------------------------------------------------------------------------

​Cheers,

Joel

[Alex M]

Anyone tried using a WFS-T server in between Arc and Postgis?
Geosever or TinyOWS(Mapserver)?

-Alex

On 11/20/2015 09:47 AM, Joel wrote:
> ​​
> Thanks all for your responses. I really appreciate it. Here are compiled
> responses:
> ----------------------------------------------------------------------------------------
>
> Problem (similar to this from GIS StackExchange

> <http://gis.stackexchange.com/questions/140978/how-to-edit-a-postgis-database-using-arcgis-for-desktop-add-in-extension-no-ar?rq=1>
> ):

>
> I'm looking at ways to directly edit PostGIS spatial data in an Esri
> ecosystem. Out of the box, ArcGIS Desktop can only read PostGIS spatial
> data. You can view data from PostGIS in ArcMap using Query Layers (
> http://resources.arcgis.com/en/help/main/10.2/index.html#//00s50000000n000000),
> but you cannot edit it.
>
> Solutions:
>
> Editing PostGIS in ArcMap requires you to register the PostGIS database as
> an enterprise geodatabase (
> http://resources.arcgis.com/en/help/main/10.2/index.html#/A_quick_tour_of_geodatabases_in_PostgreSQL/002p000000pt000000/).
>
>
> ArcGIS Server, ArcSDE, or Data Interoperability extensions licenses (all
> very costly) may be required for editing PostGIS spatial data. If you have
> an Enterprise install of ArcServer, then you can install SDE for Postgres,
> which 'Esri-enables' Postgres and you can read/write. ArcServer seems to be
> required, or alternatively the following third-party products claim to
> permit read/write functionality:
>
>
> Third-party products:
>

> GISquirrel <https://www.gisquirrel.com/home>£150.00 = $228

>
> GISquirrel allows you to view, edit and manage spatial data from Microsoft
> SQL Server or PostGIS in ArcGIS Desktop, without SDE, Server, ArcEditor or
> ArcInfo licences.
>

> ST-Links SpatialKit <http://www.st-links.com/Pages/default.aspx>$288 CAN =

> $216
>
> ArcMap Extension for directly connecting to spatial databases.
>
> SpatialKit 4.0 for ArcMap 10.0 / 10.1 / 10.2 is available for download.
>
> No ArcSDE, No ArcInfo, No ArcGIS Server.
>
> Work with Postgresql / PostGIS, SQL Server 2008 / 2008 R2 spatial databases
>

> -
>
> Seamlessly integrates with ArcMap
> -

>
> Use spatial tables and / or views as ArcMap Feature layers

> -

>
> Edit database spatial tables / views within ArcMap Editing Session

> - Support multi-connections, multi-databases, and various database

>>>>>> I've come across GISquirrel <https://www.gisquirrel.com/home>but

[TC Haddad]

I could be wildly wrong, but the last time I looked into it, it looked as though ESRI does not support WFS-T?

[R. Todd Slind]

Any interest in creating a CUGOS Slack Team so we could separate the ironic Esri support requests into a separate channel? 

[Alexander Miranda]

There already is a freenode channel (#cugos) on IRC.

[Alex Mandel]

FYI OSGeo sys admin is research web to irc clients to make it easier to use.

-Alex