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

Python Script for Field Search

JustinCrowther1

Hello,

I am looking to figure out a python script to automate, in field calculator, looking through multiple fields and providing a Yes if data is present.

Context:
I have a Feature Class for permitted sections. This feature class has multiple permits; and the permits can cover multiple sections. I am looking to create one field that indicates if the section has a permit, regardless of the permit type. I cannot figure out the script to automate this process.

Any suggestions would be greatly appreciated.

Thanks,
Justin

Vind meer berichten getagd met

Accepted answers

jskinner

You can iterate through the fields and only search the permit fields. Ex:

fc = "permits"  for field in arcpy.ListFields(fc):     #Specify all none permit fields     if field.name != "OBJECTID" and field.name != "Shape" and field.name != "Shape_Length" and field.name != "Shape_Area" and field.name != "GlobalID" and field.name != "HasPermit":         with arcpy.da.UpdateCursor(fc, [field.name, "HasPermit"], "NOT " + field.name + " IS NULL") as cursor:             #if query is valid, set hasValue variable to 'true'             hasValue = 'true'             if hasValue == 'true':                 for row in cursor:                     row[1] = "YES"                     cursor.updateRow(row)                 hasValue = 'false'  del cursor, row

All comments

jskinner

You can iterate through the fields and only search the permit fields. Ex:

fc = "permits"  for field in arcpy.ListFields(fc):     #Specify all none permit fields     if field.name != "OBJECTID" and field.name != "Shape" and field.name != "Shape_Length" and field.name != "Shape_Area" and field.name != "GlobalID" and field.name != "HasPermit":         with arcpy.da.UpdateCursor(fc, [field.name, "HasPermit"], "NOT " + field.name + " IS NULL") as cursor:             #if query is valid, set hasValue variable to 'true'             hasValue = 'true'             if hasValue == 'true':                 for row in cursor:                     row[1] = "YES"                     cursor.updateRow(row)                 hasValue = 'false'  del cursor, row

JustinCrowther1

Jake,

Thanks for the help! I tried that code with some modification to my data and it worked for two fields. Only thing i have and issue with is that I have over 50 fields to search through. Is there a way to stream line this code with out writing out each field multiple times?

Justin

jskinner

Hi Justin,

You could use the following:

fc = "permits"

with arcpy.da.UpdateCursor(fc, ["Permit1", "Permit2", "HasPermit"], "NOT Permit1 IS NULL OR NOT Permit2 IS NULL") as cursor:
    for row in cursor:
        row[2] = "YES"
        cursor.updateRow(row)

del cursor, row

What the code does is search through the permit fields (i.e. Permit1, Permit2) and if any of them have a value it will populate the 'HasPermit' field with a value of YES.

If your data does not have NULL values, you will have to update the query to:

NOT Permit1 = '' OR NOT Permit2 = ''

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.