Latest Contributions by JamesCrandall

I don't believe ".lower()" can be used with the VB parser.  That is Python. ... View more

I haven't tested this or even looked up the Eliminate tool, but this doesn't look quite right: ### Execute Eliminate arcpy.Eliminate_management(in_features = "layer", out_feature_class = outputshapefile, selection = "AREA", ex_where_clause = ' "Vegetation" = 5 ') Seems like you just need to replace with your layer variables: ### Execute Eliminate arcpy.Eliminate_management(inputshapefile, outputshapefile, "AREA", ' "Vegetation" = 5 ') ... View more

The user "behr" is excecuting the code, but is not the admin on the PC That is the likely culprit. ... View more

Your expression was actually written for VBScript, not the Python parser.  Maybe you should double-check that. ... View more

Did you set the field type to Short Integer for the Index field? I setup the same way and do not get any error. ... View more

Try to wrap your evaluation statement into quotes: If [Lin_typ] = "major" Then ... View more

I didn't notice any code suggesting to perform SA checkout and I why I posted.  The OP was in English and a quick scan of the thread didn't show any solutions in any language -- but no, I don't speak German If the user "behr" is not actually the account executing the code then I'd think there would be permission issues. ... View more

I don't see where you are checking out/in your Spatial Analyst extension.   ### see if spatial analyst extension is available for use   availability = arcpy.CheckExtension("Spatial")   if availability == "Available":      arcpy.CheckOutExtension("Spatial")      arcpy.AddMessage("SA Ext checked out")   else:      arcpy.AddError("%s extension is not available (%s)"%("Spatial Analyst Extension",availability))      arcpy.AddError("Please ask someone who has it checked out but not using to turn off the extension")      return   #do your processing with SA   # check the sa extension back in   arcpy.CheckInExtension("Spatial") ... View more

Then I would seriously question the validity of the data you are being provided.  If the provider cannot or will not perform a simple process (like removing leading/trailing spaces in a string field), then I would have some pause as to the correctness of the data in its entirety.  Anytime a developer has to perform silly gymnastics is only compounding the potential problems and potential incorrect, inconsistent and overall poor output/results. With that said, I would suggest to go back to your OP and simplify the query to bare-bones minimum.  For example I'd take this: sql = "PRODUCER like 'A%' and (SERIES_ID is  null or LENGTH(TRIM(SERIES_ID)) = 0) and SCALE > 75000"    arcpy.SelectLayerByAttribute_management(tmplyr, "NEW_SELECTION", sql) and try this: sql = "PRODUCER like 'A%'"    arcpy.SelectLayerByAttribute_management(tmplyr, "NEW_SELECTION", sql) Does it work? Yes?  Then expand it a bit: sql = "PRODUCER like 'A%' AND SCALE > 75000"    arcpy.SelectLayerByAttribute_management(tmplyr, "NEW_SELECTION", sql) No?  Then something basic like "PRODUCER" is not actually a field in your in_memory fc. ... View more

I guess I don't understand why you do not actually fix the underlying problem.  You have identified a need to issue TRIM(), so why don't you fix the datasource now and eliminate the need to perform this in your SQL? Also, print out the field names for the in_memory fc's your are generating.  Perhaps the query fails because you are not stating the correct fields? ... View more

LTRIM() or RTRIM() would be what to use. Try: sql = "PRODUCER like 'A%' and (SERIES_ID is  null or LEN(LTRIM(RTRIM(SERIES_ID))) = 0) ... View more

" I am using a for loop to go through each row and iterating a count variable each time through the loop." That sounds like a taxing event.  Hard to tell with no code to review, but have you attempted to issue your SQL when constructing your UpdateCursor? ... View more

Curtis, In RDBMS-landia, if I have >1000 values I'd probably insert them into a temporary table of the values for my IN operator and setup a JOIN to the main table I am interested in querying.  I know that doesn't specifically address your post but is likely the best solution.  Or if I were in SQL Server I'd likely opt for the Table variable instead of a Temp Table. ... View more

Then you should mark Curtis' answer as the correct one because it better describes your situation and requirements to arrive at a solution.  Also, it's best if you post the current code version you are stuck at in your original post so the forum members can arrive at a solution much quicker rather than having to dig out what it is you are attempting -- I couldn't quite tell what you needed to accomplish and was the reason for my questions rather than posting an actual solution or sample. Glad you figured it out. ... View more