topic Spatial Enable DataFrame to Enterprise GeoDatabase (EGDB) (.sde) in Python Questions

Spatial Enable DataFrame to Enterprise GeoDatabase (EGDB) (.sde)

TylerT — Mon, 25 Mar 2024 19:49:18 GMT

Hello,

I'm attempting to write a spatially enabled dataframe to an SQL Server Enterprise Geodatabase with the sedf.spatial.to_featureclass(location) method. It's not clear to me what I need to pass as the location parameter when dealing with an EGDB.

There doesn't seem to be any mention of exporting sedfs to EGDB feature classes on this page https://developers.arcgis.com/python/guide/part3-data-io-writing-data/, rather only mention of exporting to feature layer.

Any pointers would be appreciated.

Tyler

ArcGIS Enterprise 11.2
ArcGIS Pro 3.2.0

Re: Spatial Enable DataFrame to Enterprise GeoDatabase (EGDB) (.sde)

Clubdebambos — Tue, 26 Mar 2024 06:58:20 GMT

Hi @TylerT

It would be useful to see what you have attempted and the error(s) you are getting.

Re: Spatial Enable DataFrame to Enterprise GeoDatabase (EGDB) (.sde)

TylerT — Wed, 27 Mar 2024 12:50:09 GMT

Hello. Thanks for the response. This is the error I'm getting:

ExecuteError: Failed to execute. Parameters are not valid. ERROR 000732: Feature Class Location: Dataset Z:\dir\...\db.sde does not exist or is not supported Failed to execute (CreateFeatureclass).

The location was captured from ArcGIS Pro > Catalog > Databases > select Enterprise Connection > Copy Path...

Interestingly, the same path works just fine for arcpy tools such as arcpy.management.CreateFeatureclass(), and other management tools...

arcpy.env.workspace = r"Z:\dir\...\db.sde" arcpy.management.CreateFeatureclass(<args>) #This works!

My working theories are:
1) There is an added nuance in the path that I'm not seeing in the docs?,
2) The geoaccessor namespace sedf.spatial.to_featureclass(location) method requires the more complex connection string rather than a simple path (I haven't been able to test this yet, b/c I'm also troubleshooting arcpy.management.CreateDatabaseConnectionString() in a separate post since this issue is independent)?
3) It's not possible to write to SEDF to EGDB (seems unlikely, but then again, why is it not mentioned in i/o post https://developers.arcgis.com/python/guide/part3-data-io-writing-data/)?

Any thoughts?

Tyler
Enterprise 11.2
ArcGIS Pro 3.2.0

Re: Spatial Enable DataFrame to Enterprise GeoDatabase (EGDB) (.sde)

TylerT — Wed, 27 Mar 2024 14:29:29 GMT

Hello,
I broke through the barrier. It is possible to write to EDGBs using GeoAccessor sedf.spatial.to_featureclass(location). The location parameter is a string and takes a similar form as writing to a gdb (e.g. r"Z:\some_dir\...\db.sde\wetlands"). I'm not exactly sure what issue I was having. When viewing the Enterprise Database Connection in ArcGIS Pro there was an exclamation point near the connection, so I restarted my PC, removed and replaced the connection from the APRX, then it worked.

Tyler