eltopo

add data from a list using "row.setValue" to a field

Discussion created by eltopo on Jan 24, 2013
Latest reply on Jan 24, 2013 by eltopo
Hi,

Using a script I get a list of values??????, which I need to add a field using "row.Setvalue" but I have not been successful.

I hope you can help me!

thanks
GHJ


import arcpy
import glob, os
import time
from time import localtime, strftime

tic = time.clock()


#*********** PRINCIPALES VARIABLES *************
prefijo = "sde.SDE."
Nommosaico = "mostesthumrel"
variable = "rh"

outLoc = "Database Connections/Connection to GECITRO02.sde/mostestemp"
inNetCDF = "C:/IIE_Datos/Prediccion/Ejemplomosaico/MMOUT_DOMAIN1.nc"


# Process: Create Mosaic Dataset
#arcpy.CreateMosaicDataset_management(outLoc, Nommosaico, "PROJCS['Lambert_Conformal_Conic',GEOGCS['GCS_WGS_1984',DATUM['D_WGS_1984',SPHEROID['WGS_1984',6378137.0,298.257223563]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]],PROJECTION['Lambert_Conformal_Conic'],PARAMETER['False_Easting',0.0],PARAMETER['False_Northing',-27.0],PARAMETER['Central_Meridian',-124.17],PARAMETER['Standard_Parallel_1',0.0],PARAMETER['Standard_Parallel_2',0.0],PARAMETER['Scale_Factor',1.0],PARAMETER['Latitude_Of_Origin',0.0],UNIT['Kilometer',1000.0]];-20037.7 -30225.3 149134210447.956;1 1;1 1;0.000001;2;2;IsHighPrecision", "", "")

# Process: Add Field
#arcpy.AddField_management(outLoc + Nommosaico, "tiempo", "DATE", "", "", "", "T", "NULLABLE", "NON_REQUIRED", "")            

nc_FP = arcpy.NetCDFFileProperties(inNetCDF)
nc_Dim = nc_FP.getDimensions()

test = outLoc + '/*'
r = glob.glob(test)
list = []

for i in r:
   os.remove(i)

for dimension in nc_Dim:

    top = nc_FP.getDimensionSize(dimension)

    for i in range(0, top):

        if dimension == "time":

            dimension_values = nc_FP.getDimensionValue(dimension, i)

            #list.append(dimension_values)

            fech = str(dimension_values)
            vv = time.strftime(fech)

            list.append(vv)
            
            print dimension_values
            daat = "time '"+str(dimension_values)+ "'"
            #print daat
            
            nowFile = str(i)
            testt = dimension_values.replace("/","").replace(":","").replace(".","").replace("'","").replace(' ','')
            #print testt
            rast = "timerh" + nowFile
            #print rast
            
cursor = arcpy.UpdateCursor(outLoc)
for row in cursor:
    # field2 will be equal to field1 multiplied by 3.0
    row.setValue("tiempo",list)
    cursor.updateRow(row)

      
toc = time.clock()
print toc - tic 

Outcomes