The ARCHES SED archive of 3XMM sources by Mauro Lpez - - PowerPoint PPT Presentation
The ARCHES SED archive of 3XMM sources by Mauro Lpez (mauro@cab.inta- csic.es) Spanish Virtual Observatory ARCHES Scientific Workshop. Paris. 30 Nov - 2 Dec. 2015 ARCHES WP5 Objective: SED tool development & SED creation We aim to
ARCHES Scientific Workshop. Paris. 30 Nov - 2 Dec. 2015
Objective: SED tool development & SED creation We aim to produce a scientifically validated, VO-compliant set of spectral energy distributions of the objects included in the 3 XMM-Newton Serendipitous Source Catalogue. Team: Enrique Solano (SVO boss) and Mauro López (SVO minion)
2
More than 10 years focused in Virtual Observatory activities. For ARCHES: Calculate SED fluxes Create web service Create VO service Provide access and support to the community
3
Arches WP4: Provides the input catalogue/s Arches WP5 Arches WP8: Testing Arches WP13: Upload SEDs to Vizier
4
1. Where is the data? I will create synthetic data 2. Is this the data? Great! Life is good 3. But, are you sure we are not going to change the data again? 4. OH MY GOD! Data has changed and we are out of time. Run you fool! (Two heart attacks later…) Data is already available (user/password is required): sdc.cab.inta-csic.es/arches/
5
WP5 Database Controller Interface - VO
6
WP4: Data CSV S V O F i l t e r p r
i l e s e r v i c e WP5 SEDs VO SEDs ASCII SEDs
7
We use it to calculate fluxes/errors using magnitudes Most sub-catalogs covered http://svo2.cab.inta-csic.es/theory/fps3/index.php
8
Multiple “multi catalog” information
Input data was two single, big tables. Lots of rows (150.000+30.000) and lots of columns (CSV format). Query by ID (3XMM) is fast, pretty, reliable… Query by position is slower. Why?: Harvesine formula to calculate the distance
2.0*asin(sqrt(pow(sin(toRadians((archesDec-dec)/2.0)),2)+cos(toRadians(dec))*cos(toRadians (archesDec))*pow(sin(toRadians((ra-archesRa)/2)),2)))/PI/648000
9
One main table:
One “index” table:
3XMM_IAUNAME info Auxiliary tables:
10
Avoid SQL statement. Only a create database arches_wp5 was executed during this project. For everything else there’s
will transform it into a database structure.
and Hibernate will query it. Advantages: easy to expand, independent on the architecture (PSQL, MySQL, Oracle,...), everything inside the same project. Hibernate
11
Front end for accessing to the data Query by 3xmm id, Sesame or position Multiple query allowed Hide/unhide catalogs Access to external plots (thanks Laurent et al) Direct communication with VOTools through SAMP protocol HTML or ASCII output Full catalogue available to download
12
13
14
Downloaded data is structured into different folders:
15
16
Client: Only standards as HTML5, CSS and Javascript Server: JAVA, JSP and Struts. Objective in mind: to split as best as I could the View from the Controller
17
We have SEDs, we have a way to query data, but we also need to provide access to VO registries (when data is public). We have done it (access to SEDs is disabled at this moment). Simple SSAP example: http://sdc.cab.inta-csic.es/arches/queryVOAction.action?pos=351.98535,-2.10475
18
19
○ Finish a “Bible for the Arches-WP5 Server”
○ Several input catalogs have been used. A cleaning of the code is required ○ Continuous surveillance work (is the server down? is the server room on fire? do we store the backups properly? ○ Generate statistics
○ Does anything need help? I am at your service.
20