Re: [OSGeo-Discuss] Using ArcGIS Desktop with PostGIS [SEC=UNCLASSIFIED]

2014-07-11 Thread Gavin Fleming

Hi Bruce

I've done fairly  extensive research as this is a very common situation. 
The landscape is quite fluid though.


There are a few third party extensions out there but I haven't had much 
luck with them in a read-write production environment.


Native read support of PostGIS from ArcGIS desktop has been available 
for a few versions now. The clincher is write support. For that you need 
to pay up and as a minimum get ArcGIS Editor (now called Standard). 
ArcGIS ArcView (now called Basic) won't get you write access. And you 
can't get around it with WFS-T either.


So in a nutshell, to write to native PostGIS via a database connection 
or WFS-T you need either ArcGIS Standard ('Editor') or Enterprise 
('ArcInfo') or ArcGIS Server (set up to use native PostGIS geometry).


Gavin

On 11/07/2014 06:56, Bruce Bannerman wrote:

Hi,

Does anyone have any experience using PostGIS as a vector spatial data 
source with ArcGIS Desktop as a client?


I'm particularly interested in our ArcGIS Desktop users being able to 
create, update and delete spatial data managed within a PostGIS 
environment, without the use of ArcSDE or similar middle wear.


Would you be interested in sharing any experiences that you've had 
from implementation to operational use?



We have a mixed spatial environment with both ArcGIS Desktop and open 
source Desktop GIS applications as client tools.


Provided that we can arrive at a good robust solution, I'd like to 
move our ArcGIS Desktop clients away from ArcSDE, and consolidate our 
vector spatial database environment on Postgres / PostGIS.


Bruce



___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss



--
Gavin Fleming
t: 0218620670
w: 0218630660
c: 0845965680
f: 0866164820
Paarl
South Africa
18°59'19.6E 33°44'46.1S

___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] Using ArcGIS Desktop with PostGIS [SEC=UNCLASSIFIED]

2014-07-11 Thread Jo Cook
Hi Gavin and Bruce,

To add to what Gavin said, we recently did a piece of work assessing how to
use PostGIS as a back end for ArcGIS and as well as the fairly major
constraint around writing to the database we also found issues with
case-sensitivity- all database objects (tables, schemas etc)  need to be
lower-case for ArcGIS to see them, and you will need to use different
connection methods (query layers) to view data in tables with null values
in them.

Jo


On Fri, Jul 11, 2014 at 8:29 AM, Gavin Fleming gavinjflem...@gmail.com
wrote:

  Hi Bruce

 I've done fairly  extensive research as this is a very common situation.
 The landscape is quite fluid though.

 There are a few third party extensions out there but I haven't had much
 luck with them in a read-write production environment.

 Native read support of PostGIS from ArcGIS desktop has been available for
 a few versions now. The clincher is write support. For that you need to pay
 up and as a minimum get ArcGIS Editor (now called Standard). ArcGIS ArcView
 (now called Basic) won't get you write access. And you can't get around it
 with WFS-T either.

 So in a nutshell, to write to native PostGIS via a database connection or
 WFS-T you need either ArcGIS Standard ('Editor') or Enterprise ('ArcInfo')
 or ArcGIS Server (set up to use native PostGIS geometry).

 Gavin


 On 11/07/2014 06:56, Bruce Bannerman wrote:

 Hi,

  Does anyone have any experience using PostGIS as a vector spatial data
 source with ArcGIS Desktop as a client?

  I’m particularly interested in our ArcGIS Desktop users being able to
 create, update and delete spatial data managed within a PostGIS
 environment, without the use of ArcSDE or similar middle wear.

  Would you be interested in sharing any experiences that you’ve had from
 implementation to operational use?


  We have a mixed spatial environment with both ArcGIS Desktop and open
 source Desktop GIS applications as client tools.

  Provided that we can arrive at a good robust solution, I’d like to move
 our ArcGIS Desktop clients away from ArcSDE, and consolidate our vector
 spatial database environment on Postgres / PostGIS.

  Bruce



 ___
 Discuss mailing 
 listDiscuss@lists.osgeo.orghttp://lists.osgeo.org/mailman/listinfo/discuss



 --
 Gavin Fleming
 t: 0218620670
 w: 0218630660
 c: 0845965680
 f: 0866164820
 Paarl
 South Africa
 18°59'19.6E 33°44'46.1S


 ___
 Discuss mailing list
 Discuss@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/discuss




-- 
*Jo Cook*
Astun Technology Ltd, The Coach House, 17 West Street, Epsom, Surrey, KT18
7RL, UK
t:+44 7930 524 155
iShare - Data integration and publishing platform
http://www.isharemaps.com/

*

 Company registration no. 5410695. Registered in England and Wales.
Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
864201149.
___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] Using ArcGIS Desktop with PostGIS [SEC=UNCLASSIFIED]

2014-07-11 Thread Bruce Bannerman
Many thanks Gavin.

We have the required licenses, so that will be OK.

From memory, ESRI's support is a few versions of Postgres and PostGIS behind 
the current releases.

Have you had any luck with using versions of Postgres and PostGIS higher than 
ESRI claim to support.

We're running ArcGIS 10.1 and the new Postgres / PostGIS environment that we're 
looking at is 9.3.4 with PostGIS 2.1.3.

We'll be running our own tests, but it would useful to have an idea of 
potential issues.



If anyone would like me to move this thread off Discuss, please let me know. 
However I suspect that it may be of interest to a number of sites.

Bruce



From: discuss-boun...@lists.osgeo.org [discuss-boun...@lists.osgeo.org] On 
Behalf Of Gavin Fleming [gavinjflem...@gmail.com]
Sent: Friday, 11 July 2014 5:29 PM
To: discuss@lists.osgeo.org
Subject: Re: [OSGeo-Discuss] Using ArcGIS Desktop with PostGIS  
[SEC=UNCLASSIFIED]

Hi Bruce

I've done fairly  extensive research as this is a very common situation. The 
landscape is quite fluid though.

There are a few third party extensions out there but I haven't had much luck 
with them in a read-write production environment.

Native read support of PostGIS from ArcGIS desktop has been available for a few 
versions now. The clincher is write support. For that you need to pay up and as 
a minimum get ArcGIS Editor (now called Standard). ArcGIS ArcView (now called 
Basic) won't get you write access. And you can't get around it with WFS-T 
either.

So in a nutshell, to write to native PostGIS via a database connection or WFS-T 
you need either ArcGIS Standard ('Editor') or Enterprise ('ArcInfo') or ArcGIS 
Server (set up to use native PostGIS geometry).

Gavin

On 11/07/2014 06:56, Bruce Bannerman wrote:
Hi,

Does anyone have any experience using PostGIS as a vector spatial data source 
with ArcGIS Desktop as a client?

I’m particularly interested in our ArcGIS Desktop users being able to create, 
update and delete spatial data managed within a PostGIS environment, without 
the use of ArcSDE or similar middle wear.

Would you be interested in sharing any experiences that you’ve had from 
implementation to operational use?


We have a mixed spatial environment with both ArcGIS Desktop and open source 
Desktop GIS applications as client tools.

Provided that we can arrive at a good robust solution, I’d like to move our 
ArcGIS Desktop clients away from ArcSDE, and consolidate our vector spatial 
database environment on Postgres / PostGIS.

Bruce




___
Discuss mailing list
Discuss@lists.osgeo.orgmailto:Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss



--
Gavin Fleming
t: 0218620670
w: 0218630660
c: 0845965680
f: 0866164820
Paarl
South Africa
18°59'19.6E 33°44'46.1S
___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss


Re: [OSGeo-Discuss] Using ArcGIS Desktop with PostGIS [SEC=UNCLASSIFIED]

2014-07-11 Thread Jeff McKenna
Bruce, there is no issue with using this mailing list for discussing
interacting with our open tools and others...it is VERY interesting and
please do continue and share.

-jeff



On 2014-07-11, 9:01 AM, Bruce Bannerman wrote:
 Many thanks Gavin.
 
 We have the required licenses, so that will be OK.
 
From memory, ESRI's support is a few versions of Postgres and PostGIS behind 
the current releases.
 
 Have you had any luck with using versions of Postgres and PostGIS higher than 
 ESRI claim to support.
 
 We're running ArcGIS 10.1 and the new Postgres / PostGIS environment that 
 we're looking at is 9.3.4 with PostGIS 2.1.3.
 
 We'll be running our own tests, but it would useful to have an idea of 
 potential issues.
 
 
 
 If anyone would like me to move this thread off Discuss, please let me know. 
 However I suspect that it may be of interest to a number of sites.
 
 Bruce
 
 
 
 From: discuss-boun...@lists.osgeo.org [discuss-boun...@lists.osgeo.org] On 
 Behalf Of Gavin Fleming [gavinjflem...@gmail.com]
 Sent: Friday, 11 July 2014 5:29 PM
 To: discuss@lists.osgeo.org
 Subject: Re: [OSGeo-Discuss] Using ArcGIS Desktop with PostGIS  
 [SEC=UNCLASSIFIED]
 
 Hi Bruce
 
 I've done fairly  extensive research as this is a very common situation. The 
 landscape is quite fluid though.
 
 There are a few third party extensions out there but I haven't had much luck 
 with them in a read-write production environment.
 
 Native read support of PostGIS from ArcGIS desktop has been available for a 
 few versions now. The clincher is write support. For that you need to pay up 
 and as a minimum get ArcGIS Editor (now called Standard). ArcGIS ArcView (now 
 called Basic) won't get you write access. And you can't get around it with 
 WFS-T either.
 
 So in a nutshell, to write to native PostGIS via a database connection or 
 WFS-T you need either ArcGIS Standard ('Editor') or Enterprise ('ArcInfo') or 
 ArcGIS Server (set up to use native PostGIS geometry).
 
 Gavin
 
 On 11/07/2014 06:56, Bruce Bannerman wrote:
 Hi,
 
 Does anyone have any experience using PostGIS as a vector spatial data source 
 with ArcGIS Desktop as a client?
 
 I’m particularly interested in our ArcGIS Desktop users being able to create, 
 update and delete spatial data managed within a PostGIS environment, without 
 the use of ArcSDE or similar middle wear.
 
 Would you be interested in sharing any experiences that you’ve had from 
 implementation to operational use?
 
 
 We have a mixed spatial environment with both ArcGIS Desktop and open source 
 Desktop GIS applications as client tools.
 
 Provided that we can arrive at a good robust solution, I’d like to move our 
 ArcGIS Desktop clients away from ArcSDE, and consolidate our vector spatial 
 database environment on Postgres / PostGIS.
 
 Bruce
 
 
 
 
 ___
 Discuss mailing list
 Discuss@lists.osgeo.orgmailto:Discuss@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/discuss
 
 
 
 --
 Gavin Fleming
 t: 0218620670
 w: 0218630660
 c: 0845965680
 f: 0866164820
 Paarl
 South Africa
 18°59'19.6E 33°44'46.1S
 ___
 Discuss mailing list
 Discuss@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/discuss
 


-- 
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/
___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss


Re: [OSGeo-Discuss] Using ArcGIS Desktop with PostGIS [SEC=UNCLASSIFIED]

2014-07-11 Thread Newcomb, Doug
+1 Sharing of practical experiences on interoperability is always
worthwhile.

Doug


On Fri, Jul 11, 2014 at 8:10 AM, Jeff McKenna jmcke...@gatewaygeomatics.com
 wrote:

 Bruce, there is no issue with using this mailing list for discussing
 interacting with our open tools and others...it is VERY interesting and
 please do continue and share.

 -jeff



 On 2014-07-11, 9:01 AM, Bruce Bannerman wrote:
  Many thanks Gavin.
 
  We have the required licenses, so that will be OK.
 
 From memory, ESRI's support is a few versions of Postgres and PostGIS
 behind the current releases.
 
  Have you had any luck with using versions of Postgres and PostGIS higher
 than ESRI claim to support.
 
  We're running ArcGIS 10.1 and the new Postgres / PostGIS environment
 that we're looking at is 9.3.4 with PostGIS 2.1.3.
 
  We'll be running our own tests, but it would useful to have an idea of
 potential issues.
 
 
 
  If anyone would like me to move this thread off Discuss, please let me
 know. However I suspect that it may be of interest to a number of sites.
 
  Bruce
 
 
  
  From: discuss-boun...@lists.osgeo.org [discuss-boun...@lists.osgeo.org]
 On Behalf Of Gavin Fleming [gavinjflem...@gmail.com]
  Sent: Friday, 11 July 2014 5:29 PM
  To: discuss@lists.osgeo.org
  Subject: Re: [OSGeo-Discuss] Using ArcGIS Desktop with PostGIS
  [SEC=UNCLASSIFIED]
 
  Hi Bruce
 
  I've done fairly  extensive research as this is a very common situation.
 The landscape is quite fluid though.
 
  There are a few third party extensions out there but I haven't had much
 luck with them in a read-write production environment.
 
  Native read support of PostGIS from ArcGIS desktop has been available
 for a few versions now. The clincher is write support. For that you need to
 pay up and as a minimum get ArcGIS Editor (now called Standard). ArcGIS
 ArcView (now called Basic) won't get you write access. And you can't get
 around it with WFS-T either.
 
  So in a nutshell, to write to native PostGIS via a database connection
 or WFS-T you need either ArcGIS Standard ('Editor') or Enterprise
 ('ArcInfo') or ArcGIS Server (set up to use native PostGIS geometry).
 
  Gavin
 
  On 11/07/2014 06:56, Bruce Bannerman wrote:
  Hi,
 
  Does anyone have any experience using PostGIS as a vector spatial data
 source with ArcGIS Desktop as a client?
 
  I’m particularly interested in our ArcGIS Desktop users being able to
 create, update and delete spatial data managed within a PostGIS
 environment, without the use of ArcSDE or similar middle wear.
 
  Would you be interested in sharing any experiences that you’ve had from
 implementation to operational use?
 
 
  We have a mixed spatial environment with both ArcGIS Desktop and open
 source Desktop GIS applications as client tools.
 
  Provided that we can arrive at a good robust solution, I’d like to move
 our ArcGIS Desktop clients away from ArcSDE, and consolidate our vector
 spatial database environment on Postgres / PostGIS.
 
  Bruce
 
 
 
 
  ___
  Discuss mailing list
  Discuss@lists.osgeo.orgmailto:Discuss@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/discuss
 
 
 
  --
  Gavin Fleming
  t: 0218620670
  w: 0218630660
  c: 0845965680
  f: 0866164820
  Paarl
  South Africa
  18°59'19.6E 33°44'46.1S
  ___
  Discuss mailing list
  Discuss@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/discuss
 


 --
 Jeff McKenna
 MapServer Consulting and Training Services
 http://www.gatewaygeomatics.com/
 ___
 Discuss mailing list
 Discuss@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/discuss




-- 
Doug Newcomb
USFWS
Raleigh, NC
919-856-4520 ext. 14 doug_newc...@fws.gov
-
The opinions I express are my own and are not representative of the
official policy of the U.S.Fish and Wildlife Service or Dept. of the
Interior.   Life is too short for undocumented, proprietary data formats.
___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] Using ArcGIS Desktop with PostGIS [SEC=UNCLASSIFIED]

2014-07-11 Thread Randal Hale
I've migrated a forestry client to postgis out of shapefiles and file 
based geodatabases. I'm running:


 * Workstation is Ubuntu 14.04 with postgres 9.3.4 and postgis 2.1.3
   (ubuntugis packages)
 * ArcGIS 10.2.2 in a win7 VM
 * Downloaded the Postgres libraries from ESRI. The claims are that it
   only supported as high as postgres 9.2.x (use the 32 bit libraries)
 * QGIS 2.4 (osqeo4w and ubuntugis)

It worked quite well. I connected to postgres through ArcGIS and read 
all I needed to out of the database. The kicker is write and I'm not 
sure if that will ever happen. I didn't try to import into postgres. I 
still don't entirely understand the definition query explanation with 
arcgis. That's on the reading list for today.


Same with Spatialite (and I seem to have hit or miss luck with that) - 
sometimes ArcGIS reads and sometimes it doesn't. You can import into 
spatialite from ArcGIS.


So way back when we would have projects done in Arc/INFO workstation and 
the project area would be USGS quad based.


 * Everyone worked in a workspace.
 * lots of discussion and people making sure no one butted heads and
   edited in the same workspace as someone else.
 * End of the project was a weeks worth of consolidation, snapping,
   editing, and joy.

I imagine the same thing happening currently.

 * Postgres is the main data repository
 * data is handed off to arcgis clients in a systematic way.
 * Editing occurs - edits are consolidated back into postgres through
   qgis or some magic scripted button.

And we're partying like it's 1997 but no SDEbut it works. We used 
this methodology until 2002 and churned out a ton of good data.


Hope that helps and doesn't repeat anything from below. It still doesn't 
get anyone to the magic editing part though.


Randy


On 07/11/2014 08:25 AM, Newcomb, Doug wrote:
+1 Sharing of practical experiences on interoperability is always 
worthwhile.


Doug


On Fri, Jul 11, 2014 at 8:10 AM, Jeff McKenna 
jmcke...@gatewaygeomatics.com mailto:jmcke...@gatewaygeomatics.com 
wrote:


Bruce, there is no issue with using this mailing list for discussing
interacting with our open tools and others...it is VERY
interesting and
please do continue and share.

-jeff



On 2014-07-11, 9:01 AM, Bruce Bannerman wrote:
 Many thanks Gavin.

 We have the required licenses, so that will be OK.

From memory, ESRI's support is a few versions of Postgres and
PostGIS behind the current releases.

 Have you had any luck with using versions of Postgres and
PostGIS higher than ESRI claim to support.

 We're running ArcGIS 10.1 and the new Postgres / PostGIS
environment that we're looking at is 9.3.4 with PostGIS 2.1.3.

 We'll be running our own tests, but it would useful to have an
idea of potential issues.



 If anyone would like me to move this thread off Discuss, please
let me know. However I suspect that it may be of interest to a
number of sites.

 Bruce


 
 From: discuss-boun...@lists.osgeo.org
mailto:discuss-boun...@lists.osgeo.org
[discuss-boun...@lists.osgeo.org
mailto:discuss-boun...@lists.osgeo.org] On Behalf Of Gavin
Fleming [gavinjflem...@gmail.com mailto:gavinjflem...@gmail.com]
 Sent: Friday, 11 July 2014 5:29 PM
 To: discuss@lists.osgeo.org mailto:discuss@lists.osgeo.org
 Subject: Re: [OSGeo-Discuss] Using ArcGIS Desktop with PostGIS
 [SEC=UNCLASSIFIED]

 Hi Bruce

 I've done fairly  extensive research as this is a very common
situation. The landscape is quite fluid though.

 There are a few third party extensions out there but I haven't
had much luck with them in a read-write production environment.

 Native read support of PostGIS from ArcGIS desktop has been
available for a few versions now. The clincher is write support.
For that you need to pay up and as a minimum get ArcGIS Editor
(now called Standard). ArcGIS ArcView (now called Basic) won't get
you write access. And you can't get around it with WFS-T either.

 So in a nutshell, to write to native PostGIS via a database
connection or WFS-T you need either ArcGIS Standard ('Editor') or
Enterprise ('ArcInfo') or ArcGIS Server (set up to use native
PostGIS geometry).

 Gavin

 On 11/07/2014 06:56, Bruce Bannerman wrote:
 Hi,

 Does anyone have any experience using PostGIS as a vector
spatial data source with ArcGIS Desktop as a client?

 I'm particularly interested in our ArcGIS Desktop users being
able to create, update and delete spatial data managed within a
PostGIS environment, without the use of ArcSDE or similar middle wear.

 Would you be interested in sharing any experiences that you've
had from implementation to operational use?


 We have a mixed spatial environment 

Re: [OSGeo-Discuss] Using ArcGIS Desktop with PostGIS [SEC=UNCLASSIFIED]

2014-07-11 Thread Andrew Ross

Dear Bruce,

Not sure if this is interesting or not. In my previous role, my team  I 
worked on adding ArcGIS support for Ingres, which is also open source 
and similar to Postgres/PostGIS. I learned quite a bit during the 
process. I appreciated that Esri offers a very useful layer to plugin  
extend ArcMap/ArcCatalog, etc. You can code in Python, .NET, or Java.


Despite being warned by many that we were crazy to even try to do this, 
after investing to grok Esri's architecture, we got it done in only a 
few months. The end result was pretty good... full read/write and most 
major features worked well. It didn't require ArcSDE.


This wasn't every single feature of course.  For example, we didn't do 
long transaction support as it wasn't that urgent for our customer at 
the time  was going to be a lot of work. From what I understand from 
the outside, the team has nudged it along over the years fixing up bugs 
and edge cases we didn't consider in the first release.


At the time, we took a brief look to understand the landscape and there 
seemed to be some fairly significant limitations in ArcGIS support for 
PostGIS. I'm not sure if that's changed since then as it has been a 
couple of years.


The team has disbanded since, but if there were interest in engaging any 
of them, I'd be happy to make introductions. I also know of companies 
that do work in this space.


Andrew

On 11/07/14 00:56, Bruce Bannerman wrote:

Hi,

Does anyone have any experience using PostGIS as a vector spatial data 
source with ArcGIS Desktop as a client?


I'm particularly interested in our ArcGIS Desktop users being able to 
create, update and delete spatial data managed within a PostGIS 
environment, without the use of ArcSDE or similar middle wear.


Would you be interested in sharing any experiences that you've had 
from implementation to operational use?



We have a mixed spatial environment with both ArcGIS Desktop and open 
source Desktop GIS applications as client tools.


Provided that we can arrive at a good robust solution, I'd like to 
move our ArcGIS Desktop clients away from ArcSDE, and consolidate our 
vector spatial database environment on Postgres / PostGIS.


Bruce



___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] Using ArcGIS Desktop with PostGIS [SEC=UNCLASSIFIED]

2014-07-11 Thread Bruce Bannerman
Hi Andrew,

I admired the work that your former team was doing. It was a pity that 
sufficient time and resourcing was not allocated to see this potential work 
through to fruition.

People often under-estimate how much effort is required to sponsor an open 
source project, and allow sufficient time for a self-sustaining community to 
evolve.

In our case, we will not be able to add another database platform to our suite. 
We're actually reducing and trying to consolidate our technology base.

Therefore we would not be able to look at Ingres as a platform, even though it 
has the same roots as Postgres.

Bruce


From: discuss-boun...@lists.osgeo.org [discuss-boun...@lists.osgeo.org] On 
Behalf Of Andrew Ross [andrew.r...@eclipse.org]
Sent: Saturday, 12 July 2014 2:11 AM
To: discuss@lists.osgeo.org
Subject: Re: [OSGeo-Discuss] Using ArcGIS Desktop with PostGIS  
[SEC=UNCLASSIFIED]

Dear Bruce,

Not sure if this is interesting or not. In my previous role, my team  I worked 
on adding ArcGIS support for Ingres, which is also open source and similar to 
Postgres/PostGIS. I learned quite a bit during the process. I appreciated that 
Esri offers a very useful layer to plugin  extend ArcMap/ArcCatalog, etc. You 
can code in Python, .NET, or Java.

Despite being warned by many that we were crazy to even try to do this, after 
investing to grok Esri's architecture, we got it done in only a few months. The 
end result was pretty good... full read/write and most major features worked 
well. It didn't require ArcSDE.

This wasn't every single feature of course.  For example, we didn't do long 
transaction support as it wasn't that urgent for our customer at the time  was 
going to be a lot of work. From what I understand from the outside, the team 
has nudged it along over the years fixing up bugs and edge cases we didn't 
consider in the first release.

At the time, we took a brief look to understand the landscape and there seemed 
to be some fairly significant limitations in ArcGIS support for PostGIS. I'm 
not sure if that's changed since then as it has been a couple of years.

The team has disbanded since, but if there were interest in engaging any of 
them, I'd be happy to make introductions. I also know of companies that do work 
in this space.

Andrew

On 11/07/14 00:56, Bruce Bannerman wrote:
Hi,

Does anyone have any experience using PostGIS as a vector spatial data source 
with ArcGIS Desktop as a client?

I’m particularly interested in our ArcGIS Desktop users being able to create, 
update and delete spatial data managed within a PostGIS environment, without 
the use of ArcSDE or similar middle wear.

Would you be interested in sharing any experiences that you’ve had from 
implementation to operational use?


We have a mixed spatial environment with both ArcGIS Desktop and open source 
Desktop GIS applications as client tools.

Provided that we can arrive at a good robust solution, I’d like to move our 
ArcGIS Desktop clients away from ArcSDE, and consolidate our vector spatial 
database environment on Postgres / PostGIS.

Bruce


___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss


Re: [OSGeo-Discuss] Using ArcGIS Desktop with PostGIS [SEC=UNCLASSIFIED]

2014-07-11 Thread rburhum
Hello Bruce,

I have not worked on this since January of last year, but I have an ArcGIS
Extension I wrote that enables ArcMap to read/write to any GDAL datasource.
I think if you recompile it for 10.2 it should work - even if you only have
the ArcGIS Basic license.

https://github.com/rburhum/arcgis-ogr

Contributions are welcomed.

- Ragi



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Using-ArcGIS-Desktop-with-PostGIS-SEC-UNCLASSIFIED-tp5150586p5150734.html
Sent from the OSGeo Discuss mailing list archive at Nabble.com.
___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss