<html><head></head><body style="zoom: 0%;"><div dir="auto">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.<br><br></div>
<div dir="auto">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.<br><br></div>
<div dir="auto">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. <br><br></div>
<div dir="auto">HTH<br></div>
<div dir="auto">Simon<br></div>
<div dir="auto"><!-- tmjah_g_1299s -->Get <!-- tmjah_g_1299e --><a href="http://www.bluemail.me/r?b=16117"><!-- tmjah_g_1299s -->BlueMail for Android<!-- tmjah_g_1299e --></a><!-- tmjah_g_1299s --> <!-- tmjah_g_1299e --></div>
<div class="gmail_quote" >On 6 Nov 2020, at 03:21, Regina Obe <<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">I believe so, if what you are referring to is that st_geometry thing ArcGIS ships (or used to ship)
</span></p><p></p><p></p>
<p class="MsoNormal"><span style="color:#1F497D">
</span></p><p>
</p><p></p>
<div style="border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt">
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> postgis-users [mailto:postgis-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>Mark Volz<br><b>Sent:</b> Thursday, November 5, 2020 10:59 AM<br><b>To:</b> postgis-users@lists.osgeo.org<br><b>Subject:</b> [postgis-users] Postgis and ArcGIS Data Store
</p><p></p>
</div>
</div>
<p class="MsoNormal">
</p><p>
</p>
<p class="MsoNormal">Hello,
</p><p></p>
<p class="MsoNormal">
</p><p>
</p>
<p class="MsoNormal">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.
</p><p></p>
<p class="MsoNormal">
</p><p>
</p>
<p class="MsoNormal">Thanks!
</p><p></p>
<p class="MsoNormal">
</p><p>
</p>
<p class="MsoNormal"><span style="color:#1F497D">Sincerely,
</span></p><p></p><p></p>
<p class="MsoNormal"><b><span style="color:#1F497D">Mark Volz, GISP</span></b><b><span style="font-size:12.0pt;color:#1F497D">
</span></b></p><p></p><p></p>
<p class="MsoNormal">
</p><p>
</p>
</div>
</div>
<pre class="blue"> <hr><br>postgis-users mailing list<br>postgis-users@lists.osgeo.org<br><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre></blockquote></div></body></html>