topic Converting spatially enabled dataframe to feature class returns empty feature class in ArcGIS API for Python Questions

Converting spatially enabled dataframe to feature class returns empty feature class

DarrenConly — Sat, 18 Dec 2021 22:16:17 GMT

Greetings All,

I'm trying to do the following:

Convert JSON results from OpenRouteService API into geodataframe
Convert a geopandas geodataframe to a Spatially enabled dataframe (SEDF) using .from_geodataframe()
Export the SEDF to a feature class using .to_featureclass()

As the screenshot below shows, the conversion from geopandas GDF to ESRI SEDF is successful, but when I try exporting the SEDF to a feature class, the resulting feature class has no features in it.

Other notes

I do have arcpy installed and imported it.
I also tried exporting SEDF to SHP, but that also returns zero features.
If I import a feature class to an SEDF then re-export the SEDF back to feature class, it works and I get the features as expected.
There *is* a workaround if I do the following: convert SEDF to FeatureSet > FeatureSet to geojson > run JSON to features in arcgis pro. The feature class resulting from this does work and contains the features I expect. But this is clunky!

Has anyone else experienced this?

Re: Converting spatially enabled dataframe to feature class returns empty feature class

DanPatterson — Sun, 19 Dec 2021 01:32:43 GMT

there are some issues under consideration on github

Re: Converting spatially enabled dataframe to feature class returns empty feature class

jcarlson — Sun, 19 Dec 2021 20:20:51 GMT

I'm unable to replicate this issue. JSON -> GDF -> SEDF -> FC works like a charm anywhere I use the process (which is admittedly not often).

Have you done some other testing on your geodataframe to make sure it's valid? Like plot it, or run some other validation?

Re: Converting spatially enabled dataframe to feature class returns empty feature class

DarrenConly — Sun, 19 Dec 2021 23:38:01 GMT

Yes, it plots correctly when I plot the geopandas geodataframe:

It also plots correctly after I convert the GDF to ESRI's SEDF:

And as I mentioned in my original post, if I do SEDF > FeatureSet > GeoJSON File > Feature class, it works. So the kink is when trying to directly go from SEDF to feature class.

Re: Converting spatially enabled dataframe to feature class returns empty feature class

DarrenConly — Mon, 20 Dec 2021 00:32:15 GMT

Could be. I read the thread you linked to. Problem is similar (issue going from SEDF to FC), but instead of my issue (writing empty FC), it seems to mangle the geometry when writing. Looking at the GitHub issue they opened, there will be a fix for the mangled geometry coming in January 2022, maybe that fix will also fix my problem?

Re: Converting spatially enabled dataframe to feature class returns empty feature class

BillyHansen6 — Sat, 16 Jul 2022 13:11:37 GMT

I'm having the same problem! Would love some help if anybody has an idea why this is happening.

Re: Converting spatially enabled dataframe to feature class returns empty feature class

BillyHansen6 — Sat, 16 Jul 2022 13:35:40 GMT

Okay for me the problem was solved when I removed the date fields from my spatial dataframe. For some reason those were breaking the export.