[GIS] ‘List indices must be integers not tuple’ Error

arcgis-10.2arcpypython

I'm using an insert cursor to write rows to a destination feature class where the input Shapefile field names do not match the destination FC names. To accomplish this, I'm trying to use the indices of the input shape field list to input to specific fields. Running into a "List indices must be integers not tuple" error when executing and have tried all combinations of brackets, parentheses, etc. I don't think I'm seeing the error right:

outfc = #the input shapefile from earlier in code
destsfp = #the destination featureclass from earlier in code

allrowvalues = arcpy.ListFields(outfc)
rowvalues = allrowvalues[[2],[3],[5],[6],[7],[8],[9],[10],[11],[12],[13],[14]]
#open insert cursor
cursor = arcpy.da.InsertCursor(destsfp,('SHAPE@X','SHAPE@Y','SHAPE@Z','GRADIENT','BEARING','HEIGHT_IN_METRES','WIDTH_IN_METRES','LENGTH_IN_METRES','DEPRESSION_DEPTH','SYMBOLOGY','FEATURE_NAME','FEATURE_DESC'))
#insert new rows that have the above fields
for row in rowvalues:
    cursor.insertRow(row)
del cursor

Best Answer

based on all the comments, try something like this -

field_indexes_to_copy = [2, 3, 5, 6, 7, 8, 9, 10, 11, 12, 13 ,14]
search_cursor = arcpy.da.SearchCursor(outfc, "*")
insert_cursor = arcpy.da.InsertCursor(destsfp,('SHAPE@X','SHAPE@Y','SHAPE@Z','GRADIENT','BEARING','HEIGHT_IN_METRES','WIDTH_IN_METRES','LENGTH_IN_METRES','DEPRESSION_DEPTH','SYMBOLOGY','FEATURE_NAME','FEATURE_DESC'))

for row in search_cursor:
    insert_cursor.insertRow([row[i] for i in field_indexes_to_copy])

I haven't run this code myself, but I think that or something similar should work.

Related Solutions

ArcPy Insert Cursor – Not Inserting All Rows Issue

I had initially neglected to delete my irow object at the end of the script; after updating my code the insert cursor appears to be adding all rows (even the last one!) the way it should be. Here is the final code:

import arcpy, os

months = {'JAN':1,'FEB':2,'MAR':3,'APR':4,'MAY':5,'JUN':6,'JUL':7,'AUG':8,
          'SEP':9,'OCT':10,'NOV':11,'DEC':12}
ignore = ['Arbitrary_count','TOTAL_MGY','JAN','FEB','MAR','APR','MAY','JUN','JUL','AUG','SEP','OCT','NOV','DEC']

ws = r'D:\Data\Users\jbellino\Project\faswam\data\water_use\SC\FromTomAb\SC_WELLS_data_jcb.mdb'
arcpy.env.workspace = ws
arcpy.env.overwriteOutput = True
tbl = 'ORIGINAL_DHEC_WELL DATA'
itbl = 'monthly_dhec_well_data'

fields = arcpy.ListFields(tbl)

rows = arcpy.SearchCursor(os.path.join(ws,tbl))
irows = arcpy.InsertCursor(os.path.join(ws,itbl))
for row in rows:
    for month in months:
        #--for each row in the original table, and for each month stored in that row, 
        # create a new record in 'itbl'
        irow = irows.newRow()
        for field in fields:
            if field.name == month:
                #--if the field name refers to a month abbreviation it contains data
                # first convert the month abbreviation to month number
                irow.cn_mo = months[month]
                try:
                    # then grab the data in the field and process it into the appropriate 
                    # fields of the new table in the correct units
                    irow.cn_qnty_mo_va = row.getValue(field.name)*1000000
                    irow.cn_qnty_mo_va_mega = row.getValue(field.name)
                except:
                    #--skip null values
                    pass
            elif field.name not in ignore:
                #--if the field name is not a month abbreviation, just copy the data
                # to the new table
                irow.setValue(field.name,row.getValue(field.name))
        irows.insertRow(irow)
del irow,irows
del row,rows

[GIS] Python: Arcpy: Adding data to a shapefile

You can avoid most of the redundant conditional logic of Jason Miller's answer by converting your list into a dictionary:

gdppop2002_dict = {}
for pair in gdppop2002:
    gdppop2002_dict[pair[0]] = pair[1]

You can then iterate through the rows and update values directly from the dictionary:

with arcpy.da.UpdateCursor(fc, ['CNTRY_NAME', 'GDP_HEAP']) as cursor:
    for row in cursor:
        country = row[0]
        if country in gdppop2002_dict:
            row[1] = gdppop2002_dict[country]
            cursor.updateRow(row)

(Note that I've used arcpy.da.UpdateCursor, which only became available in ArcGIS 10.1. If you're on 10.0 or older, you'll have to use arcpy.UpdateCursor, which is less efficient and has slightly different syntax.)

Best Answer

Related Solutions

ArcPy Insert Cursor – Not Inserting All Rows Issue

[GIS] Python: Arcpy: Adding data to a shapefile

Related Question