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 SDE....but 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
<[email protected] <mailto:[email protected]>>
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: [email protected]
<mailto:[email protected]>
[[email protected]
<mailto:[email protected]>] On Behalf Of Gavin
Fleming [[email protected] <mailto:[email protected]>]
> Sent: Friday, 11 July 2014 5:29 PM
> To: [email protected] <mailto:[email protected]>
> 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
> [email protected]
<mailto:[email protected]><mailto:[email protected]
<mailto:[email protected]>>
> http://lists.osgeo.org/mailman/listinfo/discuss
>
>
>
> --
> Gavin Fleming
> t: 0218620670
> w: 0218630660
> c: 0845965680
> f: 0866164820
> Paarl
> South Africa
> 18°59'19.6"E 33°44'46.1"S
> _______________________________________________
> Discuss mailing list
> [email protected] <mailto:[email protected]>
> http://lists.osgeo.org/mailman/listinfo/discuss
>
--
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/
_______________________________________________
Discuss mailing list
[email protected] <mailto:[email protected]>
http://lists.osgeo.org/mailman/listinfo/discuss
--
Doug Newcomb
USFWS
Raleigh, NC
919-856-4520 ext. 14 [email protected] <mailto:[email protected]>
---------------------------------------------------------------------------------------------------------
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
[email protected]
http://lists.osgeo.org/mailman/listinfo/discuss
--
-----------------
Randal Hale
North River Geographic Systems, Inc
http://www.northrivergeographic.com
423.653.3611 [email protected]
twitter:rjhale http://about.me/rjhale
http://www.northrivergeographic.com/spatial-connect
_______________________________________________
Discuss mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/discuss
