Latest Contributions by ModernElectric

Good day:   I am working on a project that requires me to take data from a file GDB table and update a non-gis table in an Oracle database. I have multiple Update Cursor scripts that I use to update GDB FC(s) and table(s) and have no problems with that. When I build the script to update the Oracle database table, I keep getting DBMS error [ORA-00923: FROM keyword not found where expected] I cannot figure out what is going on and how to fix this. The fields, to and from and path(s) are 100% correct.  I've attached the update cursor python script. Is there something I am missing? I have 100% read/write permission on the Oracle database that is connected via an ODBC connection.  Is it possible that the ObjectID in the GDB table is causing a conflict since it doesnt exist in the Oracle table?   def AttributeUpdate(source_table, in_field, update_fields, join_table, join_key, join_values): # Make sure there is matching number of join and update fields update_dict = {} if len(update_fields) == len(join_values): for i in range(len(update_fields)): update_dict[join_values[i]] = update_fields[i] for k,v in update_dict.iteritems(): # Create Dictionary path_dict = {} srows = arcpy.SearchCursor(join_table) for srow in srows: keyrow = srow.getValue(join_key) valrow = srow.getValue(k) path_dict[keyrow] = valrow del srow, srows # Update Cursor urows = arcpy.UpdateCursor(source_table) for row in urows: upkey = row.getValue(in_field) if upkey in path_dict: row.setValue(v, path_dict[upkey]) urows.updateRow(row) else: pass # skip nulls del row, urows print '\'%s\' field in "%s" updated successfully' %(v, p.basename(source_table)) else: print 'ERROR: Number of update fields and value fields does not match' if __name__ == '__main__': DCSI = r'Database Connections\DCSI.sde\DCSI.MEWCO_TRANS_RATING' GDB = r'C:\Users\cwafstet\Documents\GIS WORKING FILES LOCAL\ELECTRIC\MEWCo ELECTRIC SYSTEM.gdb\MEWCO_TRANS_RATING' # Attribute Update DCSI_fields = ['XFMR BANK RATING'] GDB_fields = ['XFMR_BANK_RATING'] AttributeUpdate(DCSI, 'XFMR BANK ID', DCSI_fields, GDB, 'XFMR_BANK_ID', GDB_fields)     ... View more

I have already created a series of scripts to sort thru my GDB and produce infrastructure statistics. I have developed one script to run all of the scripts and export the results to a series of .TXT files: import arcpy import sys import os.path arcpy.env.transferDomains = True orig = sys.stdout with open(os.path.join("Z:\Operations\Maps and Records\Infrastructure Counts Stats\DATA EXPORT", "eJOINT_USE_INVENTORY.txt"), "wb") as f: sys.stdout = f try: execfile("JOINT_USE_COUNTS_NEW.py", {}) finally: sys.stdout = orig The issue I am having is when this exports the File GDB Table to a .TXT value, the domain code is exported. I need to have the domain description when the data is exported to the .TXT file. I have verified that the domain is assigned to the specific field. Thank You ... View more

I am working on making improvements to my collection of Python scripts to produce statistical data reports on my in-service infrastructure system. Currently, I am using a file GDB with Feature Class to Feature Class AND Summary Statistics tools with SearchCursor tool to produce the counts. However, as my infrastructure grows and becomes more complex, the script is becoming less efficient.  I figured out how to do a SearchCursor to give me the total counts of a point feature class per specific attribute criteria: with arcpy.da.SearchCursor("eSUPPORT_STRUCTURE", "SHAPE@", "POLE_OWNER = 806") as cursor: rows = {row[0] for row in cursor} count = 0 for row in rows: count += 1 print "MEWCo Poles: %s" % count  However, what I am trying to do is take this same Cursor and use it to produce the total lengths on a polyline feature class from my existing code: # Process: Feature Class to Feature Class - 20" Mainline arcpy.FeatureClassToFeatureClass_conversion(wMain, TempGDB_gdb, "wMain20", "DIAMETER = 20 AND LIFE_CYCLE_STATUS = 8") # Process: Summary Statistics - 20" Mainline arcpy.Statistics_analysis(wMain20, wMain20_Statistics, "SHAPE_Length SUM", "") I am a little stuck trying to work with a polyline FC versus a point FC. Appreciate your help ... View more