ArcGIS Pro 2.4.3 In pro, you can add a feature service and manually export the features to a file geodatabase feature class. How do you mimic that functionality in python? I have tried: import arcpy source = r 'https://path/toOur/rest/services/MapServer/0' arcpy . FeatureClassToFeatureClass_conversion ( source , r 'C:\pathTo\Test.gdb' , 'newFC' ) and get : ExecuteError: ERROR 000210: Cannot create output C:\pathTo\Test.gdb\newFC Failed to execute (FeatureClassToFeatureClass). I googled the error, and then tried to use the same python approach with an Egdb feature class as the source, and it worked splendidly. Is this a case for the python api?

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Using arcpy to copy a portal feature service to a fgdb feature class

JoeBorgione

ArcGIS Pro 2.4.3

In pro, you can add a feature service and manually export the features to a file geodatabase feature class.

How do you mimic that functionality in python? I have tried:

<SPAN class="keyword token">import</SPAN> arcpy
source <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'https://path/toOur/rest/services/MapServer/0'</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>FeatureClassToFeatureClass_conversion<SPAN class="punctuation token">(</SPAN>source<SPAN class="punctuation token">,</SPAN>r<SPAN class="string token">'C:\pathTo\Test.gdb'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'newFC'</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

and get :

ExecuteError: ERROR 000210: Cannot create output C:\pathTo\Test.gdb\newFC
Failed to execute (FeatureClassToFeatureClass).

I googled the error, and then tried to use the same python approach with an Egdb feature class as the source, and it worked splendidly. Is this a case for the python api?

Finde mehr Beiträge mit dem Tag

Accepted answers

JoshuaBixby

Wow, that is an Esri Support #fail for sure. That technical article is ancient from a web GIS perspective. It was "last published" right around the time of the first release of the ArcGIS API for Python, which likely explains why it is not using that API and instead having people make HTTP calls themselves.

Here are some basic steps to download a feature service layer as a feature class in a file geodatabase:

<SPAN class="keyword token">from</SPAN> arcgis<SPAN class="punctuation token">.</SPAN>gis <SPAN class="keyword token">import</SPAN> GIS
<SPAN class="keyword token">from</SPAN> arcgis<SPAN class="punctuation token">.</SPAN>features <SPAN class="keyword token">import</SPAN> FeatureLayer

url_gis <SPAN class="operator token">=</SPAN> <SPAN class="comment token"># URL to AGOL or Portal</SPAN>
url_fl <SPAN class="operator token">=</SPAN>  <SPAN class="comment token"># URL for feature layer to download as feature class</SPAN>
user <SPAN class="operator token">=</SPAN>  <SPAN class="comment token"># AGOL or Portal username</SPAN>
pwd <SPAN class="operator token">=</SPAN> <SPAN class="comment token"># user password</SPAN>
fgdb <SPAN class="operator token">=</SPAN> <SPAN class="comment token"># path to file geodatabase</SPAN>
fc <SPAN class="operator token">=</SPAN> <SPAN class="comment token"># name of feature class</SPAN>

gis <SPAN class="operator token">=</SPAN> GIS<SPAN class="punctuation token">(</SPAN>url_gis<SPAN class="punctuation token">,</SPAN> user<SPAN class="punctuation token">,</SPAN> pwd<SPAN class="punctuation token">)</SPAN>
fl <SPAN class="operator token">=</SPAN> FeatureLayer<SPAN class="punctuation token">(</SPAN>url_fl<SPAN class="punctuation token">)</SPAN>
fs <SPAN class="operator token">=</SPAN> fl<SPAN class="punctuation token">.</SPAN>query<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
fs<SPAN class="punctuation token">.</SPAN>save<SPAN class="punctuation token">(</SPAN>fgdb<SPAN class="punctuation token">,</SPAN> fc<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

JoshuaBixby

Joe, ArcPy isn't really built to directly deal with "web GIS," which is why the ArcGIS API for Python | ArcGIS for Developers was developed. Use arcgis.features module — arcgis 1.7.0 documentation to retrieve a FeatureLayer of the service layer, then query it to get a FeatureSet that has a save option to file geodatabase.

JoeBorgione

Mondays project... Thanks.

JoeBorgione

Joshua- esri tech support provided this link to me : How To: Create and download a file geodatabase replica from a hosted feature service using Python . This particular approach creates a replica and uses userLib2(); as I told them, I'm not interested in a replica and userlib2() is not available in 3.x. Maybe ESRI can get on board to provide us a more modern approach....

JoshuaBixby

Here are some basic steps to download a feature service layer as a feature class in a file geodatabase:

<SPAN class="keyword token">from</SPAN> arcgis<SPAN class="punctuation token">.</SPAN>gis <SPAN class="keyword token">import</SPAN> GIS
<SPAN class="keyword token">from</SPAN> arcgis<SPAN class="punctuation token">.</SPAN>features <SPAN class="keyword token">import</SPAN> FeatureLayer

url_gis <SPAN class="operator token">=</SPAN> <SPAN class="comment token"># URL to AGOL or Portal</SPAN>
url_fl <SPAN class="operator token">=</SPAN>  <SPAN class="comment token"># URL for feature layer to download as feature class</SPAN>
user <SPAN class="operator token">=</SPAN>  <SPAN class="comment token"># AGOL or Portal username</SPAN>
pwd <SPAN class="operator token">=</SPAN> <SPAN class="comment token"># user password</SPAN>
fgdb <SPAN class="operator token">=</SPAN> <SPAN class="comment token"># path to file geodatabase</SPAN>
fc <SPAN class="operator token">=</SPAN> <SPAN class="comment token"># name of feature class</SPAN>

gis <SPAN class="operator token">=</SPAN> GIS<SPAN class="punctuation token">(</SPAN>url_gis<SPAN class="punctuation token">,</SPAN> user<SPAN class="punctuation token">,</SPAN> pwd<SPAN class="punctuation token">)</SPAN>
fl <SPAN class="operator token">=</SPAN> FeatureLayer<SPAN class="punctuation token">(</SPAN>url_fl<SPAN class="punctuation token">)</SPAN>
fs <SPAN class="operator token">=</SPAN> fl<SPAN class="punctuation token">.</SPAN>query<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
fs<SPAN class="punctuation token">.</SPAN>save<SPAN class="punctuation token">(</SPAN>fgdb<SPAN class="punctuation token">,</SPAN> fc<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JoeBorgione

Thank you so much Joshua. I've been floundering about with Jupyter notebooks for the pas hour or so, but this looks just like what I need. Locally, we do have a little glitch with the GIS() method, but I'm working with the S.A to get past that.

JoeBorgione

Joshua- following the instructions given here: Working with different authentication schemes | ArcGIS for Developers I'm taking a slightly different approach in passing the user, and pwd variables; I need to pass a 'client_id' as well:

gis <SPAN class="operator token">=</SPAN> GIS<SPAN class="punctuation token">(</SPAN>url_gis<SPAN class="punctuation token">,</SPAN>user<SPAN class="punctuation token">,</SPAN>pwd<SPAN class="punctuation token">,</SPAN>client_id <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Ox05rrnllB1biFgW'</SPAN><SPAN class="punctuation token">)</SPAN>‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

But I get an error:

  File <SPAN class="string token">"C:\EnvClones\arcgispro-py3-clone243\lib\site-packages\arcgis\_impl\connection.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">449</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> oauth_authenticate
    <SPAN class="keyword token">from</SPAN> bs4 <SPAN class="keyword token">import</SPAN> BeautifulSoup

ModuleNotFoundError<SPAN class="punctuation token">:</SPAN> No module named <SPAN class="string token">'bs4'</SPAN>‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Not having a whole lot of luck with dr.google trying to find a remedy for this: it seems as though with the python 3.6 install from Pro, bs4 is no where to be found...

edited to add: actually found a couple threads that suggest using pip3 to install bs4 into python 3.6: here is one from quora. Anaconda offers one as well. I guess I need to use one of these while in my cloned environment?

JoshuaBixby

It appears to be trying to load a Python package/module that isn't installed in your virtual env. Confirm that beautifulsoup4 is installed, and if not, install it. It might be a defect in ArcGIS API for Python where they aren't packaging a dependency.

JoeBorgione

From Esri Tech Support: BUG-000118107 - In ArcGIS API for Python, requests for installing a third-party module named bs4 when the User Authentication with OAuth 2.0 method is used to login into ArcGIS Online.

by the way:

Kory Kramer‌

KoryKramer

BUG-000118107: In ArcGIS API for Python, requests for installing a ..

JoshuaBixby

I must be clairvoyant. Nah, just worked with Esri for a long time. This bug is fairly simple to work around yourself, assuming there isn't yet another bug just waiting right around the corner once the package import is resolved.

JoeBorgione

After going back and forth on this with the portal admin here, Joshua's approach works for me.

davedoesgis

Joshua Bixby‌ - Back when I used to work with MapService type services, you had to set a maximum number of features that could be retrieved. The default was 1000 and you could set it higher, but a very large data set could always be more than whatever number you put in there. So a query like this always ran the risk of not getting all the features.

Is that an issue with your code querying FeatureService type services? If so, any suggestions for a work-around?

JoshuaBixby

David, the ArcGIS API for Python is REST API-aware, so the underlying code addresses the feature limit of services and does the appropriate batching of records to retrieve the entire data set.

SoratoSouza_e_Silva

This code is very good, but my results is:

Can you help me?

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.