taskGNU Astronomy Utilities - Tasks: task #15468, Manage vector values inside tables

 
 

You are not allowed to post comments on this tracker with your current authentication level.

task #15468: Manage vector values inside tables

Submitter:  Raul Infante-Sainz <infantesainz>
Submitted:  Mon 18 Nov 2019 10:25:47 AM UTC
   
 
Should Start On:  Mon 18 Nov 2019 12:00:00 AM UTC Should be Finished on:  Mon 18 Nov 2019 12:00:00 AM UTC
Category:  Table Priority:  5 - Normal
Item Group:  Output not reasonable Status:  None
Privacy:  Public Assigned to:  None
Percent Complete:  0% Open/Closed:  Open
Effort:  0.00

Mon 18 Nov 2019 01:59:13 PM UTC, comment #1: 

Thanks a lot for bringing this up. This is an interesting format to keep columns with similar values in a FITS table without having to increase the official column number.

Following your task report, it just occurred to me that we can specify sub-columns with a `.N' added to the column name for example in the example you sent, if you wanted the third sub-column of the `apflux_g' column, you can run a command like this:


asttable tractor-0397m080.fits -capflux_g.3


We can similarly extend the concept to Gnuastro's plain-text table format (to easily print on the command-line or create FITS tables with this feature), so the sub-column metadata would be printed like this (the `.M' part is new):


# Column N.M: NAME [UNIT, TYPE, BLANK] COMMENT


For example, following the example in that section of the book, such, the meta-data for sub-column 3 of column 5 in a table would look like this:


# Column 5.3: column name [km/s,f32,-99] Redshift as speed


Unfortunately I am too busy to implement this now, but it is a very good suggestion to add this feature, I can see many scenarios where such array-column can be very useful. So I just tried to build upon the initial suggestion with some possibly useful implementation details.

Until I get the chance to implement this, if anyone is interested to try implementing it, any help would be very welcome.

Mohammad Akhlaghi <makhlaghi>
Group administrator
Mon 18 Nov 2019 10:25:47 AM UTC, original submission:  

I found some catalogues (fits tables) that instead one value per each column and row, they are arrays. As a particular example it can be checked the catalogue of DECaLS around NGC1035 (link: https://portal.nersc.gov/project/cosmo/data/legacysurvey/dr8/south/tractor/039/tractor-0397m080.fits).
In this catalogue there are multiple columns, but just focusing on the one with name `apflux_g' it can be seen that there are multiple values for a single object (row). They correspond to photometry measurements on different apertures. When considering this table with the program `Table', it gives as an output a no-sense result.

Consider the column `apflux_g' and the last row, with `asttable':


asttable tractor-0397m080.fits -capflux_g


the result is:


0.274843


It is a single value. However, the real value is an array (read with `topcat'):
 

(0.15832691, 0.33208665, 0.523447, 0.87126434, 1.099582, 1.4097637, 1.3801724, 1.514054)


Raul Infante-Sainz <infantesainz>
Group Member

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by makhlaghi (Posted a comment)
  • -email is unavailable- added by infantesainz (Submitted the item)
  •  

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

     

    No changes have been made to this item

    Back to the top

    Powered by Savane 3.13-758e.
    Corresponding source code