Latest Contributions by ZacharyHart

I'll preface this by saying I'm pretty weak on cursors but trying to boot camp myself to basic proficiency. I'm trying to create a simple script that will take a point feature class and create lines from them. These points are the start point of the the line and for sake of demonstration here, the endpoints are defined mathematically from them. Simple 2-point lines. startingPt = "STARTING_POINTS" #point feature layer in MXD fields = ['SHAPE@X', 'SHAPE@Y'] point = arcpy.Point() array = arcpy.Array() featureList = [] 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]        array.add(point)        endX = startX + 660        endY = startY + 660        array.add(point)        polyline = arcpy.Polyline(array)        insert = arcpy.da.InsertCursor(r"D:\Temp\Lines.shp",['SHAPE@'])        insert.insertRow([polyline])        print "Start: {},{} End: {},{}".format(startX,startY,endX,endY) del cursor The script successfully writes rows to the target, but the geometry is empty. I'm sure there is a simple (and stupid) mistake in the code. Any help is appreciated and I'm totally open to suggestions. I'd rather not have a copy features or append operation but just an insert unless my logic is totally flawed here. Thanks! ... View more

Basically I'm trying to create a selection that satisfies a random criteria AND a query based on an attribute field. Here is some sample code I found on StackExchange: 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)     randOids = random.sample (oids, count)     oidsStr = ", ".join (map (str, randOids))     sql = "{0} IN ({1})".format (delimOidFld, oidsStr)     arcpy.SelectLayerByAttribute_management (layer, "", sql) What I need is this in conjunction with a query (from the same input later) where FIELD = Value (for a string field). I have reviewed the ESRI help document related to Specifying a query in Python, but am having difficulty understanding how to implement this. ... View more

OK, so I feel like I've tried just about everything here. What I'm looking to do is to concatenate a iteration value (?) from a search cursor with the object ID of a feature class to create a unique ID field. I want these two values separated by a hyphen '-'. Target field (PLOT_ID) is obviously a string. There is what I've got working so far. i = 1 ptCur = arcpy.da.SearchCursor (ptFC, fldLst) for row in ptCur: [various things happen removed for brevity] Cluster_Plot = str(i) + '!OBJECTID!' arcpy.AddMessage(Cluster_Plot) arcpy.CalculateField_management(outPointsDissolve,"PLOT_ID",Cluster_Plot,"PYTHON_9.3") things are appended to a a target FC and the target field looks like this: So it appears to be treating the expression inputs as strings. From here I've tried to get a - in between the two values with no luck....even when converting the OID to a string : 'str(!OBJECTID!)'   I just can't get things to escape right i guess. Things I've tried: Cluster_Plot = str(i) + '-' + '!OBJECTID!' Here the  hyphen apparently is interpreted as an operator: Cluster_Plot = str(i) + " + '-' + " + '!OBJECTID!' Cluster_Plot = str(i) + " + '-' + " + 'str(!OBJECTID!)' I dont get this because you can use the + operator in the field calculator just fine (if you format the field as a string using str) Could someone please help me out of my misery here? ... View more

I've been searching high and low for this (Stackoverflow/exchange, etc, Geonet...). Here it goes. I have a table with a number of records. I have a field called 'Rotation' I would like to populate with a repeating set of values [0,90,180,270]. So imagine the following: PT_ID ROTATION 1 0 2 90 3 180 4 270 5 0 6 90 7 180 8 270 9 0 I've tried to simplify my question as much as possible, but its literally as simple as that. Most of the searches return information related to deleting duplicate/repeated records & values. ... View more