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; } } }

How to Delete Fields from File Geodatabase Table using ArcPy

JohnPapageorgiou

Hi,

I'm wondering if someone can help. I'm trying to write a python script that will:
1. Create a buffer
2. Use the buffer to query a feature class
3. Export a file geodatabase table of only the selected features
4. Delete unwanted fields
5. Export the cleaned up table to excel

Steps 1-3 work fine. I can even get that table to export to excel. I am having difficulty with step 4. I've tried various methods to do this but to no avail. Attached is a copy of the script. The Workspace, feature to buffer and proj_prefix are all input parameters not included in the snippet.

Thanks for any help in advance.

John

Counties_query_script.JPG

Vind meer berichten getagd met

Accepted answers

FC_Basson

I think your problem lies in line 161 where you are defining the delete table - you are using the same syntax as for the TableToTable conversion tool, which is incorrect. I believe it should be

countyTable <SPAN class="operator token">=</SPAN> <SPAN class="string token">"gis_data.gdb/"</SPAN> <SPAN class="operator token">+</SPAN> proj_prefix <SPAN class="operator token">+</SPAN> <SPAN class="string token">"_ca_counties"</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

All comments

DougHaller1

Hi All,

I am working with a similar challenge.

Is there a way to keep the fields one wants rather than remove unwanted fields? If so, could one then create a table that is a subset of the original and save it to a new folder with a new name?

I will read about Field Mapping.

Also, would it be better to manage the fields when they are shapefiles or convert the .shp to a .xls first?

Thanks.

Doug

JohnPapageorgiou

Thanks everyone for your contributions! FC Basson your suggestion solved the problem. Thank you so much!

FC_Basson

I think your problem lies in line 161 where you are defining the delete table - you are using the same syntax as for the TableToTable conversion tool, which is incorrect. I believe it should be

countyTable <SPAN class="operator token">=</SPAN> <SPAN class="string token">"gis_data.gdb/"</SPAN> <SPAN class="operator token">+</SPAN> proj_prefix <SPAN class="operator token">+</SPAN> <SPAN class="string token">"_ca_counties"</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

DanPatterson_Retired

You can get the field object and their names readily

field_names <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>f<SPAN class="punctuation token">.</SPAN>name <SPAN class="keyword token">for</SPAN> f <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN>featureclass<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Once you have those, you should check that the field names that you want to delete are actually there

How about an example to demonstrate what I mean

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> del_flds <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"ArEa"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"AREA"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Area"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NotArea"</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> fld_list <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Area"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"length"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"etc"</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> to_delete <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>i <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> del_flds <SPAN class="keyword token">if</SPAN> i <SPAN class="keyword token">in</SPAN> fld_list<SPAN class="punctuation token">]</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> to_delete
<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Area'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Then you can use the DeleteField Delete Field—Help | ArcGIS Desktop

JohnPapageorgiou

Hi Rebecca,

I'm looking into the field_mapping option right now. I'll keep your hint in mind for the next time I post a question.

thanks,

John

JohnPapageorgiou

Hi Dan,

The fields are making it to the output table I create. Is that what you mean? Can you elaborate on "add a check", do you mean create a script that list the fields?

thanks,

John

DanPatterson_Retired

Delete Field—Help | ArcGIS Desktop

Are you sure the fields exist in the file you are creating? Case is important as well. you may need to add a check to see if the field exists prior to deleting it Field—Help | ArcGIS Desktop

RebeccaStrauch__GISP

Hint: use https://community.esri.com/people/curtvprice/blog/2014/09/25/posting-code-blocks-in-the-new-geonet?sr=search&searchId=cb116ac2-10fd-404c-bd11-8ff900abd957&searchIndex=0‌ to make it easier for people to read you code and comment, versus having to open and view a snapshot.

If I understand correctly, you do not want to include some fields in the outputted Excel file. Try including the Fields you want to include using the Field Mapping. It is sometimes easier to run it manually first, then copy the python snippet from the results tab to see the format it wants.

Table To Table (Conversion)

TableToTable_conversion (in_rows, out_path, out_name, {where_clause}, {field_mapping}, {config_keyword})
Parameter Explanation

A couple other possibilities.....if your are trying to delete required fields or the file has a lock

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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