thespacedoctor

#!/bin/bash
# USAGE: sh isrunning.sh <processname>

ps_out=`ps -ef | grep $1 | grep -v 'grep' | grep -v $0`
result=$(echo $ps_out | grep "$1")
if [[ "$result" != "" ]];then
    echo "Running"
else
    echo "Not Running"
fi

thespacedoctor

The blog-post explaining these files can be found here.

thespacedoctor

#!/bin/bash
ps_out=`ps -ef | grep $1 | grep -v 'grep' | grep -v $0`
result=$(echo $ps_out | grep "$1")
if [[ "$result" != "" ]];then
    echo "Running"
else
    echo "Not Running"
fi

thespacedoctor

#!/usr/bin/env python
# encoding: utf-8
"""
*import a file into bookends database with the filename as the reference title*

:Author:
    David Young

:Date Created:
    January 30, 2020

thespacedoctor

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

:Author:
    @thespacedoctor

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

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

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

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

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