<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html><head><meta content="text/html; charset=utf-8" http-equiv="Content-Type"></head><div dir="auto">I haven't used ArcGIS etc for many years, but the old answer was yes but you needed an Enterprise GeDatabase (ArcSDE) license which works with any of the supported "storage formats".<br><br><br><br></div>
<div dir="auto"><!-- tmjah_g_1299s -->Get <a href="http://www.bluemail.me/r?b=16696">BlueMail for Android<!-- tmjah_g_1299e --></a></div>
<div class="gmail_quote" oninput="window.HTMLOUT.draftchange()">On 24 May 2021, at 18:55, Alexandre Neto <<a href=mailto:senhor.neto@gmail.com target=_blank>senhor.neto@gmail.com</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 dir="auto">I have this question for years... Never got a straight answer.<div dir="auto"><br></div><div dir="auto">Is it possible to edit PostGIS tables/geometries using ArcGIS? (Without converting into the proprietary geometry type)</div><div dir="auto"><br></div><div dir="auto">If so, what license level is needed?</div><div dir="auto"><br></div><div dir="auto">Thanks,</div><div dir="auto"><br></div><div dir="auto">Alexandre Neto</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">A sábado, 22/05/2021, 12:29, Marco Boeringa <<a href="mailto:marco@boeringa.demon.nl">marco@boeringa.demon.nl</a>> escreveu:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<p>I doubt this browsing issue has anything to do with
'random_page_cost'... Why on earth would it? This is a PostgreSQL
setting, to which the ESRI software is essentially completely
oblivious. <br>
</p>
<p>The ESRI software just sits on top of this PostgreSQL
infrastructure, it essentially doesn't do anything different than
QGIS does, just watch the SQL statements coming in in PgAdmin.<br>
</p>
<p>I have been running ArcMap and latest ArcGIS Pro versions against
up to PostgreSQL 13 / PostGIS 3.1 mostly fine using ArcGIS "Query
Layers", including browsing data from the catalogs in ArcMap and
Pro, with a postgresql config optimized for SSD (both run against
SATA and NVMe raid), and an OpenStreetMap "planet" size database
on an HPZ840 dual CPU (S2) workstation that I managed to recently
acquire second hand from a refurbished hardware supplier.<br>
</p>
<p>Yes, I have a few bug cases open at ESRI support, including one
related to a very specific serious performance issue of one of the
geoprocessing tools, but none of that related to
'random_page_cost'. Also, as soon as you start upgrading the
technical challenges to OpenStreetMap "planet" size databases,
ArcGIS certainly isn't the only software out there running into
issues here and there, QGIS does too, as well as many other
software packages. Handling > 500M record tables, just requires
thought, whatever toolbox you happen to open...</p>
<p>Marco<br>
</p>
<div>Op 22-5-2021 om 12:51 schreef Darafei
"Komяpa" Praliaskouski:<br>
</div>
<blockquote type="cite">
<div dir="ltr">ESRI has multiple issues in itself that are
terrible to debug.
<div><br>
<div>A client of ours fights a bug where it can't browse
tables once you set random_page_cost to the SSD values of
1.1 instead of 4. So I guess if we're using a bit more index
scan than usual there may be an unknown problem that does
not show itself with QGIS and GeoServer.</div>
<div><br>
</div>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Mon, May 17, 2021 at 10:05
PM Regina Obe <<a href="mailto:lr@pcorp.us" target="_blank" rel="noreferrer">lr@pcorp.us</a>> wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Has
anyone tried running PostgreSQL 13 with PostGIS 3.1 and using
ArcGIS Pro<br>
2.7 for editing?<br>
<br>
I gather from this that it is not supported?<br>
<br>
<a href="https://desktop.arcgis.com/en/system-requirements/latest/database-requirements-postgresql.htm" rel="noreferrer noreferrer" target="_blank">https://desktop.arcgis.com/en/system-requirements/latest/database-requiremen<br>
ts-postgresql.htm</a><br>
<br>
I think for ST_Geometry type (ESRI's version) I would need to
stick with<br>
PostgreSQL 12 since they probably don't have PostgreSQL 13
binaries.<br>
<br>
But I assume even for that case PostgreSQL 12 / PostGIS 3.1
should work fine<br>
as it's not reliant on ESRI's libs.<br>
<br>
Thanks,<br>
Regina<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank" rel="noreferrer">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr">
<div dir="ltr">Darafei "Komяpa" Praliaskouski<br>
OSM BY Team - <a href="http://openstreetmap.by/" target="_blank" rel="noreferrer">http://openstreetmap.by/</a><br>
</div>
</div>
<br>
<fieldset></fieldset>
<pre>_______________________________________________
postgis-users mailing list
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank" rel="noreferrer">postgis-users@lists.osgeo.org</a>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank" rel="noreferrer">https://lists.osgeo.org/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
</div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank" rel="noreferrer">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
</blockquote></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><br /></pre></blockquote></div></html>