Latest Contributions by Zeke

‎09-26-2014

Even more pythonic! Except I don't know how to format as code on the new forums here... with open(r'H:\Documents\blah\'output.txt', 'w') as fout: values = np.genfromtxt(r'H:\Documents\blah\input.txt',dtype='str') fout writelines("ID='" + str(val) + "' OR " for val in values) Also, for your output, rather than a bunch of OR clauses, you could make a python list and test using IN: ID IN ['34012', 35078', '39222'...]

‎09-24-2014

I get an error with strftime if I try to use %T, which according to TutorialsPoint is a valid format, a shortcut for %H%M%S. But this raises an error, and in fact is not in the Python.org documentation for strftime. The point being that there's erroneous information out on the web. Who knew? If it's a locale issue, you may want to look at: strftime() returns a locale depedent byte string; the result may be converted to unicode by doing strftime(<myformat>).decode(locale.getlocale()[1]) . also from the same documentation.

‎08-28-2014

Well, after working on it for a couple hours, then posting it here, I got the solution on my next try. For reference, here it is; where = arcpy.AddFieldDelimiters(intable, fcc) + ' = \'' + v + '\''

‎08-28-2014

Any help on how to properly format the where clause in the following code would be greatly appreciated. I get an Invalid Expression error despite whatever combinations I try. v is a string value. Thanks. code: for v in lstFCCvalues: try: outfeature = os.path.join(fdstarget, v + 'Roads') if arcpy.Exists(outfeature): arcpy.Delete_management(outfeature) where = arcpy.AddFieldDelimiters(intable, fcc) + ' = ' + v arcpy.Select_analysis(intable, outfeature, where) except Exception as e: exceptionMessage(e) sample error; ERROR 000358: Invalid expression "FCC" = A00 Failed to execute (Select).

‎08-27-2014

Solved. Needed quotes around the value. value = '"' + fc.capitalize() + '"' arcpy.CalculateField_management(fc, newfield, value, 'PYTHON_9.3')

‎08-27-2014

I'm getting an ExecuteError, error 000539, in the code below when Calculating the field. The error appears to be on the second instance of fc, fc.capitalize(), because when I take out the capitalize(), I get the same error but without the capitalized name. I can't figure out what the problem is. Any ideas? Thanks. # code fds = 'RawFramework' newfield = 'CountyName' lstRawFCs = arcpy.ListFeatureClasses(None, 'All', fds) for fc in lstRawFCs: try: arcpy.AddField_management(fc, newfield, 'TEXT', field_length = 25, field_alias = 'County Name') arcpy.CalculateField_management(fc, newfield, fc.capitalize(), 'PYTHON_9.3') except Exception as e: print(e.message, e.__class__) # sample error (CalculateField).\n', <class 'arcgisscripting.ExecuteError'>) ('ERROR 000539: Error running expression: St_clair \nTraceback (most recent call last):\n File "<expression>", line 1, in <module>\nNameError: name \'San_Diego\' is not defined\n\nFailed to execute (CalculateField).\n', <class 'arcgisscripting.ExecuteError'>)

‎08-05-2014

Thanks Xander! A PDF with layers sounds like what I need. Much appreciated.

‎08-02-2014

Is it possible to share .lyr files in AGOL? I have an mxd with a couple dozen layers, all symbolized and labeled nicely, and would like to share it with some non Arc users to get their feedback, let them turn layers off & on, etc. I'm doing this from home using ArcGIS for Home 10.2 for a non-profit, so I don't have a server to publish features to (unless I can do that on AGOL?). I could upload a bunch of zipped shapefiles, but would have to resymbolize them all, and don't really want to do that. Thanks.

‎07-16-2014

Thanks Ian, but ord didn't work. The values are test, a mix of letters, blanks and numbers. Ord() works on one at a time, and gave me a TypeError when I tried parsing the values. I did manage to fix the problem though. I'd forgotten that arcpy.da returns a tuple, not the (in this case) text value. When I added row[0] to the processing instead of just row, it worked as desired. Thanks everyone. I hesitate to mark my own answer as correct, don't want to violate protocol, but on the other hand that might be useful to others.

‎07-16-2014

Thanks all. I searched for a python oriented forum, couldn't find it. This new format will really take some getting used to.

‎07-16-2014

In the code below, the field values are returned in unicode (e.g. (u' 06510',)). How do I get this to return ascii, as in 06510,? Thanks. Hopefully doing this right, new forums confusing. with arcpy.da.SearchCursor(fc, "OLDPLATE") as rows: for row in rows: if row is None or len(row) == 0: lstNullOldPlates.append("Null or empty") else: lstAllOldPlates.append('{0}'.format(row))

‎07-10-2014

Append isn't used to add attribute values. It adds features to an existing feature class. The errors you're getting are because you're trying to add polygons to polylines. So what to do? Depends on what you want and how your data is set up. You could convert your polygons to lines and append them. There are other methods as well, but really depends on your setup.

‎06-23-2014

The coordinates are points, then? Have you looked at Placement Properties, where you can set the preferred orientation for each layer? E.g. Calcium above the point, Chlorine below, etc. Or there's always Annotation or Maplex.

‎06-23-2014

You might try running MXD Doctor on your original map.

‎06-20-2014

Try not putting your Update code in its own loop. If necessary, retrieve the OID or other unique field in your SearchCursor as well as the current field. Use the OID in a Where clause in your UpdateCursor. This way you'll loop through the records in your SearchCursor, and target the record the SearchCursor is on in your UpdateCursor. Or, you could try ditching the SearchCursor and just use an UpdateCursor, doing your calculation there before you call updateRow. I've never done this, but Help says UpdateCursor is read/write, so presumably it can function as a SearchCursor as well. The next() method returns a tuple of the values, so you should be able to read the necessary values out of that.

Online Status	Offline
Date Last Visited	‎12-12-2021 01:00 PM

My Ideas

Latest Contributions by Zeke

Re: Script to contatenate the same field from several records

Re: Python complains about date format?

Re: Proper syntax for where clause

Proper syntax for where clause

Re: CalculateField error

CalculateField error

Re: Sharing .lyr files or making a feature service on AGOL

Sharing .lyr files or making a feature service on AGOL

Re: Field values returned in unicode

Re: Field values returned in unicode

Field values returned in unicode

Re: Append error

Re: Overlapping layers

Re: Script ending at loop

Re: problem with arcpy.da.updateCursor

Conditional formatting for cells in a layout table...

Re: Change Legend Item names

Re: Keep labels in layout frame in map series

Keep labels in layout frame in map series

Re: Append not working