thespacedoctor

SELECT
    *
FROM
    (SELECT
        a.catalogue_table_id,
            a.catalogue_table_name,
            a.all_count,
            COALESCE(top_rank_count, 0) AS `top_rank_count`
    FROM
        (SELECT

thespacedoctor

Michael Coughlin's original script to listen to graceDB and download any new wave maps.

thespacedoctor

#!/usr/local/bin/python
# encoding: utf-8
"""
april2016-march2017-pessto-stats-plots.py
=========================================
:Summary:
    PESSTO Stat Plots

:Author:
    David Young

thespacedoctor

-- FOR A SPECIFIC TYPE OF DATA (HERE EFOSC SPECTRA)

SELECT 
    *
FROM
    (SELECT 
        COUNT(*) AS count, object, transientBucketId
    FROM
        (SELECT DISTINCT
        object, transientBucketId

thespacedoctor

SELECT 
    e.currentFilename,
    a.object,
    a.ra,
    a.decl,
    e.ra,
    e.decl,
    raDeg,
    decDeg,
    e.transientBucketId,

thespacedoctor

UPDATE phase_iii_transient_catalogue_ssdr3 p,
    (SELECT 
        transientBucketId,
            GROUP_CONCAT(name
                SEPARATOR ', ') alternative_ids
    FROM
        (SELECT DISTINCT
        t.TransientBucketId, t.name
    FROM
        transientBucket t, phase_iii_transient_catalogue_ssdr3 p

thespacedoctor

A query was done to exact ATLAS (or was it PS1?) difference detections that are likely assoicated with bright stars from the local QUB ATLAS database. The query took all GSC stars brighter than V=16, crossmatched all difference detections within 5 arcmin and calculated the mean separation of this set of crossmatches in arcsec (see CSV file).

Plot the mean separation vs GSC magnitude reveals a distinction between the bright star cores found in the difference images (below black line) and the cruft resulting from poor image subtraction in the halos of these bright stars (abive the black line).

Here's another view of that data:

thespacedoctor

Taking a sample of 1,000,000 galaxies from NED and plotting semi-major axis measurements against magnitude:

From inspection it seems the lower limb in this plot is due to a bug in NED’s calculation of a homogenised semi-major axis measurement. The individual diameter measurements for a galaxy provide sensible measurement, but measurements reported on the galaxy’s synopsis page are far too large for objects in this sample.

thespacedoctor

These are the queries we use to extract out the relevant galaxy, star and QSO information we need from SDSS for our local QUB contextual classifier (Sherlock). These queries need to be re-ran and the data re-imported into our local database for each SDSS data-release.

thespacedoctor

#!/usr/local/bin/python
# encoding: utf-8
"""
test.py
========
:Summary:
    A test script to test apache installs

:Author:
    @thespacedoctor