1
$\begingroup$

How to get ellipticities of a list of random galaxies. I saw few programs written in SQL and they were only giving stokes parameters and isophotes values for ONE galaxy(for which we input the ObjID). I am not familiar with syntax of SQL. Is there any method to put the objid in a loop so that the program generates stoke parameters values for a list of galaxies?

$\endgroup$
  • $\begingroup$ This question is technically about SQL usage, but given the number of major astronomical databases with public SQL interfaces these days, I think it's on topic. $\endgroup$ – Mike G May 5 at 15:08
1
$\begingroup$

Just found out this method in casjobs.Previously I came across one SQL code in Stackexchange in which you have to input one ObjID to get its stokes parameters and isoA and isoB values.In sample codes in DR7, you can edit the line which gives Feild values and coordinates to get Stokes parameters(type q_r,u_r in their place). enter image description here

From stokes parametres you get the ellipiticity of the galaxy from this equation (which can be done in python.)

$e = 1 - \frac{b}{a} = 1 - \frac{1 - \sqrt{Q^2 + U^2}}{1 + \sqrt{Q^2 + U^2}}. $

Note that if you are downloading the Casjobs query data in CSV or excel format,You need to write python code to read the file and apply the formula (to learn how to read csv files in python click here)

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.