Advertisement
Guest User

Untitled

a guest
Mar 27th, 2015
201
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.21 KB | None | 0 0
  1. def normNum(num):
  2. arcpy.Statistics_analysis(r'C:Geodatabase.gdbOriginal_Features',r'C:Geodatabase.gdbTemp_Table', [["Field1","MIN"],["Field1","MAX"]])
  3. with arcpy.da.SearchCursor(r'C:Geodatabase.gdbTemp_Table', ("MAX_Field1" , "MIN_Field1")) as cursor:
  4. for row in cursor:
  5. maxNum = row[0]
  6. minNum = row[1]
  7. del cursor
  8. del row
  9. arcpy.Delete_management(r'C:Geodatabase.gdbTemp_Table')
  10. return ((num - minNum) / ( maxNum - minNum))
  11.  
  12. normNum(!Field1!)
  13.  
  14. def NormalizedNumbersToField(table, field, scratchGDB):
  15. arcpy.AddField_management(table, "NORMALIZED", "DOUBLE")
  16. scratchTable = os.path.join(scratchGDB, "Temp_Feat")
  17. arcpy.Statistics_analysis(table,scratchTable, [[str(field),"MIN"],[str(field),"MAX"]])
  18. with arcpy.da.SearchCursor(scratchTable, ("MAX_" + str(field) , "MIN_" + str(field))) as cursor:
  19. for row in cursor:
  20. maxNum = row[0]
  21. minNum = row[1]
  22. del cursor, row
  23. arcpy.Delete_management(scratchTable)
  24. with arcpy.da.UpdateCursor(table, ( field , "NORMALIZED" )) as cursor:
  25. for row in cursor:
  26. number = row[0]
  27. row[1] = (( number - minNum ) / ( maxNum - minNum ))
  28. cursor.updateRow(row)
  29. del cursor, row
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement