|
|
Freeform SQL Query
This forms allows you to submit a SQL query to the VESPA database. Simply
type in your query and hit the Submit button. For help with SQL you may want
to have a look at
this cookbook. Some specific examples of how to use the VESPA database
can be found in Tojeiro et al. 2009.
Optionally, you can also upload a list of SDSS specObjID values, which you can
cross reference with the VESPA database. To do so, create a file consisting
of a single column with the specObjID values - no headers and no commas. If
you choose this file in the "Optional file of IDs" field, your list will be
uploaded into a temporary table called #upload, with a column name upID.
For example, to return stellar masses for a list of objects of your own
interest, analysed using the M05 models and a 2-parameter dust model, you
can do:
SELECT u.upID, m_stellar
FROM lookuptable as l, #upload as u, galprop as g
WHERE u.upID = l.specObjID
AND l.indexp = g.indexp
AND g.runID = 4
A list will always be uploaded to #upload if there is a file selected. If no
file is selected, the table #upload will not be created.
|
