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

Check for existence of a field

MikeDriver

How do you check for the existence of a field in a feature class? v10.
I did this, but it seems clunky.

import arcpy
fc = r"C:\temp\test.shp"
desc = arcpy.Describe(fc)
flds = desc.fields
fldin = 'no'
for fld in flds:
if fld.name == 'USNG':
fldin = 'yes'

print fldin

Najděte více příspěvků označených jako

Accepted answers

All comments

MikeDriver

Lines:
if fld.name == 'USNG':
fldin = 'yes'

should be indented, of course.

JakeSkinner

Your code will work with no problems. You can also use the 'arcpy.ListFields' function. Ex:

lstFields = arcpy.ListFields(fc)

x = False

for field in lstFields:
    if field.name == "USNG":
        print "Field exists"
        x = True

if x <> True:
    print "Field does not exist"

I tested the Describe function vs the ListFields function using the time module, and the ListFields function was slightly faster by a tenth of a second.

Also, to preserve indentation when copying/pasting your code, select your code and click the '#' button at the top. It will wrap it in CODE tags.

StacyRendall1

lstFields = arcpy.ListFields(fc)

if "USNG" in lstFields:
    print "Field exists"
else:
    print "Field does not exist"

Not sure if there is any speed difference... The 'in' thing is pretty handy for checking if something is in a list - in this case the ListFields is a list. For example:

>>> a = [3,5,6,'kitty']   # a Python list
>>> b = 2
>>> b in a
False
>>> c = 5
>>> c in a
True
>>> d = 'kitty'
>>> d in a
True
>>>

MikeDriver

Thanks all!

curtvprice

An empty list evaluates to False so here's the way I do it:

if arcpy.ListFields(tbl, field_name):
     print "Field exists"
else:
     print "Field doesn't exist"

It should be noted that AddField_management does not fail if you add a field that exists already, it just prints a warning and doesn't do anything. (Makes for less complicated ModelBuilder models.)

TylerCovington

This is the most direct. Your code is so clear and concise. Well done!

curtvprice

Stacy's arcpy.ListFields returns a list of field objects (not field names) so the "in" operator would not work. You could make it work by converting the list to field names (and converting to upper case because the in operator is case sensitive).

lstFields <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">)</SPAN>
field_names <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>f<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> f <SPAN class="keyword token">in</SPAN> lstFields<SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="string token">"USNG"</SPAN> <SPAN class="keyword token">in</SPAN> field_names<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Field exists"</SPAN> 
<SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN> 
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Field does not exist"</SPAN>‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

se2539

Tested Stacy's code above and curtvprice is correct, the "in" operator will not work.

se2539

This code worked for me. Using a couple for loops I was able to run this against multiple feature classes within multiple feature datasets to determine if a field was present.

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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