How do I generate an abbreviated list of columns for specific survey (or for all of them)?
Let’s take the first question first. We will generate a results table which you may want to generate as a Comma Separated Value table (an IDL routine is provided in our contributing software area to convert CSV to blank separated value tables). We will take the query below and paste it into the text box on the SQL form . This query will provide you with a list of tiles observed by the AIS mission and observed either in FUV or NUV bandpasses. It will list the survey and tile names, the coordinate centers for the tiles, the path name used to retrieve (say) the jpeg image, and (for cases of multiple tiles at the same coordinates, it will rank multiple observations by increasing exposure time. All statements encased within /* and */ symbols are comments and are given here for clarification to the user. To make the query inclusive to all surveys, delete the line “and nuv_mpstype=’AIS’. Before clicking the Execute button, be sure to click on the “CSV” option for a comma separated values asci
