Page History
...
CasJobs is an online tool used to query large databases. Originally created for the SDSS catalog, it has now been adapted for selected MAST archival datasets - namely GALEX, Kepler and the HSC. While the MAST Discovery Portal is the primary tool for using the HSC, CasJobs provides a powerful tool for looking at larger datasets and making more detailed queries. The HSC Homepage is also available for some specific queries.
GOAL: This tutorial provides a first look at how to use CasJobs to query the Hubble Source Catalog. For a more detailed tutorial on the syntax behind the queries the SDSS SQL Tutorial is recommended.
SCIENCE CASES: The science cases are studies of: 1. slightly extended objects (i.e., globular clusters in M87) and 2. large datasets (i.e., a Color Magntiude Diagram for the SMC).
...
Step 1 - Enter the HSC Casjobs webpage and create an account using the button in the top menu bar (blue). Go ahead and login (green). |
Step 2 - Inspect the HSC databases and functions. Click MyDB in the top menu bar (blue). This displays all the tables and functions you create in "MyDB" (My Database). Now change the "context" (the database used to run your query) from MyDB to HSCv3 (i.e., Hubble Source Catalog Version 3) (green), using the dropdown menu on the top left. This shows the available views, tables, functions and procedures related to the HSC database. |
Step 3 - Query the database. The query below is designed to find globular clusters in the galaxy M87.
...
The ORDER BY defines the order of the results (i.e. by matchID).
Now click Query. Change the context from MyDB to HSCv3 (if necessary) (blue). Note that forgetting to change the context is the most common error causing CasJobs queries to fail. Copy and paste the text from above into the blank query text box (green). Click Quick (orange) to submit the job. |
Step 4 - Examine an image. It is a good idea to look at the HSC overlayed on an image, to check for artifacts and uniformity. Copy the MatchRA and MatchDec values of the 7th source from your table. Open the HLA and paste those values into the search box (blue). Click Search. |
Step 5 - Determine the value of NumImages to use. Click HSC controls, Require NumImages > 10, and then the HSC (blue) button to overlay the HSC on this particular image. We find that NumImages > 10 leaves a number of artifacts and apparently blank circles. If you click on a few of the real objects (green) you find they all have more than NumImages = 50. Some have over 200! |
Step 6 - You can also use the MAST Discovery Portal to make the same query, since this is a relatively small dataset. Several other HSC Use Cases (e.g., #1: Using the Discovery Portal to Query the HSC - Stellar Photometry in M31; Brown et al. 2009) provide more detail. The Discovery Portal can also be used to make plots and to reach the HLA Interactive Display (like in Step 5). |
Step 7 - Now let's try something a little bigger by making a Color Magnitude Diagram (CMD) for the Small Magellanic Cloud (SMC) using the ACS data. Following similar steps to those described above, cut and paste the following text into a Query box, and hit the Submit button (since this is a longer query). The table smc_v3 should appear in MyDb in about 6 minutes or so.
...