Broccoli Production New York State, 1960-1965
Created: 2011-10-09 12:44:10
Last updated: 2011-10-09 12:46:44
This workflow takes data about agricultural production in New Jersey and New York from 1960 -1965, to compare productivity in broccoli growing.
Preview
Run
Run this Workflow in the Taverna Workbench...
Workflow Components
Authors (1)
Titles (1)
Spreadsheet Import Example |
Descriptions (1)
Example using the SpreadsheetImport service to import data from an Excel spreadsheet.
The workflow imports the file spreadsheet file WaterUse.xlsx and generates a graph from the date.
The source data is from http://data.gov.uk/ |
Dependencies (0)
Processors (9)
Name |
Type |
Description |
SpreadsheetImport |
spreadsheet |
|
GenerateGraphURL |
beanshell |
ScriptStringBuilder sb = new StringBuilder();
sb.append("http://chart.apis.google.com/chart?");
sb.append("cht=bvg");
sb.append("&chs=1000x300");
sb.append("&ch=");
sb.append("&chxt=x,y,y");
sb.append("&chbh=5,1,5");
sb.append("&chxr=0,");
sb.append(Float.parseFloat(years.get(0)).intValue());
sb.append(",");
sb.append(Float.parseFloat(years.get(years.size() - 1)).intValue());
sb.append(",2|1,0,20");
sb.append("&chds=0,20");
sb.append("&chxl=2:|1000%20megalitres%2fday");
sb.append("&chxp=2,50");
sb.append("&chco=FF0000,00FF00,0000FF");
sb.append("&chdl=");
for (int i = 0; i < headers.size(); i++) {
sb.append(headers.get(i).replace(" ", "%20"));
if (i+1 < data.size()) {
sb.append("|");
}
}
if (title != void) {
sb.append("&chtt=");
sb.append(type);
}
if (data != void) {
sb.append("&chd=t:");
for (int i = 0; i < data.size(); i++) {
List data1 = (List) data.get(i);
for (int j = 0; j < data1.size(); j++) {
Float value = Float.parseFloat(data1.get(j));
sb.append(value.intValue());
if (j+1 < data1.size()) {
sb.append(",");
}
}
if (i+1 < data.size()) {
sb.append("|");
}
}
}
graphURL = sb.toString(); |
Get_Image_From_URL |
localworker |
ScriptURL inputURL = null;
if (base != void) {
inputURL = new URL(new URL(base), url);
} else {
inputURL = new URL(url);
}
byte[] contents;
if (inputURL.openConnection().getContentLength() == -1) {
// Content size unknown, must read first...
byte[] buffer = new byte[1024];
int bytesRead = 0;
int totalBytesRead = 0;
InputStream is = inputURL.openStream();
while (bytesRead != -1) {
totalBytesRead += bytesRead;
bytesRead = is.read(buffer, 0, 1024);
}
contents = new byte[totalBytesRead];
} else {
contents = new byte[inputURL.openConnection().getContentLength()];
}
int bytesRead = 0;
int totalBytesRead = 0;
InputStream is = inputURL.openStream();
while (bytesRead != -1) {
bytesRead = is.read(contents, totalBytesRead, contents.length - totalBytesRead);
totalBytesRead += bytesRead;
if (contents.length==totalBytesRead) break;
}
image = contents;
|
Beanshell |
beanshell |
ScriptNJdata = new ArrayList();
headers = new ArrayList();
headers.add(year.remove(0));
headers.add(NJAreaPlanted.remove(0));
headers.add(NJAreaHarvested.remove(0));
NJdata.add(year.remove(0));
NJdata.add(NJAreaPlanted.remove(0));
NJdata.add(NJAreaHarvested.remove(0));
year.remove(0);
years = year; |
url_value |
stringconstant |
Valuehttp://www.myexperiment.org/files/570/download/PS3-NY-Broccoli.xls |
url_value_2 |
stringconstant |
Valuehttp://www.myexperiment.org/files/569/download/PS3-NJ-Broccoli.xls |
SpreadsheetImport_2 |
spreadsheet |
|
Beanshell_2 |
beanshell |
ScriptNYdata = new ArrayList();
headers = new ArrayList();
headers.add(year.remove(1));
headers.add(NYAreaPlanted.remove(0));
headers.add(NYAreaHarvested.remove(0));
NYdata.add(year.remove(1));
NYdata.add(NYAreaPlanted.remove(0));
NYdata.add(NYAreaHarvested.remove(0));
year.remove(0);
years = year; |
title_value |
stringconstant |
ValueBroccoli Production NY vs. NJ 1960-1965 |
Beanshells (3)
Name |
Description |
Inputs |
Outputs |
GenerateGraphURL |
|
title
data1
headers
years
data2
|
graphURL
|
Beanshell |
|
year
NJAreaPlanted
NJAreaHarvested
|
NJdata
headers
years
|
Beanshell_2 |
|
year
NYAreaPlanted
NYAreaHarvested
|
NYdata
headers
years
|
Datalinks (15)
Source |
Sink |
url_value:value |
SpreadsheetImport:fileurl |
Beanshell:years |
GenerateGraphURL:years |
Beanshell:headers |
GenerateGraphURL:headers |
Beanshell:NJdata |
GenerateGraphURL:data1 |
Beanshell_2:NYdata |
GenerateGraphURL:data2 |
title_value:value |
GenerateGraphURL:title |
GenerateGraphURL:graphURL |
Get_Image_From_URL:url |
SpreadsheetImport:Year |
Beanshell:year |
SpreadsheetImport:NJAreaHarvested |
Beanshell:NJAreaHarvested |
SpreadsheetImport:NJAreaPlanted |
Beanshell:NJAreaPlanted |
url_value_2:value |
SpreadsheetImport_2:fileurl |
SpreadsheetImport_2:NYAreaHarvested |
Beanshell_2:NYAreaHarvested |
SpreadsheetImport_2:NYAreaPlanted |
Beanshell_2:NYAreaPlanted |
SpreadsheetImport_2:Year |
Beanshell_2:year |
Get_Image_From_URL:image |
graph |
Uploader
License
All versions of this Workflow are
licensed under:
Version 1
(of 1)
Credits (2)
(People/Groups)
Attributions (1)
(Workflows/Files)
Shared with Groups (0)
None
Featured In Packs (0)
None
Log in to add to one of your Packs
Attributed By (0)
(Workflows/Files)
None
Favourited By (0)
No one
Statistics
Other workflows that use similar services
(0)
There are no workflows in myExperiment that use similar services to this Workflow.
Comments (0)
No comments yet
Log in to make a comment