Latest Contributions by JoshuaBixby

If the code works fine on all other maps, and only crashes on one map, something is likely off with that one map.  I have run into issues where MXDs are partially corrupt, not too corrupt for ArcMap to open but corrupt enough that ArcPy scripts will crash.  Have you run DocDefragmenter or MXDDoctor on the problem map?  If not, it might be worth seeing if running either of those makes a map that doesn't crash. If the MXD is healthy and defragged, there might be a data source in the map that is exposing a bug with ArcPy. ... View more

Try an upper-case "L" after mapping instead of lower-case.  The lookup or autocomplete is case sensitive. ... View more

ORA-12154 is a naming or connection identifier resolution error.  How is your client name resolution lookup configured?  Are you using TNSNAMES, LDAP, EZCONNECT, etc...? ... View more

Lance Shipman​, I figured out what was preventing the Whitehorse GeoPackage from loading.  When working with tiles in GeoPackages, the Make Raster Layer tool appears to need the zoom levels to start at 0 and increment from there.  The Whitehorse and other GeoPackages I am working with are sparse, i.e., they don't start with zoom level 0, so they fail to load.  If I go in and reset the zoom levels to start at 0, then I can get them to load. The fact that Make Raster Layer seems to need the zoom level to start at 0 is in violation of the GeoPackage standard as I read it.  The standard specifically has a couple lines that state, "Tiles MAY or MAY NOT be provided for level 0 or any other particular zoom level. This means that a tile matrix set can be sparse, i.e. not contain a tile for any particular position at a certain tile zoom level." ... View more

Regular expressions are extremely worthwhile, especially since they are a language in and of themselves so your knowledge can be transferred beyond Python. ... View more

There are numerous ways to address this issue, some of which have already been raised here.  A Google search for "python replace multiple strings" will yield even more ideas, some of them with fairly in-depth discussions. If you want to stick with using the Field Calculator, then you are going to have to use code blocks.  Another option would be to use ArcPy cursors, the Data Access ones are the newest and best. An approach I have used in the past that is simple, and seems to perform well enough with my data sets, is a variation of a suggestion from a Stack Exchange/Overflow post:  How can I do multiple substitutions using regex in python? import re repls = {     'california': 'California',     'cal': 'California',     'ca': 'California',     'florida':'Florida',     'fl':'Florida' } def multiple_replace(text):     regex = re.compile("(%s\\b)" % "\\b|".join(map(re.escape, repls.keys())),re.I)     return regex.sub(lambda mo: repls[mo.string[mo.start():mo.end()].lower()], text) The above code goes in the code block, and the field box would be multiple_replace(!State!). A couple of notes. You will need some kind of mapping between what you want to replace and what you are replacing it with.  In this example, a dictionary is being used but other Python data structures could be used as well. The posted code works on upper or lower case, but the dictionary keys need to be lowercase or you will get a Key Error potentially. ... View more

If you run the code two or three times in a row using the same dataset, does it work each time or only the first time? ... View more

From a purely Python programming perspective, having 100+ lines of code within a single try block is unusual.  What does your except clause look like? ... View more

What is the specific error message, can you post it please? ... View more

What you are running into is a bug that was addressed in ArcGIS 10.3, i.e., prior to ArcGIS 10.3 the embedded service properties were not available when an SDE data source was broken.  If you try on a 10.3 machine, I would be interested to see the results.  Normally I would provide links to documentation, but the Esri Support and Development documentation on this bug is a mess in terms of consistency and accuracy.  There is still an open bug with Esri Support even though Esri Development fixed it already. ... View more

To print out the embedded connection properties for all SDE layers in an open map document: mxd = arcpy.mapping.MapDocument("CURRENT") for lyr in arcpy.mapping.ListLayers(mxd):     if lyr.supports("SERVICEPROPERTIES"):         if lyr.serviceProperties["ServiceType"] == "SDE":             for k, v in lyr.serviceProperties.iteritems():                 print "Property: {:<30}Value:{}".format(k,v) ... View more

I gave up on dealing with invalid/irregular polygons in ArcPy, or really even ArcGIS, a few years back.  I kept running into polygons that were invalid but the standard Esri tools couldn't identify them.  Eventually, I threw in the towel and now use Safe Software's FME product to do my polygon validation when I run into problems.  When access to FME isn't available, I sometimes convert ArcPy Polygon objects to Shapely or GeoDjango geometries to find invalid polygons.  It is all a bit kludgy, but I got tired of fighting with Check Geometry and Repair Geometry. ... View more

I am running ArcGIS 10.3.1.4959. I downloaded gdal18.dll from GitHub.  Both my installed copy and the GitHub copy say version 1.8.0.10300, but my installed copy is 7.87 MB and the GitHub copy is 9.48 MB.  Although the names and file versions are the same, obviously the files aren't the same.  I will move the GitHub copy over to \bin and test it shortly. Regarding the Whitehorse GeoPackage, what table, data element, etc... are you using to determine an invalid spatial reference.  The gpkg_spatial_ref_sys table does list undefined Cartesian and Geographic coordinate reference systems, but it also lists WGS84 and Web Mercator.  The gpkg_contents and gpkg_tile_matrix_set tables state Web Mercator as the SRS ID. UPDATE:  Tried the GitHub gdal18.dll, same error:  000582.  Something else I noticed, 150+ ~10KB SQLite files were created in my %TEMP% folder.  Does this seem right?  Are they supposed to be cleaned up at some time or will my %TEMP% folder be filled with these files? ... View more