Latest Contributions by JoeBorgione

@SSWoodward I retired back in December 2022 and haven’t even thought about database sequences since then. I have landed a lot of fish however in that time… All seriousness aside, let’s say you get a large influx of data you need to append into your database and with it comes a need to alter the sequence in some fashion. In my (former) case, that could come as an annexation into a city   In a SQL Server database you can back door that but not in the case of the FGDB.  If you need me, I’ll be on the river… ... View more

@arunachalammak - Thanks for your suggestion!  I retired at the end of 2021 and haven’t written a line of Python since!   ... View more

I'd be really surprised if Arcade has a short shelf life.  I'm sold on attribute rules and without Arcade, they don't happen. ArcMap and ArcCatalog have one foot in the grave, there's just no denying it. By the end of this week, all this stuff will be in my rear-view mirror, but I've had a ton of fun with Unix Scripts, AML, PERL, VB, VBA, Python, and Arcade over the years in various flavors of ESRI-Arc* products. You may notice I left out Avenue.  IMHO that along with ArcView was a mistake and luckily did have a short shelf life. (And somehow I never spent much time or energy with it...) ... View more

What if you use an attribute rule that grabs a the next value from a geodatabase sequence? ... View more

...never, have duplicate names... ^^^ This... ... View more

Or turn the rule off when you are running the update cursor.... ... View more

Conceptually with python: Select Compartment Polygon (probably from a list) Spatially select those subcompartments within the compartment Get a count of the number of subcompartments If Count <= 26 Call an update cursor routine that updates the the subcompartmentField with CompartmentID and a letter else if count > 25 and < 51 call a different cursor See code below for what I came up with.   import string alphaList = list(string.ascii_lowercase) value = 0 compartmentID = 25 # from a list of your compartments feature class #you'll need to nest all of this in another loop NumberofSubCompartments = 15 + 1 # get 15 from the count of sub- #compartments for count in range(1,NumberofSubCompartments): if value <= 25: a = alphaList[value] value +=1 print(f'{compartmentID}{a}') elif value > 25 and value < 51: for a in alphaList: print(f'{compartmentID}{a}{value}') value += 1   No warranties or guarantees.  This is conceptual at best.  Plug in different values  in line 6 that would be the count of sub-compartments.  Those lines that use the print(fString), create the value to plug into the update cursor.   subCompartmentId = f'{compartmentID}{a}' #add your update cusor here and subcompartmentId = f'{compartmentID}{a}{value}' #add your update cursor here... I ... View more

@TimWitt2 wrote a nifty python add-in a few years back that took care of dangles. It was written for ArcMap but the code might (should?) be able to be adapted to Pro. Your illustration shows some pretty ugly tracks; it's going to take some manual editing to fix stuff like that, so get ready to roll your sleeves up and get your hands dirty. ... View more

I think the final results would be best if they were within a unique feature dataset (one for each county). Are you using feature datasets to organize your data or are you using them as they were designed to be a container of features that have special characteristics or relationships like topology, network datasets, etc?  If the former, my suggestion is to rethink that approach as it will eventually cause you headaches. As far as your for loop is concerned, that's pretty straight forward and if you are using Pro you are using python 3.x so while you can use the format function, I prefer "f-strings": countyList = ['Cache', 'Weber', 'Rich', 'Salt Lake'] for name in countyList: print(f'Some extra text {name}')  Copy and paste this code into your python ide of choice....   ... View more

The rules are fairly complicated, but I can find them by Right Clicking on Address Points in the table of contents, selecting Design and then Attribute Rules.  In the solution, the work flow has the user drop an Address Point on a street centerline and through a relationship class a Site Address Point is created.     ... View more

Take a look at the ESRI Address Data Management Solution; it has similar rules written between address points and related site address points. There is an aprx you can download that has sample data and the rules are applied there. ... View more

The above solution above doesn't seem to work for Pro versions 2.8 ... Well, I have Pro 2.8.2 installed and Spyder 5.0.5 installed in a cloned environment and things are working smoothly.  I'm two weeks out from retirement and plan to enjoy the time I have left, so I won't be upgrading to 2.9.0 anytime soon.... ... View more

Awesome idea! ... View more

I stand corrected.  I think....  Take a look at https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/extract-package.htm and see if you can make sense of it... ... View more