The table upload feature finds positional matches with coordinates in an input source list. The input table file must be created on the client machine in ASCII format according to rules regarding formatting and column names. IRSA recommends uploading new tables to the Table Formatting service, which aids users by discovering and attempting to correct common formatting problems. Please also read the DBMS Constraints for more detailed information. In particular, note that coordinates must be ra and dec in units of decimal degrees. Columns in the input table will be included in the output table, with a suffix attached. This suffix will be "_01" unless the column name ends with "_NN" where NN is any integer from 01 to 98. In the latter case, the suffix will be incremented by one, to a maximum value of 99.
Use the "Browse..." button to select the local table file for upload, or type in the file name. If the radius is not included in the table, enter the radius of the search region and select the required angular unit. If the search radius exceeds the maximum allowed value, Gator will default to the maximum value and write a message to this effect to the query monitor.
Two search modes are available for table upload:
- specify parameters through the Gator interface, or
- read parameters from user's table
Gator also allows the user to upload a table with cone search parameters defined in the input table. In that case, the "radius" box on the Gator interface must be blank or "0". In the user table, column names of "major", "ratio", and "angle" are required for an elliptical search, while a column name of "major" is necessary for a circular search. If the user wishes to perform the same cone search on all entries in the input table, these cone search parameters can be input in the Gator interface instead.
Ellipse Search Example
The following is an example of a table with elliptical search parameters: major (the semi-major axis), ratio and angle (the position angle). Missing ratio and angle columns result in a circular search with radius equal to major.
\ Example of ellipse search \ EQUINOX = 'J2000.0' | ra | dec | major | ratio | angle | | double | double | double | double| double| 185.500000 15.500000 1000. 0.25 30 186.000000 15.000000 500. 0.50 60
This example shows a table with the semi-major axis given in the third column and the ratio in the fourth column of the table. Since no position angle is provided, the default of 0 is used.
\ Example of ellipse search \ EQUINOX = 'J2000.0' | ra | dec | major | ratio | | double | double | double | double| 185.500000 15.500000 1000. 0.25 186.000000 15.000000 500. 0.50
Cone Search Example
Example of a table with the semi-major axis given in the third column of the table. Since no axis ratio or position angle is given, this results in a circular search.
\ Example of cone search \ EQUINOX = 'J2000.0' | ra | dec | major | | double | double | double | 185.500000 15.500000 1000. 186.000000 15.000000 500.