Latest Contributions by MathewCoyle

This is probably more what you want. I assume you aren't looking for an attribute of "value". Also, I am not sure if the square brackets are needed. where =  "[survey_month] = " + value arcpy.MakeFeatureLayer_management(inFC, lyrname, where) ... View more

For joined tables you still have to use the getVaue statement I am fairly certain. cur = arcpy.SearchCursor(layer) for row in cur:      row.getValue("JoinedTableName.FieldName") ... View more

You definitely have some issues here. It is not entirely clear what you are trying to do here. What field(s) are you trying to query? Are your species list your field names or are those attributes? This line needs the raw tag. arcpy.env.workspace = r"P:\CoWetlandTools\maps\distribution_maps_Johns_pytest" #"r" at beginning of path string specieslist needs to be outside your for loop. This will error out just on that. You need + signs to concatenate your strings in your where clause and format for the brackets. Also, this is assuming "X" is your field name, this is very likely incorrect. where = "X in ('" + '\',\''.join(specieslist) + "')" Also, it will help posting in [ CODE] [ /CODE] tags to see your indentation. The # sign at the top when posting. ... View more

You were very close, just a few workspace issues (you need to change the workspace to the actual .xlsx file to access the sheet, then back to the folder level to export the table and create the shapefile) and a couple small things. Give this a try, changing to your paths of course. import arcpy, os, sys, traceback arcpy.env.workspace = r"C:\GIS\xlsxTest" outPath = r"C:\GIS\xlsxTest\output" arcpy.env.overwriteOutput = True # Local variables xVal = "POINT_X" yVal = "POINT_Y" # Factory code for NAD 1983 factory_code_CS = 4269 sr = arcpy.SpatialReference() sr.factoryCode = factory_code_CS sr.create() # List all files in folder then list all tables in file fileList = arcpy.ListFiles("*.xlsx") print 'Listing .xlsx files in workspace' try:     # Loop through each file     for file in fileList:         print file         arcpy.env.workspace = os.path.join(r"C:\GIS\xlsxTest", file)         # Use splitext to set the output name of the table         dbfFile = os.path.splitext(file)[0] #+ ".xlsx"         if arcpy.Exists(dbfFile+".dbf"):             print "deleting"             arcpy.Delete_management(dbfFile+".dbf")         # Convert excel to DBF         arcpy.TableToTable_conversion("Sheet1$", outPath, dbfFile+ ".dbf")         print 'File conversion. Converted ' + file     #List dBase tables     arcpy.env.workspace = outPath     tableList = arcpy.ListTables("", "dBASE")     print ' List dBase tables in workspace'     # Loop through each table     for table in tableList:         print table             # Make XY event layer         arcpy.MakeXYEventLayer_management(table, xVal, yVal, "points_" + table, sr)         # Save output         arcpy.FeatureClassToShapefile_conversion("points_"+table, outPath)         print 'Created XY shp file for ' + table     print 'Script complete.' except:     tb = sys.exc_info()[2]     tbinfo = traceback.format_tb(tb)[0]     pymsg = "PYTHON ERRORS:\nTraceback Info:\n" + tbinfo + "\nError Info:\n     " +        str(sys.exc_type) + ": " + str(sys.exc_value) + "\n"     msgs = "ARCPY ERRORS:\n" + arcpy.GetMessages(2) + "\n"     arcpy.AddError(msgs)     arcpy.AddError(pymsg)     print msgs     print pymsg         arcpy.AddMessage(arcpy.GetMessages(1))     print arcpy.GetMessages(1) ... View more

Posting what code you are using might help. You can query by multiple fields in your where clause in the select by attributes tool. ... View more

You can start by removing the print workspace line unless you have that variable set somewhere else. ... View more

I had thought there would be some behind the curtain voodoo that could be accessed to go directly to the CustomTransformations folder, since whenever you use the Project tool with valid parameters the custom transformation will come up as an option. So somewhere out there is a CustomTransformation folder variable, but I guess it isn't accessible. ... View more

That makes it much easier to read, thanks. ... View more

So you want to clip one polygon layer based on say priority = 1 of your other polygon layer, or clip based on each possible priority in the feature class? Yes you can do that. Make a feature layer with a where clause of the features you want to clip Clip Enclose in a for loop if you want to do different where clauses base on variable values. ... View more

If you are asking about pyscripter and arcpy, yes it is by default. Any module imported in the script has intellisense enabled, without having to actually import the module via the built in interpreter. No license is checked out in the case of arcpy. [ATTACH=CONFIG]12107[/ATTACH] ... View more

You can look at pyscripter, it has intellisense enabled by default without the need for a license. I find it far superior to PythonWin for my purposes, but to each their own. http://code.google.com/p/pyscripter/ ... View more

Hate to barge in on a good conversation, but it looks like you are missing an update in your update cursor. for row in uC: if row.getValue(keyField) in updateDict:   row.setValue(testField1, updateDict[key][0])   row.setValue(testField2, updateDict[key][1])   row.setValue(testField3, updateDict[key][2])   row.setValue(testField4, updateDict[key][3])   row.setValue(testField5, updateDict[key][4])   row.setValue(testField6, updateDict[key][5])   uC.updateRow(row) ... View more