Latest Contributions by JoeBorgione

I think I'd got the route of using python to extract the access tables to a csv and then to a table to table with arcpy.  see https://datatofish.com/how-to-connect-python-to-ms-access-database-using-pyodbc/  for pyodbc and https://stackoverflow.com/questions/37289951/how-to-write-to-a-csv-line-by-line/37290105#37290105 to write to a csv... ... View more

Thanks @KoryKramer !    Not to rain on the parade but when will we see : https://community.esri.com/t5/arcgis-pro-ideas/let-us-create-an-alias-for-connected-folders-in-arcgis-pro/idi-p/969285 implemented? ... View more

Hence  'think' in italics.  I've never written arcade for anything but Pro, and always used the $featureDotAttribute syntax... ... View more

I think the difference is how you are referencing the feature attribute:   if($feature["HH_STATUS"] == 0) // try replacing with: if($feature.HH_STATUS == 0)     ... View more

If you run the Project Tool in arcgis pro, you will get all the parameters you need from the tool itself.  You can then fold them into a script as described in the help https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/project.htm ... View more

That's what's so fun about a post like this!  Several different approaches that all work. I've never ever used rsplit(). Joshua's nested map() is pretty cool too!  Just hope the OP isn't overwhelmed! ... View more

I haven't yet upgraded to 2.7 but plan to in the next (working) day or so.  When upgrading to a new version of ArcGIS Pro, if you have cloned environment that the previous version pointed to, that environment is no longer available to your newest version.  This is one of the reasons I'm always hesitant to upgrade. Seems like I get an environment just the way I want it with additional packages and ArcGis Pro gets version change. Incremental upgrades (2.6 to 2.6.1) will honor the current, active clone. ... View more

I love the contrast in our styles!  ... View more

Check for the presence of a comma.  Treat row[0] as a list, pop() off the last member of that list and glue the whole mess back together, replacing the comma.... with arcpy.da.UpdateCursor(Table, ['Fld_1']) as cursor: for row in cursor: if ',' not in row[0]: pass elif ',' in row[0]: rowList = row[0].split(' ') first = rowList.pop() last = ' '.join(rowList) newRow = f'{first} {last}'.replace(',','') row[0] = newRow cursor.updateRow(row)   ... View more

I didn't know if it would work or not.  Excel and me aren't the best of friends: we tolerate each other because we have to!   ... View more

Mixing metaphors; Arcade and Python.  I suggest just doing it all in python and run the script as scheduled task or as you suggest a notebook. ... View more

Can't you just add it to a pro project?  Better yet, wean you company off excel and into the geodatabase world... ... View more

Gotcha, and I've done the same on a very limited basis. Maybe create a batch file that sniffs them out and deletes them on start up? ... View more