arcpy/arcgis and geodatable tables

kkUSGS — Fri, 10 Jun 2022 16:18:10 GMT

Hello Pro users,

I'm using the arcpy and arcgis libraries to access feature classes from a geodatabase. The geodatabase also contains non-spatial tables. I would like to read and write these tables leveraging arcpy and pandas. That is, pandas allows much greater functionality for completing operations (compared to search cursors). But, the arcpy/arcgis allow me to access tables stored in geodatabases (and not have to have duplicative tables in a text or csv format).

I can't find documentation for what method/library to use. And it seems that this functionality may not exist (see this post of a similar issue: https://community.esri.com/t5/arcgis-api-for-python-questions/export-dataframe-to-table/td-p/1019327).

Currently, I access feature classes via the spatially enable dataframe using:

pd.DataFrame.spatial.from_featureclass(filehere)

If I try that same call on a table within the geodatabase, I receive the error: KeyError: 'shapeType' which I'm assuming is because the table doesn't have a shape field. However, I can't find documentation of the available spatial methods to see if there is a similar method in the .spatial classes (like pd.DataFrame.spatial.from_table()). I want to be able to read the table into memory. Not just point to the file location or create an in-memory layer (which is what arcpy.MakeTableView_management() would do).

Am I missing something simple? Any ideas?

Re: arcpy/arcgis and geodatable tables

Anonymous User — Fri, 10 Jun 2022 16:41:28 GMT

It looks like there are 2 good solutions at this SO question.

It also looks like ESRI is working on that feature here.

topic Re: arcpy/arcgis and geodatable tables in ArcGIS Pro Questions

arcpy/arcgis and geodatable tables

Re: arcpy/arcgis and geodatable tables