Latest Contributions by ColinLang1

For those who may benefit from it, this is the code I'm going with as slow, but workable: ## f1 is temporary feature class with todays date, output by other processes. f1 = "RSE20190328" fields = ['L_StName','L_StDir','L_StTypP','L_StTypS','L_PlName'] ## street name, street direction, street type prefix, street type suffix and place name with arcpy.da.SearchCursor(f1,fields, sql_clause=('DISTINCT','ORDER BY L_PlName, L_StName, L_StTypS')) as cursor1:    for row1 in cursor1:       street_name = row1[0]       street_direction = row1[1]       street_prefix = row1[2]       street_suffix = row1[3]       street_place_name = row1[4]       ## some street names have apostrophes in them - make the search replace that with a % because no combination I tried of escaping or backslashing the quote seemed to work correctly       where2 = "L_StName = '" + street_name.replace("'","%") + "'"       if street_direction is not None:          where2 += " and L_StDir = '" + street_direction + "' "       if street_prefix is not None:          where2 += " and L_StTypP = '" + street_prefix + "'"       if street_suffix is not None:          where2 += " and L_StTypS = '" + street_suffix + "'"       ## some place names have apostrophes in them - make the search replace that with a % because no combination I tried of escaping or backslashing the quote seemed to work correctly       if street_place_name is not None:          where2 += " and L_PlName = '" + street_place_name.replace("'","%") + "'"       ## work with left and right sides separately as they may have 0,0 ranges in different spots.       fields2 = ['L_LADD','L_HADD','ID'] ## left low address and left high address       list2 = [] ## put results into list so we can easily compare each row to the previous row -- hard to do in a cursor       with arcpy.da.SearchCursor(f1, fields2, where2, sql_clause=(None,'ORDER BY L_LADD, L_HADD')) as cursor2:          for row2 in cursor2:             if row2[0] == 0 and row2[1] == 0: ## ignore 0,0 ranges for my purposes             continue             list2.append([row2[0], row2[1], row2[2]])       for i in range (0, len(list2)-1):          if list2[1] == list2[i+1][0] - 2: ## if there is a gap of exactly 2 there is no gap or overlap             ##print "1: Good"             continue          elif list2[1] <= list2[i+1][0]:             print "2:Gap" ## print results for now - eventually I will put the results into a separate list, and do an update cursor on them to             print street_name + " " + street_suffix + " " + street_place_name + ": " + str(list2)             continue          elif list2[1] > list2[i+1][0] - 2 :             print "3:Overlap"             print street_name + " " + street_suffix + " " + street_place_name + ": " + str(list2)             continue       fields3 = ['R_LADD','R_HADD','ID'] ## right low address and right high address       list3 = []       with arcpy.da.SearchCursor(f1, fields3, where2, sql_clause=(None,'ORDER BY R_LADD, R_HADD')) as cursor3:          for row3 in cursor3:             if row3[0] == 0 and row3[1] == 0: ## ignore 0,0 ranges for my purposes                continue             list3.append([row3[0], row3[1], row3[2]])       for i in range (0, len(list3)-1):          if list3[1] == list3[i+1][0] - 2:             ##print "1: Good"             continue          elif list3[1] <= list3[i+1][0]:             print "2:Gap"             print street_name + " " + street_suffix + " " + street_place_name + ": " + str(list3)             continue          elif list3[1] > list3[i+1][0] - 2 :             print "3:Overlap"             print street_name + " " + street_suffix + " " + street_place_name + ": " + str(list3)             continue ... View more

They're definitely not equal.  Like was my only hope.  I have found the solution, and it's a head-scratcher....  this fails: where = 'UPPER("EmergencyServiceZones.POLICE") LIKE UPPER("msag_temp.Police")' this works: where = 'UPPER("msag_temp.Police") LIKE UPPER("EmergencyServiceZones.POLICE")' for some bizarre reason, a space is LIKE an underscore, but an underscore is not LIKE a space. ... View more