Latest Contributions by VishalShah2

Sorry about that Joshua, my issue was that the selection wasn't being made. Was bogged down by other projects I forgot to mention what wasn't working. ... View more

That does work, but I may leave it as my script below shows it because that way it's a lot easier to follow in terms of what's being done. I may at some point change it to reflect your comment about storing it in my gdb instead of in_memory. ... View more

Blake, I was able to follow your script most of the way through. I did have a question though. I do want to be able to save a copy of the results in my custom gdb (footage.gdb) hence why in my original script I used TableToTable_conversion previously. Anyway to incorporate that into your potential solution script? Your way made sense for some of the things. I do need to run tests to see if it works for me.  ... View more

Blake, my code still creates in the Default.gdb in my documents on my local server. I was thinking of using the in_memory workspace but not sure how to incorporate that into my code. Do you think you can help me out with that? I'll post my code that currently is working for me: import arcpy import arcpy.mapping as map from arcpy import env import datetime mxd = arcpy.mapping.MapDocument("Current") date = datetime.date.today() unitedStatesBoundary = arcpy.mapping.ListLayers(mxd, 'United States Boundary')[0] targetFeature = arcpy.mapping.ListLayers(mxd, 'Target Feature')[0] mapName = str(mxd.filePath).split('\\')[-1:][0][:-4] mapFolder = str(mxd.filePath)[:23] saveLocFS = mapFolder folderNameFS = mapName[0:7] + " UG " + mapName[8:] + " " + str(date) df = arcpy.mapping.ListDataFrames(mxd)[0] stats = [] statesFS = {6:'California'} statesAbbreviationsFS = {6:'CA'} statesCDCCode = {6:'California CDC Code'} for state in statesFS:     valueStatesFS = dict.get(statesFS, state)     valueStatesAbbreviationsFS = dict.get(statesAbbreviationsFS, state)     valueCDCCode = dict.get(statesCDCCode, state)     unitedStatesBoundaryQuery = "Name = " + "'" + str(valueStatesFS) + "'"     unitedStatesBoundary.definitionQuery = unitedStatesBoundaryQuery     arcpy.RefreshActiveView()     arcpy.SelectLayerByLocation_management(targetFeature,"intersect",unitedStatesBoundary,"","NEW_SELECTION")     mxd.save()     stateMapName = str(valueStatesAbbreviationsFS) + "_" + str(valueCDCCode)     footageFolder = footageReportFolder + "/" + footageReportFolderName + "/"     footageGDB = "footages.gdb"     inTable = 'Target Feature'     exportLoc = footageFolder + footageGDB     outTable = str(stateMapName)     outXLS = footageFolder + str(stateMapName) + ".xls"     for field in arcpy.ListFields('Target Feature'):         if field.name == 'TotalFeet':             stats.append(['TotalFeet', "SUM"])             arcpy.Statistics_analysis('Target Feature', stateMapName, stats, "")             arcpy.TableToTable_conversion(inTable, exportLoc, outTable, "")             arcpy.TableToExcel_conversion(inTable, outXLS, '', '') ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ This code is creating it first in my Default.gdb and then saving a copy in my custom gdb called footage (referenced in the code). Then it is creating an excel spreadsheet. I am looking to skip saving in the Default.gdb and preferrable store in temp in_memory workspace and then at the end of my code, clear out the in_memory workspace. ... View more

Figured it out and here's the solution: import arcpy import arcpy.mapping as map mxd = arcpy.mapping.MapDocument("Current") visibleFields = ["Field1", "Field2", "Field3", "Field4", "Field5"] field_info = arcpy.Describe('Fiber Segments').fieldInfo df = arcpy.mapping.ListDataFrames(mxd)[0] for index in xrange(0, field_info.count):     if field_info.getfieldname(index) not in visibleFields:         field_info.setvisible(index,"HIDDEN") arcpy.Delete_management('Output Feature',"") arcpy.MakeFeatureLayer_management('Input Feature','Output Feature Layer',"","",field_info) addLayer = arcpy.mapping.Layer('Output Feature Layer') arcpy.mapping.AddLayer(df, addLayer) arcpy.RefreshTOC() arcpy.RefreshActiveView() inputLayer = arcpy.mapping.ListLayers(mxd, 'Output Feature Layer')[0] symbologyLayer = r'C:\pathway\Output Feature Layer symbology.lyr' arcpy.ApplySymbologyFromLayer_management (inputLayer, symbologyLayer)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ This is working well for me without any errors. Not entirely sure why the raw string didn't work but the way it's set equal to inputLayer seems to do the trick. ... View more

Yes. I actually figured it out. I'll add that to the comments to show the solution. ... View more

Ah, line 13 is actually Output Feature Class. I'm running this tool over and over again to test it. Just using line 13 to delete the traces of the last Output Feature Class. ... View more

As always, thank you Joshua! Your help and input has been greatly appreciated and very helpful. ... View more

I think I figured out what the issue was....if you see the df variable, it has .name at the end. I use that variable later for MapToKML tool. so i need to make that a local variable instead of an universal one. and for addLayer, df variable shouldn't have .name at the end. Is that correct? I ran the script, and it did add the layer this time. ... View more

So here's the code and all of the inputs with it mxd = arcpy.mapping.MapDocument("Current") df = arcpy.mapping.ListDataFrames(mxd)[0].name visibleFields = ["Field1", "Field2", "Field3", "Field4", "Field5"] field_info = arcpy.Describe('Fiber Segments').fieldInfo # if conditional for report type when FS is working for index in xrange(0, field_info.count):     if field_info.getfieldname(index) not in visibleFields:         field_info.setvisible(index,"HIDDEN") arcpy.Delete_management('Fiber Segments NOC',"") arcpy.MakeFeatureLayer_management('Fiber Segments','Fiber Segments NOC',"","",field_info) addLayer = arcpy.mapping.Layer('Fiber Segments NOC') arcpy.mapping.AddLayer(df, addLayer) arcpy.RefreshTOC() arcpy.RefreshActiveView()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more