Latest Contributions by JakeSkinner

Try deleting the row and cursor within the 'try' statement and you should no longer get this error: try:    #update table with difference value    with arcpy.da.UpdateCursor(table, ["FEAT_SEQ", "YEAR_OF_BIRTH", "DIFFERENCE"], "FEAT_SEQ = " + str(FEAT_SEQ) +  AND ("YEAR_OF_BIRTH = " + str(list2[0]) + " OR YEAR_OF_BIRTH = " + str(list2[1]))) as cursor:             for row in cursor:                 row[2] = DIFFERENCE                 cursor.updateRow(row)     del row, cursor except:     pass ... View more

I don't believe that will improve performance.  Is there a reason you are not indexing the sample feature class? ... View more

Here is the updated code that should work: import arcpy from arcpy import env env.workspace = r"C:\temp\python\test.gdb" table = "data" # create empyt list to append ID field list = [] # iterate through table and append ID to list with arcpy.da.SearchCursor(table, ["id"]) as cursor:     for row in cursor:         list.append(row[0]) del row, cursor #remove duplicate IDs list = dict.fromkeys(list) list = list.keys() #iterate through list for id in list:     list2 = []     with arcpy.da.SearchCursor(table, ["id", "age", "difference"], "id = " + str(id)) as cursor:         for row in cursor:             #append age to new list             list2.append(row[1])     #sort list     list2.sort()     try:         #calculate the difference         difference = list2[1] - list2[0]     except:         difference = ''     del row, cursor     try:         #update table with difference value         with arcpy.da.UpdateCursor(table, ["id", "age", "difference"], "age = " + str(list2[0]) + " AND id = " + str(id)) as cursor:             for row in cursor:                 row[2] = difference                 cursor.updateRow(row)     except:         pass del row, cursor Here is an explanation of the where clauses. 1.  "id = " + str(id) "id" is the field name and 'str(id)' is the variable for the id value in the list.  The line 'for id in list' is setting this variable. 2.  "age = " + str(list2[0]) + " AND id = " + str(id)) This query is selecting the age field that is equal to the first value in the second list.  In this case, the first value is the largest year from today's data, (i.e. 1955). If you have the year 1955 in two different 'ids', the AND is ensuring that the update will update the correct row. ... View more

Just so I understand you correctly.  In your example: ID     AGE  NEWID      DIFFERENCE 2259 1955 22591955  n/a 2259 1956 22591956  1 2259 1986 22591986  n/a 2259 1989 22591989  n/a The 'Difference' value is not being calculated between 1986 and 1989 because the age from 1955 and 1956 is larger when compared to todays date.  Is that correct? ... View more

Hi Clinton, Here is an example on how you can do this: import arcpy from arcpy import env env.workspace = r"C:\temp\python\test.gdb" table = "data" # create empyt list to append ID field list = [] # iterate through table and append ID to list with arcpy.da.SearchCursor(table, ["id"]) as cursor:     for row in cursor:         list.append(row[0]) del row, cursor #remove duplicate IDs list = dict.fromkeys(list) list = list.keys() #iterate through list for id in list:     list2 = []     with arcpy.da.SearchCursor(table, ["id", "age", "difference"], "id = " + str(id)) as cursor:         for row in cursor:             #append age to new list             list2.append(row[1])     #sort list     list2.sort()     try:         #calculate the difference         difference = list2[-1] - list2[-2]     except:         pass     del row, cursor     try:         #update table with difference value         with arcpy.da.UpdateCursor(table, ["id", "age", "difference"], "age = " + str(list2[-2]) + " AND id = " + str(id)) as cursor:             for row in cursor:                 row[2] = difference                 cursor.updateRow(row)     except:         pass del row, cursor ... View more

Can you post the script you are running? ... View more

Hi Anthony, In the catalog tree, right-click on the mosaic dataset > Properties > Feature Extent tab.  You can click 'Recalculate' or manually set the extent. ... View more

Hi Nick, What version of ArcGIS Desktop are you using?  I could not reproduce this with 10.2.  Have you tried simply import the table outside of a script?  For example, right-click on the File Geodatabase > Import > Table (single). ... View more

Hi Ryan, You could probably accomplish this easier with python.  Here is an example: import arcpy from arcpy import env # set workspace where shapefiles are located env.workspace = r"C:\data\temp\python" # create empty list list = [] # append each shapefile in workspace to list for shapefile in arcpy.ListFeatureClasses("*.shp"):     list.append(shapefile) # import list of shapefiles into File Geodatabase feature dataset arcpy.FeatureClassToGeodatabase_conversion(list, r"C:\Temp\Python\Redlands.gdb\Data") # set workspace to File Geodatabase env.workspace = r"C:\Temp\Python\Redlands.gdb" # loop through each feature class in 'Data' feature dataset and add fields for fc in arcpy.ListFeatureClasses("*", "", "Data"):     arcpy.AddField_management(fc, "SHEET_NAME", "TEXT", "", "", "50")     arcpy.AddField_management(fc, "ENGINEER", "TEXT", "", "", "100")     arcpy.AddField_management(fc, "PROJECT_NO", "TEXT", "", "", "50")     arcpy.AddField_management(fc, "SHEET_NO", "TEXT", "", "", "50")     arcpy.AddField_management(fc, "DATE", "TEXT", "", "", "50") ... View more

These do not show up in my registry? Under HKEY_USERS, "esri" isn't an option, and in HKEY_CURRENT_USERS, "Server10.1" isn't an option. I know that it is installed on the machine, I am using it (and it shows up in the HKEY_LOCATION_MACHINE tree). We are using Windows 2008 R2 Standard, for whatever that's worth... Any thoughts? Make sure you are logged on as the arcgis server account user. ... View more

You can iterate through the first folder and then iterate through the second folder, find the table name that contains the name of the file from the first folder, and then perform the comparison.  Here's an example: import arcpy, os from arcpy import env folder1 = r"C:\temp\python\A" folder2 = r"C:\temp\python\B" env.workspace = folder1 for file in arcpy.ListFiles("*.csv"):     fileName = file.split(".")[0]     env.workspace = folder2     for file2 in arcpy.ListFiles("*.csv"):         if fileName in file2:             arcpy.FileCompare_management(folder1 + os.sep + file, file2, "ASCII", "CONTINUE_COMPARE", r"C:\Temp\Python" + os.sep + fileName + "_compare.txt")     env.workspace = folder1 ... View more

Hi Kaitlynn, Try adding arcpy.RefreshActiveView() at the end of your code. ... View more