<div dir="ltr"><div>Hi,<br><br>last year, I had the same kind of experience that david described in a previous post.<br><br>I "esrified" my pg database into an esri enterprise geodatabase, turned db_tune parameter into PG_Geometry and was able to read and write on my table.<br><br>I can't remember all details but editing of non-spatial tables through Arcmap (as per customer requests) was a kind of a mess...<br><br>The worst part was, migrating the entire db from dev server to production server. This was done exporting the xml workspace through ArcCatalog and recreating all constraints and relationships through a separated sql script. <br><br>I tried to backup the entire db through Postgres tools and re-import it but ArcMap refused to connect to this newly imported db.<br><br>I can't really say that Postgres/Esri was a nice marriage....<br><br></div>Regards<br><br>paolo<br><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">2014-10-09 11:38 GMT+02:00 Birgit Laggner <span dir="ltr"><<a href="mailto:birgit.laggner@ti.bund.de" target="_blank">birgit.laggner@ti.bund.de</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Hi David,<br>
<br>
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.<br>
<br>
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.<br>
<br>
Regards,<br>
<br>
Birgit.<br>
<br>
<br>
<div>Am 08.10.2014 17:28, schrieb David
Fawcett:<br>
</div><div><div class="h5">
<blockquote type="cite">
<div dir="ltr">
<div>
<div>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. <br>
<br>
</div>
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.<br>
<br>
</div>
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.<br>
<div>
<div><br>
<br>
</div>
</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Thu, Oct 2, 2014 at 2:30 AM, Birgit
Laggner <span dir="ltr"><<a href="mailto:birgit.laggner@ti.bund.de" target="_blank">birgit.laggner@ti.bund.de</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">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.<br>
<br>
Here is a link to a documentation site of ArcGIS regarding
the requirements for the interoperability with PostgreSQL:<br>
<br>
<a href="http://resources.arcgis.com/en/help/system-requirements/10.2/index.html#//015100000075000000" target="_blank">http://resources.arcgis.com/en/help/system-requirements/10.2/index.html#//015100000075000000</a><br>
<br>
Regards,<br>
<br>
Birgit.<br>
<br>
<br>
Am <a href="tel:27.09.2014%2020" value="+12709201420" target="_blank">27.09.2014 20</a>:28,
schrieb Stefan Keller:
<div>
<div><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Actually yes, I meant the "PostGIS option" of storing
data in<br>
PostgreSQL/PostGIS from ArcGIS.<br>
<br>
--S.<br>
<br>
2014-09-27 20:20 GMT+02:00 Randal Hale <<a href="mailto:rjhale@northrivergeographic.com" target="_blank">rjhale@northrivergeographic.com</a>>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
as far as I understand it (and I could be wrong on
some of this)<br>
<br>
Desktop will support reading if you load the
postgresql library files (that<br>
can be downloaded form your ESRI customer care
portal).<br>
Once those are loaded you can read through a
definition query data from<br>
postgis into arcgis. I just made a map using arcgis
and reading data from<br>
postgis.<br>
It doesn't support write unless you have SDE for
Postgresql - which isn't<br>
postgis. That dives into the world of ArcGIS
Server....<br>
<br>
<br>
ArcGIS supposedly is moving to being able to
read/write the geopackage<br>
format which to me opens read/write to PostGIS. BUT
if they open read write<br>
for postgis that starts a slow death of SDE....so I
don't believe it ever<br>
will (for the foreseeable future).<br>
<br>
Randy<br>
<br>
<br>
<br>
<br>
On 09/27/2014 02:10 PM, Stefan Keller wrote:<br>
<br>
I'm asked from time to time for an advice which
ArcGIS product<br>
supports PostGIS (read/write)?<br>
Even after reading the Esri pages I'm not sure if
it's only "ArcGIS<br>
for Server Workgroup" (formerly ArcSDE).<br>
Does it work also with ArcGIS for Desktop Basic
(ArcView)?<br>
<br>
Yours, S.<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
<br>
<br>
--<br>
-----------------<br>
Randal Hale<br>
North River Geographic Systems, Inc<br>
<a href="http://www.northrivergeographic.com" target="_blank">http://www.northrivergeographic.com</a><br>
<a href="tel:423.653.3611" value="+14236533611" target="_blank">423.653.3611</a> <a href="mailto:rjhale@northrivergeographic.com" target="_blank">rjhale@northrivergeographic.com</a><br>
twitter:rjhale <a href="http://about.me/rjhale" target="_blank">http://about.me/rjhale</a><br>
<a href="http://www.northrivergeographic.com/spatial-connect" target="_blank">http://www.northrivergeographic.com/spatial-connect</a><br>
</blockquote>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
<br>
</blockquote>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
postgis-users mailing list
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<br>
</div></div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br></blockquote></div><br></div>