Counts number of events per month in HEC table

Created: 2012-08-22 14:46:16

Download Workflow

This workflow counts the monthly number of events in a HEC table from the begining of year year_start to the end of year year_end. Returns a VOTable with the count

Preview

Download as scalable diagram (SVG)

Run

Run this Workflow in the Taverna Workbench...

Option 1:

Copy and paste this link into File > 'Open workflow location...'
http://myexperiment.org/workflows/3116/download?version=1
[ More Info Expand ]

Workflow Components

Authors (1)

Titles (1)

Descriptions (1)

Dependencies (0)

Inputs (3)

Name	Description
HEC_list_name	Name of HEC list, must contain time_start field
year_start	counts from the beginning of year_start
year_end	counts up to the end of year_end

Processors (4)

Name	Type	Description
SQLSelect	wsdl	Wsdl http://msslkz.mssl.ucl.ac.uk/helio_hec/HelioTavernaService?wsdl Wsdl Operation SQLSelect
SQLSelect_sql_select	xmlsplitter
construct_where	beanshell	Script sql_where= "extract(year from time_start)>="+startyear+" and extract(year from time_start)<="+endyear +" group by year,month";
WHAT_value	stringconstant	Value extract(year from time_start) as year, extract(month from time_start) as month,count(1)

Beanshells (1)

Name	Description	Inputs	Outputs
construct_where		startyear endyear	sql_where

Outputs (1)

Name	Description
VOTable_counts

Datalinks (7)

Source	Sink
SQLSelect_sql_select:output	SQLSelect:sql_select
HEC_list_name	SQLSelect_sql_select:FROM
construct_where:sql_where	SQLSelect_sql_select:WHERE
WHAT_value:value	SQLSelect_sql_select:WHAT
year_start	construct_where:startyear
year_end	construct_where:endyear
SQLSelect:response	VOTable_counts

Coordinations (0)

Information Workflow Type

Taverna 2

Information Uploader

Anja Le Blanc

Information License

All versions of this Workflow are licensed under:

BSD License

Information Version 1 (of 1)

Information Credits (1)

(People/Groups)

Anja Le Blanc

Information Attributions (0)

(Workflows/Files)

None

Information Tags (3)

Uploader tags

Log in to add Tags

Information Shared with Groups (1)

HELIO

Information Featured In Packs (0)

None

Log in to add to one of your Packs

Information Attributed By (1)

(Workflows/Files)

Monthly counts for event occurences between beginning of year_start and end of year_end

Information Favourited By (0)

No one

Information Statistics

1500 viewings

1160 downloads

[ see breakdown ]

Citations (0)

None

Version History

In chronological order:

Counts number of events per month in HEC table

Created by Anja Le Blanc on Wednesday 22 August 2012 14:46:15 (UTC)

Reviews (0)

No reviews yet

Be the first to review!

Comments (0)

View Timeline

No comments yet

Log in to make a comment

Other workflows that use similar services (16)

Only the first 2 workflows that use similar services are shown. View all workflows that use these services.

Taverna 2

Uploader

Anja Le Blanc

Check HEC instances for diverging content (2)

Download

This workflow check all tables in HEC on festung1 and festung3 for diverging content by comparing the last 1000 entries in each table. Output is a list of tabel names with different content.

Created: 2012-08-20 | Last updated: 2012-08-20

Credits: Anja Le Blanc

Taverna 2

Uploader

Anja Le Blanc

Monthly counts for event occurences betwee... (1)

Download

This workflow provides monthly counts of events in HEC between the beginning of year_start and the end of year_end. Returns the result as comma separated file (csv) and as list of lists.