The files in this folder can be used to automatically extract catalogued objects from the IRSA databases that fall within the Hershcel Extragalactic Legacy Project boundaries (and with suitable modification any other survey).

The following files are listed in the order that you'd want to use or produce them.  
Numbering in sequence, lettered suffixes indicate options
----------------------------------------------------------------------


1.  irsa_tables.fits 
(and other formats) generated initially from the following command.  (some files have been edited by hand)

> curl -o irsa_tables.fits "http://irsa.ipac.caltech.edu/TAP/sync?QUERY=SELECT+*+FROM+TAP_SCHEMA.tables&FORMAT=FITS"


2.  slphotdr4_cols.xml 
is a list of the columns in the slphotdr4 table selected using the following command
> curl -o slphotdr4_cols.xml "http://irsa.ipac.caltech.edu/TAP/sync?QUERY=SELECT+*+FROM+TAP_SCHEMA.columns+WHERE+table_name='slphotdr4'"


3a. HELP_servs
is a batch script to spawn all the queries for HELP on the swire tables

3b. HELP_slphotdr4
is a batch script to spawn all the queries for HELP on the slphotdr4 table


4a. HELP_tap_irsa
#   To launch a query to the IRSA TAP service, producing a FITS FILE collecting all columns

4b. HELP_tap_irsa_slphotdr4
#   To launch a query to the IRSA TAP service, producing a FITS FILE dedicated to slphotdr3

5. SA13_slphotdr4.log etc.
Files generated as the output to a single running of the HELP_tap_irsa_* scripts with naming convention
field_table.log

5x. logs
Folder containing some example logs


6. HELP_tap_irsa.urls
# authomatically appended to on each running of the HELP_tap_irsa scripts, useful cross-check but not used


7. make_get_files_script.csh
#   To parse the log files (*.log) produced by the HELP_tap_irsa.csh script and build
#   a script to retrive the files from IRSA

8. get_irsa_files.csh

is automratically generated by make_get_files_script.csh and actually gets the files from IRSA

9a. data_slphotdr4
Folder containing fits files produced by  HELP_tap_irsa_slphotdr4 etc.

10a. data_slphotdr4/fits_list.lis is a file generated by 
> ls *.fits > fits_list.lis
which can be used as a parameter in the stilts command

stilts tcat in=@fits_list.lis out=help_slphotdr4.fits

11a. data_slphotdr4/help_slphotdr4.fits

merged file containg all the records from slphotdr4 in all HELP fields, generated as in 10a above.



Other files of little interest
----------------------------------------------------------------------
old_irsa_script: a script I was using when testing

----------------------------------------------------------------------

Seb Oliver 30th November 2015