Latest Contributions by ZacharyHart

Darren Wiens‌ Dan Patterson‌ I broke it. No errors. Output FC is getting created but nothing is getting inserted. Previously I was just using an existing FC I made for sake of demonstration. Now I'm want to have the script create the FC. I've also tried using the old temp shape as a template and still not inserting. FWIW, shouldn't be anything to do with the rotation...the coordinates print right etc and I had this working up until I tried to have the cursor insert to a newly created FC.       If I explicitly set the existing output shapefile in the insert cursor like: #Open Insert Cursor insert = arcpy.da.InsertCursor(r"D:\Temp\Lines.shp",['SHAPE@']) Then it works. The current code below fails to write/insert any rows to the target FC. I've also tried to have the input points and output lines exist in different GDBs as a test; this didn't resolve the issue. Curiously, often when trying to open the empty output line FC, ArcMap crashes. import arcpy, os, sys, math from itertools import cycle #Environment settings arcpy.env.overwriteOutput = True outGDB = arcpy.env.scratchGDB #Local Variables #startingPt = arcpy.GetParameterAsText(0) #rotation = int(arcpy.GetParameterAsText(1)) #dist = int(arcpy.GetParameterAsText(2)) startingPt = "STARTING_POINTS" dist = 660 angles = [0,90,180,270] rotation = cycle(angles) outName = "crz_lines" #Create target polyline FC sr = arcpy.Describe(startingPt).spatialReference outLine = arcpy.CreateFeatureclass_management(outGDB,outName,"POLYLINE","","","",sr) #Create an array object array = arcpy.Array() #Open Insert Cursor insert = arcpy.da.InsertCursor(outLine,['SHAPE@']) fields = ['SHAPE@X', 'SHAPE@Y'] with arcpy.da.SearchCursor(startingPt, fields) as cursor:       for row in cursor:        #Set Start points        startX = row[0]        startY = row[1]        #Convert rotation values in list from degrees to radians        rad = math.radians(next(rotation))        #Calculate endpoints        endX= startX + (math.cos(rad) * dist)        endY= startY + (math.sin(rad) * dist)             #Add points to array        array.add(arcpy.Point(startX, startY))        array.add(arcpy.Point(endX, endY))        #Create Polyine object based on the array of points        polyline = arcpy.Polyline(array,sr)        #Insert the feature        insert.insertRow([polyline])        array.removeAll()        print ("Start: {},{} End: {},{}".format(startX,startY,endX,endY)) del cursor        ... View more

Darren, thanks for picking up on my bonehead move there! Thanks for the additional insight regarding the cursors. Much appreciated! ... View more

Dan, thanks for the insight and what a treasure trove in the article you wrote! Thanks! ... View more

Dan_Patterson‌ Thanks so much for the suggestions! I'm currently in the process of adding rotation to each line with some basic trig. Regarding your suggestions: I implemented this; was totally unaware of this. Thanks! Are you suggesting I un-nest the two cursors? Again, I'm a real hack here, so if you had an example or reference that would  be great. Any harsh words/warnings regarding poor practice of the structure of cursors as they are now? ... View more

Thanks! I just stumbled across another post wherein which someone was recalling words from you Dan Patterson‌ about setting the spatial reference...tried that and it wasn't the issue. I cleaned up the code a bit. Again, I'm totally up to suggestions, but this works! startingPt = "STARTING_POINTS" #point feature layer in MXD fields = ['SHAPE@X', 'SHAPE@Y'] #point = arcpy.Point() array = arcpy.Array() sr = arcpy.Describe(startingPt).spatialReference   insert = arcpy.da.InsertCursor(r"D:\Temp\Lines.shp",['SHAPE@']) with arcpy.da.SearchCursor(startingPt, fields) as cursor:       for row in cursor:        startX = row[0]        startY = row[1]        endX = startX + 660        endY = startY + 660        array.add(arcpy.Point(startX, startY))        array.add(arcpy.Point(endX, endY))        insert = arcpy.da.InsertCursor(r"D:\Temp\Lines.shp",['SHAPE@'])        polyline = arcpy.Polyline(array,sr)        insert.insertRow([polyline])        array.removeAll()        print "Start: {},{} End: {},{}".format(startX,startY,endX,endY) del cursor ... View more

Thanks Jake! ... View more

Jake, this is great and will totally get me there. To be clear, is there a way to build the sql query using a logical operator 'AND'? Here's an attempt but the query fails: def SelectRandomByCount (layer, count):     import random     layerCount = int (arcpy.GetCount_management (layer).getOutput (0))     if layerCount < count:         print "input count is greater than layer count"         return     oids = [oid for oid, in arcpy.da.SearchCursor (layer, "OID@")]     oidFldName = arcpy.Describe (layer).OIDFieldName     delimOidFld = arcpy.AddFieldDelimiters (layer, oidFldName)     TypeField = arcpy.AddFieldDelimiters (layer, "OS_TYPE")     #TypeField = "OS_TYPE"     Type = 'S3A'     randOids = random.sample (oids, count)     oidsStr = ", ".join (map (str, randOids))     sql = """ {0} IN ({1}) AND {2} = '{3}' """.format (delimOidFld, oidsStr, TypeField, Type)     print sql     arcpy.SelectLayerByAttribute_management (layer, "", sql) [EDIT: fixed...i just had to for I ask this because what I'm actually looking to do this for the same field to satisfy 5 different queries...say for "FIELD" = 'Value1', then "FIELD" = 'Value2'...etc. I guess that would be a loop within a loop? If this qualifies as another question altogether, I'll mark yours as correct. I'll hammer away at this, but do appreciate the insight! ... View more

I got it to work!!! Nice way to close out the day...for some reason the OID field needed single quotes too. If you want to modify your code I'll mark your answer as accepted. Cluster_Plot = '"{}-{}"'.format(i,'!OBJECTID!') ... View more

Hi Micah...I'm just getting a generic 'invalid syntax' error. for the first option. The second wont work because the OIDs aren't coming from the FC used to run the loop/search cursor. ... View more

Joshua, this is exactly what I needed, thanks!!! ... View more