[postgis-users] Postgis and ArcGIS Data Store

[Simon Greener]

ESRI's data tier has always supported multiple "storage types". For Postgresql they support PostGIS and their own ST_Geometry. Which, depends on how you configure it.

A GeoDatabase configured to use ST_Geometry stores cartesian/geographic/geodetic data all in that type (there is no ST_Geography). Their API and indexing treats the geographic data as cartesian when accessed from stored procedures. Geodetic calcs do occur but in the middle/client tier. If database geographic processing is important to you, then choose PostGIS's geography type, or interchange between the types using WKT.

Finally regardless as to storage type all geoprocessing eg buffer is probably not done in the database in order for the ESRI software to provide consistent results. 

HTH
Simon
⁣Get BlueMail for Android ​

On 6 Nov 2020, 03:21, at 03:21, Regina Obe <lr at pcorp.us> wrote:
>I believe so, if what you are referring to is that st_geometry thing
>ArcGIS
>ships (or used to ship)
>
> 
>
>From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On
>Behalf
>Of Mark Volz
>Sent: Thursday, November 5, 2020 10:59 AM
>To: postgis-users at lists.osgeo.org
>Subject: [postgis-users] Postgis and ArcGIS Data Store
>
> 
>
>Hello,
>
> 
>
>Can postgis/postgres run along with ArcGIS Datastore which I understand
>also
>uses postgres?  If possible I would want two separate instances so that
>ArcGIS does not mess with the data in postgis/postgres.
>
> 
>
>Thanks!
>
> 
>
>Sincerely,
>
>Mark Volz, GISP
>
> 
>
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at lists.osgeo.org
>https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20201106/26f0ba20/attachment.html>