nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Production of Graphs from Geodatabase Table

ModernGIS

What I have is a table I produced from our Customer Information System showing the billed KWH Usage and KW Demand for a ALL electric meters over a period of time (From July 2011 to July 2013). There are about 900,000 records in this table of around 9500 electric meters. What I am trying to accomplish is listed below:

Attached: Example.xlsx

This is also in a File Geodatabase as a Geodatabase Table
This table is composed of around 9500 meter records (METER NUMBER)

1) Go through the table and find METER NUMBER record with the billing period, KWH and KW Demand rows attached.

2) Extract/export/select a unique METER NUMBER with the data attached (billing period, KWH and KW Demand)

3) Take the data and build a graph showing the Billing Period along the "X" Axis, KWH and KW Demand along the "Y" Axis

4) Export the graph to a .PDF with the METER NUMBER as the file name

From there I can use the Attachments Geoprocessing tool to take the .PDF and attach it to the Meter Location in the .MXD

Long Term Goal is to create a One-Touch custom Button to select a specific METER NUMBER to create a graph described above and automatically create a .PDF.

I know this sounds like a huge project - and want to learn how to build it piece by piece to eventually accomplish the Long Term Goal.

Thanks for your help in advanced

Example.xlsx

Encuentra más publicaciones etiquetadas con

Accepted answers

DaveBarrett

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)[:-2] + ".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"

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

All comments

ModernGIS

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.

DaveBarrett

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)[:-2] + ".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"

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

ModernGIS

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"

DaveBarrett

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)

Hi not sure about the graph labels being lower case but the issue you are having with the .0 at the end of the number is due to the way python handles floating point numbers. If you take the example

number = float(123456)
print number
'123456.0'
# where you use the str(number) use a slice to remove the .0 in the pdf name
str(number[:-2]
'123456'

This should hopefully remove the issue when using the attachments tool

Cheers

Dave

ModernGIS

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

ModernGIS

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.

jskinner

If interested, here is the script that will work for 10.0:

import arcpy
from arcpy import env
env.overwriteOutput = 1
env.workspace = r"C:\temp\data.gdb"

table = "Meters"

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))
    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 = "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 PDF
    arcpy.SaveGraph_management(out_graph_name, out_graph_pdf, "MAINTAIN_ASPECT_RATIO", 600, 375)

MattSayler

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?

10.0 uses python 2.6, 10.2 uses python 2.7. The differences you'll more likely notice will be in the arcpy sitepackage itself (don't try to use 2.7 with 10.0).

If you don't have a 10.2 environment to work in, it will probably be easier to code using 10.0, and then make changes when you can reliably test in 10.2. That way you'll have the logic and a working process already laid out. The changes should be pretty minimal to get it going in 10.2. Repointing paths, switching to da cursors (which isn't actually required, but could be beneficial), and passing fields as a list instead of a string may be all that's needed. 10.2 MIGHT even be backwards compatible with 10.0 scripts, but I'm not sure as we haven't moved past 10.0 yet ourselves. Probably not totally.

ModernGIS

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?

MattSayler

Jake-

Thank you for that. Close.....

However - I am getting this error:

<type 'exceptions.AttributeError'>: 'module' object has no attrbute 'da'
Failed to execute

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.

ModernGIS

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.

jskinner

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.

ModernGIS

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

jskinner

This is what I see

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.

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.

DaveBarrett

## extract unique records from a gdb table and make mulitple tables for
## graphing

import arcpy, os

arcpy.env.overwriteOutput = True

table = r'H:\Python\test.gdb\billing'

fields = ['BILLING_PERIOD','METER_NUMBER','KWH','KW_DEMAND']

# empty list to store unique meter numbers
meterNumbers = []

# use a search cursor to extract the unique numbers
with arcpy.da.SearchCursor(table,fields) as cursor:
    for row in cursor:
        if not row[1] in meterNumbers:
            meterNumbers.append(row[1])

# for each unique cursor make a table view using the billing number for
# the selection
for meter in meterNumbers:
    ## omit the quotes if you table stores the meter number as a number not a string
    expression = arcpy.AddFieldDelimiters(table,'METER_NUMBER') + " = " + "'" + meter + "'"
    arcpy.MakeTableView_management(table,"CurrentMeter",expression)
    # copy the rows to a permanent table in the same location
    outTable = os.path.join(os.path.dirname(table),("meter_" + meter))
    arcpy.CopyRows_management("CurrentMeter",outTable)

    ## at this point can use the graphing options to generate the graphs and save
    ## unfortunately don't have the answer yet for this

Jake -

The generation of the list of Billing Numbers was there to help ModernGIS automate the hole process. If I was doing this I would aim to have an input of the whole table and an output location to store all the graphs. It should be possible to use the list of unique Billing Numbers in a for loop to generate each graph.

I've developed a bit of a lazy habit where I try to use the minimum clicks necessary. Can def cause a few headaches in the development though!

Cheers

Dave

DaveBarrett

This is an error I get back:

Traceback (most recent call last):
File "C:\temp\Script1.py", line 8, in <module>
arcpy.TableSelect_analysis(table, r"in_memory\table_sel", "METER_NUMBER = " + arcpy.GetParameterAsText(0))
File "C:\Program Files\ArcGIS\Desktop10.0\arcpy\arcpy\analysis.py", line 153, in TableSelect
raise e
ExecuteError: ERROR 999999: Error executing function.
An invalid SQL statement was used.
An invalid SQL statement was used. [Meters]
An invalid SQL statement was used. [SELECT * FROM Meters WHERE METER_NUMBER = ]
Failed to execute (TableSelect).

It looks like the error here with the sql statement is missing field delimiters
the statement should have "field" and then the equals
old:

arcpy.TableSelect_analysis(table, r"in_memory\table_sel", "METER_NUMBER = " + arcpy.GetParameterAsText(0))

new:

arcpy.TableSelect_analysis(table, r"in_memory\table_sel", '"METER_NUMBER"' + " = " + arcpy.GetParameterAsText(0))

alternatively for the field name you wish to use in the statment replace '"METER_NUMBER"' with

arcpy.AddFieldDelimiters(table,"METER_NUMBER")

this will add the correct delimiters for the workspace you are using.

http://resources.arcgis.com/en/help/main/10.1/index.html#/AddFieldDelimiters/018v0000006p000000/

hope this helps.

Dave

DaveBarrett

Okay - what is not working here?
## extract unique records from a gdb table and make mulitple tables for
## graphing

import arcpy, os

arcpy.env.overwriteOutput = True

table = "C:\MEWCo GIS System\Electric System\MEWCo_Electric_Model-LOCAL.gdb\billing"

fields = "BILLING_PERIOD";"METER_NUMBER";"KWH";"KW_DEMAND"

# empty list to store unique meter numbers
meterNumbers = []

# use a search cursor to extract the unique numbers
with arcpy.SearchCursor(table,fields) as cursor:
    for row in cursor:
        if not row[1] in meterNumbers:
            meterNumbers.append(row[1])
This is the error I'm getting:
Traceback (most recent call last):
File "Z:\Operations\Maps and Records\GeoDatabase\MEWCO GIS System\Python Scripts\SearchCursorExample.py", line 16, in <module>
    with arcpy.SearchCursor(table,fields) as cursor:
File "C:\Program Files\ArcGIS\Desktop10.0\arcpy\arcpy\__init__.py", line 820, in SearchCursor
    return gp.searchCursor(*args)
File "C:\Program Files\ArcGIS\Desktop10.0\arcpy\arcpy\geoprocessing\_base.py", line 357, in searchCursor
    self._gp.SearchCursor(*gp_fixargs(args)))
IOError: "C:\MEWCo GIS System\Electric System\MEWCo_Electric_Model-LOCAL.gdbilling" does not exist

It looks like this error is mainly caused by the use of the 10.1 data access search cursor not the normal search cursor at 10.0. The 10.0 search cursor does not support using the with context manager as well. There is no option to specify fields in 10.0 search cursor. The help below shows the syntax you need to use.

http://resources.arcgis.com/en/help/main/10.1/index.html#//018v00000050000000

Sorry should have checked what version it was you were using

Dave

ModernGIS

You can open ArcMap, and then navigate to C:\temp using the Catalog window. When you double-click on the script within the Toolbox, what do you see? Can you send a screen shot? What meter number did you specify?

This is what I see

ScreenShot.JPG

jskinner

You can open ArcMap, and then navigate to C:\temp using the Catalog window. When you double-click on the script within the Toolbox, what do you see? Can you send a screen shot? What meter number did you specify?

ModernGIS

Jake-

This is a great start - but it doesn't seem to be working according to your instructions. Is it open in ArcMap or ArcCatalog? - Also I dont see a place that asks me to type in a meter number

This is an error I get back:

Traceback (most recent call last):
File "C:\temp\Script1.py", line 8, in <module>
arcpy.TableSelect_analysis(table, r"in_memory\table_sel", "METER_NUMBER = " + arcpy.GetParameterAsText(0))
File "C:\Program Files\ArcGIS\Desktop10.0\arcpy\arcpy\analysis.py", line 153, in TableSelect
raise e
ExecuteError: ERROR 999999: Error executing function.
An invalid SQL statement was used.
An invalid SQL statement was used. [Meters]
An invalid SQL statement was used. [SELECT * FROM Meters WHERE METER_NUMBER = ]
Failed to execute (TableSelect).

ModernGIS

Attached is a zip file with an example. Try the following:

1. Extract the zip file to your C:\Temp directory
2. Open ArcMap
3. Under C:\Temp, expand the Data.gdb > Graph toolbox > double-click on the Script
4. Specify a meter number, i.e. 8151830
5. Click OK to execute the tool

Within your C:\Temp directory you should have a graph as a PDF. Is this what you are looking for?

Jake-

This is a great start - but it doesn't seem to be working according to your instructions. Is it open in ArcMap or ArcCatalog? - Also I dont see a place that asks me to type in a meter number

jskinner

Attached is a zip file with an example. Try the following:

1. Extract the zip file to your C:\Temp directory
2. Open ArcMap
3. Under C:\Temp, expand the Data.gdb > Graph toolbox > double-click on the Script
4. Specify a meter number, i.e. 8151830
5. Click OK to execute the tool

Within your C:\Temp directory you should have a graph as a PDF. Is this what you are looking for?

Temp.zip

ModernGIS

That is what the original script that I posted does. What you will need to do is create a sample graph and update the script with the correct paths to your data. Then, create a toolbox > right-click on the toolbox > Add Script > browse to the script. You will also need to add a parameter to the script of type Long.

A user can then click on the script and it will open a dialog for them to specify a Meter Number. Once they do and execute the tool, the meter number is queried and the graph is saved to a PDF.

Jake-

Sounds like I have most of the parts....a good part of them from you...and I really appreciate that.

The biggest headache right now is I cannot figure out the Script for the Search Cursor to isolate individual meter number records to produce a single graph for a specific meter number

jskinner

That is what the original script that I posted does. What you will need to do is create a sample graph and update the script with the correct paths to your data. Then, create a toolbox > right-click on the toolbox > Add Script > browse to the script. You will also need to add a parameter to the script of type Long.

A user can then click on the script and it will open a dialog for them to specify a Meter Number. Once they do and execute the tool, the meter number is queried and the graph is saved to a PDF.

ModernGIS

Your fields need to be a list.

http://resources.arcgis.com/en/help/main/10.2/index.html#//018w00000011000000

Instead of:
fields = "BILLING_PERIOD";"METER_NUMBER";"KWH";"KW_DEMAND"
try:
fields = ["BILLING_PERIOD","METER_NUMBER","KWH","KW_DEMAND"]
Mind me asking what's the purpose of creating a list of the meter numbers?

Jake-

What I am trying to do is to take a File Geodatabase Table that lists Electric Meters with their Peak KW Demand on a given billing period to eventually make a graph.

See previous posts in this thread for full explination.

I am having a heck of a time with this Search Cursor just trying to get a list of unique meter numbers with all of the rest of the data and isolating the rows of the same meter number

jskinner

Your fields need to be a list.

http://resources.arcgis.com/en/help/main/10.2/index.html#//018w00000011000000

Instead of:

fields = "BILLING_PERIOD";"METER_NUMBER";"KWH";"KW_DEMAND"

try:

fields = ["BILLING_PERIOD","METER_NUMBER","KWH","KW_DEMAND"]

Mind me asking what's the purpose of creating a list of the meter numbers?

ModernGIS

Okay - what is not working here?

## extract unique records from a gdb table and make mulitple tables for
## graphing

import arcpy, os

arcpy.env.overwriteOutput = True

table = "C:\MEWCo GIS System\Electric System\MEWCo_Electric_Model-LOCAL.gdb\billing"

fields = "BILLING_PERIOD";"METER_NUMBER";"KWH";"KW_DEMAND"

# empty list to store unique meter numbers
meterNumbers = []

# use a search cursor to extract the unique numbers
with arcpy.SearchCursor(table,fields) as cursor:
    for row in cursor:
        if not row[1] in meterNumbers:
            meterNumbers.append(row[1])

This is the error I'm getting:
Traceback (most recent call last):
File "Z:\Operations\Maps and Records\GeoDatabase\MEWCO GIS System\Python Scripts\SearchCursorExample.py", line 16, in <module>
    with arcpy.SearchCursor(table,fields) as cursor:
File "C:\Program Files\ArcGIS\Desktop10.0\arcpy\arcpy\__init__.py", line 820, in SearchCursor
    return gp.searchCursor(*args)
File "C:\Program Files\ArcGIS\Desktop10.0\arcpy\arcpy\geoprocessing\_base.py", line 357, in searchCursor
    self._gp.SearchCursor(*gp_fixargs(args)))
IOError: "C:\MEWCo GIS System\Electric System\MEWCo_Electric_Model-LOCAL.gdb illing" does not exist

ModernGIS

Here is an example on how to accomplish this. First, you will want to create a sample graph in ArcMap. Here is a screen shot of the parameters I used:

[ATTACH=CONFIG]27045[/ATTACH]

After the graph is created, right-click on it and save it out as a .grf file. Now you can use the below code to create a graph of the "KW Demand by Meter" by specifying a meter number:

import arcpy
from arcpy import env
env.overwriteOutput = 1
env.workspace = r"C:\temp\python\test.gdb"

table = "Meters"

arcpy.TableSelect_analysis(table, r"in_memory\table_sel", "METER_NUMBER = " + arcpy.GetParameterAsText(0))

out_graph_name = arcpy.GetParameterAsText(0)
out_graph_pdf = r"C:\Temp\python\Userdata" + "\\" + arcpy.GetParameterAsText(0) + ".pdf"
input_template = r"C:\Temp\Python\UserData\KW Demand.grf" #grf file previously saved
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)

Jake-

Thank you for the Python Script for creating a graph. I will work with that and see what I can come up with

ModernGIS

Hi,

Have part of an answer for you, the code below will allow you to extract out the information based on the unique billing numbers within your table. It doesn't yet create and export the graphs but more on that in a minute. Here is the code for extracting the unique billing tables.
## extract unique records from a gdb table and make mulitple tables for
## graphing

import arcpy, os

arcpy.env.overwriteOutput = True

table = r'H:\Python\test.gdb\billing'

fields = ['BILLING_PERIOD','METER_NUMBER','KWH','KW_DEMAND']

# empty list to store unique meter numbers
meterNumbers = []

# use a search cursor to extract the unique numbers
with arcpy.da.SearchCursor(table,fields) as cursor:
    for row in cursor:
        if not row[1] in meterNumbers:
            meterNumbers.append(row[1])

# for each unique cursor make a table view using the billing number for
# the selection
for meter in meterNumbers:
    ## omit the quotes if you table stores the meter number as a number not a string
    expression = arcpy.AddFieldDelimiters(table,'METER_NUMBER') + " = " + "'" + meter + "'"
    arcpy.MakeTableView_management(table,"CurrentMeter",expression)
    # copy the rows to a permanent table in the same location
    outTable = os.path.join(os.path.dirname(table),("meter_" + meter))
    arcpy.CopyRows_management("CurrentMeter",outTable)

    ## at this point can use the graphing options to generate the graphs and save
    ## unfortunately don't have the answer yet for this
the copy rows at the end is not strictly need as you can do the graph creation in memory for each billing table.

If you want to create the graph purely using arcpy and ArcGIS you have a couple of options. There are the make and save graph tools which you can use based on a template graph created in arcmap, all that is required then is to modify the data source for each graph to your current table.

Alternatively use the arcpy graph class to carry out all these steps, I believe you will need to use this class to modify the data sources in the previous example. THe save graph will then allow you to export to pdf.

There is also matplotlib shipped with arcpy and that may be a better way to create the graphs. Sorry haven't used it so can't give you any steering on utilising it.

Hope this helps and gets you started. If i come up with anything I'll post again.

Cheers

Dave

Dave-

Thank you for the Python script to find the unique Meter Number and export them out. I will play with this and see what I can come up with.

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.