[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] ArcGIS Online without ArcGIS server
From: "Regina Obe" <lr () pcorp ! us>
Date: 2023-09-16 10:21:47
Message-ID: 002501d9e887$99fa3180$cdee9480$ () pcorp ! us
[Download RAW message or body]
This is a multipart message in MIME format.
[Attachment #2 (multipart/alternative)]
This is a multipart message in MIME format.
Thanks everyone who chimed in on this. It's sad to hear but it is what it is.
From: postgis-users <postgis-users-bounces@lists.osgeo.org> On Behalf Of Marcelo \
Marques
Sent: Friday, September 15, 2023 1:59 PM
To: PostGIS Users Discussion <postgis-users@lists.osgeo.org>
Subject: Re: [postgis-users] ArcGIS Online without ArcGIS server
Hello,
The answer is "No". ArcGIS Online is not able to connect to a PostGIS enabled \
database directly.
ArcGIS Online is a SAS Software As a Service, and you need to store your data into \
the ArcGIS Online Feature Data Store.
Data Management in ArcGIS Online - \
https://doc.arcgis.com/en/arcgis-online/manage-data/data-in-online.htm
FAQ ArcGIS Online - https://doc.arcgis.com/en/arcgis-online/reference/faq.htm
However as mentioned ArcGIS Online allows you to Add a Service from a URL.
https://doc.arcgis.com/en/arcgis-online/manage-data/add-item-from-url.htm
This means if you have an ArcGIS Geodatabase on PostgreSQL you can store the spatial \
data with esri st_geometry or with postgis pg_geometry.
Then with ArcGIS Server you can publish a Map Service or Feature Service using the \
layer or layers from the PostgreSQL Geodatabase.
Then, you can use the Map Service / Feature Service URL with ArcGIS Online.
The ArcGIS Server VM and PostgreSQL Geodatabase can reside in the Cloud, e.g. Amazon \
or Azure.
I hope this clarifies.
Thanks,
> Marcelo Marques | Esri PS Products | Principal Product Engineer |
> Cloud & Database Administrator | OCP – Oracle Certified Professional |
> Esri | 380 New York St | Redlands, CA 92373 | USA |
> T +909-369-1787 | M +909-255-2079 | <http://esri.com/> esri.com |
| Esri Enterprise Mapping and Charting Databases Best Practices \
<https://community.esri.com/groups/mapping-and-charting-enterprise-databases/blog/2014/12/18/enterprise-mcs-databases-best-practices> \
|
> <https://www.linkedin.com/in/mmarquesbr/> https://www.linkedin.com/in/mmarquesbr/ |
On Fri, Sep 15, 2023 at 9:20 AM Phil Bartie <philbartie@gmail.com \
<mailto:philbartie@gmail.com> > wrote:
ArcGIS online supports WMS, WMTS, and WFS OGC web services.
https://doc.arcgis.com/en/arcgis-online/manage-data/add-item-from-url.htm
Best,
Phil
On Fri, 15 Sept 2023 at 16:43, Martin Davis <mtnclimb@gmail.com \
<mailto:mtnclimb@gmail.com> > wrote:
It's my educated guess that the answer is no. The AGOL client talks via web services \
to the backend, so it can't talk directly to a database server.
It *might* be able to talk to a non-AGOL web service (probably using OGC protocols)?
On Fri, Sep 15, 2023 at 8:26 AM Regina Obe <lr@pcorp.us <mailto:lr@pcorp.us> > \
wrote:
This may be a question to just people using ArcGIS Online or at least
familiar with it. Is it possible to have an ArcGIS online connect to a
PostGIS enabled database (assuming you have the port open etc), without an
ArcGIS Server license?
If so are their limitations in terms of what features you can use of ArcGIS
Online like their javascript apis etc?
Thanks,
Regina
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/postgis-users
[Attachment #5 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type \
content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 \
(filtered medium)"><style><!-- /* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple \
style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal>Thanks \
everyone who chimed in on this. It's sad to hear but it is what it \
is.<o:p></o:p></p><p class=MsoNormal><o:p> </o: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 \
<postgis-users-bounces@lists.osgeo.org> <b>On Behalf Of </b>Marcelo \
Marques<br><b>Sent:</b> Friday, September 15, 2023 1:59 PM<br><b>To:</b> PostGIS \
Users Discussion <postgis-users@lists.osgeo.org><br><b>Subject:</b> Re: \
[postgis-users] ArcGIS Online without ArcGIS server<o:p></o:p></p></div></div><p \
class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>Hello, <br><br>The \
answer is "No". ArcGIS Online is not able to connect to a PostGIS enabled \
database directly.<o:p></o:p></p><div><p class=MsoNormal><br>ArcGIS Online is a SAS \
Software As a Service, and you need to store your data into the <b>ArcGIS Online \
Feature Data Store</b>.<o:p></o:p></p></div><div><p \
class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><b>Data Management \
in ArcGIS Online</b> - <a \
href="https://doc.arcgis.com/en/arcgis-online/manage-data/data-in-online.htm">https:// \
doc.arcgis.com/en/arcgis-online/manage-data/data-in-online.htm</a><o:p></o:p></p></div><div><p \
class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><b>FAQ ArcGIS \
Online </b>- <a href="https://doc.arcgis.com/en/arcgis-online/reference/faq.htm">https \
://doc.arcgis.com/en/arcgis-online/reference/faq.htm</a><o:p></o:p></p></div><div><p \
class=MsoNormal><br>However as mentioned ArcGIS Online allows you to Add a Service \
from a URL.<o:p></o:p></p></div><div><p \
class=MsoNormal><o:p> </o:p></p></div><div><div><p class=MsoNormal><a \
href="https://doc.arcgis.com/en/arcgis-online/manage-data/add-item-from-url.htm" \
target="_blank">https://doc.arcgis.com/en/arcgis-online/manage-data/add-item-from-url.htm</a><o:p></o:p></p></div></div><div><p \
class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>This means if you \
have an ArcGIS Geodatabase on PostgreSQL you can store the spatial data with esri \
st_geometry or with postgis pg_geometry.<o:p></o:p></p></div><div><p \
class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Then with ArcGIS \
Server you can publish a Map Service or Feature Service using the layer or layers \
from the PostgreSQL Geodatabase.<o:p></o:p></p></div><div><p \
class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Then, you can use \
the Map Service / Feature Service URL with ArcGIS Online.<o:p></o:p></p></div><div><p \
class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>The ArcGIS Server \
VM and PostgreSQL Geodatabase can reside in the Cloud, e.g. Amazon or Azure.<br><br>I \
hope this clarifies.<o:p></o:p></p></div><div><p \
class=MsoNormal><o:p> </o:p></p></div><div><p \
class=MsoNormal>Thanks,<o:p></o:p></p><p class=MsoNormal><span \
style='font-size:9.0pt'> </span><o:p></o:p></p><p class=MsoNormal><span \
style='font-size:9.0pt'>| </span><b>Marcelo Marques </b>| Esri PS Products | \
Principal Product Engineer | <o:p></o:p></p><p class=MsoNormal><span \
style='font-size:9.0pt'>| Cloud & Database Administrator | OCP – Oracle \
Certified Professional |</span><o:p></o:p></p><p class=MsoNormal><span \
style='font-size:10.0pt;color:#7A7A7A'>|<b> Esri</b> | 380 New York St | \
Redlands, CA 92373 | USA |</span><o:p></o:p></p><p class=MsoNormal><span \
style='font-size:10.0pt;color:#7A7A7A'>|<b> </b>T +909-369-1787 | M \
+909-255-2079 | <a href="http://esri.com/"><span \
style='color:#0563C1'>esri.com</span></a> |</span><o:p></o:p></p><p \
class=MsoNormal><span style='font-size:10.0pt;color:#1F497D'> </span><span \
style='font-size:10.0pt;color:#7F7F7F'>|</span><b><i><span style='font-size:10.0pt'> \
</span></i></b><span style='font-size:10.0pt'><a \
href="https://community.esri.com/groups/mapping-and-charting-enterprise-databases/blog/2014/12/18/enterprise-mcs-databases-best-practices">Esri \
Enterprise Mapping and Charting Databases Best Practices</a> <span \
style='color:#7A7A7A'>|</span></span><o:p></o:p></p><p class=MsoNormal><span \
style='font-size:10.0pt;color:#7A7A7A'>| </span><u><span style='color:blue'><a \
href="https://www.linkedin.com/in/mmarquesbr/"><span \
style='font-size:10.0pt'>https://www.linkedin.com/in/mmarquesbr/</span></a></span></u><span \
style='font-size:10.0pt;color:#7A7A7A'> |</span><o:p></o:p></p></div><div><p \
class=MsoNormal><o:p> </o:p></p></div></div><p \
class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>On Fri, Sep 15, \
2023 at 9:20 AM Phil Bartie <<a \
href="mailto:philbartie@gmail.com">philbartie@gmail.com</a>> \
wrote:<o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC \
1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><div><p \
class=MsoNormal>ArcGIS online supports WMS, WMTS, and WFS OGC web \
services. <o:p></o:p></p><div><p \
class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><a \
href="https://doc.arcgis.com/en/arcgis-online/manage-data/add-item-from-url.htm" \
target="_blank">https://doc.arcgis.com/en/arcgis-online/manage-data/add-item-from-url.htm</a><o:p></o:p></p></div><div><p \
class=MsoNormal><o:p> </o:p></p></div><div><p \
class=MsoNormal>Best,<o:p></o:p></p></div><div><p \
class=MsoNormal>Phil<o:p></o:p></p></div></div><p \
class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>On Fri, 15 Sept \
2023 at 16:43, Martin Davis <<a href="mailto:mtnclimb@gmail.com" \
target="_blank">mtnclimb@gmail.com</a>> wrote:<o:p></o:p></p></div><blockquote \
style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in \
6.0pt;margin-left:4.8pt;margin-right:0in'><div><p class=MsoNormal>It's my educated \
guess that the answer is no. The AGOL client talks via web services to the \
backend, so it can't talk directly to a database server.<o:p></o:p></p><div><p \
class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>It *might* be able \
to talk to a non-AGOL web service (probably using OGC \
protocols)?<o:p></o:p></p></div></div><p \
class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>On Fri, Sep 15, \
2023 at 8:26 AM Regina Obe <<a href="mailto:lr@pcorp.us" \
target="_blank">lr@pcorp.us</a>> wrote:<o:p></o:p></p></div><blockquote \
style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in \
6.0pt;margin-left:4.8pt;margin-right:0in'><p class=MsoNormal>This may be a question \
to just people using ArcGIS Online or at least<br>familiar with it. Is it \
possible to have an ArcGIS online connect to a<br>PostGIS enabled database (assuming \
you have the port open etc), without an<br>ArcGIS Server license?<br>If so are their \
limitations in terms of what features you can use of ArcGIS<br>Online like their \
javascript apis etc?<br><br>Thanks,<br>Regina<br><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="https://lists.osgeo.org/mailman/listinfo/postgis-users" \
target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></p></blockquote></div><p \
class=MsoNormal>_______________________________________________<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="https://lists.osgeo.org/mailman/listinfo/postgis-users" \
target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></p></blockquote></div><p \
class=MsoNormal>_______________________________________________<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="https://lists.osgeo.org/mailman/listinfo/postgis-users" \
target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></p></blockquote></div></div></div></body></html>
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic