<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
I've migrated a forestry client to postgis out of shapefiles and
file based geodatabases. I'm running: <br>
<ul>
<li>Workstation is Ubuntu 14.04 with postgres 9.3.4 and postgis
2.1.3 (ubuntugis packages) </li>
<li>ArcGIS 10.2.2 in a win7 VM</li>
<li>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)</li>
<li>QGIS 2.4 (osqeo4w and ubuntugis)<br>
</li>
</ul>
<p>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. <br>
</p>
<p>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. <br>
<br>
</p>
So way back when we would have projects done in Arc/INFO workstation
and the project area would be USGS quad based. <br>
<ul>
<li>Everyone worked in a workspace. </li>
<li>lots of discussion and people making sure no one butted heads
and edited in the same workspace as someone else. <br>
</li>
<li>End of the project was a weeks worth of consolidation,
snapping, editing, and joy. <br>
</li>
</ul>
<p>I imagine the same thing happening currently. <br>
</p>
<ul>
<li>Postgres is the main data repository</li>
<li>data is handed off to arcgis clients in a systematic way. </li>
<li>Editing occurs - edits are consolidated back into postgres
through qgis or some magic scripted button. </li>
</ul>
<p>And we're partying like it's 1997 but no SDE....but it works. We
used this methodology until 2002 and churned out a ton of good
data. <br>
</p>
<p></p>
<p></p>
<p>Hope that helps and doesn't repeat anything from below. It still
doesn't get anyone to the magic editing part though. <br>
</p>
<p>Randy<br>
</p>
<br>
<div class="moz-cite-prefix">On 07/11/2014 08:25 AM, Newcomb, Doug
wrote:<br>
</div>
<blockquote
cite="mid:CALQGVr1TmPf7cDcOPwi+uW0-rMBfRLfsoqtptBHMHiG9zcdO9g@mail.gmail.com"
type="cite">
<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 moz-do-not-send="true"
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 moz-do-not-send="true"
href="mailto:discuss-bounces@lists.osgeo.org">discuss-bounces@lists.osgeo.org</a>
[<a moz-do-not-send="true"
href="mailto:discuss-bounces@lists.osgeo.org">discuss-bounces@lists.osgeo.org</a>]
On Behalf Of Gavin Fleming [<a moz-do-not-send="true"
href="mailto:gavinjfleming@gmail.com">gavinjfleming@gmail.com</a>]<br>
> Sent: Friday, 11 July 2014 5:29 PM<br>
> To: <a moz-do-not-send="true"
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 moz-do-not-send="true"
href="mailto:Discuss@lists.osgeo.org">Discuss@lists.osgeo.org</a><mailto:<a
moz-do-not-send="true"
href="mailto:Discuss@lists.osgeo.org">Discuss@lists.osgeo.org</a>><br>
> <a moz-do-not-send="true"
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 moz-do-not-send="true"
href="mailto:Discuss@lists.osgeo.org">Discuss@lists.osgeo.org</a><br>
> <a moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
href="mailto:Discuss@lists.osgeo.org">Discuss@lists.osgeo.org</a><br>
<a moz-do-not-send="true"
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 moz-do-not-send="true"
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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Discuss mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Discuss@lists.osgeo.org">Discuss@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/discuss">http://lists.osgeo.org/mailman/listinfo/discuss</a></pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
-----------------
Randal Hale
North River Geographic Systems, Inc
<a class="moz-txt-link-freetext" href="http://www.northrivergeographic.com">http://www.northrivergeographic.com</a>
423.653.3611 <a class="moz-txt-link-abbreviated" href="mailto:rjhale@northrivergeographic.com">rjhale@northrivergeographic.com</a>
twitter:rjhale <a class="moz-txt-link-freetext" href="http://about.me/rjhale">http://about.me/rjhale</a>
<a class="moz-txt-link-freetext" href="http://www.northrivergeographic.com/spatial-connect">http://www.northrivergeographic.com/spatial-connect</a></pre>
</body>
</html>