topic Re: arcpy insert cursor problem - adding multiple polygons in Python Questions

arcpy insert cursor problem - adding multiple polygons

RobertWetmore — Thu, 13 Nov 2014 21:01:23 GMT

I am reading rows from a database with a field "Coords" that contains polygon coordinates in the format 40.090170,-83.007704|40.089878,-83.007724..... and inserting each row as a polygon.

The first feature is drawn correctly, the second feature is drawn but is connected to and duplicates the first feature, and the third contains all three and so on.

The coordinates are cumulative (not intentionally). I tried deleting variables between iterations, but that didn't help. What am I missing?

Thanks

    import pypyodbc     import arcpy     GdbFeat = r"\\server\Arc_Server_data\publish.gdb\OUPS"     spatialRef = arcpy.Describe(GdbFeat).spatialReference     conn = pypyodbc.win_connect_mdb(r"C:\GIS\db\COWOUPSx.mdb")     cursor = conn.cursor()     cursor.execute("SELECT TicketDate, TicketNum, Coords FROM Tickets WHERE (((TicketDate) = #11/15/2014#))")     rows = cursor.fetchall()     cursor.close     del cursor     conn.close     del conn     if rows:                     polygonArray = arcpy.Array()             for row in rows:                                     Coords = row[6]                     coordinatePairList = Coords.split("|")                     for coordinatePair in coordinatePairList:                             coordinates = coordinatePair.split(",")                             currentPoint = arcpy.Point(coordinates[1],coordinates[0])                                                     polygonArray.add(currentPoint)                                                                                polygon = arcpy.Polygon(polygonArray, spatialRef)                                     polygonArray.removeAll                                     with arcpy.da.InsertCursor(GdbFeat, ("Shape@", "TicketDate", "TicketNum")) as Acursor:                             Acursor.insertRow((polygon, row[0], row[1]))                                                          del Coords                                 del polygon                     del coordinatePairList                     del coordinatePair                     del coordinates                     del currentPoint                                  del row             del rows

Re: arcpy insert cursor problem - adding multiple polygons

IanMurray — Thu, 13 Nov 2014 21:14:01 GMT

polygonArray.removeAll

need to be

polygonArray.removeAll()

Your array is never emptying, so it contains each set of coordinates with each run through the for-loop

Re: arcpy insert cursor problem - adding multiple polygons

RobertWetmore — Thu, 13 Nov 2014 21:15:14 GMT

Answered here

need to create a new array for each iteration

if rows:

        for row in rows:

                polygonArray = arcpy.Array()

I thought polygonArray.removeAll would reset the array, but it did not.

Re: arcpy insert cursor problem - adding multiple polygons

IanMurray — Thu, 13 Nov 2014 21:16:44 GMT

Creating the array after the for row in rows would work too, since it creates a new array each time. Your code was just missing the parantheses, otherwise it would have been fine as is.

Re: arcpy insert cursor problem - adding multiple polygons

RobertWetmore — Thu, 13 Nov 2014 21:18:09 GMT

That's what I thought - I was just missing the ()

Thank You