topic Re: How to read data from hosted feature layer programmatically in ArcGIS Enterprise Questions

How to read data from hosted feature layer programmatically

StephenKaranja — Sun, 14 Aug 2022 09:34:36 GMT

Hello,

I'd like to read the data in a hosted feature layer and store it in an external SQL database table. I'd like to do this programmatically through the use of a script. How should I go about doing this?

Thanks.

Re: How to read data from hosted feature layer programmatically

GeoJosh — Mon, 15 Aug 2022 13:36:00 GMT

Hi Stephen! The ArcGIS API for Python would be great for this use case. Here's a rough outline of how you'd read the data:

Get the hosted feature layer by item ID (gis.content.get)
Query the hosted feature layer and return the query results in a spatial data frame. (arcgis.features.FeatureLayer.query)
Store in your enterprise geodatabase.

You can see the Python API in action in these sample notebooks.

Re: How to read data from hosted feature layer programmatically

StephenKaranja — Mon, 15 Aug 2022 18:35:21 GMT

Thanks a lot for your response. I'll look into the ArcGIS API for Python to determine whether it will solve the problem I have.