Latest Contributions by DevinUnderwood2

I am testing it out by taking your suggestion of adding a new length field and using the following expression. It is not working as I think I have to specify when it is a non text field. Is that correct ? def FindLabel ( [LENGTH] , [PLAN]  ):     if Double ( [LENGTH] )   > 50:         return [PLAN]     else:         return [PLAN]‍‍‍‍‍ ... View more

Thanks, I will look into this. At a first look I don't see how all this can be included in a label expression. my goal is not needing to edit the actual data at all. ... View more

Great feedback, thanks. With your help I was able to use the following python label expression in my mapbook. For any water pipeline attributed with, "abandon", do not label.  Also, if any pipeline is null then label as seen below. def FindLabel ([PLAN], [AGENCY]):     if [AGENCY] == "ABANDON":         return None     elif [PLAN] in  (None, " "):         return "Plan ?"     else:         return [PLAN]‍‍‍‍‍‍‍‍‍‍‍‍‍‍ I  need to also only show pipeline labels for pipe greater than 50 feet. I tested out the following and it doesn't work. I would then need to add it to my current expression. Any ideas what is wrong with my expression. Thanks def FindLabel ( [SHAPE.LEN], [PLAN]  ):     if [SHAPE.LEN]  > 50:         return [PLAN]     else:         return [PLAN] ‍‍‍‍‍‍‍‍‍‍ ... View more

I agree that in general, nulls, empty, NA  and spaces always present issues which I don't remember how to address right away. Technically, my empty fields do not have spaces since I never typed anything in, I would assume? So, you bring up a good point, what exactly are the empty fields represented by ? ... View more

def FindLabel ( [PLAN] ):     if  [PLAN] in  (None, " "):         return "Unknown Plan"     else:         return [PLAN]‍‍‍‍‍ This work perfect, thank you. Good to know that an empty string treated the same for label expressions and the field calculator. Null is not though, having to use None to represent Null in label expressions. ... View more

Good point, I have empty strings, how would I represent empty strings, not Null ? ... View more

I made Dan's suggested changes and still no luck. I should of elaborated what string PLAN field is.  The blank fields are Null. ... View more

b = fullpath.split('\\') c = ("{}\n" * len(b)).format(*b) for i in b:   writer.writerow(i) This is one step closer. Yet writing into single cells and vertically. S\"E"\"W"... C\"O"\"N"... ... View more

Thanks for the help I put the following and results in vertical rather than horizontal and each letter is written to a different cell. b = fullpath.split("\\") c = ("{}\n" * len(b)).format(*b) for i in c:   writer.writerow (i ) ... View more

Interesting I just added .split ("\\) writer.writerow([fullpath.split("\\")]) I get the following which correctly splits it at the slashes and yields  commas. ['Sewer', 'ControlValve'] So, I only need to write to different rows where it is has a comma. ... View more

This is an example of a row I need to write to csv file by delimiting the slash. Write each section within the slashes to separate rows . I guess I need to know how to make it not recognize as a escape character ? ... \Sewer\ControlValve   ... View more

Thank you for taking the time to look at this. I get the following error. Traceback (most recent call last):   File "C:/Users/dunderwood/Documents/AutomatePublishWebLayers/Overwrite_Map_Service.py", line 24, in <module>     doc = DOM.parse(xml)   File "C:\Python27\ArcGIS10.2\lib\xml\dom\minidom.py", line 1921, in parse     return expatbuilder.parse(file)   File "C:\Python27\ArcGIS10.2\lib\xml\dom\expatbuilder.py", line 922, in parse     fp = open(file, 'rb') IOError: [Errno 2] No such file or directory: 'C:\\Users\\dunderwood\\AppData\\Local\\ESRI\\Desktop10.2\\Staging\\ARCGIS on xyz (publisher)\mapservice.sddraft' ... View more