[postgis-users] PostGIS supported by which ArcGIS
Birgit Laggner
birgit.laggner at ti.bund.de
Thu Oct 9 02:38:37 PDT 2014
Hi David,
I have no experiences with ArcSDE, but I can say, that no dba had to
esrify our database in order to enable the interoperability between
ArcGIS and PostgreSQL/PostGIS. We have a simple PostgreSQL-DB (version
9.1) with an PostGIS extension (version 2.1). All we had to do was
download a bunch of files from the ArcGIS Helpdesk, copy them into the
appropriate ArcGIS program folder of our locally installed desktop
ArcGIS, and then everything worked. We had to define the connection to
the PostgreSQL database in ArcGIS and then we were able to access the
tables of our PostgreSQL database including the PostGIS geometries (not
the raster data!) via read/write access.
If ArcGIS writes geometries into the PostgreSQL database it names the
geometry column as "shape" with the datatype "geometry" - no pg_geometry
or st_geometry.
Regards,
Birgit.
Am 08.10.2014 17:28, schrieb David Fawcett:
> I assume that on the server side, your dba has 'Esrified' the database
> by using a one of the ArcGIS desktop tools to convert your existing
> Postgres database into an 'ESRI Enterprise Geodatabase", which creates
> the sde schema and all of the sde functions, etc. This costs an
> ArcGIS Server license.
>
> We are doing this for our primary production spatial database. One
> thing that we are doing is using the PG_GEOMETRY option to specify the
> PostGIS spatial datatype instead of ESRI's ST_GEOMETRY datatype. This
> allows us to use all of the PostGIS functionality on features created
> with ESRI tools. All of my backend processes are written in
> Python/SQL/PgPSQL without any ESRI tools.
>
> I would be very surprised if you can edit geometries in PostGIS using
> the ArcGIS tools without using the SDE functionality and licensing.
> (I would love it if you can prove me wrong.) Note that the SDE
> functionality is now built into all of ESRI's products, and the SDE
> server software will be depricated after 10.2.
>
>
>
> On Thu, Oct 2, 2014 at 2:30 AM, Birgit Laggner
> <birgit.laggner at ti.bund.de <mailto:birgit.laggner at ti.bund.de>> wrote:
>
> We use ArcGIS 10.2 for read/write interaction with our PostgreSQL
> database. We only have ArcGIS Desktop without SDE. There is a
> driver (database client file) from ArcGIS for PostgreSQL, you have
> to install. We are more or less content with this concept. Surely,
> the performance is not as if you would be working directly on the
> PostgreSQL database, but still, it isn't necessary to always
> export and import into and from shapefile. That's a huge plus in
> my opinion.
>
> Here is a link to a documentation site of ArcGIS regarding the
> requirements for the interoperability with PostgreSQL:
>
> http://resources.arcgis.com/en/help/system-requirements/10.2/index.html#//015100000075000000
>
> Regards,
>
> Birgit.
>
>
> Am 27.09.2014 20 <tel:27.09.2014%2020>:28, schrieb Stefan Keller:
>
> Actually yes, I meant the "PostGIS option" of storing data in
> PostgreSQL/PostGIS from ArcGIS.
>
> --S.
>
> 2014-09-27 20:20 GMT+02:00 Randal Hale
> <rjhale at northrivergeographic.com
> <mailto:rjhale at northrivergeographic.com>>:
>
> as far as I understand it (and I could be wrong on some of
> this)
>
> Desktop will support reading if you load the postgresql
> library files (that
> can be downloaded form your ESRI customer care portal).
> Once those are loaded you can read through a definition
> query data from
> postgis into arcgis. I just made a map using arcgis and
> reading data from
> postgis.
> It doesn't support write unless you have SDE for
> Postgresql - which isn't
> postgis. That dives into the world of ArcGIS Server....
>
>
> ArcGIS supposedly is moving to being able to read/write
> the geopackage
> format which to me opens read/write to PostGIS. BUT if
> they open read write
> for postgis that starts a slow death of SDE....so I don't
> believe it ever
> will (for the foreseeable future).
>
> Randy
>
>
>
>
> On 09/27/2014 02:10 PM, Stefan Keller wrote:
>
> I'm asked from time to time for an advice which ArcGIS product
> supports PostGIS (read/write)?
> Even after reading the Esri pages I'm not sure if it's
> only "ArcGIS
> for Server Workgroup" (formerly ArcSDE).
> Does it work also with ArcGIS for Desktop Basic (ArcView)?
>
> Yours, S.
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> <mailto:postgis-users at lists.osgeo.org>
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
> --
> -----------------
> Randal Hale
> North River Geographic Systems, Inc
> http://www.northrivergeographic.com
> 423.653.3611 <tel:423.653.3611>
> rjhale at northrivergeographic.com
> <mailto:rjhale at northrivergeographic.com>
> twitter:rjhale http://about.me/rjhale
> http://www.northrivergeographic.com/spatial-connect
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> <mailto:postgis-users at lists.osgeo.org>
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org>
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20141009/176fd81d/attachment.html>
More information about the postgis-users
mailing list