Latest Contributions by ModernElectric

Chris- Thank you for the past (2) posts. I will look at both ideas and see what I can come up with. Guess I should have said I am working on ArcMap 10.2 Also, instead of creating a list of each "TWACs_NUMBER", and running a seperate cursor for each one, just run a single cursor and store the lists in a dictionary, where each twacNo is a key and each key points to a list of meterNos. In v10.1 this would look like: twacDict = {} searchRows = arcpy.da.SearchCursor(table, ["TWACs_NUMBER","METER_NUMBER"]) for searchRow in searchRows:    twacNo, meterNo = searchRow    if twacNo in twacDict:       twacDict[twacNo].append(meterNo)    else:       twacDict[twacNo] = [meterNo] del searchRow, searchRows twackList = twacDict.keys() twackList.sort() for twacNo in twackList:    meterList = twacDict[twacNo]    #make a graph here, since you now have a hook to the twacNo and it's list of meterNos ... View more

This table "in_memory\table_sel" you create will persist until you close the instance it was created in. And how do I do that? ... View more

I would find it more likely your log file is the issue. Try disabling logging and running it a few times to see if you get the same slow downs. Also, are you closing the instance of python this script is running in between executions? The in_memory workspace won't clear properly until you terminate the instance it was executed in or you clear it explicitly. I will see what I does when I remove the logging from the script. Forgive me, but the second part you are talking about... what do you mean ... View more

# Name: Electric Meter Demand Graphs - Usage.py # Description: Python script to take a single TWACs Meter and create a Usage Graphs per Feeder # Date Created: Tuesday, September 17th, 2013 @ 1:20 PM # Date Modified: Tuesday, September 17th, 2013 @ 1:20 PM # Author: C. Wafstet #94 - Modern Electric Water Company (Spokane, WA) import arcpy import arcpy import logging from arcpy import env env.overwriteOutput = 1 env.workspace = r"C:\MEWCo GIS System\Electric System\MEWCo_Electric_Model-LOCAL.gdb" table = "SERVICE_METERS_DEMAND_F1FEEDER_ABC" list = [] # if run in ArcGIS Desktop, show messages, also print to log def log(method, msg):     print msg     method(msg) logging.basicConfig(         level=logging.INFO,         format='%(asctime)s %(levelname)-s %(message)s',         datefmt='%a, %d %b %Y %H:%M:%S',         filename='MakeGraph.log',         filemode='w'         ) log(logging.info, "Creation of Graphs Started") rows = arcpy.SearchCursor(table) for row in rows:     list.append(row.TWACs_NUMBER) del row, rows # Remove duplicates from list list = dict.fromkeys(list) list = list.keys() for n in list:     arcpy.TableSelect_analysis(table, r"in_memory\table_sel", "TWACs_NUMBER = " + str(n))     # Get TWACs_Number value     for row in arcpy.SearchCursor(r"in_memory\table_sel"):         METER_NUMBER = row.getValue("METER_NUMBER")     out_graph_name = n     out_graph_pdf = r"C:\MEWCo GIS System\Electric Graphs\Electric Meters\Usage Graphs\F-1 Feeder" + "\\" + str(n)[:-2] + "-Usage" + ".pdf"     input_template = r"C:\MEWCo GIS System\Electric Graphs\GIS Graph Temps\ELECTRIC METER DEMAND - KWH USAGE.grf"     input_data = r"in_memory\table_sel" # Create the Graph     graph = arcpy.Graph() # Add a Vertical Bar series to the graph - KWH Usage     graph.addSeriesBarVertical(input_data, "KWH_USAGE") # Specify the title of the Left Axis     graph.graphAxis[0].title = "KWH_USAGE" # Specify the title of the Bottom Axis     graph.graphAxis[2].title = "BILLING_PERIOD" # Specify the title of the Graph     graph.graphPropsGeneral.title = "KWH Usage by Electric TWACs Number: " + METER_NUMBER # Output a graph, which is created in-memory     arcpy.MakeGraph_management(input_template, graph, out_graph_name) # Save the graph as an .PDF     arcpy.SaveGraph_management(out_graph_name, out_graph_pdf, "MAINTAIN_ASPECT_RATIO", 600, 375) log(logging.info, "Creation of Graphs Complete")     The code works just fine.... I worked on it for awhile to make it work the way I want it too. It just seems like - each time I run it - it takes longer and longer. ... View more

Jake- Yes - huge help on one of my previous posts to get the Python script to create the graph. Nice to know that there is a bug in the tool/script. I have been trying multiple different things for the past few days to get it to work. I will send a note to Tech Support and see what can be done. Thank you for the help. Chris Chris, I believe I was assisting your before.  I think the title of the axis's being lowercase is a bug.  I was able to reproduce this same behavior.  I would recommend following up with Tech Support. As for the title, you can use the 'getValue' method to retrieve the value of your field.  Ex: import arcpy from arcpy import env env.overwriteOutput = 1 env.workspace = r"C:\temp\data.gdb" table = "Meters" fields = ["METER_NUMBER"] list = [] rows = arcpy.SearchCursor(table) for row in rows:     list.append(row.METER_NUMBER) del row, rows #remove duplicates from list list = dict.fromkeys(list) list = list.keys() for n in list:     arcpy.TableSelect_analysis(table, r"in_memory\table_sel", "METER_NUMBER = " + str(n))         #get TWACs_Number value     for row in arcpy.SearchCursor(r"in_memory\table_sel"):         TWACs_Number = row.getValue("TWACs_Number")        out_graph_name = n     out_graph_pdf = r"C:\Temp" + "\\" + str(n) + ".pdf"     input_template = r"C:\Temp\KW Demand.grf"     input_data = r"in_memory\table_sel"     # Create the graph     graph = arcpy.Graph()     # Add a vertical bar series to the graph     graph.addSeriesBarVertical(input_data, "KW_DEMAND")     # Specify the title of the left axis     graph.graphAxis[0].title = "KW Demand"     # Specify the title of the bottom axis     graph.graphAxis[2].title = "Meter Number"     # Specify the title of the Graph     graph.graphPropsGeneral.title = TWACs_Number     # Output a graph, which is created in-memory     arcpy.MakeGraph_management(input_template, graph, out_graph_name)     # Save the graph as a PDF     arcpy.SaveGraph_management(out_graph_name, out_graph_pdf, "MAINTAIN_ASPECT_RATIO", 600, 375) ... View more

Sorry meant to add that bit in. Where you specify the name of the PDF and use str(n) use str(n)[:-2] Cheers Dave BINGO!!!! That is exactly what I am looking for. The .PDFs are coming out exactly the way they need and are named properly. Thank you I am doing more research on the graph itself. ... View more

Dave- Thank you, but how should that look here??: for n in list:     arcpy.TableSelect_analysis(table, r"in_memory\table_sel", "TWACs_NUMBER = " + str(n))     out_graph_name = n     out_graph_pdf = r"C:\MEWCo GIS System\Electric Graphs\Electric Meters\F-1 Feeder" + "\\" + str(n) + ".pdf"     input_template = r"C:\MEWCo GIS System\Electric Graphs\GIS Graph Temps\ELECTRIC METER DEMAND - KWH USAGE.grf"     input_data = r"in_memory\table_sel" ... View more

At this time - I have installed ArcGIS 10.2 and the script is working perfectly. Except (1) thing that I cannot figure out. The field that is being used to name the .PDF is TWACs_NUMBER, which is a "Double" field type. I am having a hard time getting the naming of the .PDF to come out properly. Example: TWACs_Number - 14710787 The way the .PDF is being created: 14710787.0.pdf This is going to make it difficult running the attachment tool because of the .0 at the end since in the table there is no .0 This is what the stand-alone Python script looks like: import arcpy import arcpy from arcpy import env env.overwriteOutput = 1 env.workspace = r"C:\MEWCo GIS System\Electric System\MEWCo_Electric_Model-LOCAL.gdb" table = "SERVICE_METERS_DEMAND_F1FEEDER" list = [] rows = arcpy.SearchCursor(table) for row in rows:     list.append(row.TWACs_NUMBER) del row, rows # Remove duplicates from list list = dict.fromkeys(list) list = list.keys() for n in list:     arcpy.TableSelect_analysis(table, r"in_memory\table_sel", "TWACs_NUMBER = " + str(n))     out_graph_name = n     out_graph_pdf = r"C:\MEWCo GIS System\Electric Graphs\Electric Meters\F-1 Feeder" + "\\" + str(n) + ".pdf"     input_template = r"C:\MEWCo GIS System\Electric Graphs\GIS Graph Temps\ELECTRIC METER DEMAND - KWH USAGE.grf"     input_data = r"in_memory\table_sel" # Create the Graph     graph = arcpy.Graph() # Add a Vertical Bar series to the graph - KWH Usage     graph.addSeriesBarVertical(input_data, "KWH_USAGE") # Specify the title of the Left Axis     graph.graphAxis[0].title = "KWH_USAGE" # Specify the title of the Bottom Axis     graph.graphAxis[2].title = "BILLING_PERIOD" # Specify the title of the Graph     graph.graphPropsGeneral.title = "KWH Usage by Electric TWACs Number" # Output a graph, which is created in-memory     arcpy.MakeGraph_management(input_template, graph, out_graph_name) # Save the graph as an .PDF     arcpy.SaveGraph_management(out_graph_name, out_graph_pdf, "MAINTAIN_ASPECT_RATIO", 600, 375) Also - why is it when the .PDF is greated - the graph title and lables are ALL lower case letters? Thank you ... View more

Jake-   Thank you for the script for ArcMap 10.0 It looks good - but - I have tried the script in ArcCatalog and ArcMap and each time - it crashes and get the "ArcGIS Desktop has encountered a serious application error and is unable to continue" Error screen. ... View more

Jake, he's running 10.0. The da cursors didn't show up until 10.1. Also, I don't think 10.0 cursors will take a list for the fields, just a formatted string. Okay - I am trying to run this script off of ArcMap 10.0... I am in the process of upgrading to 10.2.... What is the latest Python that I will need? ... View more

Jake- Thank you for that. Close..... However - I am getting this error: <type 'exceptions.AttributeError'>: 'module' object has no attrbute 'da' Failed to execute Here is an update to the script that will perform this for each unique meter number: import arcpy from arcpy import env env.overwriteOutput = 1 env.workspace = r"C:\temp\data.gdb" table = "Meters" fields = ["METER_NUMBER"] list = [] with arcpy.da.SearchCursor(table, fields) as cursor:     for row in cursor:         list.append("{0}".format(row[0])) del cursor, row #remove duplicates from list list = dict.fromkeys(list) list = list.keys() for n in list:     arcpy.TableSelect_analysis(table, r"in_memory\table_sel", "METER_NUMBER = " + n)     out_graph_name = n     out_graph_pdf = r"C:\Temp" + "\\" + n + ".pdf"     input_template = r"C:\Temp\KW Demand.grf"     input_data = r"in_memory\table_sel"     # Create the graph     graph = arcpy.Graph()     # Add a vertical bar series to the graph     graph.addSeriesBarVertical(input_data, "KW_DEMAND")     # Specify the title of the left axis     graph.graphAxis[0].title = "KW Demand"     # Specify the title of the bottom axis     graph.graphAxis[2].title = "Meter Number"     # Specify the title of the Graph     graph.graphPropsGeneral.title = "KW Demand by Meter"     # Output a graph, which is created in-memory     arcpy.MakeGraph_management(input_template, graph, out_graph_name)     # Save the graph as an image     arcpy.SaveGraph_management(out_graph_name, out_graph_pdf, "MAINTAIN_ASPECT_RATIO", 600, 375) If you want to run this from toolbox, right-click on the script within toolbox > Properties > Parameters tab and delete the parameter previously created. ... View more

Right-click on the Script in the toolbox, click the Source tab, and make sure this is set to the script: [ATTACH=CONFIG]27069[/ATTACH] Also, check to make sure the Parameter is set: [ATTACH=CONFIG]27070[/ATTACH] Then, when you double-click on the Script in the toolbox, you should be presented with the following: [ATTACH=CONFIG]27071[/ATTACH] The user can enter in a meter number, and then an output graph will be created like the one attached. Okay - so far this is an awesome start. I am atleast getting the script to run without any errors and the .PDF is coming out - but the graph is not showing the data.... no worries. This is something for me to build off of...... The thing I want to do is to be able to run a script that will do these for Each meter (around 9500 total) at one time. This current script works for on demand graphs. Thanks alot so far ... View more

Not sure if this makes a difference at all - but I am currently running ArcMap 10.0 and using Python 2.6. I am using IDLE to edit and run the script. Is this making a difference in the code and how its running? I am planning on upgrading to ArcMap 10.2 in the next week. ... View more