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 ( "xyz" ) 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?

Not OP but I had been using version 1.7. I didn't change anything in my code bu now I get Could not load the dataset : 'PropertyMap' instance has no attribute 'drawingInfo' after moving to 1.8

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Pandas DataFrames and tables Problem

AlbertoCañivano

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 <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">=</SPAN> gis<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>content<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN><SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">get</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN><SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">"xyz"</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN>
foto <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">=</SPAN> <SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN>item<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>tables<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">[</SPAN><SPAN class="" style="color: #990000; border: 0px; font-weight: inherit;">1</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">]</SPAN>
field_service_dataframe <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">=</SPAN> pd<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>DataFrame<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>spatial<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN><SPAN class="" style="color: #d74444; border: 0px; font-weight: inherit;">from_layer</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN>foto<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN>

Could not load the dataset<SPAN class="operator token">:</SPAN> <SPAN class="string token">'PropertyMap'</SPAN> instance has no attribute <SPAN class="string token">'drawingInfo'</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

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?

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

DanielPérez_López

I contacted the ESRI support team, they told me it was a bug in the program and that with the new release they would fix it.

Pandas DataFrames and tables Problem · Issue #771 · Esri/arcgis-python-api · GitHub

In the meantime, it's still (more or less) working for one table but for another table it's not working. Also, if I make a new Notebook with the same code, it doesn't work for any table.
I'll keep an eye on the new version of the api

bixb0012

It does seem to be a software defect. I encourage you to open a case with Esri Support and/or submit an issue on Issues · Esri/arcgis-python-api · GitHub

JohnHuillery1

Not OP but I had been using version 1.7. I didn't change anything in my code bu now I get

Could not load the dataset<SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit; font-size: 14px;">:</SPAN> <SPAN class="" style="color: #669900; border: 0px; font-weight: inherit; font-size: 14px;">'PropertyMap'</SPAN> instance has no attribute <SPAN class="" style="color: #669900; border: 0px; font-weight: inherit; font-size: 14px;">'drawingInfo'</SPAN>

after moving to 1.8

DanielPérez_López

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<SPAN class="punctuation token">.</SPAN>DataFrame<SPAN class="punctuation token">.</SPAN>spatial<SPAN class="punctuation token">.</SPAN><SPAN class="token function">from_layer</SPAN><SPAN class="punctuation token">(</SPAN>item<SPAN class="punctuation token">.</SPAN>tables<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

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<SPAN class="punctuation token">.</SPAN>tables<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">query_related_records</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Or at least I used to.

I tried

SpatialDataFrame<SPAN class="punctuation token">.</SPAN><SPAN class="token function">from_layer</SPAN><SPAN class="punctuation token">(</SPAN>item<SPAN class="punctuation token">.</SPAN>tables<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

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!

bixb0012

Since Esri deprecated the SpatialDataFrame at version 1.5, I don't think switching to it represents a long-term solution, although it is good to get you past the problem for right now. Regarding from_layer, either the documentation is wrong or the software has a defect, that much is clear.

DanielPérez_López

Hi, Joshua.
Thank you for answering.
To make the script I based on the following post:
https://community.esri.com/community/comunidad-geotec/blog/2019/10/03/agregar-la-url-de-un-adjunto-a-la-tabla-o-capa.
The author said that instead of using a layer, it was possible to enter a table (my project is about Survey123 repeats and the relational tables I need).
I modified the code for my example and it worked perfectly (running on the ArcGis Online Notebook, in BETA version: I don't know if the BETA output to production may have been the problem).

It's true that with the previous code it seems that I can't access the table anymore (as I said before I could, and with other tables I can; even mehdi pira in his answer says that he has been able to access it.

I'm testing with

<SPAN class="keyword token">from</SPAN> arcgis<SPAN class="punctuation token">.</SPAN>features <SPAN class="keyword token">import</SPAN> SpatialDataFrame<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Introduction to the Spatial DataFrame | ArcGIS for Developers

And it does read the tables. But there are fields in the table that do not read it (I am interested in taking the ObjectID of a table to get a value from the layer, through the relationship that is given between the two tables.

Thank you

bixb0012

Alberto Cañivano‌, I tested your code snippet using ArcGIS API for Python versions 1.8.x, 1.7.x, and 1.6.x; and they all fail the same way. So, unless you were using an old version of the API, I don't think anything in the API has changed recently that would make it stop working when it did before.

What version of the API have you been using up until recently?

AlbertoCañivano1

Thank you for your answer.
I keep getting bugs when I use Pandas with a table, the funny thing is that if I want to consult a layer, I don't have any problem and it shows correctly

geometry <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>item<SPAN class="punctuation token">.</SPAN>layers<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
field_service_dataframe <SPAN class="operator token">=</SPAN> pd<SPAN class="punctuation token">.</SPAN>DataFrame<SPAN class="punctuation token">.</SPAN>spatial<SPAN class="punctuation token">.</SPAN><SPAN class="token function">from_layer</SPAN><SPAN class="punctuation token">(</SPAN>geometry<SPAN class="punctuation token">)</SPAN>
field_service_dataframe<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JohnHuillery1

I also have this problem since upgrading to ArcGIS Pro 2.6. Layer and index are correct. Worked fine before upgrading ArcGIS Pro.

MehdiPira1

Hi Alberto Cañivano‌

I tested the same code with a sample feature layer and it's working fine.

I just changed the item.tables index to 0 as I only have one related table to the feature layer.

item <SPAN class="operator token">=</SPAN> gis<SPAN class="punctuation token">.</SPAN>content<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"xyz"</SPAN><SPAN class="punctuation token">)</SPAN>
foto <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>item<SPAN class="punctuation token">.</SPAN>tables<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
field_service_dataframe <SPAN class="operator token">=</SPAN> pd<SPAN class="punctuation token">.</SPAN>DataFrame<SPAN class="punctuation token">.</SPAN>spatial<SPAN class="punctuation token">.</SPAN>from_layer<SPAN class="punctuation token">(</SPAN>foto<SPAN class="punctuation token">)</SPAN>
field_service_dataframe<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Output:

I recommend check you feature layer first, then change the index.

you can also check the code on other feature layers to see if it throws the same error.

I hope that helps.

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.