<div dir="ltr">+1 Sharing of practical experiences on interoperability is always worthwhile. <div><br></div><div>Doug</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Jul 11, 2014 at 8:10 AM, Jeff McKenna <span dir="ltr"><<a href="mailto:jmckenna@gatewaygeomatics.com" target="_blank">jmckenna@gatewaygeomatics.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Bruce, there is no issue with using this mailing list for discussing<br>
interacting with our open tools and others...it is VERY interesting and<br>
please do continue and share.<br>
<br>
-jeff<br>
<div class="HOEnZb"><div class="h5"><br>
<br>
<br>
On 2014-07-11, 9:01 AM, Bruce Bannerman wrote:<br>
> Many thanks Gavin.<br>
><br>
> We have the required licenses, so that will be OK.<br>
><br>
>>From memory, ESRI's support is a few versions of Postgres and PostGIS behind the current releases.<br>
><br>
> Have you had any luck with using versions of Postgres and PostGIS higher than ESRI claim to support.<br>
><br>
> 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.<br>
><br>
> We'll be running our own tests, but it would useful to have an idea of potential issues.<br>
><br>
><br>
><br>
> 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.<br>
><br>
> Bruce<br>
><br>
><br>
> ________________________________________<br>
> From: <a href="mailto:discuss-bounces@lists.osgeo.org">discuss-bounces@lists.osgeo.org</a> [<a href="mailto:discuss-bounces@lists.osgeo.org">discuss-bounces@lists.osgeo.org</a>] On Behalf Of Gavin Fleming [<a href="mailto:gavinjfleming@gmail.com">gavinjfleming@gmail.com</a>]<br>
> Sent: Friday, 11 July 2014 5:29 PM<br>
> To: <a href="mailto:discuss@lists.osgeo.org">discuss@lists.osgeo.org</a><br>
> Subject: Re: [OSGeo-Discuss] Using ArcGIS Desktop with PostGIS [SEC=UNCLASSIFIED]<br>
><br>
> Hi Bruce<br>
><br>
> I've done fairly extensive research as this is a very common situation. The landscape is quite fluid though.<br>
><br>
> There are a few third party extensions out there but I haven't had much luck with them in a read-write production environment.<br>
><br>
> 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.<br>
><br>
> 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).<br>
><br>
> Gavin<br>
><br>
> On 11/07/2014 06:56, Bruce Bannerman wrote:<br>
> Hi,<br>
><br>
> Does anyone have any experience using PostGIS as a vector spatial data source with ArcGIS Desktop as a client?<br>
><br>
> 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.<br>
><br>
> Would you be interested in sharing any experiences that you’ve had from implementation to operational use?<br>
><br>
><br>
> We have a mixed spatial environment with both ArcGIS Desktop and open source Desktop GIS applications as client tools.<br>
><br>
> 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.<br>
><br>
> Bruce<br>
><br>
><br>
><br>
><br>
> _______________________________________________<br>
> Discuss mailing list<br>
> <a href="mailto:Discuss@lists.osgeo.org">Discuss@lists.osgeo.org</a><mailto:<a href="mailto:Discuss@lists.osgeo.org">Discuss@lists.osgeo.org</a>><br>
> <a href="http://lists.osgeo.org/mailman/listinfo/discuss" target="_blank">http://lists.osgeo.org/mailman/listinfo/discuss</a><br>
><br>
><br>
><br>
> --<br>
> Gavin Fleming<br>
> t: 0218620670<br>
> w: 0218630660<br>
> c: 0845965680<br>
> f: 0866164820<br>
> Paarl<br>
> South Africa<br>
> 18°59'19.6"E 33°44'46.1"S<br>
> _______________________________________________<br>
> Discuss mailing list<br>
> <a href="mailto:Discuss@lists.osgeo.org">Discuss@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/mailman/listinfo/discuss" target="_blank">http://lists.osgeo.org/mailman/listinfo/discuss</a><br>
><br>
<br>
<br>
</div></div><span class="HOEnZb"><font color="#888888">--<br>
Jeff McKenna<br>
MapServer Consulting and Training Services<br>
<a href="http://www.gatewaygeomatics.com/" target="_blank">http://www.gatewaygeomatics.com/</a><br>
</font></span><div class="HOEnZb"><div class="h5">_______________________________________________<br>
Discuss mailing list<br>
<a href="mailto:Discuss@lists.osgeo.org">Discuss@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/discuss" target="_blank">http://lists.osgeo.org/mailman/listinfo/discuss</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div>Doug Newcomb</div><div>USFWS</div><div>Raleigh, NC</div><div>919-856-4520 ext. 14 <a href="mailto:doug_newcomb@fws.gov" target="_blank">doug_newcomb@fws.gov</a></div>
<div>---------------------------------------------------------------------------------------------------------</div><div>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.</div>
</div>