Latest Contributions by GrahameRoss1

Agreed! Still using a workaround in the field. would like Explorer back ASAP... ... View more

I have a user starting his field season and needs to access our spatial data... no hope for a fix for at least 2+ more months? Is this related to the security updates requiring us to install TLS patch 1.2 regarding esri's data services? app works on my personal Iphone- no way to push out a fix to android quicker???  ... View more

cleaning up the code per your suggestions worked. there was not an error, it was not combining the two comparison outputs to the change table. I don't remember where I got the syntax for lines 19-21... could you explain the second half of your line 23 to me? why the second bracketed zero in the '...table_a-data[row [0]][0]...'? the unique ID field I am comparing for both cursor and dictionary is [0] whereas the acreage to compare is for both is [1]. how does 'table_a-data [row[0]][0]' equate to [1]? so I am using cursors and dictionaries... could I have done this just comparing the dictionaries? Thank you for your help- I really appreciate your time! ... View more

Thanks for your reply Richard- I was posting quickly, hoping it was a very simple answer. the old script did exactly as you say- looping through using cursors. the dictionary approach is much quicker! I just need to figure out how to write the outputs to the same change table. one other question I have: can you compare dictionaries against each other? in my instance below, I am comparing one dictionary to a search cursor result (table A dict to FC B cursor), and then doing it again (FC B dict to Table A Cursor)- I am new to this whole thing and not that clear on the logic I need to make it all work... here is the code I am working with: Thanks for your help! #Variables TESTING------------------------------------------- Table_A = r'\\StagingTesting.gdb\Table' FC_B = r'\\StagingTesting.gdb\Table_GIS_Features' Table_C = r'\\BackupTesting.gdb\changesTable' Tolerance = 0.05 ###Delete change table arcpy.DeleteRows_management(Table_C) #create cursors Table_A_Cursor = arcpy.da.SearchCursor (Table_A,['field A','field B','field C','field D','field E'],) FC_B_Cursor = arcpy.da.SearchCursor (FC_B,['field A','field B','field C','field D','field_B_Text'],) rows = arcpy.InsertCursor(Table_C, ['field D', 'field C', 'field B','field A', 'field E', 'field F']) #create dictionaries for Table A and FC B data  table_a_data = {r[0]:r[1:] for r in arcpy.da.SearchCursor (Table_A,['field A','field B','field C','field D','field E'],)} FC_B_data = {r[0]:r[1:] for r in arcpy.da.SearchCursor (FC_B,['field A','field B','field C','field D'],)} #loop through FC B find acreage updates to Table A for row in Table_A_Cursor:     table_a_data[row[0]] = row[1]     for row in FC_B_Cursor:     if abs(row [1]-table_a_data[row[0]])>Tolerance:         insert = rows.newRow()         insert.setValue("field D", row[3])         insert.setValue("field C", row[2])         insert.setValue("'field B'", row[4])         #insert.setValue("Fiel A", row[0])         #insert.setValue("field E", table_a_data[3])         insert.setValue("field F", 'NEW ACREAGE:Update Acres')         rows.insertRow(insert)         del row # find records in Table A not in FC B for row2 in FC_B_Cursor:     FC_B_data[row2[0]] = row2[1] #loop through table A for row2 in Table_A_Cursor:     if not row2[0] in FC_B_data:         insert = rows2.newRow()         insert.setValue("field D", row2[3])         insert.setValue("field C", row2[2])         insert.setValue("'field B'", row2[1])         #insert.setValue('field A', row2[0])         insert.setValue("field E", row2[4])         insert.setValue("field F", 'NOT IN GIS:DELETE FROM Table_A?')         rows.insertRow(insert)         del row2 del rows‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

I did- I zoomed in to 1:400, set Idntify From <All Layers> and identified the imagery. the high resolution 30Cm... has Microsoft as the source with a source date of 7/4/2011. looking at the blog post I reference above it looks like the imagery has been updated in the tahoe basin area... .Looking at USGS gauge height records for 7/4/11, the water level was within 1/4 foot of what it is today- but I was looking at this area about 6 months ago and I was sure the beach area was larger...! ... View more