Example for adding decimal degree RA and Dec columns
Some IRSA services accept only tables with RA and Dec columns in decimal degrees; the "add decimal degree columns" option is designed to translate either the object name or the sexigesimal RA, Dec columns to decimal degrees while reformating the table. The decimal degree RA and Dec columns in the output table will always be "ra" and "dec" so as to be accepted by the IRSA's DBMS query. If these column names exist in the input table, they will be renamed as "ra_input" and "dec_input" in the output table. Any input data that cannot be resolved by the "lookup" (via NED and SIMBAD search) will be excluded in the reformatted table.
This document presents a few examples to illustrate the mechanics of adding decimal degree columns.
Example1 : input table contains either a sexigesimal coordinate string or an object under the column name of "objname".
| objname |
13h29m52.37s +47d11m40.8s
M51
M109
M101
Check the add column options and fill in the input column name as follows,
and it produces the following reformatted upon submission.
| objname | ra | dec | 13h29m52.37s +47d11m40.8s 202.46820833 47.194666667 M51 202.48219363 47.231508870 M109 179.39991667 53.374527780 M101 210.80245824 54.349093840
Example2 : input table contains tabs and sexigesimal coordinates.
cra cdec 13h29m52.37s +47d11m40.8s 07h46m42.56s +20d00m32.1sCheck the add column options and fill in the input column name as follows,
and it produces the following reformatted upon submission.
| cra | cdec | ra | dec | 13h29m52.37s +47d11m40.8s 202.46820833 47.194666667 07h46m42.56s +20d00m32.1s 116.67733333 20.008916667
Example3 : input table is fixed length but contains sexigesimal coordinates, and the column names are "ra" and "dec".
| ra | dec | note | 01 51 41.69 +12 44 29.6 T dwarf in faint field 02 35 59.93 -23 31 20.5 faint companion 04 21 59.43 +19 32 06.4 T Tauri 05 40 51.71 -71 27 08.2 LMC field 07 30 08.00 -22 01 05.0 large galaxy in ZOA 11 57 35.98 +53 22 28.3 galaxy M109 14 15 39.67 +19 10 56.7 Arcturus 14 57 15.20 -21 21 50.0 faint T dwarf w/ bright star at fld edge 16 26 22.40 -24 24 08.0 BD in rho Oph 17 45 40.04 -29 00 28.1 Sgr A* 18 02 24.00 -23 02 00.0 Trifid Nebula M20 18 53 35.01 +33 01 42.9 Ring Nebula M57 20 56 19.07 +31 44 33.9 NGC 6992 (Veil Nebula)Check the add column options and fill in the input column name as follows,
and it produces the following reformatted upon submission.
| ra_in | dec_in | note | ra | dec | 01 51 41.6 +12 44 29. T dwarf in faint field 27.923333333 12.741388889 02 35 59.9 -23 31 20. faint companion 38.999583333 -23.52222222 04 21 59.4 +19 32 06. T Tauri 65.497500000 19.535000000 05 40 51.7 -71 27 08. LMC field 85.215416667 -71.45222222 07 30 08.0 -22 01 05. large galaxy in ZOA 112.53333333 -22.01805555 11 57 35.9 +53 22 28. galaxy M109 179.39958333 53.374444444 14 15 39.6 +19 10 56. Arcturus 213.91500000 19.182222222 14 57 15.2 -21 21 50. faint T dwarf w/ bright star at fld edge 224.31333333 -21.36388888 16 26 22.4 -24 24 08. BD in rho Oph 246.59333333 -24.40222222 17 45 40.0 -29 00 28. Sgr A* 266.41666666 -29.00777777 18 02 24.0 -23 02 00. Trifid Nebula M20 270.60000000 -23.03333333 18 53 35.0 +33 01 42. Ring Nebula M57 283.39583333 33.028333333 20 56 19.0 +31 44 33. NGC 6992 (Veil Nebula) 314.07916666 31.742500000
 |
 |
 |
 |
IRSA Charter :: IRSA Acknowledgement :: Privacy/Security Policy
JavaScript must be enabled in order for the site to display properly.