topic Re: Spatially Enabled Dataframe issues in ArcGIS API for Python Questions

Spatially Enabled Dataframe issues

MatthewSkewes2 — Wed, 05 Dec 2018 22:42:13 GMT

I previously used the SpatialDataFrame object to access online feature services. With the update of the API to 1.5.1, I have tried to utlise the new Spatially Enabled Dataframe object in the same way, as that appears to be preferred way going forward but I'm running into issues trying to access the same dataset I had no issues accessing with a SpatialDataFrame.

This is the error I receive when I use the simple code below

Exception: Could not load the dataset: cannot perform __truediv__ with this index type: DatetimeIndex

item = gis.content.get("ItemID")
flayer = item.layers[1]
sdf = pd.DataFrame.spatial.from_layer(flayer)

I'm using Python 3.6.7 with the latest version of ArcGISPro

Has anyone had similar issues?

Re: Spatially Enabled Dataframe issues

JoshuaBixby — Sun, 12 Dec 2021 09:28:38 GMT

The example code from Introduction to the Spatial DataFrame | ArcGIS for Developers works for me:

from arcgis.features import SpatialDataFrame
from arcgis import GIS

gis = (url, username, password)
item = gis.content.get("id")
flayer = item.layers[0]
sdf = SpatialDataFrame.from_layer(flayer)‍‍‍‍‍‍‍

Re: Spatially Enabled Dataframe issues

DanPatterson_Retired — Wed, 05 Dec 2018 23:06:07 GMT

The error seems to be with datetime... do you have datetime field(s) in your dataset?

Re: Spatially Enabled Dataframe issues

JohnYaist1 — Wed, 05 Dec 2018 23:14:30 GMT

Hi Matthew Skewes

We've fixed an issue with the Spatially Enabled Dataframe `from_layer()` method that will be available in tomorrow morning's release. Can you run the code after updating the api to 1.5.2 tomorrow and let me now if that addresses the issue?

Re: Spatially Enabled Dataframe issues

MatthewSkewes2 — Thu, 06 Dec 2018 00:16:32 GMT

Hi John Yaist‌

That sounds promising, I'll let you know how it goes after the update.

Cheers

Re: Spatially Enabled Dataframe issues

MatthewSkewes2 — Thu, 06 Dec 2018 21:53:51 GMT

John Yaist the update fixes the issue and using the new object has also has improved the time taken to run the script considerably.

Cheers

Re: Spatially Enabled Dataframe issues

JohnYaist1 — Thu, 06 Dec 2018 22:07:14 GMT

Sweet! Thanks for the follow-up, Matthew Skewes. Bonus on the performance boost - we're always investigating ways to improve on that...good to hear!