CARS

[OIII] wing velocity dispersion selection >300km/s PostgreSQL

Retrieves the HES name, AGN [OIII] wing velocity dispersion, observed IFU data cube and high-level products maps for all targets with a velocity dispersion of the [OIII] 5007 wing in the AGN spectrum greater than 300 km/s

SELECT agn.hes_name, agn.wing_sigma, ifu.observed, ifu.maps_full
FROM
    cars_dr1.agn_parameters AS agn,
    cars_dr1.ifu_observations AS ifu
WHERE agn.target_id = ifu.target_id AND agn.wing_sigma > 300

BPT line construction for CARS target ID 12 PostgreSQL

Reporting of BPT line ratios with proper cleaning of good data

SELECT
    log(oiii5007_flux/hbeta_flux) AS "log(oiii_hb)",
    log(nii6583_flux/halpha_flux) AS "log(nii_ha)",
    distance
FROM cars_dr1.ifu_datatable_unbinned
WHERE target_id=12
    AND (oiii5007_flux/oiii5007_flux_err)>3
    AND (nii6583_flux/nii6583_flux_err)>3
    AND (hbeta_flux/hbeta_flux_err)>3
    AND (halpha_flux/halpha_flux_err)>3
    AND (gas_vel_err<20)
    AND (gas_fwhm_err<30)

BH mass in comparison to ENLR maximum size PostgreSQL

Retrieves the target id, HES name, log BH mass, maximum size of the ENLR in kpc and the logarithm of it for all objects where the ENLR is measured and greater than 0.0

SELECT
    agn.target_id, agn.hes_name, agn.log_bh_mass, host.enlr_max_kpc,
    log(host.enlr_max_kpc) AS "log_enlr_max_kpc"
FROM
    cars_dr1.agn_parameters AS agn,
    cars_dr1.host_properties AS host
WHERE agn.target_id = host.target_id AND host.enlr_max_kpc > 0.0

Spectral Energy Distribution (SED) for target HE0040-1105 PostgreSQL

Collect integrated panchromatic photometry from the UV to FIR for a single target from the CARS database

SELECT
    phot_band, phot_centwave, phot_flux, phot_flux_error, phot_flux_limit,
    log(phot_centwave) AS log_centwave,
    log(phot_flux) AS log_phot_flux 
FROM cars_dr1.photometry
WHERE hes_name = 'HE0040-1105'

Retrieve AGN lumionsities from BLR and X-ray measurements PostgreSQL

List the bolometric luminosity based on the Hbeta BLR component and the soft X-ray lumionsity

SELECT
    tar.hes_name, tar.soft_x_flux,
    tar.lum_dist, agn.log_agn_lum,
    log(4*pi())+log(tar.soft_x_flux)-12+2*log(tar.lum_dist*3.086e24) AS log_soft_x_lum
FROM
    cars_dr1.targets AS tar,
    cars_dr1.agn_parameters AS agn
WHERE tar.target_id = agn.target_id

Examples