Find_periods_of_time_where_two_ILS_objects_are_located_at_a_maximum_of_X_degrees_longitude_from_each_otherILS_target_object100 ILS target_obj term EARTH MARS VENUS STEREO-A 2011-11-01 13:28:29.996 GMT EARTH 2011-11-01 13:28:37.461 GMT ILS_target_object200 MARS 2011-11-01 13:28:51.539 GMT ILS target_obj term EARTH MARS VENUS STEREO-A 2011-11-01 13:28:45.835 GMT Max_angle_betwee00 2 2011-11-01 13:27:58.905 GMT Angle in degrees 2011-11-01 13:27:55.617 GMT time_start00 start time for that search 2005-01-01T00:00:00 2011-11-04 14:30:09.718 GMT 2005-01-01T00:00:00 2011-11-04 14:30:19.0 GMT time_end00 end time for that search 2012-01-01T00:00:00 2011-11-04 14:30:38.875 GMT 2012-01-01T00:00:00 2011-11-04 14:30:44.281 GMT votableSQLSelect_responseSQLSelect_sql_selectFROM1WHAT1WHERE0output00net.sf.taverna.t2.activitieswsdl-activity1.3-SNAPSHOTnet.sf.taverna.t2.activities.wsdl.xmlsplitter.XMLInputSplitterActivity WHAT 1 l('text/plain') false FROM 1 l('text/plain') false WHERE 0 'text/plain' false ORDER_BY 0 'text/plain' false LIMIT 0 'text/plain' false OFFSET 0 'text/plain' false output 0 'text/xml' 0 <s:extensions xmlns:s="http://org.embl.ebi.escience/xscufl/0.1alpha"><s:complextype optional="false" unbounded="false" typename="SQLSelect" name="sql_select" qname="{http://helio-vo.eu/xml/QueryService/v0.1}SQLSelect"><s:elements><s:arraytype optional="true" unbounded="true" wrapped="false" typename="string" name="WHAT" qname="SQLSelect&gt;WHAT"><s:elementtype><s:basetype optional="false" unbounded="false" typename="string" name="" qname="{http://www.w3.org/2001/XMLSchema}string" /></s:elementtype></s:arraytype><s:arraytype optional="false" unbounded="true" wrapped="false" typename="string" name="FROM" qname="SQLSelect&gt;FROM"><s:elementtype><s:basetype optional="false" unbounded="false" typename="string" name="" qname="{http://www.w3.org/2001/XMLSchema}string" /></s:elementtype></s:arraytype><s:basetype optional="true" unbounded="false" typename="string" name="WHERE" qname="SQLSelect&gt;WHERE" /><s:basetype optional="true" unbounded="false" typename="string" name="ORDER_BY" qname="SQLSelect&gt;ORDER_BY" /><s:basetype optional="true" unbounded="false" typename="int" name="LIMIT" qname="SQLSelect&gt;LIMIT" /><s:basetype optional="true" unbounded="false" typename="int" name="OFFSET" qname="SQLSelect&gt;OFFSET" /></s:elements></s:complextype></s:extensions> net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeFROM_valuevalue00net.sf.taverna.t2.activitiesstringconstant-activity1.3-SNAPSHOTnet.sf.taverna.t2.activities.stringconstant.StringConstantActivity trajectories AS t1, trajectories AS t2 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeWHAT_valuevalue00net.sf.taverna.t2.activitiesstringconstant-activity1.3-SNAPSHOTnet.sf.taverna.t2.activities.stringconstant.StringConstantActivity t1.time net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Invokeconstruct_whereplanet10planet20angle0start0end0where_clause00net.sf.taverna.t2.activitiesbeanshell-activity1.3-SNAPSHOTnet.sf.taverna.t2.activities.beanshell.BeanshellActivity planet1 0 text/plain java.lang.String true planet2 0 text/plain java.lang.String true angle 0 text/plain java.lang.String true start 0 text/plain java.lang.String true end 0 text/plain java.lang.String true where_clause 0 0 workflow net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Invokeconstruct_time_intervalsdates1cadence0end_dates11start_dates11net.sf.taverna.t2.activitiesbeanshell-activity1.3-SNAPSHOTnet.sf.taverna.t2.activities.beanshell.BeanshellActivity dates 1 text/plain java.lang.String true cadence 0 text/plain java.lang.String true start_dates 1 1 end_dates 1 1 workflow net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeExtract_content_of_columns_from_VOTablesColumnNames1VOTable0ValueLists22net.sf.taverna.t2.activitiesdataflow-activity1.3-SNAPSHOTnet.sf.taverna.t2.activities.dataflow.DataflowActivitynet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeColumnNames_valuevalue00net.sf.taverna.t2.activitiesstringconstant-activity1.3-SNAPSHOTnet.sf.taverna.t2.activities.stringconstant.StringConstantActivity time net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Invokecadence_valuevalue00net.sf.taverna.t2.activitiesstringconstant-activity1.3-SNAPSHOTnet.sf.taverna.t2.activities.stringconstant.StringConstantActivity 24 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokewriteVOTableobj20obj10angle0start1end1votable00net.sf.taverna.t2.activitiesbeanshell-activity1.3-SNAPSHOTnet.sf.taverna.t2.activities.beanshell.BeanshellActivity obj1 0 text/plain java.lang.String true obj2 0 text/plain java.lang.String true angle 0 text/plain java.lang.String true start 1 text/plain java.lang.String true end 1 text/plain java.lang.String true votable 0 0 workflow net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeILS_SQLsql_select0response00net.sf.taverna.t2.activitieswsdl-activity1.3-SNAPSHOTnet.sf.taverna.t2.activities.wsdl.WSDLActivity http://msslxw.mssl.ucl.ac.uk:8080/helio-ils/HelioTavernaService?wsdl SQLSelect net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeSQLSelect_sql_selectFROMFROM_valuevalueSQLSelect_sql_selectWHATWHAT_valuevalueSQLSelect_sql_selectWHEREconstruct_wherewhere_clauseconstruct_whereplanet1ILS_target_object1construct_whereplanet2ILS_target_object2construct_whereangleMax_angle_betweeconstruct_wherestarttime_startconstruct_whereendtime_endconstruct_time_intervalsdatesExtract_content_of_columns_from_VOTablesValueListsconstruct_time_intervalscadencecadence_valuevalueExtract_content_of_columns_from_VOTablesColumnNamesColumnNames_valuevalueExtract_content_of_columns_from_VOTablesVOTableILS_SQLresponsewriteVOTableobj2ILS_target_object2writeVOTableobj1ILS_target_object1writeVOTableangleMax_angle_betweewriteVOTablestartconstruct_time_intervalsstart_dateswriteVOTableendconstruct_time_intervalsend_datesILS_SQLsql_selectSQLSelect_sql_selectoutputvotablewriteVOTablevotableSQLSelect_responseILS_SQLresponse c63d80b5-c84b-4ba0-8bfd-b36f09a7af02 2011-10-28 17:04:34.24 BST b3eb71da-dc47-4b35-8c54-53f842602b68 2011-11-01 15:32:06.875 GMT b66efb0d-f7ef-4828-b641-e387a2d71f19 2011-11-01 10:10:23.156 GMT dfdcfc7b-6ec3-489b-8527-75c8d9619fc0 2011-11-18 14:41:20.937 GMT Find periods of time where two ILS objects are located at a maximum of X degrees longitude from each other 2011-11-01 13:25:09.388 GMT 53b23f4a-5b41-439e-a997-14b78bde9f9a 2011-10-28 15:21:59.178 BST 38c9b37a-1b05-4d88-adb7-f717f0c943d3 2011-10-28 15:19:55.248 BST a2591d81-79a8-4a51-ab55-fe4412070145 2011-11-02 15:48:56.828 GMT 7571c0bc-2f1b-4f47-8a28-845a6133a1dc 2011-11-01 10:15:42.750 GMT Inputs: name of target_obj of ILS of two objects and a number of degrees which these obejcts are allowed to be appart in hci longitude coordinates. Output VOTable of time periods where these two objects are closer than +/- input angle together. 2011-11-01 13:27:44.297 GMT 390a9c23-891f-44ce-8a80-bc499e7ac3c4 2011-10-31 14:00:45.328 GMT 0763cdc6-ab4c-413e-bb93-eef6e9e718fa 2011-10-28 13:37:10.721 BST 8c6564ec-ce4a-44e1-8627-a845df0bcf6c 2011-11-04 14:30:44.406 GMT 54e0582d-7c82-496a-acd2-b57904252a61 2011-11-01 15:27:08.875 GMT 1a1850a8-c642-4b51-970f-0906135a5d8b 2011-11-18 13:39:02.156 GMT Anja Le Blanc 2011-11-01 13:23:41.401 GMT 06607f49-bc12-4f7e-84d1-d905292c231f 2011-10-31 15:21:15.421 GMT e4c81a6b-3c65-45d8-bb2f-0393708811fd 2011-11-18 14:15:16.390 GMT 192d66df-6656-4249-9cc2-1cd1173593d2 2011-11-01 11:40:31.859 GMT 7ee61e83-5f14-41c6-9f59-d1af62952c38 2011-11-04 15:37:02.421 GMT 409eff2c-cdbb-49e8-9221-cb32c504bf6d 2011-11-01 11:35:29.906 GMT e46e3611-c172-4686-a83a-830c0802698d 2011-10-31 15:42:16.62 GMT 5aa2ec7d-d549-4693-9597-79bbc6a5f239 2011-10-28 14:08:59.458 BST e2189f64-b8a2-4659-bbf6-6f2e258adf10 2011-11-04 15:28:37.437 GMT bad02b78-5132-40ff-955a-ab88c685260e 2011-11-01 10:28:06.578 GMT d651a8e3-fbeb-4620-892a-ad100f07e03b 2011-11-18 14:48:41.906 GMT 9b0933a6-9da5-45c4-b19b-791c1794e1b8 2011-10-28 10:31:06.577 BST 79f51a51-eea8-4ecf-9869-db97429a3629 2011-10-31 13:59:33.937 GMT bb561ed4-e5ac-415f-a877-82a325d9a418 2011-11-01 10:39:58.250 GMT 4b46c7a9-12a4-4d31-b924-6e64f9403c41 2011-10-31 08:56:53.250 GMT 9d7e1349-e078-4cde-85d2-b66ae85ffb21 2011-10-28 17:05:13.771 BST 953e5520-5735-427a-854f-88eb42662363 2011-11-01 15:13:57.93 GMT 3e41c488-f5e2-4e3e-bfe2-f1eca1522fd1 2011-10-28 14:37:43.853 BST 62c20965-cf5e-42eb-a5b2-4a5f5e4908ec 2011-11-01 10:48:28.921 GMT 34c39558-fd3a-4a6f-9702-c9882b5e80be 2011-11-01 11:34:08.62 GMT 038d12fc-d83b-4d44-bba6-8cedcffc5294 2011-11-18 13:40:08.734 GMT 11ff5cdb-8ee0-483a-902e-1cc159a640c0 2011-11-01 11:38:32.15 GMT 51ff5772-74f1-416f-a56c-0c4a55875225 2011-11-18 14:42:04.0 GMT 73089c4d-b914-4140-9181-d806720d068d 2011-11-18 13:13:11.859 GMT 51c58963-5730-4c98-868b-c059ae13ee51 2011-11-01 11:38:04.906 GMT 06286872-06ac-4e21-8585-4abe74f936d7 2011-11-01 13:29:41.738 GMT 191fee88-7b8a-4458-972b-e86a6be54bb5 2011-11-01 15:34:09.406 GMT Extract_content_of_columns_from_VOTablesVOTable00 VOTable from which values should be extraced 2011-02-24 10:15:26.359 GMT ColumnNames11 List of Strings with Column names of the VOTable 2011-02-24 10:13:51.281 GMT ColumnNames Column names - in the order of the value list 2011-02-24 10:16:32.781 GMT ValueLists contains vectors of values, the order is specified by ColumnNames 2011-02-24 10:16:55.890 GMT parseVOTablevoTable0collumn1collumn11valueLists22net.sf.taverna.t2.activitiesbeanshell-activity1.3-SNAPSHOTnet.sf.taverna.t2.activities.beanshell.BeanshellActivity voTable 0 text/plain java.lang.String true collumn 1 text/plain java.lang.String true valueLists 2 2 debug 0 0 collumn 1 1 workflow net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.5 1000 5000 10 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeparseVOTablevoTableVOTableparseVOTablecollumnColumnNamesColumnNamesparseVOTablecollumnValueListsparseVOTablevalueLists 86f4cf0d-4675-489a-b863-b04b0e927648 2011-02-24 10:05:44.953 GMT Anja Le Blanc 2011-02-24 10:10:21.390 GMT Extracts all values from all columns which are passed from the input ColumnNames 2011-02-24 10:12:38.984 GMT d54f2acb-8a20-40c2-861d-f4331a4778e4 2011-02-24 10:17:55.359 GMT 2cd3acee-1f14-452f-bdc5-3635c094b1c8 2011-11-01 10:28:00.953 GMT a8493547-4587-4e72-b72f-25dccabb6ab1 2011-02-24 10:12:52.359 GMT 714fdf6b-4a56-46fb-917b-fcb77691ffec 2011-03-04 14:48:16.340 GMT a978c8b4-8f51-49fd-9fc7-5584a21888ee 2011-11-01 10:48:17.250 GMT Extract content of columns from VOTables 2011-02-24 10:11:23.953 GMT