[postgis-users] PostGIS supported by which ArcGIS

Thu Oct 9 05:48:09 PDT 2014

Hi,

last year, I had the same kind of experience that david described in a
previous post.

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.

I can't remember all details but editing of non-spatial tables through
Arcmap (as per customer requests) was a kind of a mess...

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.

I tried to backup the entire db through Postgres tools and re-import it but
ArcMap refused to connect to this newly imported db.

I can't really say that Postgres/Esri was a nice marriage....

Regards

paolo

2014-10-09 11:38 GMT+02:00 Birgit Laggner <birgit.laggner at ti.bund.de>:

>  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>
> 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: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
>>> >:
>>>
>>>> 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
>>>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>>>
>>>>
>>>> --
>>>> -----------------
>>>> 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
>>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> 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
>>
>
>
>
> _______________________________________________
> postgis-users mailing listpostgis-users at lists.osgeo.orghttp://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/ddbf6cc0/attachment.html>