Latest Contributions by JoeBorgione

I've been an ESRI user continuously since 1990 and have seen a number of software rebuilds along the way. It's been nearly two years since I've used ArcGIS Pro exclusively; I think this is the best I've seen.  Never look back.... ... View more

I have similar rules with my site address points.  That's something I've wrestled with as well, firing rules upon editing the feature, regardless of how small an edit it is.  The best I've come up with is to disable the rule, make your edits and then re-enable the rule when you're done. ... View more

You might have to go into the aprx then and re-insert the new name table to get the the new alias name. I don't do much in the lines of mapping.  I'm just a simple data miner..... ... View more

If your data is in a FGDB why bother testing on a shapefile? ... View more

What have you tried? ... View more

I created a shapefile just to try what you are doing I get really weird results in a SQL select window.  I bet I haven't created a shapefile in over 10 years, and this is one of the reasons why:         ... View more

Take a closer look at the online help page.  Like other arcpy tools, this one creates an Object, and you have to tease the properties out of that object to make sense of it.  The help page gives a good example of mixing arcpy along with the os module in python to get what you are after.  ... View more

I don't see where you actually make a feature layer after line 3 in the first code block.   Edited moments later: are you really using a shape file, because they don't support <Null> values.... ... View more

Great catch @JohannesLindner ! ... View more

  for lyr in lyrList: if lyr.isFeatureLayer: a for-loop. It reads if a layers in the lyrList is a feature layer it gets stored as Boolean (T/F) in lyr? Not really. You need to do something when an if statement evaluates to True or False.... aprx = arcpy.mp.ArcGISProject("CURRENT") m = aprx.activeMap lyrList = m.listLayers() len(lyrList) # returns 11 for i in lyrList: print(i) Address Points Site Addresses Subdivisions_MSD MSD.SLCOMSD.AddressGridMSD RoadCenterline All CenterlinesMSD MunicipalitiesMSD MSD.SLCOMSD.ParcelsMSD MSD.SLCOMSD.Zones ZipcodesMSD World Imagery for i in lyrList: if i.isFeatureLayer: print('yay') ''' returns yay yay yay yay yay yay yay yay yay yay '''   Notice that while the length of my layer list = 11, when the if statement evaluates true, 'yay' is only printed 10 times. That's because the entry 'World Imagery' is not a feature layer.  Use an else to capture that: for i in lyrList: if i.isFeatureLayer: print('yay') else: print(f'{i} is not a feature layer') ''' returns yay yay yay yay yay yay yay yay yay yay World Imagery is not a feature layer '''   ... View more

Hadn't even thought about that! ... View more

In the code below, I concatenate a bunch of attributes and then use the proper() function to make the final text pretty.  Use the upper () function instead in line 12... var values = [$feature.NAME, $feature.POSTTYPE, $feature.POSTDIR] var combined_value = []; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return proper(Concatenate(combined_value, " "));  This fires on Insert and Update. ... View more

I've never added a python window that way, but I have a python window open by going to the View Tab, and clicking on Python Window. I didn't need to import arcpy. ... View more