topic Re: Feature Layer to DataFrame in ArcGIS API for Python Questions

Feature Layer to DataFrame

JillKelly — Sun, 12 Dec 2021 10:45:06 GMT

I understand that SpatialDataFrame has been replaced by a "spatially enabled dataframe." It looks like the former was a function in arcgis.features while the latter goes through pandas. I cannot get either to work! On advice from another thread, I rolled back my pandas to 0.23.4, but that has not helped (arcgis api version 1.6). Using tab-complete, pandas.DataFrame.spatial does not appear to have any methods. Apparently arcgis.features.GeoAccessor has a .from_layer method that yields a pandas dataframe, but I wasn't able to define a feature layer from a url.

Old Way (SpatialDataFrame):

New Way ("spatially enabled dataframe" via pandas):

Third way (GeoAccessor):

from arcgis.features import FeatureLayer, GeoAccessor
FL = FeatureLayer('http://[my institution].maps.arcgis.com/home/item.html?id=fbcae48fb3e64ad886ee84ddb225f39a')
df = GeoAccessor.from_layer(FL)‍‍‍

That FL does not have properties and cannot be mapped, so it's no surprise from_layer fails as well.

Any thoughts?

Re: Feature Layer to DataFrame

HåkonDreyer — Sun, 12 Dec 2021 17:01:00 GMT

If I haven't misunderstood your problem I guess layer.query().sdf is what you are looking for.

from arcgis import GIS
gis = GIS()
_content = gis.content.search("Ziekenhuisen")
_layer = _content[0].layers[0]
_layer.query().sdf

Re: Feature Layer to DataFrame

JillKelly — Tue, 30 Apr 2019 13:03:15 GMT

That *is* what I needed. Apparently you cannot assign it to a variable, which (mistakenly) led me to believe that approach was out of date. Really what I needed is:

df = pandas.DataFrame(_layer.query().sdf)

And now I have that -- thanks!

Re: Feature Layer to DataFrame

HåkonDreyer — Tue, 30 Apr 2019 13:10:55 GMT

Glad to be of help, and actually it's even easier than that:

Re: Feature Layer to DataFrame

JoshuaBixby — Tue, 30 Apr 2019 14:51:52 GMT

Please mark the reply as correct to close out the question, thanks.