[OSGeo-Discuss] Using ArcGIS Desktop with PostGIS [SEC=UNCLASSIFIED]
Randal Hale
rjhale at northrivergeographic.com
Fri Jul 11 05:52:43 PDT 2014
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
> <jmckenna at gatewaygeomatics.com <mailto:jmckenna at 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-bounces at lists.osgeo.org
> <mailto:discuss-bounces at lists.osgeo.org>
> [discuss-bounces at lists.osgeo.org
> <mailto:discuss-bounces at lists.osgeo.org>] On Behalf Of Gavin
> Fleming [gavinjfleming at gmail.com <mailto:gavinjfleming at gmail.com>]
> > Sent: Friday, 11 July 2014 5:29 PM
> > To: discuss at lists.osgeo.org <mailto:discuss at 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 at lists.osgeo.org
> <mailto:Discuss at lists.osgeo.org><mailto:Discuss at lists.osgeo.org
> <mailto:Discuss at 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.6"E 33°44'46.1"S
> > _______________________________________________
> > Discuss mailing list
> > Discuss at lists.osgeo.org <mailto:Discuss at 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 at lists.osgeo.org <mailto:Discuss at lists.osgeo.org>
> http://lists.osgeo.org/mailman/listinfo/discuss
>
>
>
>
> --
> Doug Newcomb
> USFWS
> Raleigh, NC
> 919-856-4520 ext. 14 doug_newcomb at fws.gov <mailto:doug_newcomb at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/discuss
--
-----------------
Randal Hale
North River Geographic Systems, Inc
http://www.northrivergeographic.com
423.653.3611 rjhale at northrivergeographic.com
twitter:rjhale http://about.me/rjhale
http://www.northrivergeographic.com/spatial-connect
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/discuss/attachments/20140711/5159b1b0/attachment-0002.html>
More information about the Discuss
mailing list