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

Row 'isNull()' problem

KevinYanuk

Hello,

I am attempting to loop over a centerline shapefile and pull out specific values per field value to set as a new row value in another shapefile.

However, the code fails when the returned value is null, even when using the isNull() method as so:

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002z0000001q000000

if not self.centerline.isNull(suffix):     self.newStreet.S_suffix = self.centerline.getValue(suffix)

Has anyone run into this problem with this method before?

Find more posts tagged with

Accepted answers

JimCousins

I have not run into this specifically, but what about putting in some error handling to allow your code to continue on past these rows?
Implement the Try-Except block statement.
Regards,
Jim

All comments

rzufelt

Does this work for you?

if self.centerline.getValue(suffix) is not None:
    self.newStreet.S_suffix = self.centerline.getValue(suffix)

JamesCrandall

da.SearchCursor has some options too:


fields = ['fld1', 'fld2', 'fld3']
for field in fields:
   where = field + " IS NOT NULL"
   try:
       with arcpy.da.SearchCursor(fc, fields, where) as cursor:
          for row in cursor:
              value = row[0]
              print field + ": " + str(value) #or use "value" to do something
   except Error:
       pass

del row, cursor

note: I first tested for "IS NULL" values and simply printed them out and it correctly listed/printed the fields and the null value. So then I just altered it to "IS NOT NULL" to get the opposite result, printing all values for each field that is not null. I did not fully research this for better option, do additional testing or determine if this is actually incorrect --- so I am very open to critique of the above!

KevinYanuk

I have not run into this specifically, but what about putting in some error handling to allow your code to continue on past these rows?
Implement the Try-Except block statement.
Regards,
Jim

Thanks for the reply - that is what I had to do:

                try:
                    if not self.centerline.isNull(name):
                        self.newStreet.S_name = self.centerline.getValue(name)
                except:
                    pass
                
                try:
                    if not self.centerline.isNull(prefix):
                        self.newStreet.S_prefix = self.centerline.getValue(prefix)
                except:
                    pass

                try:
                    if not self.centerline.isNull(suffix):
                        self.newStreet.S_suffix = self.centerline.getValue(suffix)
                except:
                    pass

                try:
                    if not self.centerline.isNull(type):
                        self.newStreet.S_type = self.centerline.getValue(type)
                except:
                    pass

Although, not the prettiest, I suppose it works.

JimCousins

I have not run into this specifically, but what about putting in some error handling to allow your code to continue on past these rows?
Implement the Try-Except block statement.
Regards,
Jim

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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