Latest Contributions by RhettZufelt

If walk doesn't go into mxd's, then wouldn't they particularly useless? Would be nice if they removed the "auto filter" that blocks the .lyr, .mxd, etc files.  Should be able to report it as well as other .extention files. I posted an enhancement on the ideas page, you may want to promote it. https://c.na9.visual.force.com/apex/ideaView?id=087E00000004eZ1&returnUrl=%2Fapex%2FideaList%3Fc%3D09a300000004xET%26sort%3Drecent R_ ... View more

Have not tried this, so don't know if it would work, but you might try to MakeXYeventLayer http://resources.arcgis.com/en/help/main/10.1/index.html#//00170000006z000000 . Like I said, not tried in python, but in ArcGIS, this lets you select the x/y fields from a table, and creates a point event theme from it and carries all the attributes in the original table itself. Then, just export the event theme to shapefile. Just a thought, R_ ... View more

Don't know if this is related, but I had issues trying to check out the sa extention in the past.  No errors, just didn't  do the work. Saw online (don't remember if it was post or help pages) that once arcpy is imported, the license level can't be set, and I needed my Info license to utilize sa. So, I did the following and it worked fine: import arcinfo import arcpy then the rest of your imports and code. Like I said, not sure if this would have anything to do with it, but would only take a few seconds to type it in and try. Good luck, R_ ... View more

Guess I'm used to seeing Layer as a reference to the layer object (can be pointed to inside a layer file (just a pointer)), so not sure if that is supposed to list .lyr files, or just layers themselves (as when running in ArcMap).  As far as Map, I don't see any definition/explanation about what that is supposed to be.  Everywhere else in the docs, the refer to a map document/mxd.  Seems like they need to include some definitions in the documentation to clarify.  they give valid raster types and valid feature types, why not valid all types?? So if they are actually referring to *.lyr and *.mxd files as a datatype rather than a pointer file, then you are correct, they do not report these.  I guess in any case you are correct, as these types of files appear to be ignored by da.walk.  In any case, it seems like an oversight.  If it reports .dwg, .shp, .txt, .jpg, .etc., one would think it would easily report .lyr and .mxd as well. R_ ... View more

Curious as to what documentation you looked at.  I looked here http://resources.arcgis.com/en/help/main/10.1/index.html#//018w00000023000000 and don't even see the mention of mxd, lyr, or mpk anywhere on the page. Looks to me like it is reporting exactly what it says it will.  Might have to grab the "missing" files with the old os.walk option. R_ ... View more

Not sure why you would want a separate mxd, but do you also want to duplicate the data for each one as well? Why not just put a definition query on the mxd to match the FID that you want, zoom to the displayed features, then save as a new mxd.  Then, change the definition query to the next one, zoom to extent, then save as new mxd.  This will give you a map document  for each of your 125 features, but will utilize the one, already existing data set without having to make a copy. something like this should do it:  BTW row.name should be row.getValue('Name') - part of why yours wasn't working. import arcpy, os from arcpy import env #Overwrite features arcpy.env.overwriteOutput = True shape = r"K:\Working\Alex_Gole\cult.shp" output = r"K:\Working\Alex_Gole\test" layer = r"K:\Working\Alex_Gole\letter_lyr_new" mxd = arcpy.mapping.MapDocument(r"K:\Working\Alex_Gole\Try.mxd") df = arcpy.mapping.ListDataFrames(mxd, "Layers")[0] inset = arcpy.mapping.ListDataFrames(mxd, "New Data Frame")[0] lyr1 = arcpy.mapping.ListLayers(mxd, "cult", df)[0]  # pick the layer you want to "extract" data from #For each work order: rows = arcpy.SearchCursor(lyr1, "", "", "FID", "FID") for row in rows:    name = str(row.getValue('Name'))    sqlExp = '"FID" = ' + str(row.getValue('FID'))    # Create a clause to select only the current record    lyr1.definitionQuery = sqlExp    df.extent = lyr1.getSelectedExtent(True) newMxd = "Fig1_" + name mxd.saveACopy(r"K:\Working\Alex_Gole\test\\" + newMxd + ".mxd") print "Saving ", newMxd + ".mxd" print "All done." del mxd I have a script that is similar, but instead of saving as a new mxd each time (especially since I have over 8000 records), I just arcpy.mapping.ExportToJPEG(mxd, outfile, resolution=266) and export to a jpeg file, and move on to the next FID since this is the final output desired anyway. R_ ... View more

Michelle, Glad I could help.  I'm fairly new to python also, and these forums are a great way to "learn" about it. The more I can help someone, the more I learn as picking apart others code lets me see some of the many ways to do something in python (and there are often many ways to skin the same cat). Also, if you get a chance, could you click the checkmark in the upper right of the post that answered your question and click the up arrow (promote) also. This will mark the thread as answered to make it easier for others to search/find answers in the future and give me credit for answering the question as well. R_ ... View more

Have you made any customizations to your FV app?  I can't reproduce your issue. If I put some services in there that take a long time to load, it just takes longer to load my FV app, but the order in the TOC remains the same. Perhaps someone else has experienced this issue and can help. R_ What version of FV and TOC widget are you using?  What "type" of layers are you loading? Are you trying to use the LayerList widget and/or MapSwitcher="true" as well? ... View more

import arcpy import os from arcpy import env # Location where the images will be copied to: arcpy.env.workspace = r'X:\Archive\1930_1949\MO\JP2_Zone15' with open(r'X:\Archive\Python_Scripts\UTM_15.txt', 'r') as f:         prj = f.readlines()[0] outPath = arcpy.env.workspace listFiles = open(r'X:\Archive\1930_1949\MO\Index\List_Files_Zone15.csv', 'r') Fname_old = "" cnt = 0 for inputRasters in listFiles.readlines():         inputFilenames = os.path.splitext(os.path.basename(inputRasters))[0]         if Fname_old != inputFilenames:             cnt = 0         print inputFilenames         print inputRasters         outPut = os.path.join(outPath,inputFilenames + ".jp2")         print outPut         print ''        if arcpy.Exists(outPut):                                                          ###  This will delete the file if it already exists             arcpy.Delete_management(outPut)                                      ###  However, if it is in your list, I suspect that you want it regardless of filename already exists        if arcpy.Exists(outPut):                                                                      cnt += 1             Fname_old = inputFilenames             outPut =  os.path.join(outPath,inputFilenames + "_" + str(cnt) + ".jp2")   ###  This would append an _# (1,2,3, etc) to the of the filename and project/save it anyway        arcpy.ProjectRaster_management(inputRasters, outPut, prj) Might try this to remove the raster if exists.  Or the second option that will just append an _# to the end of filename if already exists. Of course, this would only work if the "matching" filenames were consecutive in your list (otherwise, the cnt gets set back to zero). Otherwise, might look into loading your output filenames into a list, then when iterating you can check to see if the file already exists, if so, append a number or break the loop. MyList = [] outPath = r'X:\Archive\1930_1949\MO\JP2_Zone15\' for inputRasters in listFiles.readlines():         inputFilenames = os.path.splitext(os.path.basename(inputRasters))[0]         if inputFilenames not in MyList:             MyList.append(inputFilenames)         else:             continue             for filename in MyList:       outPut = os.path.join(outPath,filename + ".jp2")       arcpy.ProjectRaster_management(filename, outPut, prj) Of course, if you really don't want it to do anything when the filenames are duplicates, you can read your filelist into a python list, then make a set of it. Sets will remove any duplicates and the resultant set will have unique values only. for inputRasters in listFiles.readlines():         inputFilenames = os.path.splitext(os.path.basename(inputRasters))[0]         MyList.append(inputFilenames) MySet = set(MyList) for rasts in MySet:     outPut = os.path.join(outPath,rasts + ".jp2")     arcpy.ProjectRaster_management(rasts, outPut, prj) R_ ... View more

When I changed the AADT in the selectLayer to flayer, it gave me an error of "flayer does not exist". I think that's because I don't think I made the AADT layer named flayer, flayer was assigned to listlayers. Maybe, it gave me that error because I am running it inside the mxd with the layers it needs. I did put in the MakeFeatureLayer_management above the SelectLayers. But my result was the same. I only have 524 missing records and it is finding 878. If you are running inside ArcMap, that explains how you can select on a feature class, ArcMap automatically reports it as a featurelayer to python so the MakeFeatureLayer is not needed unless you plan on running this as standalone outside ArcMap. It looks to me that flayer is assigned to ListLayers with filter on  layer name = AADT.  So, if there is actually a layer named AADT in the TOC, it should be assigned to the flayer variable Also, your matched = set(FList) & set(AList) will give you the values that occur in both lists, but no way to tell which list it is coming from.  So, potentially, you are trying to select something from flayer that only occurs in alayer..... Something like below might be a better approach: import arcpy, traceback mxd = arcpy.mapping.MapDocument("CURRENT") flayer = arcpy.mapping.ListLayers(mxd, "AADT")[0] alayer = arcpy.mapping.ListLayers(mxd, "AADTAnnoLabel")[0] FRows = arcpy.SearchCursor(flayer) ARows = arcpy.SearchCursor(alayer) FList = [] AList = [] for row in FRows:     Fvalue = row.getValue("FLAG")     FList.append(str(Fvalue)) Fset = set(FList)                                   ###  I used sets here to eliminate possible duplicate values for row in ARows:     Avalue = row.getValue("TFLAG")     AList.append(str(Avalue)) Aset = set(AList)                                   ###  I used sets here to eliminate possible duplicate values for x in Fset:     if x not in Aset:         exp = '"FLAG" = ' + "'" + x + "'"         #print exp         arcpy.SelectLayerByAttribute_management(flayer, "ADD_TO_SELECTION", exp) Would think this would select all records in FList that match the expression and are not found in AList Also, you might try to un-comment the print statement and make sure the exp variable is being set to a "valid" python syntax as this can sometimes be tricky in script (though prints statements really slow things down). R_ ... View more

John, Try commenting out your print statements once you get it working correctly. I have some scripts that take about a hour to run, will take 4 or more hours if I include the print statements.  Takes a lot more load/time than one would think. R_ ... View more

Here is how I access the 32 bit (being that I installed ArcGIS desktop (32 bit) and AGS Server (64 bit) on same computer. If I am running a scheduled script or one spawned from another, I use this code in a batch file: cd C:\Python27\ArcGIS10.1 Python C:\arcgisserver\python\buildings.py Exit However, to run in a 32 bit IDE, I made a shortcut with the follwing info [ATTACH=CONFIG]24732[/ATTACH], double click on it, and opens IDE in 32 bit (as you can see in the info at the top of the IDE). I have gotten very few scripts to actually run correctly in the 64 bit window. Also, I am finding many bugs introduced in the 10.1 arcpy so, if you have the ability, you might try your code in the 10.0 version and see if you've found another bug.... R_ Also, not sure in this case, but a lot of ArcGIS tools use the raster extention to determine the file type.  without an extention (as in your data), and not in a FGDB, most ArcTools will assume that is a GRID dataset.  If not, perhaps this is causing an issue? Just a thought ... View more

Please how can i handle the issue of schema Lock? This schema lock issue is really getting on my nerves. Best way I have found is to have each script spawned in a separate python process.  So, I have code similar to the following as my main "control" script: import os buildings = r"C:\arcgisserver\python\buildings.bat" mapping = r"C:\arcgisserver\python\mapping.bat" MRs = r"C:\arcgisserver\python\MRs.bat" finish = r"C:\arcgisserver\python\finish.bat" os.system(mapping) os.system(buildings) os.system(MRs) os.system(finish) Then, the respective .bat files would be similar to: cd C:\Python27\ArcGIS10.1 Python C:\arcgisserver\python\buildings.py Exit This way, a sepratate python process is spawned to run each script.  When it hits the "Exit" in the batch file, it closes that python process and releases ALL lock files.  then it moves on to the next script. Hope this helps, R_ ... View more

My program is to find missing records when comparing to layers inside an mxd and then highlight the ones that are missing. For example, if one layer has 105H1 then the other layer should have it if not then it highlights that record to alert the user it is missing in the other layer. Right, now it is highlighting ones that are missing but also highlighting random ones that are in both layers??? I think my problem is the loop at the bottom of my program but a) I'm not sure and b) I don't know how to fix it.  import arcpy, traceback mxd = arcpy.mapping.MapDocument("CURRENT") lstLayers = arcpy.mapping.ListLayers(mxd) flayer = arcpy.mapping.ListLayers(mxd, "AADT")[0] alayer = arcpy.mapping.ListLayers(mxd, "AADTAnnoLabel")[0] FRows = arcpy.SearchCursor(flayer) ARows = arcpy.SearchCursor(alayer) ffields = arcpy.ListFields(flayer, "FLAG", "String") afields = arcpy.ListFields(alayer, "TFLAG", "String") FList = [] AList = [] for row in FRows:     Fvalue = row.getValue("FLAG")     FList.append(str(Fvalue)) for row in ARows:     Avalue = row.getValue("TFLAG")     AList.append(str(Avalue)) matched = set(FList) & set(AList) for x in matched:     exp = '"FLAG" = ' + "'" + x + "'"     arcpy.SelectLayerByAttribute_management("AADT", "ADD_TO_SELECTION", exp) arcpy.SelectLayerByAttribute_management("AADT", "SWITCH_SELECTION","#") Well, not sure, but see a couple things that might be an issue. I can't get switch_selection to work right without the "#" at the end. Also, your select by attribute you are saying to select from layer AADT. How does it know what layer that is, didn't you assign it to the variable "flayer" and should use that instead. And, even though ArcMap will let you select by attributes and export to python, selectbyattributes will not work on a feature class itself (ArcMap converts to layer on fly). Not sure how you are selecting records unless you are running this from within ArcMap, as it won't allow me to run that on a feature class in stand alone python. To overcome this, I run a makefeaturelayer on the dataset before the selectbyattributes and switch_selection code. Then it will allow me to select by attributes, and switch. Unfortunatly, not anywhere I can test at the moment, but thought I'd throw in a couple ideas in case it helps, R_ ... View more