Select to view content in your preferred language

Pandas DataFrames and tables Problem

4492
10
08-05-2020 12:33 AM
AlbertoCañivano
Occasional Contributor

I have a service published in ArcGis Online that consists of a layer and two related tables.
I have to access one of the tables to write a url and I'm using Pandas to do it. Until now it worked correctly, but now I get the following error.

item = gis.content.get("xxxxxxxxxxx")
foto = (item.tables)[1]
field_service_dataframe = pd.DataFrame.spatial.from_layer(foto)

Could not load the dataset: 'PropertyMap' instance has no attribute 'drawingInfo'

If I want to access the layer, I can create the dataframe correctly; however with a table I can't.
Is it normal that only the data of the layer can be accessed or I have something missing in my code?

Tags (3)
10 Replies
DanielPérez_López
Occasional Contributor

Thank you for your interest in my problem and excuse the "username dance" I write with.

So you're telling me that it's not possible to access a table within a feature service published in ArcGis Online using

pd.DataFrame.spatial.from_layer(item.tables[0])

 right?

I need to access that table because I want to automatically modify a field with a value I collect in my survey.

I get this value from a layer via

item.tables[0].query_related_records()


Or at least I used to.

I tried

SpatialDataFrame.from_layer(item.tables[0)

and I can get into the table, as I told you

.

However, the "objectID" field of the table, which I need to get the related value from the layer, doesn't appear, all fields (GlobalId, ParentId..except that one).

Can you think of another way to access the table?

Thanks!