Latest Contributions by JoeBorgione

In python you need to use strftime() from the datetime module to format date fields as a string.  See this for a handy how-to. ... View more

If you google 'ESRI Error 000597', you get this return.  Check the data you are appending for null values in fields where the target data does not allow null values. ... View more

How many more columns are appended to the table with the join?  And are you really using shapefiles?  Is there a particular reason you cannot use a relationship class rather than a permenant join? ... View more

As I've said before, the G in GIS isn't Google... Is 65 meters an issue for you?  I mean do you need better precision than that? If so perhaps you need to consider a different work flow for your conversions.  Remember too that various projections and spatial references may and often times do use different datums.  Consequently, a conversion may induce 'error'. @MelitaKennedy  ... View more

Good idea @DavidPike ! ... View more

You aren't the only one; if you search on something like 'special characters' in the python space, you'll see I am your compadre in pain.  The problem with allowing special characters in a database is they may be great for the those entering/creating the data but they suck for those of use who actually use the data.   As you've probably discovered, once you filter out for one special character, there are a dozen more that pop up. Can you provide some of the data that it's choking on?  Even just in the form of a csv.  Maybe another set of eyes is all you need.   EDITED MOMENTS LATER.... I just noticed in lines 9 & 10 you haven't used arcpy.makeFeatureLayer   prior to your selections.  I wonder if that might be you problem. ... View more

You’re killing me, Patterson! The OP is wondering ‘Who are these guys and why can’t I get straight answer out of them?’ ... View more

@DanPatterson - python 2.7 continues to be patched with security updates... Even if 2.7 got patched, would that not require a new install of the patched version?  And how does anyone know when it's been patched?  And what has been patched patched? Having said that, dump arcmap, there is no reason to keep it going since people have had since 2015 to adapt to the newer technology.  Couldn't agree more! ... View more

I used weave Perl into AMLs.  Pretty cool, back then. But ArcGIS Pro and Python 3.x is my story now, and I'm stickin' to it!   ... View more

How are you to continue to use ArcMap with a security risk that there doesn't seems to be a fix for. That's a great question!  The short answer is something along the lines of; you don't. The security risk is always going to be a problem, and if you think about, it's been there for years.   Python 2.x is old school as opposed to the later 3.x releases and has limited shelf life at best.  My agency abandoned ArcMap/ArcCatalog a couple years ago.  I don't miss it at all. ... View more

@ABishop I'm glad it worked out for you!  I'm no genius, and in fact much of my python 'training' has come from this forum.  You'll start to get the hang of things as you encounter other problems to solve. I very much like python and use it everyday. Don't be afraid to explore the web with a google phrase like 'xyz python' or 'python xyz'  There are tons of resources out there for you.  And of course, you can ask questions here! ... View more

@ABishop   something to try in your console just to see how and if /elif block works with a counter, and exit(): import time counter = 0 for i in range(0,10): counter += 1 if counter < 5: time.sleep(1) print(counter) elif counter == 5: print(f'Counter is at {counter} You know what that means! See you later, alligator!') time.sleep(5) exit() ... View more

I may have lead you astray.  At line 29, use the exit() method like this: if blah blah blah: exit()   More reading for you. ... View more