Number of recorded features in catalogue per month

Created: 2012-08-22 09:24:03

Download Workflow

The number of features of the specified catalogue are counted per month between beginning of the year_start und the end of the year_end. Return format is VOTable

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/3114/download?version=1
[ More Info Expand ]

Workflow Components

Authors (1)

Titles (1)

Descriptions (1)

Dependencies (0)

Inputs (3)

Name	Description
HFC_table_name	Name of the HFC catalogue, it must have a 'date_obs' field VIEW_AR_HQI VIEW_SP_HQI VIEW_CH_HQI VIEW_FIL_HQI
year_end	Search ends at the end of this year (2009)
year_start	Searches start at the beginning of this year (1998)

Processors (4)

Name	Type	Description
SQLSelect	wsdl	Wsdl http://voparis-helio.obspm.fr/hfc-hqi/HelioTavernaService?wsdl Wsdl Operation SQLSelect
SQLSelect_sql_select	xmlsplitter
WHAT_value	stringconstant	Value YEAR(date_obs) as year, MONTH(date_obs) as month, count(*) as count
Beanshell	beanshell	Script sql_where= "year(date_obs)>="+startyear+ " and year(date_obs)<="+endyear+" group by year,month";

Beanshells (1)

Name	Description	Inputs	Outputs
Beanshell		startyear endyear	sql_where

Outputs (1)

Name	Description
SQLSelect_response

Datalinks (7)

Source	Sink
SQLSelect_sql_select:output	SQLSelect:sql_select
HFC_table_name	SQLSelect_sql_select:FROM
WHAT_value:value	SQLSelect_sql_select:WHAT
Beanshell:sql_where	SQLSelect_sql_select:WHERE
year_end	Beanshell:endyear
year_start	Beanshell:startyear
SQLSelect:response	SQLSelect_response

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 (4)

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 feature occurences between beginning of year_start and end of year_end

Information Favourited By (0)

No one

Information Statistics

1522 viewings

1085 downloads

[ see breakdown ]

Citations (0)

None

Version History

In chronological order:

Number of recorded features in catalogue per month

Created by Anja Le Blanc on Wednesday 22 August 2012 09:24:02 (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 (7)

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

Taverna 2

Uploader

Donal Fellows

Associate hessi flares with active regions (3)

Download

This workflow is querying the HFC ActiveRegions list and HEC hessi_flare list. It requires a time periode and a search radius arround the centre of an Active Region as inputs It produces two outputs: AnnotatedFeatureTable is a modified VOTable where a field is added with the number of associated hessi flares. CombinedTable is a 2 dimensional list with an VOTable for each Active region and one with an VOTable for all associated flares for that Active Region.

Created: 2011-06-22 | Last updated: 2012-07-10

Credits: Donal Fellows

Taverna 2

Uploader

Anja Le Blanc

Check the content of the Registry for mism... (1)

Download

This workflow check for tables which are registered in the HELIO registry but not available in the HFC and for tables which are in the UOC but which are not registred.

Created: 2012-07-26

Credits: Anja Le Blanc

Number of recorded features in catalogue per month

Preview

Run

Run this Workflow in the Taverna Workbench...

Workflow Components

Wsdl

Wsdl Operation

Value

Script

Reviews (0)

Comments (0)

Other workflows that use similar services (7)