Latest Contributions by JamesMacKay3

Looks like just a missing parenthesis.  Your current code: return !shape.length@kilometers! /40)*60‍‍ Should be: return (!shape.length@kilometers! / 40) * 60‍‍‍ (I'm guessing?) ... View more

You can use the workspace environment variable and ListFeatureClasses() to step through your classes: arcpy.env.workspace = r"Database Connections\YourConnection.sde" for fc in arcpy.ListFeatureClasses():     arcpy.FeatureClassToFeatureClass_conversion(fc, targetFolder, fc)‍‍‍‍‍‍ ListFeatureClasses has some optional parameters for filtering feature classes by name and type as well.  Depending on your naming conventions it may not be a bad idea to look into ValidateTableName() as well, you can call it before calling FC to FC to make sure the table name is valid for the target (usually is but doesn't hurt to check). ... View more

You can get a list of versioned feature classes using something like this from the Python window: arcpy.env.workspace = r"Database Connections\YourConnFile.sde" for fc in arcpy.ListFeatureClasses():     if arcpy.Describe(fc).isVersioned:         print(fc) ‍‍‍‍‍‍‍‍‍‍‍‍‍‍ You could do that for each distinct connection you've got, or put the SDE file paths in a list and iterate through them all together. Edit: This will only work with standalone feature classes and would have to be extended to detect those inside of feature datasets... ... View more

Although I didn't build it for attribute tables, I've had some success with spellchecking using Microsoft Word through Python.  The gist of my process was that I looped through a bunch of metadata files, grabbed a specific subset of metadata elements, wrote each element's text value to a new line in a text file, spellchecked the file in Word, then exported the errors out to a list. Upsides: Easy to setup Downsides: Not very fast when batch-processing a bunch of different metadata documents Occasionally Word would visibly pop-up and stall the process Obvious baked-in dependency I did this as a one-off though, so I didn't really worry about the downsides - if I were to use it frequently I'd really want to nail down the second downside in particular. Code looked something like this: import win32com.client app = win32com.client.gencache.EnsureDispatch("Word.Application") for metadataFile in metadataFiles:     # Extracted specific metadata elements here, put into list.     # ...     # Dump to text file     with io.open(tempDocPath, "w") as tempFile:         for elementText in elementTextBlocks:             tempFile.write(unicode(elementText))             tempFile.write(u"\n\n")     # Open the doc     doc = app.Documents.Open(tempDocPath)     for error in doc.SpellingErrors:         # Do stuff         # ...     doc.Close()     del doc app.Quit() ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Of course the Close()/del/Quit() stuff was handled in finally blocks and all that, and because I was getting a lot of recurring proper nouns flagged as errors I ended up building in an exclusion process where Line 18 would be, but basically I ended up dumping everything to a CSV with the filename and misspelled word. ... View more

Good point, another way would be to ditch MakeFeatureLayer and use arcpy.mapping.Layer instead. ... View more

Use the getOutput() method on the MakeFeatureLayer result: lyr = arcpy.MakeFeatureLayer_management(yourLayer).getOutput(0)‍ ... View more

I usually stick with cursors as well but I've found using off-the-shelf tools and field mappings typically provide better performance than cursors... So if it's something I'm going to be running regularly and performance matters, I bite the bullet and get into mappings. ... View more

If that doesn't work, try adding this second line after your line 20: fms = arcpy.FieldMappings() fms.addTable(in_file1)‍‍ ... View more

I'm not sure if it's strictly necessary or if it's possible to achieve the equivalent result without it, but when creating the FieldMappings object in the past I've called the addTable method immediately after creation, passing in the input dataset(s). ... View more

Yes, you'll need to call it for each unique feature class name.  You may also want to have a look at the "Validate Field Name" function, since you're using a template as part of your feature class creation.  You could be pulling in a field that has a name that's valid in one type of workspace but invalid in another - for example, some field names may be valid in a File Geodatabase that aren't valid in SQL Server or in a Shapefile. ... View more

That error usually means there's whitespace, a hyphen, something like that in the table name - strange error in this case though since "Fiber" should be valid.  Try using this function to validate your table name: (Edit: Posted the wrong link in my original post) ValidateTableName—Help | ArcGIS for Desktop  ... View more

As that's a web map, it could be as simple as publishing a feature layer using ArcGIS Server or ArcGIS Online, creating a web map and applying a heat map renderer to your layer.  How it turns out depends on what your point data look like though. ... View more

I'm not sure if there's a way to do it with standard tools, but I know of a way using Python given that in a polygon with holes, null point values (None in Python) separate the outer ring from inner rings: def findHoles(polygonLayerName):     # Get the layer from the current map document.     mxd = arcpy.mapping.MapDocument("CURRENT")     lyrList = arcpy.mapping.ListLayers(mxd, polygonLayerName)     if len(lyrList) == 0:         print("Layer not found")         return     layer = lyrList[0]     # Iterate through the layer's features.     oidList = []     with arcpy.da.SearchCursor(layer, ["OID@", "SHAPE@"]) as cursor:         for row in cursor:             polygon = row[1]             for partIdx in range(0, polygon.partCount):                 if None in list(polygon.getPart(partIdx)):                     oidList.append(row[0])                     break     # Select the features and refresh the view.     layer.setSelectionSet("NEW", oidList)     arcpy.RefreshActiveView() ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more