spatial.to_featurelayer strips time resulting in data loss

martinschaefer1

Hi,

 

Exporting a spatially enabled dataframe (SDF) to AGOL using spatial.to_featurelayer with a datetime column strips the time as it creates a shapefile and due to the way shapefiles handle dates. Alternative is to create a str column using strftime or to use the more cumbersome method of creating a csv item and publishing that, completely bypassing the SDF.

 

Could  I suggest:

1. Adding a check to to_featurelayer, and either returning  a warning or converting the datetime to string
2. Adding a warning to the documentation

Code to demonstrate the issue attached as .ypnb.

 

Best wishes

M.

 

 

time_test.zip

Clip_57.jpg

GauravJobanputra_0-1714176217350.png

martinschaefer1

That's a good shout. I was using AGOL Notebooks, which I kinda assumed had the latest version. Lesson 1, check, don't trust.

AGOL Notebooks is on 1.8.1, and to_featurelayer creates a shapefile. Running a Pro Notebook shows 1.8.3, and to_featurelayer creates a gdb in AGOL, solving this issue.

I will let ESRI support know, as I had raised a job with them first, they did not have the solultion, thanks for the suggestion.